Druid连接池工具类

 1 package cn.zmh.PingCe;
 2 
 3 import com.alibaba.druid.pool.DruidDataSourceFactory;
 4 
 5 import javax.sql.DataSource;
 6 import java.sql.Connection;
 7 import java.sql.ResultSet;
 8 import java.sql.SQLException;
 9 import java.sql.Statement;
10 import java.util.Properties;
11 /**
12  * Druid连接池工具类
13  * */
14 public class JdbcUtils {
15     // 1 定义成员变量   DataSource
16     private static DataSource ds;
17     static{
18         // 2 加载配置文件   获得连接池
19         Properties p = new Properties();
20         try {
21             p.load(JdbcUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
22             ds = DruidDataSourceFactory.createDataSource(p);
23         } catch (Exception e) {
24             e.printStackTrace();
25         }
26     }
27     // 3 获得链接
28     public static Connection getConnection() throws SQLException {
29         return ds.getConnection();
30     }
31     // 4 释放资源
32     public static void close(Statement stat,Connection conn){
33         if(stat!=null){
34             try {
35                 stat.close();
36             } catch (SQLException e) {
37                 e.printStackTrace();
38             }
39         }
40         if(conn!=null){
41             try {
42                 conn.close();
43             } catch (SQLException e) {
44                 e.printStackTrace();
45             }
46         }
47     }
48     public static void close(ResultSet rs,Statement stat,Connection conn){
49         if(rs!=null){
50             try {
51                 rs.close();
52             } catch (SQLException e) {
53                 e.printStackTrace();
54             }
55         }
56         if(stat!=null){
57             try {
58                 stat.close();
59             } catch (SQLException e) {
60                 e.printStackTrace();
61             }
62         }
63         if(conn!=null){
64             try {
65                 conn.close();
66             } catch (SQLException e) {
67                 e.printStackTrace();
68             }
69         }
70     }
71     // 5 获得连接池
72     public static DataSource getDataSource(){
73         return ds;
74     }
75 }
配置文件后缀.properties