导入jar包
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.12</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.9</version>
</dependency>
配置 配置文件
在resources 目录下新建 druid.properties
driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/shangpinhoutai?serverTimezone=UTC&useSSL=false
username=root
password=123456
#初始化连接数量
initialSize=5
#最大连接数
maxActive=10
#最大等待时间
maxWait=3000
获取链接对象
// 加载配置文件
Properties properties = new Properties();
InputStream stream = ClassLoader.getSystemResourceAsStream("druid.properties");
properties.load(stream);
// 获取链接对象
DataSource ds= DruidDataSourceFactory.createDataSource(properties);
Connection connection= ds.getConnection();
System.out.println(connection);