mybatis 中 foreach collection的两种用法

灰太狼 2022-05-14 00:48 477阅读 0赞

针对list 和map结构的传参

代码如下

controller

//测试传入参数为list结构 mybatis
        @RequestMapping(value = "/demo/getMemberByListId", method = RequestMethod.POST, produces = "application/json; charset=UTF-8")
        @ResponseBody
        public List<Member> getMemberByList()
                throws BizException {
            List<Integer> ids = new ArrayList<>();
            ids.add(1);ids.add(2);
            List<Member> r = new ArrayList<Member>();
            r = memberService.getMemberByListId(ids);
            return r;
    
        }
      //测试传入参数为map结构 mybatis
        @RequestMapping(value = "/demo/getMemberByMapId", method = RequestMethod.POST, produces = "application/json; charset=UTF-8")
        @ResponseBody
        public List<Member> getMemberByMapId()
                throws BizException {
            List ids = new ArrayList();
            ids.add(1);
            ids.add(2);
            Map params = new HashMap();
            params.put("ids", ids);
            List<Member> r = new ArrayList<Member>();
            r = memberService.getMemberByMapId(params);
            return r;
    
        }

service

List<Member> getMemberByListId(List<Integer> ids);
    
        List<Member> getMemberByMapId(Map params);

serviceImpl

@Override
        public List<Member> getMemberByListId(List<Integer> ids) {
            return   this.memberMapper.getMemberByListId(ids);
        }
    
        @Override
        public List<Member> getMemberByMapId(Map params) {
            return  this.memberMapper.getMemberByMapId(params);
        }

mapper.java

List<Member> getMemberByListId(@Param("ids")List<Integer> ids);
    
        List<Member> getMemberByMapId(Map params);

mapper.xml

<select id="getMemberByListId" resultMap="BaseResultMap">
    		select
    		<include refid="Base_Column_List" /> 
    		from member where uid in  
    		<foreach collection="ids" index="index" item="item" open="(" separator="," close=")">
                #{item}
            </foreach>
    	</select>
    	
    	<select id="getMemberByMapId" resultMap="BaseResultMap">
    		select
    		<include refid="Base_Column_List" /> 
    		from member where uid in  
    		<foreach collection="ids" index="index" item="item" open="(" separator="," close=")">
                #{item}
            </foreach>
    	</select>

参考:[https://blog.csdn.net/qq\_24084925/article/details/53790287][https_blog.csdn.net_qq_24084925_article_details_53790287]

[https_blog.csdn.net_qq_24084925_article_details_53790287]: https://blog.csdn.net/qq_24084925/article/details/53790287