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>
@Testpublic 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>
@Testpublic 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());    }}