conn.jsp

大量jsp编程使用例子

<%!
Connection con = null;
Statement stmt = null;
ResultSet rs = null;

public void jspInit() //执行数据库连结动作
{
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	//载入驱动程式类别
		con = DriverManager.getConnection("jdbc:odbc:BookDB");	//建立数据库连线
		//建立Statement变量, 并设定记录指标类型为可前後移动
		stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					     ResultSet.CONCUR_READ_ONLY);
	}
	catch(Exception ex)
	{
		System.out.println(ex.toString());
	}
}
public void jspDestroy() //关闭变量
{
	try
	{
		stmt.close(); //关闭Statement变量
		con.close();  //关闭Connection变量
		rs.close(); //关闭ResultSet变量
	}
	catch(Exception ex)
	{
		System.out.println(ex.toString());
	}
}
%>