第12讲 数据库编程.pptVIP

定义Connection的方法 // 获取数据库连接方法 public Connection getCon() throws Exception { try { Class.forName(drivername); con = DriverManager.getConnection(url, user, pass); return con; } catch (SQLException e) { System.err.println(e.getMessage()); throw e; } 定义ResultSet 方法 public ResultSet executeQuery(String sql) throws Exception { try { con = getCon(); stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery(sql); } catch (SQLException ex) { System.err.println(ex.getMessage()); } return rs; } 执行更新操