java 避免不同库使用left join查询速率低效 采用 sql 注入foreach 遍历list查询方式

java 避免不同库使用left join查询速率低效 采用 sql 注入foreach 遍历list查询方式

（1）前端接受回用“，”拼接起来的字符串 String select_copy_ids

 List<Integer> copyIds = DBUtil.getParamIntList(select_copy_ids);
                List<Integer> roleIds = new ArrayList<Integer>();
                List<DrillingRoleModel> copyRoleModels = drillingModelService.listDrillingRoleModelCopyById(copyIds);

（2）将带“，”拼接字符串 装换为List

 public static List<Integer> getParamIntList(String value) throws Exception {
        List<Integer> returnList = new ArrayList<Integer>();
        if (StringUtils.isBlank(value)) {
            return returnList;
        } else {
            try {
                String[] idsStr = value.split(ConstUtil.SPLIT_DH);
                for (String id : idsStr) {
                    returnList.add(Integer.parseInt(id));
                }
            } catch (Exception e) {
                throw new Exception("处理提交请求参数：Int List类型异常，转换值value=" + value);
            }
            return returnList;
        }
    }

（3）数据库xml配置

<select id="listDrillingRoleModelCopyById" resultType="com.baofoo.admin.entity.data.drilling.DrillingRoleModel">
		SELECT * FROM BAOFOO_ADMIN.drilling_role_model WHERE id IN (
		<foreach collection="list" item="item" index="index" separator=",">
			#{item}
		</foreach>
		)
	</select>