IDEA 03 (动态sql和分页)

目录

一、foreach标签

1、BookMapper.xml

2、BookMapper

3、BookBizImpl

4、BookBiz

5、BookBizImplTest

二、模糊查询

1、test1

①BookBiz

 ②BookBizImpl

 ③BookMapper.xml

④BookMapper.java

⑤BookBizImplTest

2、test2

①BookBiz

 ②BookBizImpl

 ③BookMapper.xml

 ④BookMapper.java

⑤BookBizImplTest

3、test3

①BookBiz

②BookBizImpl

③BookMapper.xml

④BookMapper.java

三、结果集的处理

1、list1

①BookBiz

②BookBizImpl

③BookMapper.xml

④BookMapper.java

⑤BookVo

⑥BookBizImplTest

2、list2

①BookBiz

②BookBizImpl

③BookMapper.xml

④BookMapper.java

⑤BookVo

 ⑥BookBizImplTest

3、list3

①BookBiz

②BookBizImpl

③BookMapper.xml

总结：

1、MyBatis中#和$的区别

MyBatis中#和$的区别

---

 

一、foreach标签

1、BookMapper.xml

<!--bookIds 就是{1,2,3,4,5}-->
  <select id="selectByIn" resultMap="BaseResultMap" parameterType="java.util.List" >
    select
    <include refid="Base_Column_List" />
    from t_mvc_book
    where bid in
    <foreach collection="bookIds" open="(" close=")" separator="," item="bid">
      #{bid}
    </foreach>
  </select>

2、BookMapper

//  通过in关键字进行查询：讲解foreach 标签的使用
//    如果说参数是非实体类(book,Order,....)，那么急的加上注解 @param,bookIds是对应collection属性的
    List<Book> selectByIn(@Param("bookIds") List bookIds);

3、BookBizImpl

 @Override
    public List<Book> selectByIn(List bookIds) {
        return bookMapper.selectByIn(bookIds);
    }

4、BookBiz

List<Book> selectByIn(List bookIds);

5、BookBizImplTest

@Test
    public void selectByIn() {
        List<Integer> bookIds = Arrays.asList(new Integer[]{31, 32, 33, 34});
        bookBiz.selectByIn(bookIds).forEach(System.out::println);
    }

 运行效果：

 

 

二、模糊查询

1、test1

①BookBiz

public List<Book> selectBooksLike1(String bname);

 ②BookBizImpl

@Override
    public List<Book> selectBooksLike1(String bname) {
        return bookMapper.selectBooksLike1(bname);
    }

 ③BookMapper.xml

<select id="selectBooksLike1" resultType="com.chenchen.model.Book" parameterType="java.lang.String">
  select * from t_mvc_book where bname like #{bname}
</select>

④BookMapper.java

List<Book> selectBooksLike1(@Param("bname") String bname);

⑤BookBizImplTest

@Test
    public void selectBooksLike1() {
        bookBiz.selectBooksLike1("%圣墟%").forEach(System.out::println);
    }