- 导入jar包
druid-1.0.9.jar
以及JDBC驱动jar包mysql-connector-java-5.1.37-bin.jar
- 定义配置文件
名称:任意名称.properties
路径:任意文件夹下
- 加载配置文件:类加载器
- 创建核心对象数据库连接池对象:通过工厂类
DruidDataSourceFactory
- 获取连接:
getconnection()
配置文件:
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/db03
username=root
password=root
initialSize=5
maxActive=10
maxWait=3000
使用:
package Druid;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;
public class DruidDemo01 {
public static void main(String[] args) throws Exception {
ClassLoader cl = DruidDemo01.class.getClassLoader();
InputStream file = cl.getResourceAsStream("druid.properties");
Properties pro = new Properties();
pro.load(file);
DataSource ds = DruidDataSourceFactory.createDataSource(pro);
Connection conn = ds.getConnection();
}
}