DBCP入门测试---写法

DBCP

DBCP数据库连接池的简单连接## 标题

package dbcp;

import org.apache.commons.dbcp2.BasicDataSource;

import java.sql.SQLException;
import java.util.Date;

/**
 * @author USER
 * @creat 2020-10-02 10:39
 */
public class DBCPDemo {
    public static void main(String[] args) {

        BasicDataSource basicDataSource = new BasicDataSource();

        basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
        basicDataSource.setUrl("jdbc:mysql://localhost:3310/msg");
        basicDataSource.setUsername("root");
        basicDataSource.setPassword("root");


        //最大连接数量
        basicDataSource.setMaxIdle(10);
        //初始化的时候,数据连接池中数据连接数量
        basicDataSource.setInitialSize(3);
        //连接池空闲状态下,最小的连接数量
        basicDataSource.setMinIdle(5);
        //最长等待的时间
        basicDataSource.setMaxWaitMillis(10000);


        try {
            System.out.println(basicDataSource.getConnection());
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

    }
}

1291113768, URL=jdbc:mysql://localhost:3306/msg, UserName=root@localhost, MySQL-AB JDBC Driver