目录
1.模糊查询
条件语句使用拼接的方法:concat(‘%’,#{条件},‘%’)
<select id="selectAll01" resultMap="bookmap">
select * from books where book_name like concat('%',#{name},'%')
</select>
测试
@Test
public void test2(){
BookDao bookDao = session.getMapper(BookDao.class);
List<Book> books = bookDao.selectAll01("计算机");
System.out.println(books);
}
2.分页查询
首先,引入相关的依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.11</version>
</dependency>