毕业设计源代码（人才招聘网站）

package com.bwm.db; import java.sql.*; public class Conn { private static Connection con; private Statement stmt; private ResultSet rs; private static final String drivername = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; private static final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=talentTable;user=sa;password=sa;"; //创建连接对象 public static synchronized Connection getCon() throws Exception { try { Class.forName(drivername);//反射机制 con = DriverManager.getConnection(url); return con; } catch (SQLException e) { System.err.println(e.getMessage()); throw e; } } public Statement getStmtread() { try { con = getCon();//获取数据库连接 //statement: 数据库结果集的数据表，通过执行查询数据库的语句生成 stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,//设置为可滚动的，CONCUR_READ_ONLY常量指示不可以更新的 ResultSet 对象的并发模式 ResultSet.CONCUR_READ_ONLY); return stmt; } catch (Exception e) { System.err.println(e.getMessage()); e.printStackTrace(); } return null; } //获取结果集 public ResultSet getRs(String sql) { try { stmt = getStmtread(); rs = stmt.executeQuery(sql);//执行查询数据库的语句 return rs; } catch (Exception e) { System.err.println(e.getMessage()); e.printStackTrace(); } return null; } public Statement getStmt() { try { con = getCon(); stmt = con.createStatement();//Statement 对象执行不带参数的 SQL 语句 return stmt; } catch (Exception e) { System.err.println(e.getMessage()); e.printStackTrace(); } return null; } public synchronized void close() { try { if (rs != null) { rs.close(); rs = null; } } catch (Exception e) { System.err.println(e.getMessage()); e.printStackTrace(); } try { if (stmt != null) { stmt.close(); stmt = null; } } catch (Exception e) { System.err.println(e.getMessage()); e.printStackTrace(); } try { if (con != null) { con.close(); con = null; } } catch (Exception e) { System.err.println(e.getMessage()); e.printStackTrace(); } } }