SELECT COUNT(*) FROM 表名

# 第一個(gè) ?：從哪一個(gè)索引的數(shù)據(jù)開(kāi)始查詢(xún)(默認(rèn)從 0 開(kāi)始)
# 第二個(gè) ?：查詢(xún)多少條數(shù)據(jù)
SELECT * FROM 表名 LIMIT ?, ?

// 優(yōu)先計(jì)算總頁(yè)數(shù)
int totalPage = rows % pageSize == 0 ? rows / pageSize : rows / pageSize + 1;
//上一頁(yè)等于當(dāng)前頁(yè)-1,但不能超過(guò)1頁(yè)界限
int prevPage = currentPage - 1 >= 1 ? currentPage - 1 : 1;
//下一頁(yè)等于當(dāng)前頁(yè)+1,但不能超過(guò)總頁(yè)數(shù)界限
int nextPage = currentPage + 1 <= totalPage ? currentPage + 1 : totalPage;

/**
* 封裝結(jié)果數(shù)據(jù)（某一頁(yè)的數(shù)據(jù)）
*/
@Getter
public class PageResult<T> {
?? ?// 兩個(gè)用戶(hù)的輸入
?? ?private int currentPage; // 當(dāng)前頁(yè)碼
?? ?private int pageSize; // 每頁(yè)顯示的條數(shù)
?? ?// 兩條 SQL 語(yǔ)句執(zhí)行的結(jié)果
?? ?private int totalCount; // 總條數(shù)
?? ?private List<T> data; // 當(dāng)前頁(yè)結(jié)果集數(shù)據(jù)
?? ?// 三個(gè)程序計(jì)算的數(shù)據(jù)
?? ?private int prevPage; // 上一頁(yè)頁(yè)碼
?? ?private int nextPage; // 下一頁(yè)頁(yè)碼
?? ?private int totalPage; // 總頁(yè)數(shù)/末頁(yè)頁(yè)碼
?? ?// 分頁(yè)數(shù)據(jù)通過(guò)下面構(gòu)造期封裝好
?? ?public PageResult(int currentPage, int pageSize, int totalCount, List<T>
?? ?data) {
?? ??? ?this.currentPage = currentPage;
?? ??? ?this.pageSize = pageSize;
?? ??? ?this.totalCount = totalCount;
?? ??? ?this.data = data;
?? ??? ?// 計(jì)算三個(gè)數(shù)據(jù)
?? ??? ?this.totalPage = totalCount % pageSize == 0 ? totalCount / pageSize :
?? ??? ?totalCount / pageSize + 1;
?? ??? ?this.prevPage = currentPage - 1 >= 1 ? currentPage - 1 : 1;
?? ??? ?this.nextPage = currentPage + 1 <= this.totalPage ? currentPage + 1 :
?? ??? ?this.totalPage;
?? ?}
}

@Setter
@Getter
/**
* 封裝分頁(yè)查詢(xún)需要的兩個(gè)請(qǐng)求傳入的分頁(yè)參數(shù)
*/
public class QueryObject {
?? ?private int currentPage = 1; // 當(dāng)前頁(yè)碼，要跳轉(zhuǎn)到哪一頁(yè)的頁(yè)碼（需要給默認(rèn)值）
?? ?private int pageSize = 3; // 每頁(yè)顯示條數(shù)（需要給默認(rèn)值）
}

//DAO接口提供兩個(gè)根據(jù)查詢(xún)對(duì)象的查詢(xún)方法
int queryForCount();
List<Product> queryForList(QueryObject qo);
//DAO實(shí)現(xiàn)類(lèi)
@Override
//查詢(xún)數(shù)據(jù)庫(kù)總數(shù)據(jù)條數(shù)
public int queryForCount() {
?? ?SqlSession session = MyBatisUtil.getSession();
?? ?int totalCount =
?? ?session.selectOne("cn.xxx.mapper.ProductMapper.queryForCount");
?? ?session.close();
?? ?return totalCount;
}
@Override
//查詢(xún)某一頁(yè)的結(jié)果集
public List<Product> queryForList(QueryObject qo) {
?? ?SqlSession session = MyBatisUtil.getSession();
?? ?List<Product> products =
?? ?session.selectList("cn.xxx.mapper.ProductMapper.queryForList",qo);
?? ?session.close();
?? ?return products;
}

<select id="queryForCount" resultType="int">
SELECT COUNT(*) FROM product
</select>
<select id="queryForList" resultType="cn.xxx.domain.Product">
SELECT * FROM product LIMIT #{start}, #{pageSize}
</select>

@Setter
@Getter
/**
* 封裝分頁(yè)查詢(xún)需要的兩個(gè)請(qǐng)求傳入的分頁(yè)參數(shù)
*/
public class QueryObject {
?? ?private int currentPage = 1; // 當(dāng)前頁(yè)碼，要跳轉(zhuǎn)到哪一頁(yè)的頁(yè)碼（需要給默認(rèn)值）
?? ?private int pageSize = 3; // 每頁(yè)顯示條數(shù)（需要給默認(rèn)值）
?? ?// 用于 Limit 子句第一個(gè) ? 取值
?? ?public int getStart(){
?? ??? ?return (currentPage - 1) * pageSize;
?? ?}
}

//IProductService接口
public interface IProductService {
?? ?/**
?? ?* 完成查詢(xún)某一頁(yè)的業(yè)務(wù)邏輯功能
?? ?*/
?? ?PageResult<Product> query(QueryObject qo);
}
//Service實(shí)現(xiàn)類(lèi)
public class ProductServiceImpl implements IProductService {
?? ?private IProductDAO productDAO = new ProductDAOImpl();
?? ?@Override
?? ?public PageResult<Product> query(QueryObject qo) {
?? ??? ?// 調(diào)用 DAO 查詢(xún)數(shù)據(jù)數(shù)量
?? ??? ?int totalCount = productDAO.queryForCount();
?? ??? ?// 為了性能加入判斷，若查詢(xún)的數(shù)據(jù)數(shù)量為 0，說(shuō)明沒(méi)有數(shù)據(jù)，返回返回空集合，即集合中沒(méi)有
?? ??? ?元素
?? ??? ?if(totalCount == 0){
?? ??? ??? ?return new PageResult(qo.getCurrentPage(), qo.getPageSize(),
?? ??? ??? ?totalCount, Collections.emptyList());
?? ??? ?}
?? ??? ?// 執(zhí)行到這里代表有數(shù)據(jù)，查詢(xún)當(dāng)前頁(yè)的結(jié)果數(shù)據(jù)
?? ??? ?List<Product> products = productDAO.queryForList(qo);
?? ??? ?return new PageResult(qo.getCurrentPage(), qo.getPageSize(), totalCount,
?? ??? ?products);
?? ?}
}

//創(chuàng)建業(yè)務(wù)層對(duì)象
private IProductService productService = new ProductServiceImpl();

protected void list(HttpServletRequest req, HttpServletResponse resp) throws
ServletException, IOException {
?? ?QueryObject qo = new QueryObject();
?? ?// 獲取請(qǐng)求參數(shù) currentPage，并轉(zhuǎn)型封裝
?? ?String currentPage = req.getParameter("currentPage");
?? ?if(StringUtil.hasLength(currentPage)) {
?? ??? ?qo.setCurrentPage(Integer.valueOf(currentPage));
?? ?}
?? ?// 獲取請(qǐng)求參數(shù) pageSize，并轉(zhuǎn)型封裝
?? ?String pageSize = req.getParameter("pageSize");
?? ?if(StringUtil.hasLength(pageSize)) {
?? ??? ?qo.setPageSize(Integer.valueOf(pageSize));
?? ?}
?? ?// 調(diào)用業(yè)務(wù)層方法來(lái)處理請(qǐng)求查詢(xún)某一頁(yè)數(shù)據(jù)
?? ?PageResult<Product> pageResult = productService.query(qo);
?? ?// 把數(shù)據(jù)共享給 list.jsp
?? ?req.setAttribute("pageResult", pageResult);
?? ?// 控制跳轉(zhuǎn)到 list.jsp 頁(yè)面
?? ?req.getRequestDispatcher("/WEB-INF/views/product/list.jsp").forward(req,
?? ?resp);
}

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
?? ?<head>
?? ??? ?<title>產(chǎn)品列表</title>
?? ??? ?<script type="text/javascript">
?? ??? ??? ?window.onload = function () {
?? ??? ??? ??? ?var trClzs = document.getElementsByClassName("trClassName");
?? ??? ??? ??? ?for(var i = 0; i < trClzs.length; i++){
?? ??? ??? ??? ??? ?trClzs[i].onmouseover = function () {
?? ??? ??? ??? ??? ??? ?console.log(1);
?? ??? ??? ??? ??? ??? ?this.style.backgroundColor = "gray";
?? ??? ??? ??? ??? ?}
?? ??? ??? ??? ??? ?trClzs[i].onmouseout = function () {
?? ??? ??? ??? ??? ??? ?console.log(2);
?? ??? ??? ??? ??? ??? ?this.style.backgroundColor = "";
?? ??? ??? ??? ??? ?}
?? ??? ??? ??? ?}
?? ??? ??? ?}
?? ??? ??? ?// 分頁(yè) JS
?? ??? ??? ?function changePageSize() {
?? ??? ??? ??? ?document.forms[0].submit();
?? ??? ??? ?}
?? ??? ?</script>
?? ?</head>
?? ?<body>
?? ??? ?<a href="/replaceImg.jsp" rel="external nofollow" ><img src="${USER_IN_SESSION.headImg}" title="更換頭
?? ??? ?像"/></a><br/>
?? ??? ?<a href="/product?cmd=input" rel="external nofollow" >添加</a>
?? ??? ?<form action="/product">
?? ??? ??? ?<table border="1" cellspacing="0" cellpadding="0" width="80%">
?? ??? ??? ??? ?<tr>
?? ??? ??? ??? ??? ?<th>編號(hào)</th>
?? ??? ??? ??? ??? ?<th>貨品名</th>
?? ??? ??? ??? ??? ?<th>分類(lèi)編號(hào)</th>
?? ??? ??? ??? ??? ?<th>零售價(jià)</th>
?? ??? ??? ??? ??? ?<th>供應(yīng)商</th>
?? ??? ??? ??? ??? ?<th>品牌</th>
?? ??? ??? ??? ??? ?<th>折扣</th>
?? ??? ??? ??? ??? ?<th>進(jìn)貨價(jià)</th>
?? ??? ??? ??? ??? ?<th>操作</th>
?? ??? ??? ??? ?</tr>
?? ??? ??? ??? ?<c:forEach var="product" items="${pageResult.data}" varStatus="status">
?? ??? ??? ??? ??? ?<tr class="trClassName">
?? ??? ??? ??? ??? ??? ?<td>${status.count}</td>
?? ??? ??? ??? ??? ??? ?<td>${product.productName}</td>
?? ??? ??? ??? ??? ??? ?<td>${product.dir_id}</td>
?? ??? ??? ??? ??? ??? ?<td>${product.salePrice}</td>
?? ??? ??? ??? ??? ??? ?<td>${product.supplier}</td>
?? ??? ??? ??? ??? ??? ?<td>${product.brand}</td>
?? ??? ??? ??? ??? ??? ?<td>${product.cutoff}</td>
?? ??? ??? ??? ??? ??? ?<td>${product.costPrice}</td>
?? ??? ??? ??? ??? ??? ?<td>
?? ??? ??? ??? ??? ??? ??? ?<a href="/product?cmd=delete&id=${product.id}" rel="external nofollow" >刪除</a>
?? ??? ??? ??? ??? ??? ??? ?<a href="/product?cmd=input&id=${product.id}" rel="external nofollow" >修改</a>
?? ??? ??? ??? ??? ??? ?</td>
?? ??? ??? ??? ??? ?</tr>
?? ??? ??? ??? ?</c:forEach>
?? ??? ??? ??? ?<tr align="center">
?? ??? ??? ??? ??? ?<td colspan="9">
?? ??? ??? ??? ??? ??? ?<a href="/product?currentPage=1" rel="external nofollow" >首頁(yè)</a>
?? ??? ??? ??? ??? ??? ?<a href="/product?currentPage=${pageResult.prevPage}" rel="external nofollow" >上一頁(yè)</a>
?? ??? ??? ??? ??? ??? ?<a href="/product?currentPage=${pageResult.nextPage}" rel="external nofollow" >下一頁(yè)</a>
?? ??? ??? ??? ??? ??? ?<a href="/product?currentPage=${pageResult.totalPage}" rel="external nofollow" >尾頁(yè)</a>
?? ??? ??? ??? ??? ??? ?當(dāng)前第 ${pageResult.currentPage} / ${pageResult.totalPage} 頁(yè)
?? ??? ??? ??? ??? ??? ?一共 ${pageResult.totalCount} 條數(shù)據(jù)
?? ??? ??? ??? ??? ??? ?跳轉(zhuǎn)到<input type="number" onchange="changePageSize()"
?? ??? ??? ??? ??? ??? ?name="currentPage" value="${pageResult.currentPage}" style="width: 60px;"頁(yè)
?? ??? ??? ??? ??? ??? ?每頁(yè)顯示
?? ??? ??? ??? ??? ??? ?<select name="pageSize" onchange="changePageSize()">
?? ??? ??? ??? ??? ??? ??? ?<option value="3" ${pageResult.pageSize == 3 ? 'selected' : ''}> 3 </option>
?? ??? ??? ??? ??? ??? ??? ?<option value="5" ${pageResult.pageSize == 5 ? 'selected' : ''}> 5 </option>
?? ??? ??? ??? ??? ??? ??? ?<option value="8" ${pageResult.pageSize == 8 ? 'selected' : ''}> 8 </option>
?? ??? ??? ??? ??? ??? ?</select>條數(shù)據(jù)
?? ??? ??? ??? ??? ?</td>
?? ??? ??? ??? ?</tr>
?? ??? ??? ?</table>
?? ??? ?</form>
?? ?</body>
</html>