MyBatis怎么进行双重foreach循环

这篇文章主要介绍mybatis怎么进行双重foreach循环，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

进行双重foreach循环

mapname是一个Map<String,Map<String,Object>> 对象

<foreach collection="mapname" index="key1" item="value1" separator=",">    <foreach collection="value1" index="key2" item="value2" separator=",">        #{key1},        #{key2},        #{value2}    </foreach></foreach>

使用场景

比如说一个付款人下面对应的运单的金额，那么key1就是付款人编号，key2是运单编号，value2是分摊的金额 

mybatis foreach循环,传入多个参数

上代码

controller：

@RequestMapping(value = "/findPage", method = RequestMethod.POST)    @ResponseBody    public Object findPage(@RequestParam(required=false) String jobCateGory,@RequestParam(required=false) String ids,@RequestParam(required=false) String cities) {        try {            List<Integer> listJob = new ArrayList<Integer>();            List<Integer> listIds = new ArrayList<Integer>();            List<String> listCities = new ArrayList<String>();            //按照城市名称和工种查询            if(StringUtils.isNotBlank(jobCategory) && StringUtils.isNotBlank(cities)){                String[] temp = jobCategory.split(",");                String[] cityTemp = cities.split(",");                for(int i=0;i<temp.length;i++){                    listJob.add(Integer.valueOf(temp[i]));                }                for(int i=0;i<cityTemp.length;i++){                    listCities.add(cityTemp[i]);                }                List<WEBsitesJob> list = jobService.findPage(listJob, listIds, listCities);                return new ExtGridReturn(list.size(), list);            }            //按照工种查询            if(StringUtils.isNotBlank(jobCategory)){                String[] temp = jobCategory.split(",");                for(int i=0;i<temp.length;i++){                    listJob.add(Integer.valueOf(temp[i]));                }            }            //按照职位名称查询            if(StringUtils.isNotBlank(ids)){                String[] temp = ids.split(",");                for(int i=0;i<temp.length;i++){                    listIds.add(Integer.valueOf(temp[i]));                }            }            //按照城市查询            if(StringUtils.isNotBlank(cities)){                String[] temp = cities.split(",");                for(int i=0;i<temp.length;i++){                    listCities.add(temp[i]);                }            }            List<WebsitesJob> list = jobService.findPage(listJob, listIds, listCities);            return new ExtGridReturn(list.size(), list);        } catch (Exception e) {            LOGGER.error("分页获取信息出错", e);            return new ExceptionReturn(e);        }    }

mapper

    List<WebsitesJob> findPage(@Param("jobCategorys") List<Integer> jobCategorys,@Param("ids") List<Integer> ids,@Param("workPlace") List<String> workPlace);

xml

<!-- 前台查询列表 -->   <select id="findPage" resultType="cn.edu.hbcf.plugin.websites.pojo.WebsitesJob">           select n.ID id,              n.NAME name,              n.WORKPLACE workPlace,              n.JOBCATEGORY jobCategory,              n.SALARY salary,              n.RESPONSIBILITIES responsibilities,              n.REQUIREMENTS requirements,              n.ISHOT isHot,              n.UPDATEDATE updateDate,              n.UPDATEUSER updateUser,              u.real_name updateName         from websites_job n         left join base_users u on n.updateUser = u.account         <where>             <if test="jobCategorys.size()!=0">                 or    n.jobCategory in                   <foreach collection="jobCategorys" index="index" item="item" open="(" separator="," close=")">                    #{item}                </foreach>            </if>            <if test="ids.size()!=0">                or n.id in                   <foreach collection="ids" item="item" index="index" open="(" separator="," close=")">                    #{item}                </foreach>             </if>             <if test="workPlace.size()!=0">                or n.WORKPLACE in                   <foreach collection="workPlace" item="item" index="index" open="(" separator="," close=")">                    #{item}                </foreach>             </if>         </where>         order by n.ISHOT,n.ID desc   </select>

以上是“MyBatis怎么进行双重foreach循环”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注编程网精选频道！