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