conn.jsp

来自「《jsp时尚编程百例》的配套光盘中100个实例 初学者学习时可以参考。」· JSP 代码 · 共 33 行

<%!
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());
	}
}
%>