用Druid德鲁伊数据库连接池方式连接MySQL8.0数据库
分别导入MySQL驱动和durid数据库连接池驱动
public void test1() throws Exception {
//读取配置文件druid.properties
InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
Properties pros = new Properties();
pros.load(is);
DataSource source = DruidDataSourceFactory.createDataSource(pros);
Connection conn = source.getConnection();
System.out.println(conn);
}
其中,src下的配置文件为:【druid.properties】
url=jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=Asia/Shanghai
driverClassName=com.mysql.cj.jdbc.Driver
username=root
password=123456
注:我连接的数据库是test