From 4d32a9903a11f33cf0e14da25f1e7286b50258f6 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 27 七月 2021 16:08:31 +0800
Subject: [PATCH] V1.63 edit at date 2021-07-27 1.表'db_ram_db.tb_fbs9100_setparam'新增恒流参数字段
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 33 +++++++++++++++++++++++++++++++++
1 files changed, 33 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index 97a5f79..960019b 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -60,6 +60,7 @@
createLicense_Table(pool, recreate); //创建超级用户表以及添加vip用户
+ createDatabase_Backup_Table(pool, recreate); //创建数据库备份表
}
@@ -1025,6 +1026,36 @@
}
/**
+ * 创建数据库备份表 web_site.tb_database_backup
+ */
+ public static void createDatabase_Backup_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Database_Backup_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS "+Sql_Mysql.Database_Backup_Table+" (" +
+ " `num` int(11) NOT NULL AUTO_INCREMENT," +
+ " `database_name` varchar(64) NOT NULL," +
+ " `table_name` varchar(64) NOT NULL," +
+ " `backup_en` int(11) NOT NULL DEFAULT '0'," +
+ " `backup_flag` int(11) NOT NULL DEFAULT '0'," +
+ " `note` varchar(64) NOT NULL DEFAULT '保留'," +
+ " PRIMARY KEY (`num`)" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;" +
+ "";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(true == recreate) {
+ //sql.sqlMysqlExecute(sql_str01);
+ //sql.sqlMysqlExecute(sql_str02);
+ }
+ sql.sqlMysqlExecute(sql_str02); //创建基站故障表
+
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
+ /**
* 创建电池组更换记录表
*/
public static void createBattReplace_Table(MysqlConnPool pool, boolean recreate) {
@@ -1244,6 +1275,8 @@
}
+
+
public static void main(String[] args) {
MysqlConnPool pool = new MysqlConnPool("123.207.82.239", 3360, 10);
DB_web_site website = new DB_web_site();
--
Gitblit v1.9.1