SSM三大框架实现用户管理系统（源代码及实现步骤）

灰太狼 2024-04-18 23:58 21阅读 0赞

# 第一步：项目准备 #

**此系统是使用IDEA开发，在maven框架上实现的**

### 1.1 项目结构 ###

1.  创建bean包，存放用户**实体类User**；
2.  创建controller包，存放SpringMVC的控制类（servlet），**登录检查类和用户控制类**；
3.  创建interceptors包，存放登录检查的**拦截器类**；
4.  创建mapper包，存放Mybatis的**用户接口类**；
5.  创建pagingquery包，存放**分页查询**的逻辑类及对象类；
6.  创建service包，存放**业务类**接口及其实现类；

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDc4NDY3Mw_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDc4NDY3Mw_size_16_color_FFFFFF_t_70 1]

### 1.2 依赖导入 ###

<?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.project</groupId>
      <artifactId>SSM01</artifactId>
      <version>1.0.0</version>
      <packaging>war</packaging>
    
      <name>SSM01 Maven Webapp</name>
      
      <url>http://www.example.com</url>
    
      <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>1.7</maven.compiler.source>
        <maven.compiler.target>1.7</maven.compiler.target>
        <project.spring.version>5.0.0.RELEASE</project.spring.version>
      </properties>
    
      <dependencies>
        
    
    
        <dependency>
          <groupId>org.projectlombok</groupId>
          <artifactId>lombok</artifactId>
          <version>1.16.20</version>
        </dependency>
    
        <dependency>
          <groupId>jstl</groupId>
          <artifactId>jstl</artifactId>
          <version>1.2</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-core</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
    
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-beans</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
    
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-test</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
    
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-expression</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
    
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-context</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.aspectj</groupId>
          <artifactId>aspectjweaver</artifactId>
          <version>1.8.13</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-jdbc</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-tx</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-aop</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-web</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-webmvc</artifactId>
          <version>${project.spring.version}</version>
        </dependency>
    
        
        
        <dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>druid</artifactId>
          <version>1.1.9</version>
        </dependency>
        
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>5.1.38</version>
        </dependency>
    
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.4.5</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>1.3.1</version>
        </dependency>
    
        
        <dependency>
          <groupId>log4j</groupId>
          <artifactId>log4j</artifactId>
          <version>1.2.17</version>
        </dependency>
    
        <dependency>
          <groupId>org.slf4j</groupId>
          <artifactId>slf4j-api</artifactId>
          <version>1.7.25</version>
        </dependency>
    
        <dependency>
          <groupId>org.slf4j</groupId>
          <artifactId>slf4j-log4j12</artifactId>
          <version>1.7.25</version>
        </dependency>
    
        
        <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>javax.servlet-api</artifactId>
          <version>3.1.0</version>
        </dependency>
        <dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>4.12</version>
        </dependency>
    
      </dependencies>
    
    
    </project>

### 1.3 前端页面准备 ###

#### （1）登录页面 ####

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Login</title>
    </head>
    <body background="/static/loginpicture.png">
        <center>
    
                <h1 style="color: crimson;">登录页面</h1>
                <form action="/logincheck" method="post" >
                    账号：<input name="username"/><br/>
                    密码：<input type="password" name="password"/><br/>
                    <input type="submit" value="提交"/>
                </form>
    
        </center>
    </body>
    </html>

#### （2）系统主页面 ####

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    <html>
    <head>
        <title>Title</title>
    
        <script>
            function goPage(page) {
                //设置当前页的值
                document.getElementById("currentPage").value = page;
                //提交表单
                var form = document.getElementById("searchForm");
                form.submit();   //提交表单
            }
        </script>
    
    </head>
    <body background="/static/backpicture.png">
        <center>
            <h1>用户管理系统</h1>
    
            <form id="searchForm" action="/pagequery" method="post">
                工号：<input name="id" value="${queryObject.id}"/>
                姓名：<input name="username" value="${queryObject.username}"/>
                密码：<input name="password" value="${queryObject.password}"/>
                <input type="submit" value="点击查询"/><br/>
    
                <br/>
                <a href="/check" style="margin-right: 640px;height: 80px">新增</a><br/>
                <table border="1"   style="width:50%;height: 60%">
                    <tr>
                        <th>数量</th>
                        <th>编号</th>
                        <th>姓名</th>
                        <th>密码</th>
                        <th>操作</th>
    
                    </tr>
                    <c:forEach items="${user.list}" var="info" varStatus="i">
                        <tr>
                            <td>${i.count}</td>
                            <td>${info.id}</td>
                            <td>${info.username}</td>
                            <td>${info.password}</td>
                            <td align="center"><a href="/check?mark=${info.id}">修改</a>|<a href="/delete?mark=${info.id}">删除</a></td>
                        </tr>
    
                    </c:forEach>
    
                    <tr>
                        <td colspan="5" align="center">
                            <a href="javascript:void(0);" onclick="goPage(1)">首页</a>
                            <a href="javascript:void(0);" onclick="goPage(${user.prevPage})">上页</a>
                            <a href="javascript:void(0);" onclick="goPage(${user.nextPage})">下页</a>
                            <a href="javascript:void(0);" onclick="goPage(${user.totalPages})">尾页</a>
                            <input name="currentPage" id="currentPage" value="${queryObject.currentPage}"/><input type="submit" value="跳转"><br/>
                            每页显示<select name="pageSize" onchange="goPage(1)">
                                <option value="2" ${queryObject.pageSize == 2?'selected':''}>2</option>
                                <option value="4" ${queryObject.pageSize == 4?'selected':''}>4</option>
                                <option value="6" ${queryObject.pageSize == 6?'selected':''}>6</option>
                            </select>条   
                            当前${user.currentPage}页/共${user.totalPages}页/共${user.totalCount}条
    
                        </td>
    
                    </tr>
    
                </table>
            </form>
        </center>
    </body>
    </html>

#### （3）新增/修改用户页面 ####

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>Title</title>
    </head>
    <body background="/static/wangtian.jpg">
        <center>
            <h2>用户信息</h2>
            <form action="/insertANDupdate" method="post">
                <input type="hidden" name="id" value="${user_update.id}"/>
                账号：<input name="username" value="${user_update.username}"/><br/>
                密码：<input type="password" name="password" ${user_update.password}/><br/>
                <input type="submit" value="提交"/>
            </form>
    
        </center>
    
    </body>
    </html>

# 第二步：配置Spring框架 #

#### 2.1 配置Spring配置文件（applicationContext.xml） ####

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
    
    
        
        
        <context:property-placeholder location="classpath:db.properties" system-properties-mode="NEVER"/>
    
        <bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${username}"/>
            <property name="password" value="${password}"/>
        </bean>
    
    
        
        <bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="datasource"/>
            
            <property name="typeAliasesPackage" value="com.project.SSM.user4crud"/>
            
            <property name="mapperLocations" value="classpath:com/project/SSM/user4crud/mapper/*.xml"/>
            
            <property name="configLocation" value="classpath:mybatis.xml"/>
        </bean>
    
    
    
        
    
        
        
        
    
    
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.project.SSM.user4crud.mapper"/>
            
        </bean>
    
    
    
    
        
        <context:component-scan base-package="com.project.SSM.user4crud"/>
    
    
    
        
        
        
        <bean id="manager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
            <property name="dataSource" ref="datasource"/>
        </bean>
    
        
        <aop:config>
            <aop:pointcut id="point" expression="execution( * com.project.SSM.user4crud.service.IUserService.*(..))"/>
            <aop:advisor advice-ref="advice" pointcut-ref="point"/>
        </aop:config>
        
        <tx:advice id="advice" transaction-manager="manager">
            <tx:attributes>
                
                <tx:method name="select*" read-only="true"/>
                <tx:method name="find*" read-only="true"/>
                <tx:method name="*"/>
            </tx:attributes>
        </tx:advice>
    
    
    
    
    </beans>

#### 2.2 配置service业务类 ####

（1） 创建接口 **IUserService**

public interface IUserService {
    
        int insert(User user);
    
        int delete(Integer id);
    
        int update(User user);
    
        User selectone(Integer id);
    
        List<User> select();
    
        /*登录检查*/
        User finduser(User user);
    
        /*模糊查询*/
        List<User> query(User user);
    
        /*分页条件查询*/
        PageResult pagquery(QueryObject qo);
    }

（2） 创建**接口实现类**

@Service
    public class UserServiceImpl implements IUserService {
        @Autowired
        private IUserMapper mapper;
    
        @Override
        public int insert(User user) {
            int insert = mapper.insert(user);
            return insert;
        }
    
        @Override
        public int delete(Integer id) {
            int delete = mapper.delete(id);
            return delete;
        }
    
        @Override
        public int update(User user) {
            int update = mapper.update(user);
            return update;
        }
    
        @Override
        public User selectone(Integer id) {
            User selectone = mapper.selectone(id);
            return selectone;
        }
    
        @Override
        public List<User> select() {
            List<User> select = mapper.select();
            return select;
        }
    
        @Override
        public User finduser(User user) {
            User finduser = mapper.finduser(user);
            return finduser;
        }
    
        //模糊查询
        public List<User> query(User user) {
            List<User> query = mapper.query(user);
            return query;
        }
    
        //分页查询
        public PageResult pagquery(QueryObject qo) {
            //将前台获取到的 当前页数、每页数量，直接赋值给pageResult
    
            //从数据库查询 总条数、数据集 后，赋值给pageResult
            Integer integer = mapper.queryCount(qo);
            if(integer==0){
                /*若此条件下查询数量为0，就不必去查结果集，直接返回一个空集合*/
    
                return new PageResult(qo.getCurrentPage(),qo.getPageSize(),integer,Collections.EMPTY_LIST);
            }else{
                List<User> users = mapper.queryList(qo);
                return new PageResult(qo.getCurrentPage(),qo.getPageSize(),integer,users);
            }
    
        }
    }

#### 2.3 配置bean实体类 ####

import lombok.*;
    
    @Setter@Getter@ToString
    @AllArgsConstructor@NoArgsConstructor
    public class User {
    
        private Integer id;
        private String username;
        private String password;
    }

#### 2.4 配置日志log4j ####

log4j.logger.com.project.SSM.user4crud=TRACE 根据自己需求修改

# Global logging configuration
    log4j.rootLogger=ERROR, stdout
    # MyBatis logging configuration...
    log4j.logger.com.project.SSM.user4crud=TRACE
    # Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
    log4j.appender.stdout.Encoding=GBK

# 第三步：配置Mybatis框架 #

#### 3.1 配置数据源文件db.properties ####

根据自己需求更改

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql:///person?useUnicode=true&characterEncoding=UTF-8
    username=root
    password=xxx

#### 3.2 配置Mybatis配置文件mybatis.xml ####

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        
        
        
        <settings>
            <setting name="lazyLoadingEnabled" value="true"/>
            <setting name="aggressiveLazyLoading" value="false"/>
            <setting name="lazyLoadTriggerMethods" value=""/>
        </settings>
    </configuration>

#### 3.3 创建mapper接口文件 IUserMapper ####

package com.project.SSM.user4crud.mapper;
    
    import com.project.SSM.user4crud.bean.User;
    import com.project.SSM.user4crud.pagingquery.PageResult;
    import com.project.SSM.user4crud.pagingquery.QueryObject;
    
    import java.util.List;
    
    public interface IUserMapper {
    
        int insert(User user);
    
        int delete(Integer id);
    
        int update(User user);
    
        User selectone(Integer id);
    
        List<User> select();
    
        /*登录检查*/
        User finduser(User user);
    
        /*模糊查询*/
        List<User> query(User user);
    
        /*分页查询（一）总条数（带着模糊查询的条件）*/
        Integer queryCount(QueryObject qo);
        /*分页查询（二）数据集（带着模糊查询的条件）*/
        List<User> queryList(QueryObject qo);
    }

#### 3.4 创建mapper接口的映射文件usermapper.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.project.SSM.user4crud.mapper.IUserMapper">
    
        
        <resultMap id="usermap" type="com.project.SSM.user4crud.bean.User">
            
            <id column="id" property="id"/>
            <result column="name" property="username"/>
            <result column="passwd" property="password"/>
        </resultMap>
    
        
        
        <insert id="insert" useGeneratedKeys="true" keyProperty="id" keyColumn="id">
            insert into users value (null,#{username},#{password})
       </insert>
    
        
        <update id="update">
            update users set name=#{username},passwd=#{password} where id=#{id}
        </update>
    
        
        <delete id="delete">
            delete from users where id=#{id}
        </delete>
    
    
        <select id="select" resultMap="usermap">
            select * from users
        </select>
    
        
        <select id="selectone"  resultMap="usermap">
            select * from users where id=#{id}
        </select>
    
        
        <select id="finduser" resultMap="usermap">
            select * from users where name=#{username} and passwd=#{password}
        </select>
    
        
        <select id="query" resultMap="usermap">
            select * from users
            <where>
                <if test="id != null and id != ''">
                    and id=#{id}
                </if>
                <if test="username != null and username != ''">
                    and name like concat('%',#{username},'%')
                </if>
                <if test="password !=null and password != '' ">
                    and passwd like concat('%',#{password},'%')
                </if>
            </where>
        </select>
    
        
        <select id="queryCount" resultType="integer">
            select count(*) from users
            <where>
                <if test="id != null and id != ''">
                    and id=#{id}
                </if>
                <if test="username != null and username != ''">
                    and name like concat('%',#{username},'%')
                </if>
                <if test="password !=null and password != '' ">
                    and passwd like concat('%',#{password},'%')
                </if>
            </where>
        </select>
        
        <select id="queryList" resultMap="usermap">
            select * from users
            <where>
                <if test="id != null and id != ''">
                    and id=#{id}
                </if>
                <if test="username != null and username != ''">
                    and name like concat('%',#{username},'%')
                </if>
                <if test="password !=null and password != '' ">
                    and passwd like concat('%',#{password},'%')
                </if>
            </where>
            limit #{start},#{pageSize}
        </select>
    </mapper>

# 第四步：Spring整合Mybatis #

整合代码已经加在配置文件当中，整合原理可以参考：  
[Spring整合Mybatis][Spring_Mybatis]

# 第五步：配置SpringMVC框架 #

#### 5.1 创建主配置文件springmvc.xml ####

#### 5.2 创建Controller类 ####

（1）创建用户**登录检查类**LoginCheckController

@Controller
    public class LoginCheckController {
        @Autowired
        private IUserService service;
    
        /*ModelAndView mv = new ModelAndView();*/
    
        @RequestMapping("/logincheck")
        public void loginCheck (User user, HttpSession session, HttpServletResponse res) throws IOException {
            //判断能否登陆,并且将用户信息存入session中
            /*User user = new User(null,username,password);*/
            User finduser = service.finduser(user);
    
            if(finduser!=null){
                session.setAttribute("usersession",finduser.getUsername());
                res.sendRedirect("/pagequery");
    
    
            }else{
                res.sendRedirect("/login.html");
            }
    
        }
    }

（2）创建**用户控制类** UserController

@Controller
    public class UserController {
        @Autowired
        private IUserService service;
    
        ModelAndView mv = new ModelAndView();
        QueryObject qo = new QueryObject();
        /*@RequestMapping("/select")
        public ModelAndView select(Model model){
            List<User> select = service.select();
            Model user = model.addAttribute("user", select);
            mv.setViewName("/WEB-INF/user/index.jsp");
            return mv;
        }*/
    
        @RequestMapping("/delete")
        public ModelAndView delete(Integer mark){
    
            int delete = service.delete(mark);
            mv.setViewName("/pagequery");
            return mv;
        }
    
        @RequestMapping("/check")
        public ModelAndView check(Integer mark){
            //判断是增加请求还是修改请求
            if(mark!=null){
                //mark不为空，是修改请求,先根据id查询用户的其他数据
                User selectone = service.selectone(mark);
                mv.addObject("user_update",selectone);
            }else{
                mv.clear();
            }
            //是增加请求
            mv.setViewName("/WEB-INF/user/addANDupdate.jsp");
            return mv;
        }
    
        @RequestMapping("/insertANDupdate")
        public ModelAndView insertANDupdate(User user, HttpServletResponse res) throws IOException {
            //根据id判断，是保存请求还是修改请求
    
            if(user.getId()!=null){
    
                service.update(user);
            }else{
                service.insert(user);
            }
    
            res.sendRedirect("/pagequery");
            //mv.setViewName("/pagequery");   会带着查询条件，不能使用
    
            return mv;
        }
    
    
    
        /*//模糊查询
        @RequestMapping("/mohuquery")
        public ModelAndView mohuquert(User user){
            mv.addObject("preuser",user);
            List<User> query = service.query(user);
            mv.addObject("user",query);
            mv.setViewName("/WEB-INF/user/index.jsp");
            return mv;
        }*/
    
        //分页查询(替代了模糊查询和基础全部查询)
        @RequestMapping("/pagequery")
        public ModelAndView pageQuery(QueryObject qo){
    
            PageResult pagquery = service.pagquery(qo);
    
            mv.addObject("user",pagquery);
            mv.setViewName("/WEB-INF/user/index.jsp");
            return mv;
        }
    }

#### 5.3 创建用户登录拦截器类UserLoginInterceptors ####

public class UserLoginInterceptors implements HandlerInterceptor {
        //前置拦截，判断seesion中是否存在用户
        public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
            HttpSession session = request.getSession();
            Object user = session.getAttribute("usersession");
            if(user == null) {
                response.sendRedirect("/login.html");
                return false;
            }
            return true;
    
        }
    }

# 第六步：Spring整合SpringMVC #

整合代码已经加在配置文件当中，整合原理可以参考：  
[Spring整合SpringMVC][Spring_SpringMVC]

# 第七步：配置分页查询 #

此系统实现了**多条件查询**及**分页查询**功能，并且分页查询是基于多条件查询基础上实现的，当时用分页查询时，页面的请求跳转指向分页查询。

#### 7.1 创建分页查询 逻辑处理类 PageResult ####

//分页查询 --> 逻辑处理类
    @Getter@Setter@ToString
    public class PageResult {
    
        //前台页面传递（根据当前页和每页显示条数，就可以计算完成分页）
        private Integer currentPage;    /*当前页数*/
        private Integer pageSize;       /*每页显示的数据条数*/
    
    
        //从数据库查询出
        private Integer totalCount;         /*总条数*/
        private List list;              /*查询满足条件结果集*/
    
        //计算得到
        private Integer totalPages;         /*总页数*/
        private Integer prevPage;           /*上一页页数*/
        private Integer nextPage;           /*下一页页数*/
    
    
        public PageResult(Integer currentPage,Integer pageSize,Integer totalCount,List list){
            this.currentPage = currentPage;
            this.pageSize = pageSize;
    
            this.list = list;
            this.totalCount = totalCount;
    
            this.totalPages = Double.valueOf(Math.ceil(totalCount*1.0/pageSize)).intValue();
            this.prevPage = currentPage - 1> 1 ? currentPage - 1: 1 ;
            this.nextPage = currentPage + 1<totalPages ? currentPage + 1:totalPages;
        }
    }

#### 7.2 创建分页查询 属性封装类 QueryObject ####

//分页查询 --> 属性封装类
    @Setter@Getter@ToString
    @AllArgsConstructor@NoArgsConstructor
    public class QueryObject {
    
    
        private Integer currentPage = 1;   /*默认第一页*/
    
        private Integer pageSize = 4;       /*默认每页显示4条数据*/
    
        /*要带模糊查询属性*/
        private Integer id;
        private String username;
        private String password;
    
       public Integer getId() {
            return id;
        }
    
        public String getUsername() {
            return StringUtils.isNullOrEmpty(this.username)?null:this.username;
        }
    
        public String getPassword() {
            return StringUtils.isNullOrEmpty(this.password)?null:this.password;
        }
    
    
        public Integer getStart(){
            return (this.currentPage-1)*this.pageSize;
        }
    }

# 第八步：结果展示 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDc4NDY3Mw_size_16_color_FFFFFF_t_70 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDc4NDY3Mw_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/f14e829cd3564f4a8e3f3f8cc6a5d0c7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDc4NDY3Mw_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/a3c6c83c74874ce28a37d7fe9bd1d681.png
[Spring_Mybatis]: https://blog.csdn.net/weixin_44784673/article/details/100804630
[Spring_SpringMVC]: https://blog.csdn.net/weixin_44784673/article/details/100805328
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDc4NDY3Mw_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/6af9df29884845aea06e4a05ed132f0a.png