From 1ca2ea6eacb2614161da0aef416c726a3c4ca400 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期五, 27 九月 2024 15:16:03 +0800
Subject: [PATCH] Linux 需手动创建账号 CREATE USER 'whyc'@'localhost' IDENTIFIED BY 'Fg001@hdw'; GRANT ALL PRIVILEGES ON *.* TO 'whyc'@'localhost'; FLUSH PRIVILEGES;
---
BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java | 103 +++++++++++++++++++++++++++++----------------------
1 files changed, 58 insertions(+), 45 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java b/BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java
index d719fd0..5303ed4 100644
--- a/BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java
+++ b/BattMonitor_DB_Builder/src/com/sql/MysqlConnPool.java
@@ -1,45 +1,58 @@
-package com.sql;
-import java.beans.PropertyVetoException;
-import java.sql.Connection;
-import java.sql.SQLException;
-
-import com.mchange.v2.c3p0.ComboPooledDataSource;
-
-public class MysqlConnPool {
- private ComboPooledDataSource mysql_ds = new ComboPooledDataSource();
- private int mSqlPort = 5306;
-
- public MysqlConnPool(String server_ip, int port, int conncount_max)
- {
- try {
- init(server_ip, port, conncount_max);
- } catch (PropertyVetoException e) {
- e.printStackTrace();
- }
- }
- public void init(String server_ip, int port, int conncount_max) throws PropertyVetoException
- {
- mSqlPort = port;
- mysql_ds.setDriverClass("com.mysql.jdbc.Driver");
- mysql_ds.setJdbcUrl("jdbc:mysql://" + server_ip + ":" + mSqlPort);
- mysql_ds.setUser("root");
- mysql_ds.setPassword("lmx8688139");
- mysql_ds.setMaxPoolSize(conncount_max);
- mysql_ds.setMinPoolSize(2);
- mysql_ds.setIdleConnectionTestPeriod(60);
- }
- public Connection getConn()
- {
- Connection con = null;
- try {
- con = mysql_ds.getConnection();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return con;
- }
-
- public int getSqlConnPort() {
- return mSqlPort;
- }
-}
+package com.sql;
+import java.beans.PropertyVetoException;
+import java.sql.Connection;
+import java.sql.SQLException;
+
+import com.mchange.v2.c3p0.ComboPooledDataSource;
+
+public class MysqlConnPool {
+ private ComboPooledDataSource mysql_ds = new ComboPooledDataSource();
+ private int mSqlPort = 5306;
+
+ public MysqlConnPool(String server_ip, int port, int conncount_max)
+ {
+ try {
+ initMySQL8(server_ip, port, conncount_max);
+ } catch (PropertyVetoException e) {
+ e.printStackTrace();
+ }
+ }
+ public void init(String server_ip, int port, int conncount_max) throws PropertyVetoException
+ {
+ mSqlPort = port;
+ mysql_ds.setDriverClass("com.mysql.jdbc.Driver");
+ mysql_ds.setJdbcUrl("jdbc:mysql://" + server_ip + ":" + mSqlPort);
+ 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 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;
+ try {
+ con = mysql_ds.getConnection();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ return con;
+ }
+
+ public int getSqlConnPort() {
+ return mSqlPort;
+ }
+}
--
Gitblit v1.9.1