而不是对全部的数据进行分页显示
同上篇分页,不同的是dao层进行查询时的代码是这样的:
public List<Book> queryBookList2(String name, int pageNo, int pageSize) throws SQLException {
QueryRunner queryRunner = new QueryRunner(C3P0Utils.getDataSource());
String sql="select * from book where bookname LIKE ? limit ?,?";
List<Book> list = queryRunner.query(sql, new BeanListHandler<Book>(Book.class),"%"+name+"%",(pageNo-1)*pageSize,pageSize);
return list;
}
因为这是模糊查询.