conn.jsp

来自「[收藏]这是来自javax论坛spider的作品」· JSP 代码 · 共 32 行

<%!
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public void jspInit()
{
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	//载入驱动程式类别
		con = DriverManager.getConnection("jdbc:odbc:gBook");	//建立数据库连线
		//建立Statement变量
		stmt = con.createStatement();
	}
	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());
	}
}
%>