package cn.tsjinrong.fastfile.util;/** * @ClassName: Page * @Description: TODO(分页组件的父类，用来封装分页的 通用内容和逻辑) * @author zhanghaiyang * @date 2016年1月14日 下午12:37:55 * @Copyright © 2016上海通善互联网金融信息服务有限公司 */public class Page {// 用户输入的分页条件private int currentPage = 1; // 当前页private int pageSize = 15; // 每页最大行数// 用于实现分页SQL的条件，是根据用户输入条件计算而来的private int begin;private int end;// 自动计算出的总行数private int rows;// 根据总行数计算总页数，然后将总页数输出给页面private int totalPage;public int getRows() {return rows;}public void setRows(int rows) {this.rows = rows;}public int getTotalPage() {// 根据总行数，计算总页数if (rows % pageSize == 0) {totalPage = rows / pageSize;} else {totalPage = rows / pageSize + 1;}return totalPage;}public void setTotalPage(int totalPage) {this.totalPage = totalPage;}public int getBegin() {// 在mapper.xml使用begin属性时，对其进行计算begin = (currentPage - 1) * pageSize;return begin;}public void setBegin(int begin) {this.begin = begin;}public int getEnd() {// 在mapper.xml使用end属性时，对其进行计算end = currentPage * pageSize + 1;return end;}public void setEnd(int end) {this.end = end;}public int getCurrentPage() {return currentPage;}public void setCurrentPage(int currentPage) {this.currentPage = currentPage;}public int getPageSize() {return pageSize;}public void setPageSize(int pageSize) {this.pageSize = pageSize;}}public ModelAndView findVideosByPage(HttpServletRequest request, HttpServletResponse response, FileProperties fp) {ModelAndView model = new ModelAndView("/video/video_list");Map<String, Object> params = new HashMap<String, Object>(3);if (StringUtils.isNotBlank(fp.getBusiId())) {params.put("busiId", fp.getBusiId());}if (StringUtils.isNotBlank(fp.getApplyName())) {params.put("applyName", fp.getApplyName());}if (fp.getApplyDateStart() != null && StringUtils.isNotBlank(fp.getApplyDateStart())) {params.put("applyDateStart", DateUtil.parseDate(fp.getApplyDateStart()));} else {params.put("applyDateStart", DateUtil.addDay(new Date(), -7));}if (fp.getApplyDateEnd() != null && StringUtils.isNotBlank(fp.getApplyDateEnd())) {params.put("applyDateEnd", DateUtil.parseDate(fp.getApplyDateEnd()));} else {params.put("applyDateEnd", DateUtil.format(new Date()));}fp.setRows(fastfileVideoService.selectRows(params));model.addObject("fastfileVideoInfoPage", fp);List<FastfileVideoInfo> fastfileVideoInfos = fastfileVideoService.selectByPage(fp);model.addObject("fastfileVideoInfos", fastfileVideoInfos);model.addObject("applyDateStart", DateUtil.format(DateUtil.addDay(new Date(), -7)));model.addObject("applyDateEnd", DateUtil.format(new Date()));return model;}<select id="selectByPage" resultMap="BaseResultMap" parameterType="cn.tsjinrong.fastfile.util.FileProperties">select<include refid="Base_Column_List" />from fastfile_video_info where 1=1<if test="busiId != null and busiId !=‘‘">and busi_id = #{busiId,jdbcType=VARCHAR}</if><if test="applyName != null and applyName !=‘‘">and apply_name=#{applyName,jdbcType=VARCHAR}</if><if test="applyDateStart != null and applyDateStart !=‘‘">and apply_date &gt;= #{applyDateStart,jdbcType=DATE}</if><if test="applyDateEnd != null and applyDateEnd !=‘‘">and apply_date &lt;= #{applyDateEnd,jdbcType=DATE}</if>and del_flag = 0order by apply_date desc limit #{beginRow},#{pageSize}</select>