MyBatis入参为数组类型和List集合类型的foreach迭代

最新推荐文章于 2024-02-02 09:35:42 发布

大炮的大炮没有大炮

最新推荐文章于 2024-02-02 09:35:42 发布

阅读量1.2k

点赞数

本文链接：https://blog.csdn.net/qq_36074180/article/details/74923265

版权

//MyBatis入参为数组类型foreach迭代

public  List<Book>  findinfo4(String[]  author);

<select id="findinfo4" resultType="Book">
    SELECT  *  FROM   bookinfo
    <if test="array.length>0">
        WHERE   bookauthor  IN
        <foreach collection="array" open="(" close=")" separator="," item="b">
               #{b}
        </foreach>
    </if>
</select>

@Test
public void   TestBook4(){

   String[]  author={"吴承恩","qqq"};
    List<Book> list = bookDao.findinfo4(author);
    for (Book item:list) {
        System.out.println(item.getBookname());
    }
}

//MyBatis入参为List集合类型的foreach迭代

public  List<Book>  findinfo5(List<String>  book);

<select id="findinfo5" resultType="Book">
    SELECT  *  FROM   bookinfo
    <if test="list.size>0">
        WHERE   bookauthor  IN
        <foreach collection="list" open="(" close=")" separator="," item="b">
            #{b}
        </foreach>
    </if>
</select>
@Test
public void   TestBook5(){
   List<String> list=new ArrayList<String>();
   list.add("吴承恩");
   list.add("qqq");
    List<Book> lis = bookDao.findinfo5(list);
    for (Book item:lis) {
        System.out.println(item.getBookname());
    }
}
2.public  List<Book>  findinfo6(List<Book>  book);
<select id="findinfo6" resultType="Book">
    SELECT  *  FROM   bookinfo
    <if test="list.size>0">
        WHERE   bookauthor  IN
        <foreach collection="list" open="(" close=")" separator="," item="b">
            #{b.bookauthor}
        </foreach>
    </if>
</select>
@Test
public void   TestBook6(){
   List<Book>  list=new ArrayList<Book>();
   Book  book=new Book();
   book.setBookauthor("吴承恩");
    Book  book2=new Book();
    book2.setBookauthor("qqq");
     list.add(book);
     list.add(book2);
    List<Book> lis = bookDao.findinfo6(list);
    for (Book item:lis) {
        System.out.println(item.getBookname());
    }
}