pagebounds mysql_mybatis PageBounds应用分页

第一步：分页工具类

package com.smartmorse.vo;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import com.github.miemiedev.mybatis.paginator.domain.Order;

import com.github.miemiedev.mybatis.paginator.domain.PageBounds;

public class PageForm {

public static final String CHINESE_PINYIN = "nlssort(? ,'NLS_SORT=SCHINESE_PINYIN_M')";

private int page = 1;

private int limit = 20;

private String sort;

private Map orderExprs = new HashMap();

public int getPage() {

return page;

}

public void setPage(int page) {

this.page = page;

}

public int getLimit() {

return limit;

}

public void setLimit(int limit) {

this.limit = limit;

}

public String getSort() {

return sort;

}

public void setSort(String sort) {

this.sort = sort;

}

public void addOrderExpr(String property, String expr){

this.orderExprs.put(property,expr);

}

public PageBounds toPageBounds(){

List orders = Order.formString(sort);

for (int i = 0; i < orders.size(); i++) {

Order order = orders.get(i);

if(orderExprs.get(order.getProperty()) != null){

orders.set(i, new Order(

order.getProperty(),

order.getDirection(),

orderExprs.get(order.getProperty()))

);

}

}

return new PageBounds(page, limit, orders);

}

}

第二步 应用后端代码

@Controller

@RequestMapping("/membercheck")

public class MemberCheckController {

@Autowired

MemberCheckService memberCheckService;

@SystemControllerLog(description = "签到(退)列表")

@RequestMapping(value = "/list", method = RequestMethod.GET)

public String list(HttpServletRequest request, Model model, PageForm pageForm, MemberCheckVo memberCheck){

String dcode = (String) request .getSession().getAttribute("dcode");

memberCheck.setDistrictCode(dcode);

StringBuffer searchstr = new StringBuffer();//传参解决分页异常

if(StringUtil.isNotNull(memberCheck.getDistrictCode())){

searchstr.append("&districtCode="+memberCheck.getDistrictCode());

}

if(StringUtil.isNotNull(memberCheck.getMemberName())){

searchstr.append("&memberName="+memberCheck.getMemberName());

}

if(StringUtil.isNotNull(memberCheck.getCheckInStartDate())){

searchstr.append("&checkInStartDate="+memberCheck.getCheckInStartDate());

}

if(StringUtil.isNotNull(memberCheck.getCheckInEndDate())){

searchstr.append("&checkInEndDate="+memberCheck.getCheckInEndDate());

}

if(StringUtil.isNotNull(memberCheck.getCheckOutEndDate())){

searchstr.append("&checkOutEndDate="+memberCheck.getCheckOutEndDate());

}

if(StringUtil.isNotNull(memberCheck.getCheckOutStartDate())){

searchstr.append("&checkOutStartDate="+memberCheck.getCheckOutStartDate());

}

if(StringUtil.isNotNull(memberCheck.getStatus())){

searchstr.append("&status="+memberCheck.getStatus());

}

model.addAttribute("searchstr", searchstr);

model.addAttribute("memberCheck",memberCheck);

model.addAttribute("list", memberCheckService.selectByPage(memberCheck,pageForm.toPageBounds()));

return "membercheck/list";

}

}

第三步 前端应用

type="text/css" />

签到(退)列表

签到时间

placeholder="开始时间" onClick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})"

readonly="readonly"

value="${memberCheck.checkInStartDate }">

至

placeholder="结束时间" onClick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})"

readonly="readonly"

value="${memberCheck.checkInEndDate }">

签退时间

placeholder="开始时间" onClick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})"

readonly="readonly"

value="${memberCheck.checkOutStartDate }">

至

placeholder="结束时间" onClick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})"

readonly="readonly"

value="${memberCheck.checkOutEndDate }">

操作员姓名

placeholder=""

value="${memberCheck.memberName }">

状态

全部

selected >未签到

selected >已签到

selected >已签退

筛选

重置

id="dataTables-example">

会员名称pos编号打卡日期签到时间签退时间状态

${item.memberName }${item.posNo }

未签到

已签到

已签退

value="${listPaginator.totalCount}" />

value="${listPaginator.totalPages}" />

value="${listPaginator.page}" />

value="${ctx }/membercheck/list" />

value="${searchstr}" />//解决异常

//清空表单

function emptyForm(){

$('input','#selectForm')

.not(':button, :submit, :reset, :hidden')

.val('');

$('option','#selectForm')

.removeAttr('selected');

}

js文件

function exeData(num, type) {

loadpage();

}

function loadpage() {

var myPageCount = parseInt($("#PageCount").val());

var countindex = parseInt($("#countindex").val());

var pageUrl=$("#pageUrl").val()+"?page=";

var pageParameter=$("#pageParameter").val();

var Pagedq=$("#Pagedq").val();

$.jqPaginator('#pagination', {

totalPages: parseInt($("#countindex").val()),

visiblePages: parseInt($("#visiblePages").val()),

currentPage: parseInt($("#Pagedq").val()),

first: '

首页',

prev: '

上一页',

next: '

下一页',

last: '

末页',

page: '

{{page}}',

onPageChange: function (num, type) {

if (type == "change") {

exeData(num, type);

location.href=pageUrl+num+pageParameter;

}

}

});

$("#pagination").append("

共"+myPageCount+"条/共"+countindex+"页");

}

$(function () {

loadpage();

});