//Biz层
List<Map<String,Object>> deleList=userRoleOrgDAL.selectForDele(deleIDList);//通过id获取ROLE_ID,ORG_ID作为后续删除条件
Map<String, Object>[] array = toArray(deleList);//调用方法将deleList获取到条件组合的map
Boolean isSuccess=userRoleOrgDAL.userRoleOrgDele(deleList, array);//oracle层执行批量删除
//Biz中调用的方法,将带有双参数的List<Map<String,Object>>集合转换成双参数的数组
public Map<String, Object>[] toArray(List<Map<String,Object>> urpList){
List<Map<String,Object>> list = new ArrayList<>();
for(Map<String,Object> urpMap:urpList){
Map<String,Object> map = new HashMap<String,Object>();
map.put("USER_ID",urpMap.get("USER_ID"));
map.put("ROLE_ID",urpMap.get("ROLE_ID"));
map.put("ORG_ID",urpMap.get("ORG_ID"));
list.add(map);
}
return ((Map<String, Object>[]) list.toArray(new Map[list.size()]));
}
//oracle层
public List<Map<String, Object>> selectForDele(List<String> deleList) {
StringBuffer sql=new StringBuffer();
sql.append("select USER_ID,ROLE_ID,ORG_ID from T_CCPC_DB_URP where ID in (:IDS)");
Map<String, Object> paramMap = new HashMap<String, Object>();
paramMap.put("IDS", deleList);
List<Map<String, Object>> queryForList = jdbcTemplate.queryForList(sql.toString(), paramMap);
return queryForList;
}
public Boolean userRoleOrgDele(List<String> deleList,Map<String, Object>[] array) { //根据带有双参数的数组,一一对应到sql语句中的两个参数
StringBuffer sql=new StringBuffer();
sql.append("delete from T_EAP_SYS_ROLE_USER where ROLE_ID in :ROLE_ID and USER_ID in :USER_ID ");
int[] isDele = jdbcTemplate.batchUpdate(sql.toString(), array);
return isDele>0? true:false;
}