mysql连接池

来源：互联网发布：java项目的难点和亮点编辑：程序博客网时间：2024/05/10 13:12
package pack;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.LinkedList;class ConnectionSrc {    private static String url = "jdbc:mysql://localhost:3306/test";    private static String user = "root";    private static String password = "111111";    private LinkedList<Connection> connectionPool = new LinkedList<Connection>();    private Connection createCollection() throws SQLException {        return DriverManager.getConnection(url, user, password);    }    public ConnectionSrc() throws SQLException {        for(int i = 0; i<5; i++)            connectionPool.addLast(this.createCollection());    }    public Connection getConnection() {        return connectionPool.removeFirst();    }    public void free(Connection conn) {        connectionPool.addLast(conn);    }}public class Main {    public static void main(String[] args) throws SQLException, ClassNotFoundException {        Class.forName("com.mysql.jdbc.Driver");        ConnectionSrc cs = new ConnectionSrc(); //建5个连接        for(int i = 0; i<10; i++) {   //取10个连接，会重用            Connection conn = cs.getConnection();            System.out.println(conn);            cs.free(conn);        }    }}
0 0