＜MyBatis＞查询sq，根据某个字段，入参传list循环判断-Toy模板网

这篇具有很好参考价值的文章主要介绍了＜MyBatis＞查询sq，根据某个字段，入参传list循环判断。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

实现类：

public PageInfo<Map<String, Object>> selectFormData(HttpServletRequest request,Map<String, Object> paramMap) {
	List<String> regionList = Arrays.asList("北京","西安","上海");
	paramMap.put("regionList", regionList);
	CommonUtil.getPageHelper(paramMap);  // 分页
    List<Map<String, Object>> deptInfo = questionListMapper.selectFormData(paramMap); 
    PageInfo<Map<String, Object>> result = new PageInfo<>(deptInfo);
	return result;
}

Mapper类：

List<Map<String, Object>> selectFormData(Map<String, Object> paramMap);

Mybatis层：

<select id="selectFormData" parameterType="map" resultType="map">
        select * from bcg_question_list_form_data
        where (processID IS NOT NULL)
        and not(taskDefKey = #{taskDefKey} and xxApprovalResult = #{xxApprovalResult})
        <include refid="selectValue"/>
        <if test = "null != regionList and regionList.size > 0">
            and region in
            <foreach collection="regionList" index="index" item="id" open="(" separator="," close=")">
                #{id}
            </foreach>
        </if>
        order by statuSort,createTimeSecond desc
    </select>

重点关注： 根据：北京，西安，上海，过滤数据：文章来源地址https://www.toymoban.com/news/detail-510646.html

        <if test = "null != regionList and regionList.size > 0">
            and region in
            <foreach collection="regionList" index="index" item="id" open="(" separator="," close=")">
                #{id}
            </foreach>
        </if>