第十二讲.ppt.ppt

?//载入驱动程式类别 ???? ???????con?=?DriverManager.getConnection(jdbc:odbc:test); ????????????//建立数据库连线???????????? ????????} ????????catch(Exception?ex) ????????{???? ????????????System.out.println(ex.toString()); ????????}???????? ????} ??????/** ?*?方法名：close ???????*?级别：private ???????*?@param?????(无) ???????*?@return????(无) ???????*?@throws????(无) ???????*?作用：关闭数据库联机 ???????*/ ????private?void?close() ????{ ????????try ????????{ ????????????con.close();?//关闭Connection对象???????? ????????????con?=??null; ????????} ??catch(SQLException?sex) ????????{???? ????????????System.out.println(sex.toString()); ????????}???? ????} ??????/** ???????*?方法名：getConnection ???????*?级别：public ???????*?@param?????(无) ?*?@return????Connection?????数据库联机 ???????*?@throws????(无) ???????*?作用：返回一个数据库联机 ???????*/ ????public?Connection?getConnection() ????{? ????????//若con为null时,?重新建立数据库连结 ????????if(con?==?null) ????????????BulidConnection(); ????????return?this.con; ????}???? ??????/** ??*?方法名：valueBound ???????*?级别：public ???????*?@param?????HttpSessionBindingEvent?????事件 ???????*?@return????(无) ???????*?@throws????(无) ???????*?作用：建立一个数据库联机，并输出相关信息 ???????*/ ????public?void?valueBound(HttpSessionBindingEvent?event) ???????{ ?????????BulidConnection(); ????????????System.out.println(会话级别的数据库连接已经建立！！！); ???????} ?/** ???????*?方法名：valueUnbound ???????*?级别：public ???????*?@param?????HttpSessionBindingEvent?????事件 ???????*?@return????(无) ???????*?@throws????(无) ???????*?作用：关闭一个数据库联机，并输出相关信息 ???????*/ ????public?void?valueUnbound(HttpSessionBindingEvent?event) ????{ ????????if(con?!=?null) ????????????close();?//呼叫close方法 ?System.out.println(会话级别的数据库连接已经关闭！！！); ????} } 编译这个Bean源文件。注意，编译前要设定好classpath的路径，使得它所包含的类库中有javax.servlet.http.*包。然后，建立两个用来测试此Bean的jsp页面文件DBBean1.jsp与DBBean2.jsp，它们的程序代码差不多，都是用来显示数据库内容的，现在就只列出DBBean1.jsp的源文件，如下： %@?page?contentType=text/html;?charset=GB2312? ????import=java.sql.*% HTML