Mybatis模糊查询的两种实现方式

//模糊查询使用Map集合传参

public  List<Book>  findinfo(Map<String,Object>map);

<select id="findinfo" resultType="Book">
      SELECT  *  FROM   bookinfo    WHERE  bookauthor LIKE  '%' #{bookauthor} '%'  AND    bookprice=#{bookprice}
</select>
@Test
public void   TestBook(){
    Map<String,Object>  map=new HashMap<String, Object>() ;
    map.put("bookauthor","吴");
    map.put("bookprice",12);
    List<Book> list = bookDao.findinfo(map);
    for (Book item:list) {
        System.out.println(item.getBookname());
    }
}

//模糊查询使用索引查询
public  List<Book>  findinfo2(String  bookauthor,Double  bookprice);

<select id="findinfo2" resultType="Book">
    SELECT  *  FROM   bookinfo    WHERE  bookauthor LIKE  '%' #{0} '%'  AND    bookprice=#{1}
</select>
@Test
public void   TestBook2(){
  String name="吴";
  int  price=12;
    List<Book> list = bookDao.findinfo2(name,new Double(price));
    for (Book item:list) {
        System.out.println(item.getBookname());
    }
}