JDBC工具类

public class JDBCUtil {
 private static Properties prop = new Properties();
 private static ThreadLocal<Connection> tdl = new ThreadLocal<Connection>();
 static {
  InputStream is = null;
  try {
   is = JDBCUtil.class.getResourceAsStream("/jdbc_oracle.properties");
   prop.load(is);
   // 1.加载驱动
   Class.forName(prop.getProperty("driver"));
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   try {
    is.close();
   } catch (IOException e) {
    e.printStackTrace();
   }
  }
 }
 // 获取连接Connection
 public static Connection getConnection() throws Exception {
  Connection con = tdl.get();
  if (con == null) {
   // 2.建立连接
   con = DriverManager.getConnection(prop.getProperty("url"), prop.getProperty("username"),
     prop.getProperty("password"));
  }
  return con;
 }
 
 // 释放资源
 public static void close(ResultSet rs, PreparedStatement pstm, Connection con) throws Exception {
  if (rs != null)
   rs.close();
  if (pstm != null)
   pstm.close();
  if (con != null) {
   con.close();
   tdl.remove();
  }
 }
 // 释放资源
 public static void close(PreparedStatement pstm, Connection con) throws Exception {
  if (pstm != null)
   pstm.close();
  if (con != null) {
   con.close();
   tdl.remove();
  }
 }
}

jdbc_oracle.properties配置文件中的参数如下:

driver=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:xe
username=hr
password=hr