From 31bdd44a249bf026dcb75edc938740ef13e1b57f Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期三, 25 九月 2024 15:54:53 +0800
Subject: [PATCH] 该分支是连接MySQL8.X初始化
---
BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java b/BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java
index 1cbd0fb..5303ed4 100644
--- a/BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java
+++ b/BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java
@@ -12,7 +12,7 @@
public MysqlConnPool(String server_ip, int port, int conncount_max)
{
try {
- init(server_ip, port, conncount_max);
+ initMySQL8(server_ip, port, conncount_max);
} catch (PropertyVetoException e) {
e.printStackTrace();
}
@@ -29,6 +29,18 @@
mysql_ds.setMinPoolSize(2);
mysql_ds.setIdleConnectionTestPeriod(60);
}
+ public void initMySQL8(String server_ip, int port, int conncount_max) throws PropertyVetoException
+ {
+ mSqlPort = port;
+ mysql_ds.setDriverClass("com.mysql.cj.jdbc.Driver");
+ mysql_ds.setJdbcUrl("jdbc:mysql://" + server_ip + ":" + mSqlPort + "?useSSL=false&serverTimezone=UTC");
+ mysql_ds.setUser("root");
+ mysql_ds.setPassword("lmx8688139");
+ //mysql_ds.setPassword("Dongli&12345678"); //清远电信数据库密码修改
+ mysql_ds.setMaxPoolSize(conncount_max);
+ mysql_ds.setMinPoolSize(2);
+ mysql_ds.setIdleConnectionTestPeriod(60);
+ }
public Connection getConn()
{
Connection con = null;
--
Gitblit v1.9.1