| | |
|---|
| | | //String s1 ="delete from sys_security_paper where number like concat('%','赣洪2022','%') and right(number,5) >2000"; |
|---|
| | | //myAsyncService.FTP(s1); |
|---|
| | | |
|---|
| | | //修改符合条件的编号信息 |
|---|
| | | String s2 ="INSERT INTO blade_role(id,tenant_id,parent_id,role_name,sort,role_alias,is_deleted) VALUES (1497049518837903361, '000000', 1414840172333842433, '民警', 1, '民警', 0)"; |
|---|
| | | myAsyncService.FTP(s2); |
|---|
| | | // //修改符合条件的编号信息 |
|---|
| | | // String s2 ="INSERT INTO blade_role(id,tenant_id,parent_id,role_name,sort,role_alias,is_deleted) VALUES (1497049518837903361, '000000', 1414840172333842433, '民警', 1, '民警', 0)"; |
|---|
| | | // myAsyncService.FTP(s2); |
|---|
| | | |
|---|
| | | String sql = "update blade_user set status = 2 where cardid = '362524200312182017';" + |
|---|
| | | "update blade_user set status = 2 where cardid = '362524200301120013';" + |
|---|
