Struts+Spring+MyBatis MVC模式实现分页分页查询

最新推荐文章于 2020-05-29 22:18:39 发布

花折剑

最新推荐文章于 2020-05-29 22:18:39 发布

阅读量154

点赞数

本文链接：https://blog.youkuaiyun.com/rexyona/article/details/84363313

版权

java 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一种基于Java的分页查询实现方案，通过自定义PageModel类进行分页参数管理，结合MyBatis实现数据库分页查询，并展示了从Action到DAO层的具体实现过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[b]首先引用一个写好的翻页模板工具类[/b]


import java.util.List;

/*
 * 翻页模板工具类
 * 
 * */
public final class PageModel<T> {
	private int currentPage;// 当前页
	private int pageSize;// 每页显示条数
	private int totalPage;// 总页数
	private int totalRecord;// 总记录数
	private List<T> dataList;// 分页数据

	private PageModel() {
	}

	/*
	 * 初始化PageModel实例
	 */
	private PageModel(final int pageSize, final String page, final int totalRecord) {
		// 初始化每页显示条数
		this.pageSize = pageSize;
		// 设置总记录数
		this.totalRecord = totalRecord;
		// 初始化总页数
		setTotalPage();
		// 初始化当前页
		setCurrentPage(page);

	}

	/*
	 * 外界获得PageModel实例
	 */
	public static PageModel newPageModel(final int pageSize, final String page,
			final int totalRecord) {

		return new PageModel(pageSize, page, totalRecord);
	}

	// 设置当前请求页
	private void setCurrentPage(String page) {
		try {
			currentPage = Integer.parseInt(page);

		} catch (java.lang.NumberFormatException e) {
			// 这里异常不做处理，当前页默认为1
			currentPage = 1;
		}
		// 如果当前页小于第一页时，当前页指定到首页
		if (currentPage < 1) {

			currentPage = 1;
		}

		if (currentPage > totalPage) {

			currentPage = totalPage;

		}

	}

	private void setTotalPage() {
		if (totalRecord % pageSize == 0) {

			totalPage = totalRecord / pageSize;
		} else {
			totalPage = totalRecord / pageSize + 1;
		}
	}

	/*
	 * 获得当前页
	 */
	public int getCurrentPage() {
		return currentPage;
	}

	/*
	 * 获得总页数
	 */
	public int getTotalPage() {
		return totalPage;

	}

	/*
	 * 获得开始行数
	 */
	public int getStartRow() {
		return (currentPage - 1) * pageSize;
	}

	/*
	 * 获得结束行
	 */
	public int getEndRow() {
		return currentPage * pageSize;
	}

	/*
	 * 获得翻页数据
	 */
	public List<T> getDataList() {
		return dataList;
	}

	/*
	 * 设置翻页数据
	 */
	public void setDataList(List<T> dataList) {
		this.dataList = dataList;
	}

	//首页
	 public int getFirst() {

	 return 1;
	 }
	//
	//上一页

	 public int getPrevious() {

	 return currentPage - 1;
	 }
	//
	// // 下一页
	 public int getNext() {

	 return currentPage + 1;
	 }
	//
	// // 尾页
	//
	 public int getLast() {

	 return totalPage;
	 }

[b]Action中[/b]

public String showBorrowPage() {

		Integer currentPage;

		String page = this.getParameter("page");
		// totalRecor计算

		int totalRecord = 0;
		try {
			totalRecord = borrowManagerService.selectTotalRecord();
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}

		PageModel pageModel = PageModel.newPageModel(3, page,
				totalRecord);
		List<Borrow> dataList = new ArrayList<Borrow>();
		try {
			dataList = borrowManagerService.pageSelect(pageModel);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		pageModel.setDataList(dataList);
		this.getReqeust().put("pageModel", pageModel);
		this.getReqeust().put("currentPage",pageModel.getCurrentPage());

		//System.out.println(pageModel.getTotalPage());
		return "showBorrowPage";
	}

[b]serviece层[/b]


package com.weixin.bm.rack.service;
public class BorrowManagerServiceImpl implements BorrowManagerService {
	private BorrowDao borrowDao;

	public final void setBorrowDao(BorrowDao borrowDao) {
		this.borrowDao = borrowDao;
	}

    //分页查询
	public List<Borrow> pageSelect(PageModel pageModel) throws SQLException {
		List<Borrow> borrowList = new ArrayList<Borrow>();
		borrowList = borrowDao.pageSelect(pageModel.getStartRow(), pageModel
				.getEndRow());
		return borrowList;
	}
	//计算总条数
	public int selectTotalRecord() throws SQLException {
		 int totalRecord = borrowDao.selectTotalRecord();
		return totalRecord;
	}

}

[b]dao层[/b]

package com.weixin.bm.rack.dao;
import org.mybatis.spring.support.SqlSessionDaoSupport;

import com.weixin.bm.rack.po.Borrow;

public class BorrowDaoImpl extends SqlSessionDaoSupport implements BorrowDao {
	private final static String BM_BORROW_NAMESPACE = "com.weixin.bm.rack.po.BorrowMapper.";
         //分页查询
	public List<Borrow> pageSelect(int startRow,int endRow) throws SQLException {
		List<Borrow> borrowList = new ArrayList<Borrow>();
         Map params =new HashMap();
         params.put("startRow", new Integer(startRow));
         params.put("endRow", new Integer(endRow));

		borrowList = this.getSqlSession().selectList(BM_BORROW_NAMESPACE+"pageSelect",params);

		return borrowList;
	}
         //得到总条数
	public int selectTotalRecord() throws SQLException {
		int totalRecord = (Integer)this.getSqlSession().selectOne(BM_BORROW_NAMESPACE+"selectTotalRecord");
		return totalRecord;
	}

}

[b]Mybatis配置[/b]


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.weixin.bm.rack.po.BorrowMapper">

	<!-- 结果集映射 -->
	<resultMap type="Borrow" id="BorrowResultMap">
		<result property="id" column="id" />
		<result property="managerId" column="manager_id" />
		<result property="borrowerId" column="borrower_id" />
		<result property="bookId" column="book_id" />
		<result property="borrowDate" column="borrow_date" />
		<result property="returnDate" column="return_date" />
		<result property="returnFlag" column="return_flag" />

	</resultMap>

	<!-- 一对多配置 -->
	<resultMap type="Borrow" id="borrow2Book" extends="BorrowResultMap">
		<association property="book" column="book_id" javaType="Book"
			select="com.weixin.bm.rack.po.BookMapper.selectBookById" />
	</resultMap>

		<!-- 分页查询 -->
	<select id="pageSelect" resultMap="borrow2Book" parameterType="map">
		<![CDATA[
		select * from (select * from  (select  id,            
		   manager_id ,      
		   borrower_id ,     
		   book_id,          
		   borrow_date,        
		   return_date,       
		   return_flag,
       	   rownum rn
        FROM bm_borrow) 
        where rn <= #{endRow} ) 
        where rn > #{startRow}
         ]]> 
	</select>
	<!-- 查询总条数-->
	<select id="selectTotalRecord" resultType="int">
	select count(*) from bm_borrow
	</select>


</mapper>

[b]实体层[/b]


package com.weixin.bm.rack.po;

import java.util.Date;
public class Borrow{

	private int id;
	private int managerId;
	private int borrowerId;
	private int bookId;
	private Date borrowDate;
	private Date returnDate;
	private String returnFlag;
	private Book book;
	public Borrow(){

	}
省略Set和Get方法

[b]展示层[/b]


   <s:set var="pageModel" value="#request.pageModel"/>
  <s:iterator var="borrow" value="#pageModel.dataList">

  <tr>
    <td width="200" height="35" align="center"><s:property value="#borrow.id"/></td>
    <td height="35" align="center"><s:property value="#borrow.book.category.categoryName"/></td>
    <td height="35" align="center"><s:property value="#borrow.book.bookName"/></td>
    <td height="35" align="center"><s:property value="#borrow.book.bookAuthor"/></td>
    <td height="35" align="center"><s:property value="#borrow.book.bookPublish"/></td>
    <td height="35" align="center"><s:property value="#borrow.borrowDate"/></td>
    <td height="35" align="center"><s:property value="#borrow.returnDate"/></td>
    <td height="35" align="center"><s:property value="#borrow.returnFlag"/></td>
  </tr>
  </s:iterator>


  <tr>
    <td width="200" height="35" align="center"><a href="book_showMainPage">首页</a></td>
    <td height="35" colspan="5" align="center"><a><s:property value="#request.currentPage"/></a>/<a><s:property value="#request.totalPage"/></a>   
    	<a href="borrow_showBorrowPage?page=<s:property value='#pageModel.first'/>">首页</a>
    	<a href="borrow_showBorrowPage?page=<s:property value='#pageModel.previous'/>">上一页</a>
    	<a href="borrow_showBorrowPage?page=<s:property value='#pageModel.next'/>">下一页</a>
    	<a href="borrow_showBorrowPage?page=<s:property value='#pageModel.last'/>">尾页</a>
    <td height="35" align="center" ><a onclick="saveAsExcel(table1)">导出Excel</a></td>
    <td height="35" align="center" ><a onclick="javascript:window.print();">打印</a></td>
  </tr>