package com.itheima.druid;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.FileInputStream;
import java.sql.Connection;
import java.util.Map;
import java.util.Properties;
/*Druid的数据库链接池演示*/
public class DruidDemo {
public static void main(String[] args) throws Exception {
//1.导入jar包
//2.定义配置文件
//3.加载配置文件
Properties prop = new Properties();
prop.load(new FileInputStream("src/druid.properties"));
//4、获取连接池对象
DataSource dataSource = DruidDataSourceFactory.createDataSource(prop);
//5.获取对应的数据库连接
Connection connection = dataSource.getConnection();
System.out.println(connection);
//System.out.println(System.getProperty("user.dir"));
}
}
下面这个是错误:
九月 11, 2023 6:36:38 下午 com.alibaba.druid.pool.DruidDataSource error
严重: init datasource error, url: "jdbc:mysql://localhost:3306db1?severTimezone=UTC&userSeverPrepStmts=true"
java.sql.SQLException: connect error, url "jdbc:mysql://localhost:3306db1?severTimezone=UTC&userSeverPrepStmts=true", driverClass com.mysql.cj.jdbc.Driver
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1737)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:924)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1403)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1399)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:100)
at com.itheima.druid.DruidDemo.main(DruidDemo.java:27)
【相关推荐】
猜测是数据库驱动与数据库不匹配导致无法正常连接,尤其是MySQL版本高于5.7.29以后需要8版本的驱动器
jdbc:mysql://localhost:3306db1?severTimezone=UTC&userSeverPrepStmts=true
写错了吧