ssh分页完整实例数据库mysql

package ssh.actions; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import org.apache.log4j.Logger; import org.apache.struts2.ServletActionContext; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import ssh.entities.Department; import ssh.entities.Employees; import ssh.entities.QueryInfo; import ssh.entities.TaoBaoLog; import ssh.services.interfaces.EmployeesServiceInte; import ssh.services.interfaces.TaoBaoLogServiceInte; import ssh.util.Page; import com.opensymphony.xwork2.ActionSupport; import com.sun.org.apache.bcel.internal.generic.NEW; import freemarker.template.SimpleDate; public class TaoBaoLogAction extends ActionSupport { private static Logger logger = Logger.getLogger(TaoBaoLogAction.class); TaoBaoLogServiceInte toabaologService; List<TaoBaoLog> logList; QueryInfo query; Page page=new Page(); public Page getPage() { return page; } public void setPage(Page page) { this.page = page; } public QueryInfo getQuery() { return query; } public void setQuery(QueryInfo query) { this.query = query; } public static Logger getLogger() { return logger; } public static void setLogger(Logger logger) { TaoBaoLogAction.logger = logger; } public List<TaoBaoLog> getLogList() { return logList; } public void setLogList(List<TaoBaoLog> logList) { this.logList = logList; } public TaoBaoLogServiceInte getToabaologService() { return toabaologService; } public void setToabaologService(TaoBaoLogServiceInte toabaologService) { this.toabaologService = toabaologService; } public String getOnePage(){ String status=ServletActionContext.getRequest().getParameter("states"); if(status==null||status.equals("selFirst")){ logList=toabaologService.getAll(query); System.out.println("-=-=-=-="+logList.size()); page.setRecordCount(!logList.isEmpty()?logList.size():0); page.setPageSize(20); page.setPageIndex(1); page.setPageCountMethod(); //设置好总页好，并存放在page里 logList=toabaologService.getBY(query,page); System.out.println("---"+logList.size()); }else{ String crrPage=ServletActionContext.getRequest().getParameter("currentPage"); page.setPageIndex(Integer.parseInt(crrPage)); logList=toabaologService.getBY(query,page); System.out.println("===="+logList.size()); } return SUCCESS; } /*public String getOnePageRecords(){ logList=toabaologService.getBY(query, page); return SUCCESS; } */ /* public static void main(String[] args) { ApplicationContext app=new ClassPathXmlApplicationContext("applicationContext.xml"); TaoBaoLogAction ta=(TaoBaoLogAction) app.getBean("tblogAction"); ta.getAll(); } */ }