ssm框架中分页查询的核心代码和记住密码功能

最新推荐文章于 2026-08-09 11:55:55 发布

原创最新推荐文章于 2026-08-09 11:55:55 发布 · 1.2k 阅读

8 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

SSM框架学习

博客包含分页查询和记住密码功能的实现代码。分页查询涉及分页类、持久化层、业务层、控制器及jsp页面等核心代码；记住密码功能则涵盖登录控制器代码和jsp页面代码，还展示了分页查询的效果图。

1.分页查询的核心代码

1.1 分页类Page

package com.imooc.oa.entity;

import java.util.List;

public class Page<T> {
    private int currentPage;    //当前页数
    private int totalPage;      //总页数
    private int pageSize;       //每页的记录数
    private int totalCount;       //总的记录数
    private List<T> list;



    public Page(){

    }

    public int getCurrentPage() {
        return currentPage;
    }

    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }

    public int getTotalPage() {
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }

    public int getPageSize() {
        return pageSize;
    }

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

    public int getTotalCount() {
        return totalCount;
    }

    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }

    public List<T> getList() {
        return list;
    }

    public void setList(List<T> list) {
        this.list = list;
    }

    public Page(int currentPage, int totalPage, int pageSize, int totalCount, List<T> list) {
        this.currentPage = currentPage;
        this.totalPage = totalPage;
        this.pageSize = pageSize;
        this.totalCount = totalCount;
        this.list = list;
    }

    @Override
    public String toString() {
        return "Page{" +
                "currentPage=" + currentPage +
                ", totalPage=" + totalPage +
                ", pageSize=" + pageSize +
                ", totalCount=" + totalCount +
                ", list=" + list +
                '}';
    }
}

1.2 持久化层Dao层

 @Select("<script> select * from employee <if test='start!=null and size!=null'> limit #{start},#{size} </if> </script>")
    List<Employee> findByPage(HashMap<String,Object> map);

    @Select("select count(*) from employee")
    //查询总记录数
    int findAllCount();

1.3 业务层service层

public interface EmployeeBiz {
    void add(Employee employee);
    void edit(Employee employee);
    void remove(String sn);
    Employee get(String sn);
    List<Employee> getAll();
    //查询所有数据记录数
    int findAllCount();
    Page<Employee> findByPage(int currentPage);
    }

1.4 service层实现类

  @Override
    public int findAllCount() {
        return employeeDao.findAllCount();
    }

    @Override
    public Page<Employee> findByPage(int currentPage) {
        HashMap<String, Object> map = new HashMap<>();
        Page<Employee> page = new Page<>();

        //封装当前的页数
        page.setCurrentPage(currentPage);

        //每页显示的数据
        int pageSize = 5;
        page.setPageSize(pageSize);

        //封装总记录数
        int totalCount = employeeDao.findAllCount();
        page.setTotalCount(totalCount);

        //封装总页数
        double totalPage = totalCount;
        //向上取整
        Double number = Math.ceil(totalPage / pageSize);
        page.setTotalPage(number.intValue());

        map.put("start",(currentPage-1)*pageSize);
        map.put("size",page.getPageSize());

        //封装每页显示的数据
        List<Employee> lists = employeeDao.findByPage(map);
        page.setList(lists);
        return page;
    }

1.5 控制器

 @RequestMapping("list")
    public String list(@RequestParam(value = "currentPage",defaultValue = "1",required = false)int currentPage, Model model){
        model.addAttribute("pagemsg",employeeBiz.findByPage(currentPage));
        return "employee_list";
    }

1.6 jsp页面核心代码

        <table id="message-table" class="table admin-form theme-warning tc-checkbox-1">
                        <thead>
                        <tr class="">
                            <th class="text-center hidden-xs">Select</th>
                            <th class="hidden-xs">工号</th>
                            <th class="hidden-xs">姓名</th>
                            <th class="hidden-xs">所属部门</th>
                            <th class="hidden-xs">职务</th>
                            <th>操作</th>
                        </tr>
                        </thead>
                        <tbody>
                        <c:forEach items="${requestScope.pagemsg.list}" var="emp">
                            <tr class="message-unread">
                                <td class="hidden-xs">
                                    <label class="option block mn">
                                        <input type="checkbox" name="mobileos" value="FR">
                                        <span class="checkbox mn"></span>
                                    </label>
                                </td>
                                <td>${emp.sn}</td>
                                <td>${emp.name}</td>
                                <td class="text-center fw600">${emp.department.name}</td>
                                <td class="hidden-xs">
                                    <span class="badge badge-warning mr10 fs11">${emp.post}</span>
                                </td>
                                <td>
                                    <a href="/employee/to_update?sn=${emp.sn}">编辑</a>
                                    <a href="/employee/remove?sn=${emp.sn}">删除</a>
                                </td>
                            </tr>
                        </c:forEach>
                        </tbody>
                    </table>
                    <table border="0" cellspacing="0" cellpadding="0"  width="900px">
                        <tr>
                            <td class="td2">
                                <span>第${requestScope.pagemsg.currentPage }/ ${requestScope.pagemsg.totalPage}页</span>
                                <span>总记录数：${requestScope.pagemsg.totalCount }  每页显示:${requestScope.pagemsg.pageSize}</span>
                                <span>
                                          <p style="text-align: right">
                               <c:if test="${requestScope.pagemsg.currentPage != 1}">
                                   <a  href="${pageContext.request.contextPath }/employee/list?currentPage=1">[首页]</a>
                                   <a href="${pageContext.request.contextPath }/employee/list?currentPage=${requestScope.pagemsg.currentPage-1}">[上一页]</a>
                               </c:if>

                               <c:if test="${requestScope.pagemsg.currentPage != requestScope.pagemsg.totalPage}">
                                   <a href="${pageContext.request.contextPath }/employee/list?currentPage=${requestScope.pagemsg.currentPage+1}">[下一页]</a>
                                   <a href="${pageContext.request.contextPath }/employee/list?currentPage=${requestScope.pagemsg.totalPage}">[尾页]</a>
                               </c:if>
                                        </p>
                           </span>
                            </td>
                        </tr>
                    </table>

1.7 效果图
在这里插入图片描述

2.记住密码功能实现代码

2.1登录控制器代码

  @RequestMapping("/login")
    public String login(HttpSession session, @RequestParam String sn, @RequestParam String password, HttpServletRequest request, HttpServletResponse response){
        Employee employee = globalBiz.login(sn,password);

        if (employee == null) {
            return "redirect:to_login";
        }
        else{
            session.setAttribute("employee",employee);
           String sn1= request.getParameter("sn");
           String pwd=request.getParameter("password");
           String ck=request.getParameter("ck");
           Cookie [] cookies=request.getCookies();
           if ("on".equals(ck)){//判断前端页面是否勾选了记住密码
               Cookie cookie=new Cookie("userinfo",sn1+"_"+pwd);
               cookie.setMaxAge(60);
               response.addCookie(cookie);
           }
           else{
               Cookie cookie = new Cookie("userinfo",null);
               cookie.setMaxAge(0);
               //储存
               cookie.setPath("/");
               response.addCookie(cookie);

           }

        }
        return "redirect:self";
    }

2.2 jsp页面

 <form method="post" action="login" id="contact">
                        <%
                            String sn=null;
                            String password=null;
                            Cookie[] cookies=request.getCookies();
                            for (Cookie cookie:cookies){
                                if (cookie.getName().equals("userinfo")){
                                    sn = cookie.getValue().split("_")[0];
                                    password = cookie.getValue().split("_")[1];
                                    //再一次的存起来（备用）
                                    request.setAttribute("sn", sn);
                                    request.setAttribute("password", password);
                                }
                            }
                        %>
                      <input type="text" name="sn" id="sn" class="gui-input" placeholder="请输入工号..." value="${sn}" />
                     <input type="password" name="password" id="password" class="gui-input" placeholder="请输入密码..." value="${password}" />