工具类:
public String getNewModCode(String parentCode,String behindNum) {
String newCode = "";
int x = 0;
List<String> codeList = sysModuleMapper.getAllModCode(parentCode);
if(codeList.size()>0){
x = Integer.valueOf(codeList.get(codeList.size()-1))-Integer.valueOf(codeList.get(0))+1;
if(codeList.get(0).equals(behindNum)){
if(codeList.size()<x){
for(int i=0;i<codeList.size();i++){
if(Integer.valueOf(codeList.get(i))+1==Integer.valueOf(codeList.get(i+1))){
continue;
}else{
behindNum = Integer.valueOf(Integer.valueOf(codeList.get(i))+1).toString();
break;
}
}
}else{
behindNum = Integer.valueOf(Integer.valueOf(codeList.get(codeList.size()-1))+1).toString();
}
}
}
if(parentCode.length()>1){
newCode = parentCode + behindNum;
}else{
newCode = behindNum;
}
return newCode;
}
SQL:
select s.mod_code from sys_module s where s.parent_code=#{parentCode} order by s.mod_code asc
使用于小数据量的菜单,机构数据添加,注意:999+1