From b57bfd9d4d1ab6e2de15eff090f6efdbe49c65ce Mon Sep 17 00:00:00 2001
From: LiJun <LiJun@192.168.10.18>
Date: 星期五, 02 十一月 2018 17:07:35 +0800
Subject: [PATCH] 修改底层建表程序建表语句
---
BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java | 49 ++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 48 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java b/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java
index 5dd09fa..04cc4fd 100644
--- a/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java
+++ b/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java
@@ -260,7 +260,7 @@
ResultSet rs = null;
try {
rs= sql.sqlMysqlQuery(sql_str1);
- System.out.println(sql_str1);
+ //System.out.println(sql_str1);
boolean hasInsertStation = false;;
while(rs.next()) {
int dev_id = rs.getInt("FBSDeviceId");
@@ -282,4 +282,51 @@
sql.close_con();
}
}
+
+ /**
+ * 创建设备的系统参数表
+ * @param con_pool
+ * @param recreate_tb
+ */
+ public static void createFBS9100SysParam_TableOnRam(MysqlConnPool con_pool,boolean recreate_tb) {
+ String sql_str0 = "DROP TABLE IF EXISTS " + Sql_Mysql.FBS9100SysParam_Table + "; ";
+ String sql_str1 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100SysParam_Table
+ + " ( `num` BIGINT NOT NULL AUTO_INCREMENT, "
+ + "`dev_ip` varchar(20) NOT NULL DEFAULT '127.0.0.0', "
+ + "`dev_id` BIGINT NOT NULL DEFAULT 0, "
+ + "`op_cmd` INT NOT NULL DEFAULT 0, "
+ + "`IPADDR` varchar(20) NOT NULL DEFAULT '127.0.0.0', "
+ + "`SubIPADDR` varchar(20) NOT NULL DEFAULT '127.0.0.0', "
+ + "`NetGateADDR` varchar(20) NOT NULL DEFAULT '127.0.0.0', "
+ + "`GroupVolRange` INT NOT NULL DEFAULT 0, "
+ + "`GroupVolSorce` INT NOT NULL DEFAULT 0, "
+ + "`CurrentRange` INT NOT NULL DEFAULT 0, "
+ + "`CurrentTyte` INT NOT NULL DEFAULT 0, "
+ + "`MonomerOrder` INT NOT NULL DEFAULT 0, "
+ + "`BackLightTime` INT NOT NULL DEFAULT 0, "
+ + "`MACADDR` varchar(30) NOT NULL DEFAULT '0.0.0.0.0.0', "
+ + "`LoaderCount` INT NOT NULL DEFAULT 0, "
+ + "`DtCardCount` INT NOT NULL DEFAULT 0, "
+ + "`PowerBreakChargeCurr` FLOAT NOT NULL DEFAULT 0, "
+ + "`MajorBattGroupNum` INT NOT NULL DEFAULT 0, "
+ + "`POF_BG_Boost_Cnt` INT NOT NULL DEFAULT 0, "
+ + "`POF_BG_Boost_VolStop` FLOAT NOT NULL DEFAULT 0, "
+ + "`POF_BG_Boost_VolStart` FLOAT NOT NULL DEFAULT 0, "
+ + " UNIQUE INDEX index_dev_id_uniq (`dev_id`), "
+ + " PRIMARY KEY (`num`) ) "
+ + " ENGINE=MEMORY DEFAULT CHARSET=utf8";
+ Sql_Mysql sql = new Sql_Mysql(con_pool.getConn());
+ try {
+ if(true == recreate_tb) {
+ sql.sqlMysqlExecute(sql_str0);
+ } else {
+ //sql.sqlMysqlExecute("DELETE FROM " + Sql_Mysql.FBS9100SysParam_Table);
+ }
+ sql.sqlMysqlExecute(sql_str1);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
}
--
Gitblit v1.9.1