mysql线程池

mysql依赖

   <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>

配置文件 db.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://192.168.232.211:3306/school
user = root
password=ok

public class FinalFields {
    public static final String MYSQL_DRIVER_STR="driver";
    public static final String MYSQL_USER_STR="user";
    public static final String MYSQL_URL_STR="url";
    public static final String MYSQL_PWD_STR="password";
}

加载配置文件

import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;

public class PropUtils {
    public static Properties getProperties(String profileName) throws IOException {
        //加载resource文件里的db.properties
        ClassLoader classLoader = PropUtils.class.getClassLoader();
        InputStream is = classLoader.getResourceAsStream(profileName);
        Properties props = new Properties();
        props.load(is);
        return props;
    }
}

建立Connection对象

import java.io.IOException;
import java.sql.*;
import java.util.Properties;

/**
 * 获取数据库连接对象 Connection
 */
public class Mysql {
    private static String driver;
    private static String url;
    private static String user;
    private static String password;
    static {
        Properties props = null;
        try {
            props = PropUtils.getProperties("db.properties");
        } catch (IOException e) {
            e.printStackTrace();
        }
        driver=props.getProperty(FinalFields.MYSQL_DRIVER_STR);
        url=props.getProperty(FinalFields.MYSQL_URL_STR);
        user=props.getProperty(FinalFields.MYSQL_USER_STR);
        password=props.getProperty(FinalFields.MYSQL_PWD_STR);
    }

    public static Connection getConnection(){
        System.out.println(driver);
        Connection connection = null;
        try {
            Class.forName(driver);//加载驱动
            connection = DriverManager.getConnection(url, user, password);
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }
        return connection;
    }
    //释放资源
    public static void close(Connection conn, PreparedStatement psmt, ResultSet rs){
        if (rs!=null){
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (psmt!=null) {
            try {
                psmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (conn!=null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    public static void main(String[] args) {
        Connection connection = Mysql.getConnection();
        System.out.println(connection);
        Mysql.close(connection,null,null);
    }
}

package nj.zb.kb11;

import java.sql.Connection;
import java.util.LinkedList;


public class MysqlConnectionPool {
    private Integer initNum = 5; //初始化时Connection的数量
    private Integer increase = 5; // 每次获取Connection对象的数量
    private Integer min = 3;      // 允许连接池中拥有Connection对象的最小数量
    private Integer max = 20;     //  允许连接池中拥有Connection对象的最大数量

    private Byte b = 1;   // 同步锁
    private boolean xiaoguogo = false;  // false 小谷在家  true 小谷出去取Connection对象去了


    // 用于存放Connection对象
    private LinkedList<Connection> pool = new LinkedList<>();

    private void produceConnection(Integer num) {
        for (int i = 0; i < num; i++) {
            if(!checkPoolMaxNum()){
                xiaoguogo = false;
                pool.add(JDBCUtils.getConnection());
            }
        }
    }

    private boolean checkPoolMaxNum() {
        if (pool.size() > max) {
            return true;
        } else {
            return false;
        }
    }

    private MysqlConnectionPool() {
        produceConnection(initNum);
    }

    /**
     * 查询连接池Connection对象的数量
     *
     * @return
     */
    public Integer count() {
        return pool.size();
    }


    public Connection getConnection() {
//        pool.get(0);
//        pool.getFirst();
        synchronized (b) {
            while (pool.size() == 0) {
                System.out.println("warning, 连接池没有连接。。。。。。");
                try {
                    Thread.sleep(100);
                } catch (InterruptedException e) {
                    e.printStackTrace();
                }
            }
            if (pool.size() <= min && !xiaoguogo) {   // 3
                xiaoguogo = true;
                new Thread(new Runnable() {
                    @Override
                    public void run() {
                        produceConnection(increase);
                    }
                }).start();
            }
            return pool.pop();
        }
    }

    public void close(Connection conn) {
        synchronized (b) {
            if (conn == null) {
                return;
            } else {
                if (checkPoolMaxNum()) {
                    JDBCUtils.close(conn);
                } else {
                    pool.add(conn);
                }
            }
        }
    }


//   懒汉模式
//    private static MysqlConnectionPool poolInstance=null;
//    public static MysqlConnectionPool getPoolInstance(){
//        if(poolInstance==null){
//            poolInstance = new MysqlConnectionPool();
//        }
//        return poolInstance;
//    }

    //  饿汉模式
    private static MysqlConnectionPool poolInstance2 = new MysqlConnectionPool();

    public static MysqlConnectionPool getPoolInstance() {
        return poolInstance2;
    }


}