springmvc+spring+mybatis分页查询实例版本1,ver1.0

2023-07-22 13:27:22

无聊做做看看,几乎没有怎么仔细做过这方面的,总是以为很简单,想想就会,实际做起来结合工作经验感觉还是挺有收获的,可以用在自己的项目上

第一版本思路:框架使用ssm,这个无所谓,采用分页语句查询指定页面的数据,根据数据记录总数,页面显示记录数计算有多少页,每次提交后计算当前页显示的上标和下标,然后进行分页查询,功能实现了,效果不满意,代码贴上,接口就不贴了,直接上接口的实现类,数据根据sql语句自己造吧

package com.mi.controller;

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 com.mi.form.PageTableForm;

import com.mi.service.impl.UserInfoServiceImpl;

@Controller

@RequestMapping("/user")

public class UserInfoCotroller {

    @Autowired

    private UserInfoServiceImpl userInfoServiceImpl;

    private PageTableForm pageTableForm;

    @RequestMapping("/init")

    public String init(Model model) {

        pageTableForm = new PageTableForm();

        return "redirect:/user/query.do";

    }

    @RequestMapping("/query")

    public String queryUserInfo(Model model, PageTableForm pageTableForm) {

        int currentPage = pageTableForm.getCurrentPage() == 0 ? 1 : pageTableForm.getCurrentPage();

        pageTableForm.setCurrentPage(currentPage);

        pageTableForm = userInfoServiceImpl.queryUserInfo(pageTableForm);

        model.addAttribute("pageTableForm", pageTableForm);

        return "userInfo";

    }

    public UserInfoServiceImpl getUserInfoServiceImpl() {

        return userInfoServiceImpl;

    }

    public void setUserInfoServiceImpl(UserInfoServiceImpl userInfoServiceImpl) {

        this.userInfoServiceImpl = userInfoServiceImpl;

    }

    public PageTableForm getPageTableForm() {

        return pageTableForm;

    }

    public void setPageTableForm(PageTableForm pageTableForm) {

        this.pageTableForm = pageTableForm;

    }

}

package com.mi.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import com.mi.dao.UserInfoMapper;

import com.mi.entity.User;

import com.mi.form.PageTableForm;

import com.mi.service.UserInfoService;

@Service("userInfoService")

public class UserInfoServiceImpl implements UserInfoService {

    @Autowired

    private UserInfoMapper userInfoMapper;

    private List<User> userList;

    @Override

    public PageTableForm queryUserInfo(PageTableForm pageTableForm) {

        pageTableForm = getOperation(pageTableForm);

        int beginIndex = pageTableForm.getBeginIndex();

        //int endIndex = pageTableForm.getEndIndex();

        userList = userInfoMapper.queryUserInfo(beginIndex);

        pageTableForm.setUserList(userList);

        return pageTableForm;

    }

    public PageTableForm getOperation(PageTableForm pageTableForm) {

        pageTableForm.setUserCount(getCount());

        if (pageTableForm.getUserCount() % 3 == 0) {

            pageTableForm.setPageCount(pageTableForm.getUserCount() / pageTableForm.getPageSize());

        } else {

            pageTableForm.setPageCount(pageTableForm.getUserCount() / pageTableForm.getPageSize() + 1);

        }

        pageTableForm.setBeginIndex(pageTableForm.getCurrentPage() * 3 - 3);

    //    pageTableForm.setEndIndex(pageTableForm.getCurrentPage() * 3);

        return pageTableForm;

    }

    public UserInfoMapper getUserInfoMapper() {

        return userInfoMapper;

    }

    public void setUserInfoMapper(UserInfoMapper userInfoMapper) {

        this.userInfoMapper = userInfoMapper;

    }

    @Override

    public int getCount() {

        return userInfoMapper.getCount();

    }

    public List<User> getUserList() {

        return userList;

    }

    public void setUserList(List<User> userList) {

        this.userList = userList;

    }

}

package com.mi.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import org.springframework.stereotype.Repository;

import com.mi.entity.User;

@Repository("userInfoMapper")

public interface UserInfoMapper {

    public List<User> queryUserInfo(@Param("beginIndex") int beginIndex);

    public int getCount();

}

<?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.mi.dao.UserInfoMapper">

    <select id="queryUserInfo" resultType="com.mi.entity.User">

        SELECT id,user_name userName,age FROM user_t where 1=1 limit #{beginIndex},3

    </select>

    <select id="getCount" resultType="int">

        SELECT count(*) FROM user_t

    </select>

    <!-- <insert id="addUser" parameterType="com.mi.entity.User"

        flushCache="true">

        INSERT INTO user_t (id,user_name,password,age) VALUES

        (#{id},#{userName},#{password},#{age})

    </insert>

    <delete id="deleteUser" parameterType="com.mi.entity.User" flushCache="true">

        DELETE FROM user_t where id=#{id}

    </delete>

    <update id="updateUser" parameterType="com.mi.entity.User" flushCache="true">

        UPDATE user_t SET user_name = 'zzxy' WHERE id=#{id}

    </update> -->

</mapper>

package com.mi.form;

import java.util.List;

import com.mi.entity.User;

public class PageTableForm {

    private int currentPage;// 当前页

    private int pageSize = 3;// 每页记录数

    private int beginIndex;// 开始位置

    private int endIndex;// 结束位置

    private int pageCount;// 共多少页

    private int userCount;// 共多少条记录

    private List<User> userList;

...省略get set

}

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>Insert title here</title>

<script type="text/javascript"

    src="<%=request.getContextPath()%>/js/jquery-1.8.3.min.js"></script>

<script type="text/javascript">

    $(function() {

        $("#prev").click(

                function() {

                    var currentPage = parseInt($("#currentPage").val()) - 1;

                    $("#currentPage").val(currentPage);

                    $("#form0").submit();

                })

        $("#next").click(

                function() {

                    var currentPage = parseInt($("#currentPage").val()) + 1;

                    $("#currentPage").val(currentPage);

                    $("#form0").submit();

                })

    })

</script>

</head>

<body>

    <form action="${pageContext.request.contextPath}/user/query.do" id="form0" method="POST">

        <table border="1">

            <thead>

                <tr>

                    <td width="60px">id</td>

                    <td width="120px">name</td>

                    <td width="60px">age</td>

                </tr>

            </thead>

            <tbody>

                <c:forEach var="user" items="${pageTableForm.userList}" varStatus="status">

                    <tr>

                        <td>${user.id}</td>

                        <td>${user.userName}</td>

                        <td>${user.age}</td>

                    </tr>

                </c:forEach>

                <tr>

                    <td><c:if test="${pageTableForm.currentPage > 1}">

                            <input id="prev" type="button" value="上一页">

                        </c:if></td>

                    <td>当前<label>${pageTableForm.currentPage}</label>页/共<label>${pageTableForm.pageCount}</label>页</td>

                    <td><c:if test="${pageTableForm.currentPage < pageTableForm.pageCount}">

                            <input id="next" type="button" value="下一页">

                        </c:if></td>

                </tr>

            </tbody>

        </table>

        <input id="currentPage" type="hidden" name="currentPage" value="${pageTableForm.currentPage}">

    </form>

</body>

</html>

最终效果:

每次都会提交一次请求,比较差强人意,下个版本计划用js实现,拒绝垃圾代码

码农公寓

相关文章