Java：DBHelper

package com.happy.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * 连接帮助类
 *
 * @author Happy
 *
 */
public class DBHelper {
 /**
  * 得到数据库连接
  *
  * @return
  */
 public static Connection getConn() {
  Read read = new Read();
  Connection conn = null;
  try {
   Class.forName(read.readProperties("DriverName")).newInstance();
   conn = DriverManager.getConnection(read.readProperties("ConnUrl"),
     read.readProperties("UserName"), read.readProperties("Password"));
  } catch (Exception e) {
   e.printStackTrace();
  }
  return conn;
 }

 /**
  * 关闭数据库连接
  *
  * @param conn
  */
 public static void closeAll(Connection conn) {
  if (null != conn) {
   try {
    conn.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
 }

 /**
  * 关闭数据库连接
  *
  * @param conn
  */
 public static void closeAll(Connection conn, PreparedStatement ps) {
  if (null != ps) {
   try {
    ps.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  DBHelper.closeAll(conn);
 }
 
 /**
  * 关闭数据库连接
  *
  * @param conn
  */
 public static void closeAll(Connection conn, ResultSet rs) {
  if (null != rs) {
   try {
    rs.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  DBHelper.closeAll(conn);
 }

 /**
  * 关闭数据库连接
  *
  * @param conn
  */
 public static void closeAll(Connection conn, PreparedStatement ps,
   ResultSet rs) {
  if (null != rs) {
   try {
    rs.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  DBHelper.closeAll(conn, ps);
 }
}