一个jsp做的考试系统

package sys; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DB { public Connection getConnection() { Connection con = null; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String connectionUrl = "jdbc:sqlserver://localhost:1433;"+"databaseName=dexam;user=sa;password=142232;"; con = DriverManager.getConnection(connectionUrl); } catch (Exception e) { System.out.print(e.toString()+"\n"); System.out.println("数据库连接错误，请检查设置"); } return con; } //查找数据 public ResultSet getResultSet(String sql,Connection con) throws SQLException { Statement stmt = null; ResultSet rs = null; try { stmt = con.createStatement(); rs = stmt.executeQuery(sql); } catch (Exception e) { System.out.print(e.toString()+"\n"+"取得结果记录集出错"); } return rs; } //增删改数据 public Boolean updateData(String updateString,Connection con) { Statement stmt = null; try { stmt = con.createStatement(); stmt.executeUpdate(updateString); return true; } catch (Exception e) { // TODO: handle exception return false; } } }