使用JavaBean连接数据库.doc

JSP+JavaBean 1、JavaBean类1、显示学生信息内容JavaBeanpackage com.DataBase;import java.sql.*;public class MyDbBean private Statement stmt = null; ResultSet rs = null; private Connection conn = null; private String dsn; /构造函数 public MyDbBean() /根据dsn参数，加载驱动程序，建立连接 public void getConn(String dbname, String uid, String pwd) throws Exception try dsn = jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName= +dbname; Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver).newInstance(); conn = DriverManager.getConnection(dsn, uid, pwd); catch (Exception ex) System.err.println(aq.executeQuery: + ex.getMessage(); /执行查询类的SQL语句，有返回集 public ResultSet executeQuery1(String sql) rs = null; try stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery(sql); catch(SQLException ex) System.err.println(aq.executeQuery:+ex.getMessage(); return rs; /执行更新类的SQL语句，无返回集 public void executeUpdate2(String sql) stmt = null; rs=null; try stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); stmt.executeQuery(sql); stmt.close(); conn.close(); catch(SQLException ex) System.err.println(aq.executeQuery: + ex.getMessage(); /关闭对象 public void closeStmt() try stmt.close(); catch(SQLException ex) System.err.println(aq.executeQuery: + ex.getMessage(); public void closeConn() try conn.close(); catch(SQLException ex) System.err.println(aq.executeQuery: + ex.getMessage(); “list.jsp” 学籍管理系统 学籍管理系统 学号 姓名 性别 年龄 籍贯 院系 更改 删除 a href=change.jsp?xuehao=修改 a href=del.jsp?xuehao=删除 添加新记录 2、添加记录“insert.jsp” 添加记录 添加新记录 学号     姓名     性别     男 女 年龄     籍贯     院系         “query.jsp” 插入数据 0) response.sendRedirect(err.jsp); sql=insert into stuInfo(学号,姓名,性别,年龄,籍贯,院系); sql=sql+values(+xuehao+,+name+,+sex+,+i+,+jiguan+,+department+); query.executeUpdate2(sql); out.println(正在处理信息，请稍后.); rs.close(); query.closeStmt(); query.closeConn(); % 3、更改记录“change.jsp” 修改记录 修改记录 form name=form1 method=post action=change_query.jsp?xuehao= 学号     姓名     input type=text name=name size=8 value= 性别    男 女 男 女 年龄     input type=text name=age size=2 value= 籍贯     input type=text name=jiguan size=8 value= 院系     input type=text name=department size=8 value=     “change_query.jsp” 修改记录 % xuehao=request.getParameter(xuehao).trim(); out.print(xuehao); name=request.getParameter(name).trim(); name=new String(name.getBytes(ISO-8859-1),UTF-8); sex=request.getParameter(sex).trim(); sex=new String(sex.getBytes(ISO-8859-1),UTF-8); age=request.getParameter(age).trim(); i=Integer.parseInt(age); jiguan=request.getParameter(jiguan).trim(); jiguan=new String(jiguan.getBytes(ISO-8859-1),UTF-8); department=request.getParameter(department).trim(); department=new String(department.getBytes(ISO-8859-1),UTF-8); if(name.equals() response.sendRedirect(err1.jsp); try /调用getConn()方法与数据库建立连接 modify.getConn(Data_Stu,sa,); sql=update stuInfo set 姓名= +name+,性别= +sex+,年龄=+i+,籍贯= +jiguan+,院系= +department+ where 学号= +xuehao+; modify.executeUpdate2(sql); out.println(正在修改记录，请稍后.); modify.closeStmt(); modify.closeConn(); catch(Exception e) response.sendRedirect(err.jsp); % 4、删除记录“del.jsp” 删除记录 % xuehao=request.getParameter(xuehao).trim(); try /调用getConn()方法与数据库建立连接 del.getConn(Data_Stu,sa,); sql=delete from stuInfo where 学号=+xuehao+; del.executeUpdate2(sql); out.println(正在删除数据，请稍后. +); del.closeStmt(); del.closeConn(); catch(Exception e) response.sendRedirect(err.jsp); % JSP+ Servlet 访问数据库无标题文档 客户查询 请输入用户名：   根据 总数查询 总数范围在 和 之间  package tree;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class query extends HttpServlet private static final String CONTENT_TYPE = text/html; charset=GB2312; /Initialize global variables public void init() throws ServletException super.init(); /执行HTTP Post请求 public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException PrintWriter out=response.getWriter(); response.setContentType(CONTENT_TYPE);/设置响应的MIME类型。 out.print(); out.print(); /获得客户端用Post方法传来的数据String USERNAME=request.getParameter(USERNAME); System.out.println(USERNAME); String PASSWORD=null; String TOTAL=null; String REALNAME=null; String NUMBER=null; Connection con=null; Statement stmt=null; ResultSet rs=null; try Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); catch(ClassNotFoundException e)e.printStackTrace(); try con=DriverManager.getConnection(jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=pubs,sa,); stmt=con.createStatement(); String sql=Select * from GUEST where USERNAME like +USERNAME+; rs=stmt.executeQuery(sql); out.print(); out.print(); out.print(+NUMBER); out.print(+USERNAME); out.print(+PASSWORD); out.print(+TOTAL); out.print(+REALNAME); out.print(); /循环将结果集显示while(rs.next() out.print(); NUMBER=rs.getString(NUM); out.print(+NUMBER+); USERNAME=rs.getStrin