SQLServer数据库连接（二）

属性文件连接数据库

public class DBConnection {
 private static ReadProperties readPro = null;

 // 加载驱动
 static {
  try {
   readPro = ReadProperties.getInstance();
   Class.forName(readPro.getProperty("driver"));
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
 }

 // 连接数据库
 public Connection getConnection() throws SQLException {
  return DriverManager.getConnection(readPro.getProperty("url"), readPro
    .getProperty("username"), readPro.getProperty("password"));
 }
 
 // 查询方法
 public Result excuteQuery(Connection con, String sql, Object[] params)
   throws SQLException {
  Result r = null;
  PreparedStatement pstmt = null;
  ResultSet rs = null;
  try {
   pstmt = con.prepareStatement(sql);
   for (int i = 0; i < params.length; i++) {
    pstmt.setObject(i + 1, params[i]);
   }
   rs = pstmt.executeQuery();
   r = ResultSupport.toResult(rs);
  } finally {
   pstmt.close();
   con.close();
  }
  return r;
 }

 // 增删改方法
 public int excuteUpdate(Connection con, String sql, Object[] params)
   throws SQLException {
  int num = 0;
  PreparedStatement pstmt = con.prepareStatement(sql);
  for (int i = 0; i < params.length; i++) {
   pstmt.setObject(i + 1, params[i]);
  }
  num = pstmt.executeUpdate();
  pstmt.close();
  con.close();
  return num;
 }
}