database connection pool

数据库连接池

Druid为监控而生的数据库连接池,它是阿里巴巴开源平台上的一个项目.Druid是Java语言中最好的数据库连接池,Druid能够提供强大的监控和扩展功能.它可以替换DBCP和C3P0连接池.Druid提供了一个高效、功能强大、可扩展性好的数据库连接池.

作者：索伦x
链接：https://www.jianshu.com/p/6e01354213d8
来源：简书
著作权归作者所有.商业转载请联系作者获得授权,非商业转载请注明出处.
Database connections are large resource items,It can be uniformly provisioned by the database connection pool.
写一下Driud的入门
The first step is to importDruid的jar包.

import java.sql.Connection;
import java.util.Properties;

/** * Druid数据库连接池 */
public class DruidDemo1 {
    
    public static void main(String[] args) throws Exception {
    
        //1配置jar包

        //2加载配置文件
        Properties properties=new Properties();
        properties.load(new FileInputStream("jdbc-01\\src\\druid.properties"));//配置文件的相对路径
        //获取连接
        DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
        Connection connection = dataSource.getConnection();
        /** * 获取了connectionthen you can writesql操作数据库了 * 可以选择statement或者preparestatement来执行sql */
        System.out.println(connection);
        //The following can output the root path of the current project,From this you can know the relative path of the file
        System.out.println(System.getProperty("user.dir"));
    }
}

properties.load(new FileInputStream(“jdbc-01\src\druid.properties”));//配置文件的相对路径
This is my config file path.
看一下配置文件

driverClassName=com.mysql.jdbc.Driver//This is used to load the driver.
url,username,passwordis the same as before.