JSP做的《在线售书系统》

package test; import java.sql.*; public class userlogin { String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String sConnStr = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=booksale"; Connection conn = null; ResultSet rs = null; int rs1; public userlogin() { try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e) { System.err.println("加载数据库驱动错误: " + e.getMessage()); } } public ResultSet executeQuery(String sql) { rs = null; try { conn = DriverManager.getConnection(sConnStr,"admin","123456"); Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println("执行SQL语句错误: " + ex.getMessage()); } return rs; } public int executeUpdate(String sql) { try { conn = DriverManager.getConnection(sConnStr,"admin","123456"); Statement stmt = conn.createStatement(); rs1=stmt.executeUpdate(sql); } catch(SQLException ex) { System.err.println("执行SQL语句错误: " + ex.getMessage()); } return rs1; } }