public class JdbcUtils {
private static final Logger logger = LoggerFactory.getLogger(JdbcUtils.class);
private static DataSource dataSource = null;
public static synchronized Connection getConnection(String url, String userName, String password){
if (null == dataSource){
try {
Map<String, Object> propertiesMap = new HashMap<>();
propertiesMap.put("driverClassName", "com.mysql.jdbc.Driver");
propertiesMap.put("url", url+"?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC");
propertiesMap.put("username", userName);
propertiesMap.put("password", password);
propertiesMap.put("initialSize","1");
propertiesMap.put("minIdle","1");
propertiesMap.put("maxActive","10");
propertiesMap.put("maxWait","10000");
propertiesMap.put("timeBetweenEvictionRunsMillis","60000");
propertiesMap.put("minEvictableIdleTimeMillis","300000");
dataSource = DruidDataSourceFactory.createDataSource(propertiesMap);
} catch (Exception e) {
logger.info("[jdbc] getCollection error:{}",e);
}
}
Connection conn = null;
try {
conn = dataSource.getConnection();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return conn;
}
}
jdbc数据库连接池怎么配
于 2022-02-26 19:54:56 首次发布