1,【工具类】
package Tools;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.FileInputStream;
import java.util.Properties;
import java.sql.*;
/**
* 数据库链接对象工具类
* 德鲁伊使用
*/
public class JDBCUtilsMe {
private static DataSource ds;
//在静态代码块完成 ds 初始化
static {
Properties properties = new Properties();
try {
properties.load(new
FileInputStream("src\\druid.properties"));
ds = DruidDataSourceFactory.createDataSource(properties);
} catch (Exception e) {
e.printStackTrace();
}
}
//编写 getConnection 方法
public static Connection getConnection() throws SQLException {
return ds.getConnection();
}
public static void close(ResultSet resultSet, Statement statement, Connection connection) {
try {
if (resultSet != null) {
resultSet.close();
}
if (statement != null) {
statement.close();
}
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}
2,【配置文件】
driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/emp?rewriteBatchedStatements=true
username=root
password=123456
# 初始连接大小
initialSize=10
# 最小空闲连接大小
minIdle=5
# 最大活动连接大小
maxActive=50
# 最大等待时间(5000ms)
maxWait=5000
3,【测试使用】
import Tools.JDBCUtilsMe;
import java.sql.SQLException;
public class TestDruid {
public static void main(String[] args) throws SQLException {
System.out.println("JDBCUtilsMe.getConnection() = " + JDBCUtilsMe.getConnection());
}
}