testconn.jsp

来自「jsp连接样例!详细说明了jsp的连接方法!新手值得一看!」· JSP 代码 · 共 30 行

<%@page contentType="text/html; charset=gb2312" language = "java"%>
<%@page import = "java.sql.*"%>
<%!
String strSql;
Connection conn;
Statement stmt;
ResultSet result;
%>
<%
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	conn = DriverManager.getConnection("jdbc:odbc:quchch","","");
	stmt = conn.createStatement();
	strSql = "Select * From tab";
	result = stmt.executeQuery(strSql);
	while(result.next()){
		out.println(result.getString("name"));
		out.println("<BR>");
	}
	result.close();
	stmt.close();
	conn.close();
}catch(Exception e){
	out.println(e);
}finally{
	if(conn!=null){
       conn.close();
	}
}
%>