Mybatis的分页和动态sql

目录

一：forEach

BookMapper.xml

 BookMapper.java

BookBiz 

BookBizImpl 

BookBizImplTest

 效果图

二：模糊查询

BookBizImplTest

 BookMapper.java

BookBiz

 BookBizImpl 

BookMapper.xml 

效果图

三：查询分页

BookBizImplTest

 BookMapper.java

BookBiz

BookMapper.xml 

 BookBizImpl 

效果图 

四：结果集

BookBizImplTest

 BookMapper.java

BookMapper.xml 

BookBiz

BookBizImpl 

效果图 

五：特殊符号

BookVo

BookMapper.xml 

---

一：forEach

BookMapper.xml

  <select id="selectByIn" resultType="com.zking.model.Book" 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>

 BookMapper.java

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

BookBiz 

 List<Book> selectByIn(List bookIds);

BookBizImpl 

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

BookBizImplTest

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

 效果图

二：模糊查询

#{...}

${...}

Concat

注意：#{...}自带引号，${...}有sql注入的风险

BookBizImplTest

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

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

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

    @Test
    public void list1() {
        bookBiz.list1().forEach(System.out::println);
    }

    @Test
    public void list2() {
        bookBiz.list2().forEach(System.out::println);
    }
    @Test
    public void list3() {
        BookVo vo=new BookVo();
        vo.setBookIds(Arrays.asList(new Integer[]{31,32,33}));
        bookBiz.list3(vo).forEach(System.out::println);
    }

    @Test
    public void list4() {
        bookBiz.list4().forEach(System.out::println);
    }

    @Test
    public void list5() {
        Map map=new HashMap();
        map.put("bid",32);
        System.out.println(bookBiz.list5(map));
    }

 BookMapper.java

 List<B