java mysql ajax分页查询数据格式_ajax分页查询信息的通用方法

packagecn.xm.exam.action.haul;importjava.sql.SQLException;importjava.util.HashMap;importjava.util.Map;importjavax.annotation.Resource;importorg.apache.log4j.Logger;importorg.springframework.context.annotation.Scope;importorg.springframework.stereotype.Controller;importcom.opensymphony.xwork2.ActionSupport;importcn.xm.exam.bean.haul.Haulinfo;importcn.xm.exam.service.haul.HaulinfoService;importcn.xm.exam.utils.PageBean;importcn.xm.exam.utils.ValidateCheck;/*** 查询大修的Action

*

*@authorQiaoLiQiang

* @time 2017年11月10日下午7:45:09*/@Controller

@Scope("prototype")

@SuppressWarnings("all")public class FindHaulAction extendsActionSupport {private Logger logger = Logger.getLogger(FindHaulAction.class);//日志记录器

private Map response;//用于包装返回结果的map

@ResourceprivateHaulinfoService haulinfoService;private String currentPage;//当前页

private String currentCount;//页大小

private String bigName;//大修名称

private String bigStatus;//大修状态

private String startMonth;//创建月份

@OverridepublicString execute() {

response= new HashMap();

Map condition =generateQueryHaulCondition();

PageBean pageBean = null;try{

pageBean=haulinfoService.getHaulinfoPageByCondition(Integer.valueOf(currentPage),

Integer.valueOf(currentCount), condition);

}catch(NumberFormatException e) {

logger.error("数字格式化异常", e);

}catch(SQLException e) {

logger.error("查询大修SQL异常", e);

}

response.put("pageBean", pageBean);returnSUCCESS;

}/*** 组装查询条件

*

*@paramcondition

*@return

*/

private MapgenerateQueryHaulCondition() {

Map condition = new HashMap();if(ValidateCheck.isNull(currentCount)) {

currentCount= "8";

}if(ValidateCheck.isNull(currentPage)) {

currentPage= "1";

}if(ValidateCheck.isNotNull(bigName)) {

condition.put("bigName", bigName);

}if(ValidateCheck.isNotNull(bigStatus)) {

condition.put("bigStatus", bigStatus);

}if(ValidateCheck.isNotNull(startMonth)) {

condition.put("startMonth", startMonth);

}returncondition;

}//get set

public MapgetResponse() {returnresponse;

}public void setResponse(Mapresponse) {this.response =response;

}publicString getCurrentPage() {returncurrentPage;

}public voidsetCurrentPage(String currentPage) {this.currentPage =currentPage;

}publicString getCurrentCount() {returncurrentCount;

}public voidsetCurrentCount(String currentCount) {this.currentCount =currentCount;

}publicString getBigName() {returnbigName;

}public voidsetBigName(String bigName) {this.bigName =bigName;

}publicString getBigStatus() {returnbigStatus;

}public voidsetBigStatus(String bigStatus) {this.bigStatus =bigStatus;

}publicString getStartMonth() {returnstartMonth;

}public voidsetStartMonth(String startMonth) {this.startMonth =startMonth;

}

}