蓄电池监控管理平台数据库初始化程序
parent: f69289f6 | 补丁 | 提交 | ignore whitespace
Administrator
2023-10-25 3d85c67b464a02f0620a1996873e108f790f908f 
V1.89 edit at date 2023-10-24
	1.'db_user.tb_user_inf'表修改'UsnId'长度 varchar(200)->varchar(1000)
	2.'db_user.tb_user_inf'表修改'upassword'长度 varchar(200)->varchar(1000)
	3.修改添加默认账号的密码字符串
6个文件已修改
20 ■■■■■ 已修改文件
BattMonitor_DB_Builder/bin/com/database_util/DB_App_Sys.class 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/bin/com/database_util/DB_db_user.class 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java 1 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java 15 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 BattMonitor_DB_Builder/bin/com/database_util/DB_App_Sys.class

Binary files differ



 BattMonitor_DB_Builder/bin/com/database_util/DB_db_user.class

Binary files differ



 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt


@@ -3,6 +3,8 @@


    


V1.89 edit at date 2023-10-24


    1.'db_user.tb_user_inf'表修改'UsnId'长度 varchar(200)->varchar(1000)


    2.'db_user.tb_user_inf'表修改'upassword'长度 varchar(200)->varchar(1000)


    3.修改添加默认账号的密码字符串    123456-X9rYw0Za1T7vgFO9cEMghH8f+Uo1Dhc3jAnMPpaKnCXL8nJ5xqueQ7Pldp0GmOr3imulIqxIQjdwZ43trz6s9YDi9lpEDNGVHQAx6hazHQmSnQ04HrPRn6xn9hvYo6BaJQYf+Jw5SmYwRgBWHbIA6atl/czRcDnXV9p7TCtcE8YsrgFYyT07D7/AmjPl1taiJmYnrojmqrQbOY/WE7nvHftjRkJoQcywYOfLY4zy4VOwhD6//Kpzo6klsLTuZgWMP1Wr4BzNB41EyjN68lzRiPhTQN0E8MuXwNSUS2sOODr96r6m9Z15Gg0iuzs60pz3HNXXoreRDjb5qZODprnEau0i94A9vuGaDS+Lr0QFV95ZAnCQ0t0j11QgxnuiBL0UIBNLYexCyTn3T5+cPDPMBC9bsMkCLzWvrapIFcGqrboxzx9g6KUh9jH24Eeckwndqqz5S+I0GeZbEZEAjHqgNSCPMDX0L8+CBvm6atT5kXpy1gls5YDsEDds0bTl9baf




V1.88 edit at date 2023-10-09


    1.修复表 `db_app_sys`.`tb_page_param`中默认数据插入bug修复




 BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java


@@ -444,7 +444,6 @@


                    + " AND table_name='tb_page_param'"


                    + " AND column_name='param'");


            if(res.next()) {    


                System.out.println("修改字段长度");


                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Page_Param_Table 


                        + " MODIFY COLUMN param varchar(255);");


            }




 BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java


@@ -1302,7 +1302,7 @@


                                + " ADD COLUMN `upassword` varchar(200) NOT NULL DEFAULT ''");


            }else{


                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.UserInfTable 


                        + " MODIFY COLUMN `upassword` varchar(200) NOT NULL DEFAULT '';");


                        + " MODIFY COLUMN `upassword` varchar(1000) NOT NULL DEFAULT '';");


            }


            


            //添加公钥X


@@ -1384,14 +1384,14 @@


                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 


                                + " CHANGE COLUMN `uSnId` `uSnId` VARCHAR(1000) NOT NULL DEFAULT '123456';");


            }


            //修改password的长度改成varchar(200)


            //修改password的长度改成varchar(1000)


            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"


                    + " WHERE table_schema='db_user'"


                    + " AND table_name='tb_user_inf'"


                    + " AND column_name='upassword'");


            if(res.next()) {


                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 


                        + " CHANGE COLUMN `upassword` `upassword` VARCHAR(200) NOT NULL DEFAULT '';");


                        + " CHANGE COLUMN `upassword` `upassword` VARCHAR(1000) NOT NULL DEFAULT '';");


            }


            


            


@@ -1481,7 +1481,8 @@


            


            


            //123456--------


            String upstr = "jFr3/n7JBhwxVE+uiMzC9LapSjDb97x1P7s8npTTLepabMucHcgVPwU/rkiG4tLlEICjYJKINQzoZQ0bqGxhwASe9vT2KukOOHJAEmBjs1uWkJoK0GLMZtNt7oiRoQzVSzPCfmtlc64gplUCSH6UTqqkMu//pEn/67W4sTLzUzg=";


            //String upstr = "jFr3/n7JBhwxVE+uiMzC9LapSjDb97x1P7s8npTTLepabMucHcgVPwU/rkiG4tLlEICjYJKINQzoZQ0bqGxhwASe9vT2KukOOHJAEmBjs1uWkJoK0GLMZtNt7oiRoQzVSzPCfmtlc64gplUCSH6UTqqkMu//pEn/67W4sTLzUzg=";


            String upstr = "X9rYw0Za1T7vgFO9cEMghH8f+Uo1Dhc3jAnMPpaKnCXL8nJ5xqueQ7Pldp0GmOr3imulIqxIQjdwZ43trz6s9YDi9lpEDNGVHQAx6hazHQmSnQ04HrPRn6xn9hvYo6BaJQYf+Jw5SmYwRgBWHbIA6atl/czRcDnXV9p7TCtcE8YsrgFYyT07D7/AmjPl1taiJmYnrojmqrQbOY/WE7nvHftjRkJoQcywYOfLY4zy4VOwhD6//Kpzo6klsLTuZgWMP1Wr4BzNB41EyjN68lzRiPhTQN0E8MuXwNSUS2sOODr96r6m9Z15Gg0iuzs60pz3HNXXoreRDjb5qZODprnEau0i94A9vuGaDS+Lr0QFV95ZAnCQ0t0j11QgxnuiBL0UIBNLYexCyTn3T5+cPDPMBC9bsMkCLzWvrapIFcGqrboxzx9g6KUh9jH24Eeckwndqqz5S+I0GeZbEZEAjHqgNSCPMDX0L8+CBvm6atT5kXpy1gls5YDsEDds0bTl9baf";


            res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf);


            /*if(res.next()) {


                int count = res.getInt("num_count");


@@ -1500,7 +1501,8 @@


                    int count = res.getInt("num_count");


                    if(count<1) {


                        //默认没有添加用户信息时添加'admin'


                        sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1001', '" + upstr + "', 'admin', 'admin', 'employeeid', '12345678912', '12345678912', 'abcde@mail.com', '', '1980-01-01', '2015-12-09', '男', '广东省', 'protitle', 'authority', '默认班组', 'duties', 'tasks', '1', 'note', '"+upstr+"', '', '', '48505834353130373639353153594E4F', NULL, '0','0','0','1','1',null,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"','2022-05-19 14:53:44','2022-05-19 14:53:44',null,'00:00:01~23:59:59','*');");


                        //sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1001', '" + upstr + "', 'admin', 'admin', 'employeeid', '12345678912', '12345678912', 'abcde@mail.com', '', '1980-01-01', '2015-12-09', '男', '广东省', 'protitle', 'authority', '默认班组', 'duties', 'tasks', '1', 'note', '"+upstr+"', '', '', '48505834353130373639353153594E4F', NULL, '0','0','0','1','1',null,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"','2022-05-19 14:53:44','2022-05-19 14:53:44',null,'00:00:01~23:59:59','*');");


                        sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+"(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(1001,'" + upstr + "',    'admin','','默认班组','" + upstr + "',1,0,1,1,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"',null,'2021-12-14 16:16:04','00:00:00~23:59:59','*');");


                    }else {


                        //修复前期添加默认账号时添加成了临时账号


                        sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.UserInfTable + " SET type = 1,expiration_time = null,lock_time = null,visit_time='00:00:00~23:59:59',visit_ip = '*' WHERE uName = 'admin'");


@@ -1512,7 +1514,8 @@


                    int count = res.getInt("num_count");


                    if(count<1) {


                        //默认没有添加用户信息时添加'superuser'


                        sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1002', '" + upstr + "', 'superuser', '1234567', '100010000', '12345678', '15346259512', '123456789@qq.com', '', '1990-04-20', '2016-03-28', '男', '湖北省', '软件工程师', 'authority111', '默认班组', 'dutie', '完成软件的研发工作', '0', 'note', '"+upstr+"', '', '', '14031C0F0136063E', NULL, '0','0','0','1','1',null,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"','2022-05-19 14:53:44','2022-05-19 14:53:44',null,'00:00:01~23:59:59','*');");


                        //sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1002', '" + upstr + "', 'superuser', '1234567', '100010000', '12345678', '15346259512', '123456789@qq.com', '', '1990-04-20', '2016-03-28', '男', '湖北省', '软件工程师', 'authority111', '默认班组', 'dutie', '完成软件的研发工作', '0', 'note', '"+upstr+"', '', '', '14031C0F0136063E', NULL, '0','0','0','1','1',null,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"','2022-05-19 14:53:44','2022-05-19 14:53:44',null,'00:00:01~23:59:59','*');");


                        sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+"(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(1002,'" + upstr + "',    'superuser','','默认班组','" + upstr + "',1,0,1,1,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"',null,'2021-12-14 16:16:04','00:00:00~23:59:59','*');");


                    }else {


                        //修复前期添加默认账号时添加成了临时账号


                        sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.UserInfTable + " SET type = 1,expiration_time = null,lock_time = null,visit_time='00:00:00~23:59:59',visit_ip = '*' WHERE uName = 'superuser'");




 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt


@@ -3,6 +3,8 @@


    


V1.89 edit at date 2023-10-24


    1.'db_user.tb_user_inf'表修改'UsnId'长度 varchar(200)->varchar(1000)


    2.'db_user.tb_user_inf'表修改'upassword'长度 varchar(200)->varchar(1000)


    3.修改添加默认账号的密码字符串    123456-X9rYw0Za1T7vgFO9cEMghH8f+Uo1Dhc3jAnMPpaKnCXL8nJ5xqueQ7Pldp0GmOr3imulIqxIQjdwZ43trz6s9YDi9lpEDNGVHQAx6hazHQmSnQ04HrPRn6xn9hvYo6BaJQYf+Jw5SmYwRgBWHbIA6atl/czRcDnXV9p7TCtcE8YsrgFYyT07D7/AmjPl1taiJmYnrojmqrQbOY/WE7nvHftjRkJoQcywYOfLY4zy4VOwhD6//Kpzo6klsLTuZgWMP1Wr4BzNB41EyjN68lzRiPhTQN0E8MuXwNSUS2sOODr96r6m9Z15Gg0iuzs60pz3HNXXoreRDjb5qZODprnEau0i94A9vuGaDS+Lr0QFV95ZAnCQ0t0j11QgxnuiBL0UIBNLYexCyTn3T5+cPDPMBC9bsMkCLzWvrapIFcGqrboxzx9g6KUh9jH24Eeckwndqqz5S+I0GeZbEZEAjHqgNSCPMDX0L8+CBvm6atT5kXpy1gls5YDsEDds0bTl9baf




V1.88 edit at date 2023-10-09


    1.修复表 `db_app_sys`.`tb_page_param`中默认数据插入bug修复