构造30个测试账号

Administrator

2023-10-18 70d2da49a167136d8a9e44ccbff8eb9c8f029020

构造30个测试账号

 BattMonitor_DB_Builder/bin/com/database_util/DB_db_user.class

Binary files differ

 BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java

@@ -1549,7 +1549,7 @@
                    int count = res.getInt("num_count");
                    if(count<1) {
                        //默认没有添加用户信息时添加'未登录的用户账号'
                        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(1,'" + upstr + "',             'sys_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','*');");
                        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(1,'" + upstr + "',    'sys_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','*');");
                    }
                }
                
@@ -1747,4 +1747,13 @@
        }
    }
    
	
	
    public static void main(String[] args) {
        String upstr = "jFr3/n7JBhwxVE+uiMzC9LapSjDb97x1P7s8npTTLepabMucHcgVPwU/rkiG4tLlEICjYJKINQzoZQ0bqGxhwASe9vT2KukOOHJAEmBjs1uWkJoK0GLMZtNt7oiRoQzVSzPCfmtlc64gplUCSH6UTqqkMu//pEn/67W4sTLzUzg=";
        String phone = "153745192"; 
        for(int i =1;i<=30;i++ ) {
            System.out.println("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("+(2007+i)+",'" + upstr + "',  '"+("test"+(i))+"','"+(phone + (i+10))+"','默认班组','" + upstr + "',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');");			
        }
    }
}