1.导入mysql驱动jar包
mysql-connector-java-8.0.11.jar
2.导入Druidjar驱动jar包
druid-1.1.10.jar
3.创建测试类 (DruidTest)
public class DruidTest {
@Test
public void getConnection() {
Connection conn = null;
try {
//1.读取配置文件
Properties pros = new Properties();
InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
pros.load(is);
//2.创建数据库连接池
DataSource source = DruidDataSourceFactory.createDataSource(pros);
//3.获取连接
conn = source.getConnection();
System.out.println(conn);
} catch (Exception e) {
e.printStackTrace();
}finally {
//4.关闭连接
try {
if (conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
- 其中配置文件如下(druid.properties):
-
url=jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC username=root password=root driverClassName=com.mysql.cj.jdbc.Driver
相关的jar包:https://pan.baidu.com/s/113p7lCqcuf19uC9mINvMbA
提取码:59dt