//模糊查询使用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());
}
}
