学习博客：druid德鲁伊线程池的使用

没什么说的，其实就是正常的获取连接部分变成了德鲁伊下的jar包帮助我们获取，然后提供了线程池

package cn.zsp2.util;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import org.junit.Test;

import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class JDBCUtils {
    private static DataSource ds ;
    static{

        try {
            Properties pro =new Properties();
            InputStream is =
                    ClassLoader.getSystemClassLoader().getResourceAsStream(
                    "druid" +
                    ".properties");
            pro.load(is);
            ds = DruidDataSourceFactory.createDataSource(pro);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public  static Connection getConnection() throws Exception {


        Connection conn = ds.getConnection();
        return conn;
    }
    public static  void  closeResource(Connection connection, Statement pre)
    {
        try {
            if(pre!=null)
                pre.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

        try {
            if(connection!=null)
                connection.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
    public static  void  closeResource(Connection connection,
                                       Statement pre, ResultSet rs)
    {
        try {
            if(pre!=null)
                pre.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        try {
            rs.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        try {
            if(connection!=null)
                connection.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }

}