1.导入相关jar包
2.新建连接通过配置文件方式(传统方式)
driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/bookdb?useUnicode=true&characterEncoding=UTF8&serverTimezone=UTC username=root password=123456
public class Main {
public static void main(String[] args) {
Main main1=new Main();
main1.getConn();
}
public void getConn() {
Connection connection=null;
try {
//1.加载配置文件将配置文件加载到Properties对象中
Properties pro=new Properties();
InputStream resourceAsStream = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
pro.load(resourceAsStream);
//2.通过工厂方式创建连接池,将值交给连接池
DataSource dataSource = DruidDataSourceFactory.createDataSource(pro);
//3.建立连接
connection = dataSource.getConnection();
System.out.println(connection);
} catch (Exception e) {
e.printStackTrace();
}finally {
if (connection!=null){
try {
connection.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
}
3.新建连接通过配置文件方式(优化方式)
由于新建连接池只需要建立一个,避免冗余采用静态代码块方式建立连接和关闭工具类。
public class Utils_Connection {
private static DataSource dataSource;
static {
try {
//由于只需要创建一个数据库连接池
Properties properties=new Properties();
properties.load(ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties"));
dataSource = DruidDataSourceFactory.createDataSource