使用JavaBean连接数据库

《使用JavaBean连接数据库》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、JSP+JavaBean1、JavaBean类1、显示学生信息内容JavaBeanpackagecom.DataBase;importjava.sql.*;publicclassMyDbBean{privateStatementstmt=null;ResultSetrs=null;privateConnectionconn=null;privateStringdsn;//构造函数publicMyDbBean(){}//根据dsn参数，加载驱动程序，建立连接publicvoidgetConn(Stringdbname,Stringuid,S

2、tringpwd)throwsException{try{dsn="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName="+dbname;Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();conn=DriverManager.getConnection(dsn,uid,pwd);}catch(Exceptionex){System.err.println("aq.executeQu

3、ery:"+ex.getMessage());}}//执行查询类的SQL语句，有返回集publicResultSetexecuteQuery1(Stringsql){rs=null;try{stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);rs=stmt.executeQuery(sql);}catch(SQLExceptionex){System.err.println("aq.executeQuery:"+ex

4、.getMessage());}returnrs;}//执行更新类的SQL语句，无返回集publicvoidexecuteUpdate2(Stringsql){stmt=null;rs=null;try{stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);stmt.executeQuery(sql);stmt.close();conn.close();}catch(SQLExceptionex){System.err

5、.println("aq.executeQuery:"+ex.getMessage());}}//关闭对象publicvoidcloseStmt(){try{stmt.close();}catch(SQLExceptionex){System.err.println("aq.executeQuery:"+ex.getMessage());}}publicvoidcloseConn(){try{conn.close();}catch(SQLExceptionex){System.err.println("aq.executeQuery:"+

6、ex.getMessage());}}}“list.jsp”<%@pagecontentType="text/html"pageEncoding="UTF-8"%><%@pageimport="java.sql.*"%>

7、n"/><%!Stringurl,sql;%><%!inti;%>学籍管理系统