package com.hx.mybatis.aes.springbean; import com.gitee.sunchenbin.mybatis.actable.annotation.Column; import com.gitee.sunchenbin.mybatis.actable.annotation.Table; import com.hx.common.annotations.MysqlHexAes; import com.hx.common.dao.mapper.CommonMapper; import com.hx.common.service.CommonService; import com.hx.exception.ServiceException; import com.hx.mybatisTool.SqlSentence; import com.hx.util.StringUtils; import com.hx.util.mysql.aes.MysqlHexAesTool; import java.lang.reflect.Field; import java.util.*; import java.util.concurrent.ExecutorService; import java.util.concurrent.Executors; public class InitMysqlData { /** * 项目启动就执行后就执行该方法 */ //@PostConstruct 2022-06-17屏掉,暂时用不上 public static void initData(String packPath, CommonService commonService){ //项目启动的时候填入 if(!StringUtils.isEmpty(packPath)){ Set> classes = VariableAesKey.classData(packPath); SqlSentence sqlSentence = new SqlSentence(); Map values = new HashMap<>(); //解析表数据 List fieldDatas = entityhandle(classes); int pageSize = 500; //创建一个定长线程池,可控制线程最大并发数,超出的线程会在队列中等待。 ExecutorService fixedThreadPool = Executors.newFixedThreadPool(20); try{ for(FieldData fieldData:fieldDatas){ //获取条数 sqlSentence.sqlSentence("SELECT COUNT(0) FROM "+fieldData.getTableName(),values); int total = commonService.selectCountSql(sqlSentence); if(total ==0 ){ continue; } int pageTotal = total/pageSize+1; for(int i= 0;i values = new HashMap<>(); //查询数据 StringBuilder selectField = new StringBuilder(); selectField.append(fieldData.getId()); for(String fieldName:fieldData.getEncrypFields()){ selectField.append(","+fieldName); } pageNum = pageNum*pageSize; sqlSentence.sqlSentence("SELECT "+selectField.toString()+" FROM "+fieldData.getTableName()+" LIMIT "+pageNum+","+pageSize,values); List> list = commonService.selectListMap(CommonMapper.class,sqlSentence); boolean isUpdate = false; for (Map map:list){ isUpdate = false; StringBuilder setField = new StringBuilder(); for (Map.Entry entry : map.entrySet()) { String mapKey = entry.getKey(); String mapValue = (String) entry.getValue(); if(StringUtils.isEmpty(mapValue)){ continue; } if(mapValue.length()%32==0 && MysqlHexAesTool.isHexStrValid(mapValue)){ continue; } if(fieldData.getId().equals(mapKey)){ continue; } if(setField.length()>0){ setField.append(","); } setField.append(mapKey+" = #{m."+mapKey+"}"); isUpdate = true; } if(isUpdate){ values = map; sqlSentence.sqlSentence("UPDATE "+fieldData.getTableName()+" SET "+setField.toString()+" WHERE "+fieldData.getId()+" = #{m."+fieldData.getId()+"}",values); if(commonService.updateSentence(sqlSentence)!=1){ throw new ServiceException("更新超过1条,更新失败!"); } } } } /**获取到表的数据*/ public static List entityhandle(Set> classes){ List fildDatas = new ArrayList<>(); //存储单表字段信息 FieldData fildData; //存储需要加密的字段 Set encrypFields; String fildName; for(Class cl:classes){ fildData = new FieldData(); encrypFields = new HashSet<>(); //表名称 if(!cl.isAnnotationPresent(Table.class)){ continue; } Table table = cl.getAnnotation(Table.class); fildData.setTableName(table.name()); // 取得本类的全部属性 Field[] fields = cl.getDeclaredFields(); fields = VariableAesKey.getPatentFields(fields,cl); for (Field field:fields) { fildName = null; if(field.isAnnotationPresent(Column.class)){ Column column = field.getAnnotation(Column.class); fildName = column.name(); if(StringUtils.isEmpty(fildName)){ fildName = field.getName(); } if(column.isKey()){ fildData.setId(fildName); } }else{ fildName = field.getName(); } // 判断方法中是否有指定注解类型的注解 if (!field.isAnnotationPresent(MysqlHexAes.class)) { continue; } // 根据注解类型返回方法的指定类型注解 MysqlHexAes mysqlHexAes = field.getAnnotation(MysqlHexAes.class); //判断版本号是不是一样的 if(!StringUtils.isEmpty(VariableAesKey.INIT_VERSION)){ if(!VariableAesKey.INIT_VERSION.equals(mysqlHexAes.initVersion())){ continue; } }else{ if(!StringUtils.isEmpty(mysqlHexAes.initVersion())){ continue; } } String aesKey = mysqlHexAes.aesKey(); if(StringUtils.isEmpty(aesKey)){ aesKey = VariableAesKey.AES_KEY; if(StringUtils.isEmpty(aesKey)){ throw new RuntimeException("mysql的AES秘钥不能为空:"+field.getName()); } } encrypFields.add(fildName); } //是否有需要加密得字段 if(encrypFields.size()<=0){ continue; } fildData.setEncrypFields(encrypFields); fildDatas.add(fildData); } return fildDatas; } }