一定要有两个组件
https://www.lanzoux.com/b01i9ragh
密码:811i
附上蓝奏云链接,不限速
放在lib下,然后buildpath引入
src文件下
druid.properties内容
url=jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true
username=root
password=******************
driverClassName=com.mysql.cj.jdbc.Driver
!!!!!!!!!url / 的后面是连接的数据库名称
测试连接代码内容
package com.jdbc.qudong;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;
import javax.sql.DataSource;
import org.junit.Test;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
public class DruidTest {
@Test
public void getConnection() throws Exception {
Properties pros =new Properties();
InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
//FileInputStream is = new FileInputStream(new File("src/druid.properties"));
pros.load(is);
DataSource source = DruidDataSourceFactory.createDataSource(pros);
Connection conn = source.getConnection();
System.out.println(conn);
}
}
还没成功来联系我,或者给我留言
写文不易,求个赞赞!!!!!!