第讲 数据库编程.ppt

定义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; } 执行更新操作 public int executeUpdate(String sql) throws Exception { int result = 0; try { con = getCon(); stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); result = stmt.executeUpdate(sql); } catch (SQLException ex) { result = 0; } try { stmt.close(); } catch (SQLException ex1) { } return result; } 关闭数据库的连接 public void close() { try { if (rs != null) {rs.close();} } catch (Exception e) { e.printStackTrace(System.err); } try { if (stmt != null) {stmt.close();} } catch (Exception e) { e.printStackTrace(System.err); } try { if (con != null) {con.close();} } catch (Exception e) { e.printStackTrace(System.err); } } 应用方便、简单 public class TestConn { private ResultSet rs; private String sql="select id,name,classid from students"; public void getStudentInfo() throws Exception{ Conn con=new Conn(); rs=con.executeQuery(sql); while(rs.next()){ System.out.print(rs.getString(1)+"\t"); System.out.print(rs.getString(2)+"\t"); System.out.println(rs.getString(3)); } } public static void main(String[] args) { try { new TestConn().getStudentInfo(); } catch (Exception e) { e.printStackTrace(); } } } 注意 如果配置文件中有中文字符，在读取配置文件时会出错。 原因： Property文件中，使