Mybatis的foreach

0、准备实体类和对应的表

Blog.java

package com.dmx.demo.model;

import lombok.Getter;
import lombok.Setter;
import lombok.ToString;

import java.util.List;
@Getter
@Setter
@ToString
public class Blog {
    private int id;
    private String title;
    private String content;
    private List<Comment> comments;
}

blog表

1、编写foreach

<select id="getBlogInList"  resultType="com.dmx.demo.model.Blog" parameterType="java.util.List">
    select * from blog
    <where>
        <foreach collection="list" index="index" item="integerList" open="blog.id in (" separator="," close=")">
            #{integerList}
        </foreach>
    </where>

</select>

2、执行查询

控制器

@RequestMapping("/ccc")
public List<Blog> blogss(){
    List<Integer> list = new ArrayList<Integer>();
    list.add(1);
    list.add(2);
    list.add(3);
    return  blogService.getBlogss(list);
}

查询

public List<Blog> getBlogss(List<Integer> list){
    return blogMapper.getBlogInList(list);
}

结果：

查询出id在1、2、3的博客