<%!
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public void jspInit() //執(zhí)行數(shù)據(jù)庫(kù)連結(jié)動(dòng)作
{
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //載入驅(qū)動(dòng)程式類別
		con = DriverManager.getConnection("jdbc:odbc:BookDB"); //建立數(shù)據(jù)庫(kù)連線
		//建立Statement變量, 并設(shè)定記錄指標(biāo)類型為可前后移動(dòng)
		stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					     ResultSet.CONCUR_READ_ONLY);
	}
	catch(Exception ex)
	{
		System.out.println(ex.toString());
	}
}
public void jspDestroy() //關(guān)閉變量
{
	try
	{
		stmt.close(); //關(guān)閉Statement變量
		con.close();  //關(guān)閉Connection變量
		rs.close(); //關(guān)閉ResultSet變量
	}
	catch(Exception ex)
	{
		System.out.println(ex.toString());
	}
}
%>