mapper的xml文件可以按如下方式来写:SELECT SQL_CALC_FOUND_ROWS * FROM表名及条件WHERE ID in (SELECT ID from (SELECT ID FROM A LIMIT ${(pageNo-1)*pageSize},#{pageSize}) AS t)order by ID;SELECT FOUND_ROWS(*) AS total;
mapper接口:List selectPage(@Param("pageNo") Integer pageNo, @Param("pageSize") Integer pageSize);
service层:Mapper接口实例.selectPage(Integer pageNo,Integer pageSize);
controller层:List list = Service实例.selectPage(pageNo,pageSize);List wcenters = (List) list.get(0); //数据集合Integer total = ((List) list.get(1)).get(0);//总量注意:在使用时需要在配置文件中,设置允许sql进行多语句执行:allowMultiQueries=true,在sql的url上加上这个配置就可以了。