Java 关于数据库连接(Druid)的连接
3个jar的包
①:druid-1.0.9.jar
②: mchange-commons-java-0.2.12.jar
③:mysql-connector-java-8.0.25.jar
一个配置文件:
名字:druid.properties
driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/wangbaguanli
#?useUnicode=true&characterEncoding=utf-8&userSSL=false&serverTimezone=GMT%2B8
username=root
password=1363435208
# 初始化连接数量
initialSize=5
# 最大连接数
maxActive=10
# 最大超时时间
maxWait=3000
测试连接是否成功:
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;
public class One {
public static void main(String[] args) throws Exception {
Properties pro=new Properties();
InputStream resourceAsStream = One.class.getClassLoader().getResourceAsStream("druid.properties");
pro.load(resourceAsStream);
DataSource dataSource = DruidDataSourceFactory.createDataSource(pro);
Connection connection = dataSource.getConnection();
System.out.println(connection);
}
}
嗯,就是这样,没错