基于SSM对用户信息进行分页展示（IDEA详细开发）

最新推荐文章于 2023-01-01 19:34:23 发布

小样x

最新推荐文章于 2023-01-01 19:34:23 发布

阅读量880

点赞数 1

分类专栏： Java后端相关随笔文章标签： spring bootstrap ssm

本文链接：https://blog.csdn.net/weixin_39615182/article/details/114987782

版权

Java后端相关随笔专栏收录该内容

27 篇文章 10 订阅

订阅专栏

一、效果展示

在这里插入图片描述

视频讲解：https://www.bilibili.com/video/BV1gC4y1p7z2?p=878
实现代码在最后（免费分享）

二、实现步骤

2.1 新建Maven项目

在这里插入图片描述

2.2 搭建基本环境

创建如下数据库，并自行添加数据
在这里插入图片描述
导入依赖
pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.yx</groupId>
    <artifactId>SSMPage</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <dependencies>
        <!--SpringMVC-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.1.6.RELEASE</version>
        </dependency>
        <!--serrvlet编译环境-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.1</version>
            <scope>provided</scope>
        </dependency>
        <!--jsp编译环境-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.0</version>
            <scope>provided</scope>
        </dependency>
        <!--javax.servlet/jstl -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

        <!--fastjson-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.54</version>
        </dependency>
        <!--juint-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <!--spring-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.1.6.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.3.6.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aspects</artifactId>
            <version>5.1.6.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>4.3.6.RELEASE</version>
        </dependency>
        <!--Mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>

        <!--mysql驱动依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.29</version>
            <scope>runtime</scope>
        </dependency>
        <!--druid连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.16</version>
        </dependency>
        <!--分页-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.10</version>
        </dependency>
    </dependencies>

    <build>
        <!--更改Maven编译规则-->
        <resources>
            <resource>
                <!--资源目录-->
                <directory>src/main/java</directory>
                <includes>
                    <include>*.xml</include>
                    <include>**/*.xml</include><!--**表示多级目录-->
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>
</project>

src/main/resources下导入三个文件

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
         http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

    <!--DataSource-->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <!--基本配置-->
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <!--SqlSessionFactory 要DataSource支持-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--注入连接池-->
        <property name="dataSource" ref="dataSource"/>
        <!--注入dao-mapoper文件信息-->
        <property name="mapperLocations">
            <list>
                <value>classpath:com/yx/dao/*.xml</value>
            </list>
        </property>
        <!--使得实体类中用类名作为别名-->
        <property name="typeAliasesPackage" value="com.yx.entity"></property>

        <!--分页-->
        <property name="plugins">
            <array>
                <bean class="com.github.pagehelper.PageInterceptor">
                    <property name="properties">
                        <props>
                            <!--页号在合理值 0 - max-->
                            <prop key="reasonable">true</prop>
                        </props>
                    </property>
                </bean>
            </array>
        </property>
    </bean>

    <!--Dao 需要 MapperScannerConfigurer支持-->
    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.yx.dao"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>
    <!--告知spring注解位置，保证注解有效性，下面扫描表示Controller不扫，给MVC扫-->
    <context:component-scan base-package="com.yx">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"></context:exclude-filter>
    </context:component-scan>
    <!--引入一个事务管理器-->
    <bean id="tx" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--@Transactional 告诉spring，定制事务是基于DataSourceTransactionManager-->
    <tx:annotation-driven transaction-manager="tx"></tx:annotation-driven>

</beans>

jdbc.properties

jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/mybatis_test?useUnicode=true&characterEncoding=utf-8
jdbc.username = root
jdbc.password = root

mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd">
    <!--注解扫描，只扫Controller-->
    <context:component-scan base-package="com.yx" use-default-filters="false">
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"></context:include-filter>
    </context:component-scan>
    <!--注解驱动-->
    <mvc:annotation-driven></mvc:annotation-driven>
    <!--静态资源handler-->
    <mvc:default-servlet-handler/>

    <mvc:annotation-driven>
        <mvc:message-converters>
            <bean class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">
                <!--声明类型转换-->
                <property name="supportedMediaTypes">
                    <list>
                        <value>application/json</value>
                    </list>
                </property>
            </bean>
        </mvc:message-converters>
    </mvc:annotation-driven>

    <!--视图解析器(捕获后端控制器 + 拼接)-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!--前缀-->
        <property name="prefix" value="/"></property>
        <!--后缀-->
        <property name="suffix" value=".jsp"></property>
    </bean>

</beans>

新建实体类User（与数据库列名对应）

package com.yx.entity;

import java.util.Date;

public class User {
    private Integer id;

    private String username;

    private String password;

    private Boolean gender;

    private Date registerTime;

    public User() {
    }

    public User(Integer id, String username, String password, Boolean gender, Date registerTime) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.gender = gender;
        this.registerTime = registerTime;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", gender=" + gender +
                ", registerTime=" + registerTime +
                '}';
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Boolean getGender() {
        return gender;
    }

    public void setGender(Boolean gender) {
        this.gender = gender;
    }

    public Date getRegisterTime() {
        return registerTime;
    }

    public void setRegisterTime(Date registerTime) {
        this.registerTime = registerTime;
    }
}

新建User后台控制器UserController

package com.yx.web;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;


@Controller
public class UserController {
    
    @GetMapping("/users")
    public void queryUsers(Model model){
        
    }
}

在main目录下新建webapp/WEB-INF/web.xml
web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">

    <!--SpringMVC前端（核心）控制器，启动Controller组件-->
    <servlet>
        <servlet-name>mvc_yx</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <!--声明配置文件位置-->
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:mvc.xml</param-value>
        </init-param>
        <!--懒汉式 饿汉式 （可选）-->
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>mvc_yx</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <!--防乱码-->
    <filter>
        <filter-name>encoding</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>utf-8</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>encoding</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!--在项目启动时，同时启动Spring工厂，使得Dao和Service以及Druid连接池启动-->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
</web-app>

至此，基本环境搭建完毕，如下
在这里插入图片描述

2.3 功能实现

接下来便是功能实现，dao->service->controller三层依次实现
先新建UserDao

package com.yx.dao;

import com.yx.entity.User;

import java.util.List;

public interface UserDao {
    List<User> queryUsers();
}

再写UserDaoMapper.xml

<?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.yx.dao.UserDao">

    <select id="queryUsers" resultType="User">
        select id,username,password,gender,regist_time as registerTime
        from user
    </select>
</mapper>

在这里插入图片描述
再写一个TestPage.java对刚写的UserDao进行测试

package com.yx;

import com.yx.dao.UserDao;
import com.yx.entity.User;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.util.List;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class TestPage {
    @Autowired
    private UserDao userDao;
    @Test
    public void test1(){
        List<User> users = userDao.queryUsers();
        for (User user : users) {
            System.out.println(user);
        }
    }
}

在这里插入图片描述
运行后，测试成功

同样的写service

UserServiceImpl.java

package com.yx.service.impl;

import com.github.pagehelper.PageHelper;
import com.yx.dao.UserDao;
import com.yx.entity.User;
import com.yx.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Service("userService") //默认id  userServiceImpl
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDao userDao;

    @Transactional(propagation = Propagation.SUPPORTS)
    public List<User> queryUsers() {
        return userDao.queryUsers();
    }
}

UserService.java

package com.yx.service;

import com.yx.entity.User;

import java.util.List;


public interface UserService {
    List<User> queryUsers();
}

在TestPage中测试UserService，新增service注入和test2变成

package com.yx;

import com.yx.dao.UserDao;
import com.yx.entity.User;
import com.yx.service.UserService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.util.List;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class TestPage {
    @Autowired
    private UserDao userDao;
    @Autowired
    @Qualifier("userService")
    private UserService userService;

    @Test
    public void test1(){
        List<User> users = userDao.queryUsers();
        for (User user : users) {
            System.out.println(user);
        }
    }
    @Test
    public void test2(){
        List<User> users = userService.queryUsers();
        for (User user : users) {
            System.out.println(user);
        }
    }
}

运行test2，测试成功
在这里插入图片描述
接下来完善UserController

package com.yx.web;

import com.yx.entity.User;
import com.yx.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;

import java.util.List;

@Controller
public class UserController {

    @Autowired
    @Qualifier("userService")
    private UserService userService;

    @GetMapping("/users")
    public String queryUsers(Model model){
        List<User> users = userService.queryUsers();
        model.addAttribute("users",users);
        return "user";
    }
}

return “user” 会被mvc.xml中的视图解析器识别，拼接成/user.jsp
所以我们在webapp下写一个user.jsp
在这里插入图片描述

<%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2021-3-18 0018
  Time: 15:02
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <table width="550px" align="center" border="1px">
        <thead>
            <tr>
                <th>id</th>
                <th>username</th>
                <th>password</th>
                <th>gender</th>
                <th>registerTime</th>
            </tr>
        </thead>
        <tbody>
            <c:forEach items="${requestScope.users}" var="user">
                <tr>
                    <td>${user.id}</td>
                    <td>${user.username}</td>
                    <td>${user.password}</td>
                    <td>${user.gender}</td>
                    <td><fmt:formatDate value="${user.registerTime}" pattern="yyyy-MM-dd"/></td>
                </tr>
            </c:forEach>
        </tbody>
    </table>
</body>
</html>

配置Tomcat 并运行，输入下面地址，出现对应数据库中内容

在这里插入图片描述

2.4 界面美化和上下翻页实现

webapp下新建userPro.jsp，视作user.jsp的扩展，将BootStrap框架中表格样式导入

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<!doctype html>
<html>
<head>
    <title>Title</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap 的 CSS 文件 -->
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.0/dist/css/bootstrap.min.css" integrity="sha384-B0vP5xmATw1+K9KRQjQERJvTumQW0nPEzvF6L/Z6nronJ3oUOFUFpCjEUQouq2+l" crossorigin="anonymous">
    <!--jQuery 和 Bootstrap 集成包（集成了Popper） -->
    <script src="https://cdn.jsdelivr.net/npm/jquery@3.5.1/dist/jquery.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-LCPyFKQyML7mqtS+4XytolfqyqSlcbB3bvDuH9vX2sdQMxRonb/M3b9EmhCNNNrV" crossorigin="anonymous"></script>

</head>
<body>
<table class="table table-striped table-dark">
    <thead>
    <tr>
        <th>id</th>
        <th>username</th>
        <th>password</th>
        <th>gender</th>
        <th>registerTime</th>
    </tr>
    </thead>
    <tbody>
    <c:forEach items="${requestScope.users}" var="user">
        <tr>
            <td>${user.id}</td>
            <td>${user.username}</td>
            <td>${user.password}</td>
            <td>${user.gender}</td>
            <td><fmt:formatDate value="${user.registerTime}" pattern="yyyy-MM-dd"/></td>
        </tr>
    </c:forEach>
    </tbody>
</table>
<nav aria-label="...">
    <ul class="pagination justify-content-center">
        <li class="page-item disabled">
            <a class="page-link" href="#" tabindex="-1" aria-disabled="true">Previous</a>
        </li>
        <li class="page-item"><a class="page-link" href="#">1</a></li>
        <li class="page-item active" aria-current="page">
            <a class="page-link" href="#">2</a>
        </li>
        <li class="page-item"><a class="page-link" href="#">3</a></li>
        <%--<c:forEach begin="1" end="${requestScope.data.pages}" var="pageNum">
            <li class="page-item"><a class="page-link" href="#">${pageNum}</a></li>
        </c:forEach>--%>
        <li class="page-item">
            <a class="page-link" href="#">Next</a>
        </li>
    </ul>
</nav>
</body>
</html>

修改UserController中的return，改为userPro，视图解析器会拼接成/userPro.jsp
输入地址后

在这里插入图片描述

上面将所有数据都显示出来，分页也只是有样式，点击没有反应，我们把对应功能进行实现，让每页展示3条数据

配置分页插件
在这里插入图片描述
UserServiceImpl中加分页的PageHelper，参数100，3表示查第100页，每页显示3条数据，明显数据只有10条，只能显示4页，最后一页只有一条数据，那么PageHelper会自动转到最后一页，即输入比总页数还大的参数，最后自动转为最后一页，输入比1小的数，会自动转为第一页。自动帮你防止参数越界。
在这里插入图片描述
我们到TestPage测试test2方法，点执行，查到最后一页的一条数据

所以从上面可以知道分页需要pageNum和pageSize两个参数，我们可以将两个参数封装一下，封装成Page实体放在entity中
Page.java

package com.yx.entity;

public class Page {

    private Integer pageNum=1;//默认第1页

    private Integer pageSize=3;//默认页大小3

    public Page() {
    }

    public Page(Integer pageNum, Integer pageSize) {
        this.pageNum = pageNum;
        this.pageSize = pageSize;
    }

    @Override
    public String toString() {
        return "Page{" +
                "pageNum=" + pageNum +
                ", pageSize=" + pageSize +
                '}';
    }

    public Integer getPageNum() {
        return pageNum;
    }

    public void setPageNum(Integer pageNum) {
        this.pageNum = pageNum;
    }

    public Integer getPageSize() {
        return pageSize;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize = pageSize;
    }
}

修改UserService，UserServiceImpl
在这里插入图片描述

修改UserController，加Page对象

测试，传入自己定义的page先做个测试

重新部署，输入地址，地址中夹带参数测试

接下来，实现上一页 / 下一页
先改UserService和UserServiceImpl
在这里插入图片描述
这样返回的就是一个封装着大量分页数据的对象
UserController也要改

接下来就可以到页面userPro.jsp改了
最后改结果

userPro.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<!doctype html>
<html>
<head>
    <title>Title</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap 的 CSS 文件 -->
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.0/dist/css/bootstrap.min.css" integrity="sha384-B0vP5xmATw1+K9KRQjQERJvTumQW0nPEzvF6L/Z6nronJ3oUOFUFpCjEUQouq2+l" crossorigin="anonymous">
    <!--jQuery 和 Bootstrap 集成包（集成了Popper） -->
    <script src="https://cdn.jsdelivr.net/npm/jquery@3.5.1/dist/jquery.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-LCPyFKQyML7mqtS+4XytolfqyqSlcbB3bvDuH9vX2sdQMxRonb/M3b9EmhCNNNrV" crossorigin="anonymous"></script>

</head>
<body>
<table class="table table-striped table-dark">
    <thead>
    <tr>
        <th>id</th>
        <th>username</th>
        <th>password</th>
        <th>gender</th>
        <th>registerTime</th>
    </tr>
    </thead>
    <tbody>
    <c:forEach items="${requestScope.data.list}" var="user">
        <tr>
            <td>${user.id}</td>
            <td>${user.username}</td>
            <td>${user.password}</td>
            <td>${user.gender}</td>
            <td><fmt:formatDate value="${user.registerTime}" pattern="yyyy-MM-dd"/></td>
        </tr>
    </c:forEach>
    </tbody>
</table>
<nav aria-label=".. .">
    <ul class="pagination justify-content-center">
        <c:if test="${requestScope.data.hasPreviousPage}">
            <li class="page-item">
                <a class="page-link" href="${pageContext.request.contextPath}/users?pageNum=${requestScope.data.prePage}" tabindex="-1" aria-disabled="true">Prevoius</a>

            </li>
        </c:if>

        <c:if test="${!requestScope.data.hasPreviousPage}">
            <li class="page-item disabled">
                <a class="page-link" href="#" tabindex="-1" aria-disabled="true">Prevoius</a>
            </li>
        </c:if>
        <c:forEach begin="1" end="${requestScope.data.pages}" var="i">
            <!--表示选中的等于当前页，那么就页面蓝色选中标识，没选中就不是蓝色标识-->
            <c:if test="${i==requestScope.data.pageNum}">
                <li class="page-item active"><a class="page-link" href="${pageContext.request.contextPath}/users?pageNum=${i}">${i}</a></li>
            </c:if>
            <c:if test="${i!=requestScope.data.pageNum}">
                <li class="page-item"><a class="page-link" href="${pageContext.request.contextPath}/users?pageNum=${i}">${i}</a></li>
            </c:if>
        </c:forEach>

        <c:if test="${requestScope.data.hasNextPage}">
            <li class="page-item">
                <a class="page-link" href="${pageContext.request.contextPath}/users?pageNum=${requestScope.data.nextPage}">Next</a>
            </li>
        </c:if>
        <c:if test="${!requestScope.data.hasNextPage}">
            <li class="page-item disabled">
                <a class="page-link" href="#">Next</a>
            </li>
        </c:if>

    </ul>
</nav>
</body>
</html>

最终效果，上一页下一页都可以点击，且第一页最后一页的Previous和Next都会禁用(灰色)
在这里插入图片描述

在这里插入图片描述

代码下载链接：https://download.csdn.net/download/weixin_39615182/15909415
在这里插入图片描述

小样x

关注

1
点赞
踩
7

收藏

觉得还不错? 一键收藏
打赏
0
评论
基于SSM对用户信息进行分页展示（IDEA详细开发）

目录一、效果展示二、步骤2.1 新建Maven项目2.2 搭建基本环境2.3 功能实现2.4 界面美化和上下翻页实现一、效果展示二、步骤2.1 新建Maven项目2.2 搭建基本环境创建如下数据库，并自行添加数据导入依赖pom.xml<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://w
复制链接

扫一扫