该分支是连接MySQL8.X初始化

DELL

2024-09-25 31bdd44a249bf026dcb75edc938740ef13e1b57f

该分支是连接MySQL8.X初始化

 BattMonitor_DB_Builder/.classpath

@@ -1,25 +1,25 @@
<?xml version="1.0" encoding="UTF-8"?>
<classpath>
    <classpathentry kind="src" path="src"/>
    <classpathentry exported="true" kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/JavaSE-1.8"/>
    <classpathentry kind="lib" path="lib/aopalliance-1.0.jar"/>
    <classpathentry kind="lib" path="lib/c3p0-0.9.5.jar"/>
    <classpathentry kind="lib" path="lib/c3p0-oracle-thin-extras-0.9.5.jar"/>
    <classpathentry kind="lib" path="lib/dom4j-1.6.1.jar"/>
    <classpathentry kind="lib" path="lib/ftplet-api-1.0.6.jar"/>
    <classpathentry kind="lib" path="lib/ftpserver-core-1.0.6.jar"/>
    <classpathentry kind="lib" path="lib/jcl-over-slf4j-1.5.2.jar"/>
    <classpathentry kind="lib" path="lib/jconn3.jar"/>
    <classpathentry kind="lib" path="lib/jxl.jar"/>
    <classpathentry kind="lib" path="lib/log4j-1.2.14.jar"/>
    <classpathentry kind="lib" path="lib/mchange-commons-java-0.2.9.jar"/>
    <classpathentry kind="lib" path="lib/mina-core-2.0.4.jar"/>
    <classpathentry kind="lib" path="lib/mysql-connector-java-5.1.30-bin.jar"/>
    <classpathentry kind="lib" path="lib/slf4j-api-1.5.2.jar"/>
    <classpathentry kind="lib" path="lib/slf4j-log4j12-1.5.2.jar"/>
    <classpathentry kind="lib" path="lib/spring-beans-2.5.5.jar"/>
    <classpathentry kind="lib" path="lib/spring-context-2.5.5.jar"/>
    <classpathentry kind="lib" path="lib/spring-core-2.5.5.jar"/>
    <classpathentry kind="lib" path="lib/sqljdbc4.jar"/>
    <classpathentry kind="output" path="bin"/>
</classpath>
<?xml version="1.0" encoding="UTF-8"?>

<classpath>

    <classpathentry kind="src" path="src"/>

    <classpathentry exported="true" kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/JavaSE-1.8"/>

    <classpathentry kind="lib" path="lib/aopalliance-1.0.jar"/>

    <classpathentry kind="lib" path="lib/c3p0-0.9.5.jar"/>

    <classpathentry kind="lib" path="lib/c3p0-oracle-thin-extras-0.9.5.jar"/>

    <classpathentry kind="lib" path="lib/dom4j-1.6.1.jar"/>

    <classpathentry kind="lib" path="lib/ftplet-api-1.0.6.jar"/>

    <classpathentry kind="lib" path="lib/ftpserver-core-1.0.6.jar"/>

    <classpathentry kind="lib" path="lib/jcl-over-slf4j-1.5.2.jar"/>

    <classpathentry kind="lib" path="lib/jconn3.jar"/>

    <classpathentry kind="lib" path="lib/jxl.jar"/>

    <classpathentry kind="lib" path="lib/log4j-1.2.14.jar"/>

    <classpathentry kind="lib" path="lib/mchange-commons-java-0.2.9.jar"/>

    <classpathentry kind="lib" path="lib/mina-core-2.0.4.jar"/>

    <classpathentry kind="lib" path="lib/slf4j-api-1.5.2.jar"/>

    <classpathentry kind="lib" path="lib/slf4j-log4j12-1.5.2.jar"/>

    <classpathentry kind="lib" path="lib/spring-beans-2.5.5.jar"/>

    <classpathentry kind="lib" path="lib/spring-context-2.5.5.jar"/>

    <classpathentry kind="lib" path="lib/spring-core-2.5.5.jar"/>

    <classpathentry kind="lib" path="lib/sqljdbc4.jar"/>

    <classpathentry kind="lib" path="lib/mysql-connector-java-8.0.28.jar"/>

    <classpathentry kind="output" path="bin"/>

</classpath>


 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -1,4 +1,4 @@
蓄电池监控平台建表程序
蓄电池监控平台建表程序   -  连接MySQL 8.X 数据库初始化
    注意:1.新增电源机房时需要重新运行
    
    

 BattMonitor_DB_Builder/lib/mysql-connector-java-8.0.28.jar

Binary files differ

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java

@@ -5,7 +5,7 @@
import java.util.Date;

import com.base.Com;
import com.mysql.jdbc.UpdatableResultSet;

import com.sql.MysqlConnPool;
import com.sql.Sql_Mysql;


 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;


 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,4 +1,4 @@
蓄电池监控平台建表程序
蓄电池监控平台建表程序   -  连接MySQL 8.X 数据库初始化
    注意:1.新增电源机房时需要重新运行