在SSM框架搭建之maven方式(二)基礎(chǔ)上進(jìn)一步做以下修改
創(chuàng)新互聯(lián)成都企業(yè)網(wǎng)站建設(shè)服務(wù),提供成都做網(wǎng)站、網(wǎng)站設(shè)計(jì)網(wǎng)站開發(fā),網(wǎng)站定制,建網(wǎng)站,網(wǎng)站搭建,網(wǎng)站設(shè)計(jì),自適應(yīng)網(wǎng)站建設(shè),網(wǎng)頁(yè)設(shè)計(jì)師打造企業(yè)風(fēng)格網(wǎng)站,提供周到的售前咨詢和貼心的售后服務(wù)。歡迎咨詢做網(wǎng)站需要多少錢:028-86922220
pom.xml添加如下代碼
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
spring-mybatis.xml的id標(biāo)簽為sqlSessionFactory節(jié)點(diǎn)中添加如下內(nèi)容
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<value>
<!-- 你使用的數(shù)據(jù)庫(kù)類型 -->
helperDialect=MySQL
reasonable=true
autoRuntimeDialect=true
</value>
</property>
</bean>
</array>
</property>
將UserController.java中的內(nèi)容改寫為如下代碼
package com.lymn.it.controller;
import java.util.List;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.lymn.it.model.User;
import com.lymn.it.service.UserService;
@Controller
public class UserController {
@Autowired
UserService userService;
Logger logger=Logger.getLogger(UserController.class);
@RequestMapping(value="/user")
public String user(@RequestParam(defaultValue="1",required=true,value="pageNo") Integer pageNo,Model model) {
logger.info("查詢所有用戶數(shù)據(jù)");
PageHelper.startPage(pageNo, 5);
List<User> userList = userService.getAllUsers();
PageInfo<User> pageInfo=new PageInfo<User>(userList);
model.addAttribute("userList", userList);
model.addAttribute("pageInfo", pageInfo);
logger.info("查詢完畢,返回頁(yè)面");
return "user";
}
}
將user.jsp中的內(nèi)容改寫為如下代碼
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>User</title>
</head>
<body>
<center>
<table width="200" border="1">
<tr>
<th scope="col">userid</th>
<th scope="col">username</th>
<th scope="col">password</th>
<th scope="col">email</th>
</tr>
<c:forEach items="${userList}" var="user">
<tr>
<td>${user.userid}</td>
<td>${user.username}</td>
<td>${user.password}</td>
<td>${user.email}</td>
</tr>
</c:forEach>
</table>
<p>當(dāng)前 ${pageInfo.pageNum }頁(yè),總${pageInfo.pages }
頁(yè),總 ${pageInfo.total } 條記錄</div></p>
<a href="user?pageNo=${pageInfo.firstPage}">第一頁(yè)</a>
<c:if test="${pageInfo.hasPreviousPage }">
<a href="user?pageNo=${pageInfo.pageNum-1}">上一頁(yè)</a>
</c:if>
<c:if test="${pageInfo.hasNextPage }">
<a href="user?pageNo=${pageInfo.pageNum+1}">下一頁(yè)</a>
</c:if>
<a href="user?pageNo=${pageInfo.lastPage}">最后頁(yè)</a>
</center>
</body>
訪問(wèn)如下圖所示表示成功
網(wǎng)站名稱:SSM框架集成分頁(yè)插件
URL標(biāo)題:http://muchs.cn/article10/pdjgdo.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供電子商務(wù)、網(wǎng)站策劃、微信公眾號(hào)、企業(yè)建站、微信小程序、App開發(fā)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)