From 9ecd2bf82d543e86b12a10d8e33b0085111cdd1d Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期一, 06 十二月 2021 12:04:20 +0800
Subject: [PATCH] V1.95 edit at date 2021-12-6 1：新增`db_app_sys`.`tb_page_param2` 模板表创建并初始化数据,db_user.tb_user_inf表下添加字段
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 40 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 40 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
index 0430df5..16add9c 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
@@ -37,9 +37,49 @@
createTb_dashboard_module_chart_Table(pool, recreate);
createTb_Page_Param_User_Table(pool, recreate);
+
+ createTb_Page_Param2_Table(pool, recreate);//创建表并初始化值
+// tb_page_param2
}
+ private static void createTb_Page_Param2_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Page_Param2_Table;
+ String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Page_Param2_Table + " (" +
+ " `id` int(11) NOT NULL AUTO_INCREMENT," +
+ " `param` varchar(45) DEFAULT NULL COMMENT '参数'," +
+ " `label` varchar(45) DEFAULT NULL COMMENT '标签'," +
+ " `value` varchar(45) DEFAULT NULL COMMENT '参数的值'," +
+ " `category` int(11) DEFAULT NULL COMMENT '分类'," +
+ " PRIMARY KEY (`id`)" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='页面参数配置,配置非状态量参数';";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+
+ //添加在线充电列
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) num FROM db_app_sys.tb_page_param2;");
+ if(false != res.next()) {
+ int num = res.getInt("num");
+ if(num>0){
+// System.out.println(" db_app_sys.tb_page_param2 num = "+num);
+ }else{
+ sql.sqlMysqlExecute("INSERT INTO db_app_sys.`tb_page_param2`(`param`, `label`, `value`, `category`) VALUES "
+ + "('account_fail_time', '账号允许连续失败次数(24小时内)', '6', '1'),"
+ + "('account_lock_time', '账号锁定时间(-1为管理员解锁)', '20', '1')");
+ }
+ }
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
/**
*
* @Title: createTb_Page_Param_User_Table
--
Gitblit v1.9.1