mybatis配合mysql分页_MyBatis怎样实现MySQL动态分页

展开全部

针对上述思路，首先在 demo.mybatis.model下面新建一个名为32313133353236313431303231363533e58685e5aeb931333363373762PagenateArgs的分页参数实体类与一个名为SortDirectionEnum的枚举 类，里面包含当前页面索引pageIndex, 当前页展示业务记录数pageSize， pageStart属性表示从第几条开始，(pageStart=pageIndex*pageSize)因为limit关键词用法是表示【limit 起始条数(不包含)，取几条】，orderFieldStr排序字段，orderDirectionStr 排序方向，所以具体创建如下：

package david.mybatis.model;/* * 分页参数实体类 */public class PagenateArgs { private int pageIndex; private int pageSize; private int pageStart; private String orderFieldStr; private String orderDirectionStr; public PagenateArgs() { // TODO Auto-generated constructor stub } public PagenateArgs(int pageIndex, int pageSize, String orderFieldStr, String orderDirectionStr) { this.pageIndex = pageIndex; this.pageSize = pageSize; this.orderFieldStr = orderFieldStr; this.orderDirectionStr = orderDirectionStr; pageStart = pageIndex * pageSiz