From 61b944654f948047a667d1fab85e85c76290901b Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期三, 11 十月 2023 15:59:09 +0800
Subject: [PATCH] 2.新增表'db_ram_db.tb_check_dialog' CREATE TABLE `tb_check_dialog` ( `num` bigint(20) NOT NULL AUTO_INCREMENT, `dev_id` int(64) NOT NULL DEFAULT '910000001', `test_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00', PRIMARY KEY (`num`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index 2149907..b309133 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -167,6 +167,7 @@
public final static String DEV60870_Inverter_Info = DB_RamDB + ".tb_dev_60870_inverter_info"; //电操开关遥测实时状态表
public final static String FBS9140_Topology_State = DB_RamDB + ".tb_fbs9140_topology_state"; //并联BTS拓扑状态信息
public final static String FBS9149_SetParam = DB_RamDB + ".tb_fbs9149_setparam"; //并联BTS9组参数表
+ public final static String Check_Dialog_Table = DB_RamDB + ".tb_check_dialog"; //充放电一体机离线检测表
/**************************** db_user数据库 ***************************************************/
@@ -1254,6 +1255,13 @@
sql.setQueryTimeout(60);
sql.execute(sql_str);
}
+ //执行sql语句
+ public void sqlMysqlTotalExecute(String sql_str) throws SQLException
+ {
+ Statement sql = mysql_con.createStatement();
+ sql.setQueryTimeout(5*60);
+ sql.execute(sql_str);
+ }
//在事物中执行多条sql语句
--
Gitblit v1.9.1