V1.95 edit at date 2021-12-6 1：新增`db_app_sys`.`tb_page_param2` 模板表创建并初始...

whycrzg

2021-12-06 9ecd2bf82d543e86b12a10d8e33b0085111cdd1d

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

@@ -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

 BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java

@@ -1000,6 +1000,72 @@
                    sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1002', '1', 'superuser', '1234567', '100010000', '12345678', '15346259512', '123456789@qq.com', '', '1990-04-20', '2016-03-28', '男', '湖北省', '软件工程师', 'authority111', '默认班组', 'dutie', '完成软件的研发工作', '0', 'note', 'c4ca4238a0b923820dcc509a6f75849b', '', '', '14031C0F0136063E', '27', '','0');");
                }
            }
			

            //添加old_password
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='old_password'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                                + " ADD COLUMN `old_password` varchar(64) DEFAULT NULL COMMENT '旧的密码';");
            }
            //添加type
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='type'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                                + " ADD COLUMN `type` tinyint(1) DEFAULT '1' COMMENT '账号类型 1:长期,2:临时 ';");
            }
            //添加status
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='status'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                                + " ADD COLUMN `status` tinyint(1) DEFAULT '1' COMMENT '账号状态 1:激活,2:休眠,3:锁定,0:注销';");
            }
            //添加expiration_time
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='expiration_time'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                                + " ADD COLUMN `expiration_time` datetime DEFAULT NULL COMMENT '临时账号的到期时间';");
            }
            //添加last_login_time
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='last_login_time'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                                + " ADD COLUMN `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间';");
            }
            //添加password_update_time
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='password_update_time'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                                + " ADD COLUMN `password_update_time` datetime DEFAULT NULL COMMENT '密码更新时间,至少3个月一次';");
            }

            //添加create_time
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='create_time'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                                + " ADD COLUMN `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间';");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {

 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -263,6 +263,7 @@
    public static final String Tb_dashboard_module_chart_Table = DB_AppSys + ".`tb_dashboard_module`";
    public static final String Tb_dashboard_module_Table = DB_AppSys + ".`tb_dashboard_module_chart`";
    public static final String Tb_Page_Param_User_Table = DB_AppSys + ".`tb_page_param_user`";
    public static final String Tb_Page_Param2_Table = DB_AppSys + ".`tb_page_param2`";
    
    
    

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -328,4 +328,8 @@
    
V1.94 edit at date 2021-11-27
    1：新增`web_site`.`tb_3d_station` 模板表创建
    
V1.95 edit at date 2021-12-6
    1：新增`db_app_sys`.`tb_page_param2` 模板表创建并初始化数据,db_user.tb_user_inf表下添加字段
    
    

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -28,7 +28,7 @@
    /**************************************************************************/
    /**************************************************************************/
    public final static boolean app_debug = false;
    public final static float m_VersionNum = (float) 1.94;
    public final static float m_VersionNum = (float) 1.95;
    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
    /**************************************************************************/
    /**************************************************************************/