S2SH+MySql做的分页

package com.chi.action; import java.sql.Timestamp; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import com.chi.idao.IAttendanceType; import com.chi.idao.IStat; import com.chi.idao.Iattendance; import com.chi.idao.Iemployee; import com.chi.pojo.AddAttend; import com.chi.pojo.Attendance; import com.chi.pojo.AttendanceType; import com.chi.pojo.Employee; import com.chi.pojo.PageBean; import com.chi.pojo.SearchCondition; import com.chi.pojo.StatAttendance; import com.chi.service.MemberService; import com.opensymphony.xwork2.ActionContext; public class MainAction { //操作数据方法 private Iemployee employeeImpl; private Iattendance attendanceImpl; private IAttendanceType attendanceTypeImpl; @SuppressWarnings("unused") private IStat statImpl; private SearchCondition searchCondition; public SearchCondition getSearchCondition() { return searchCondition; } public void setSearchCondition(SearchCondition searchCondition) { this.searchCondition = searchCondition; } //pojo private Attendance attendance; private Employee employee; private AttendanceType attendanceType; private AddAttend addAttend;//添加考勤信息 private StatAttendance stat;//统计考勤信息 private MemberService memberService;//分页 private PageBean pageBean; private int page=1; public int getPage() { return page; } public void setPage(int page) { this.page = page; } public void setMemberService(MemberService memberService) { this.memberService = memberService; } public PageBean getPageBean() { return pageBean; } public void setPageBean(PageBean pageBean) { this.pageBean = pageBean; } public void setStatImpl(IStat statImpl) { this.statImpl = statImpl; } public StatAttendance getStat() { return stat; } public void setStat(StatAttendance stat) { this.stat = stat; } public AddAttend getAddAttend() { return addAttend; } public void setAddAttend(AddAttend addAttend) { this.addAttend = addAttend; } public Attendance getAttendance() { return attendance; } public void setAttendance(Attendance attendance) { this.attendance = attendance; } public Employee getEmployee() { return employee; } public void setEmployee(Employee employee) { this.employee = employee; } public AttendanceType getAttendanceType() { return attendanceType; } public void setAttendanceType(AttendanceType attendanceType) { this.attendanceType = attendanceType; } public void setEmployeeImpl(Iemployee employeeImpl) { this.employeeImpl = employeeImpl; } public void setAttendanceImpl(Iattendance attendanceImpl) { this.attendanceImpl = attendanceImpl; } public void setAttendanceTypeImpl(IAttendanceType attendanceTypeImpl) { this.attendanceTypeImpl = attendanceTypeImpl; } /* * 显示雇员 * 考勤信息 * 考勤类型 * */ @SuppressWarnings("unchecked") public void showInfo(){ List<Employee> employeeList=employeeImpl.getAllEmployee(); List<Attendance> attendanceList=attendanceImpl.getAllAttendance(); List<AttendanceType> attendanceTypeList=attendanceTypeImpl.getAllAttendanceType(); ActionContext.getContext().put("employeeList",employeeList);//雇员的信息，工号，姓名 ActionContext.getContext().put("attendanceList", attendanceList);//考情信息。考勤日期，备注 ActionContext.getContext().put("attendanceTypeList", attendanceTypeList);//考勤类型 //分页 this.pageBean=memberService.queryForPage(10,page); } //-------------------------------------------------------------------------------------------------------- public String toMain(){//首页界面 //分页的pageBean,参数pageSize表示每页显示记录数,page为当前页 //每页显示10条数据， //List employeeList=employeeImpl.getAllEmployee(); showInfo(); return "success"; } public String toForward(){ //跳转到考勤录入界面 showInfo(); return "forward"; } //考勤信息录入 public String toAdd() throws Exception{ String[] employeeId=addAttend.getEmployeeId(); String toAttendanceTime=addAttend.getAttendanceTime(); String[] attendanceTypeId=addAttend.getAttendanceTypeId(); String[] attendanceRemark=addAttend.getAttendanceRemark(); SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd"); Date attendTime=sdf.parse(toAttendanceTime); Timestamp attendanceTime=new Timestamp(attendTime.getTime()); for(int i=0;i<employeeId.length;i++){ Attendance attendance=new Attendance(); attendance.setAttendanceRemark(attendanceRemark[i]);//保存备注信息 attendance.setAttendanceTime(attendanceTime); attendance.setAttendanceType(attendanceTypeImpl.getById(Integer.parseInt(attendanceTypeId[i]))); attendance.setEmployee(employeeImpl.getById(Integer.parseInt(employeeId[i]))); attendanceImpl.saveAttendance(attendance);//逐个保存对象 } showInfo(); return "add"; } //考勤删除 public String toDelete(){ String[] delAttendanceId=addAttend.getDelAttendanceId(); for(int i=0;i<delAttendanceId.length;i++){ //Attendance attendance=new Attendance(); attendanceImpl.deleteAttendanceById(Integer.parseInt(delAttendanceId[i])); } showInfo(); return "delete"; } // 考勤统计 // public String toStat(){ // // //List<Employee> employeeList=employeeImpl.getAllEmployee();//统计出考勤情况 // //ActionContext.getContext().put("employeeList", employeeList); // String sql="select distinct employeeNo ,employeeName,attendanceTypeName," + // "count(attendanceTypeName) attendanceTypeNameTotal from Attendance left join AttendanceType "+ // "on attendanceTypeId=fk_attendanceType"+ // " left join Employee "+ // "on employeeId=fk_employeeId"+ // " group by employeeNo ,employeeName,attendanceTypeName"; // List<StatAttendance> statList=statImpl.getBySql(sql); // ActionContext.getContext().put("statList", statList); // return "statist"; // } //查询 public String doSearch(){ int pageSize=10; this.pageBean=memberService.queryForPage(10,page); int offset=PageBean.countOffSet(10,page); //当前页开始记录 //10为每页显示的条数 List<Attendance> attendanceList=attendanceImpl.getByCondition(searchCondition,offset,10); // PageBean pageBean=new PageBean(); pageBean.setAllRow(attendanceList.size()); int allRow=pageBean.getAllRow();//获取总条数 int totalPage=attendanceList.size()%pageSize==0?allRow/pageSize:allRow/pageSize+1; pageBean.setTotalPage(totalPage); // pageBean.setPageSize(pageSize); // pageBean.setCurrentPage(PageBean.countCurrentpage(page)); pageBean.setList(attendanceList);//将遍历出的数据放入list中 // pageBean.init(); // List attendanceList=attendanceImpl.getByName(searchCondition.getSearchTimeFrom()); List<AttendanceType> attendanceTypeList=attendanceTypeImpl.getAllAttendanceType(); ActionContext.getContext().put("attendanceList", attendanceList);//考情信息。考勤日期，备注 ActionContext.getContext().put("attendanceTypeList", attendanceTypeList);//考勤类型 //this.pageBean=memberService.queryForPage(10,page); return "success"; } }