SpringMVC+MyBatis+EasyUI 实现分页查询

发布时间：2020-12-14 18:01:58 所属栏目：大数据来源：网络整理

导读：user_list.jsp % @ page import = " com.ssm.entity.User " % @ page pageEncoding UTF-8 import java.util.List % html head @ include file meta.jsp % meta charset ="UTF-8" title 用户列表 / link rel ="stylesheet" type ="text/css" href ="jquery-ea

user_list.jsp

<%@ page import="com.ssm.entity.User" %>
@ page pageEncodingUTF-8 importjava.util.List%>
<html>
head>
    @ include filemeta.jsp%>

    meta charset="UTF-8">
    title>用户列表</link rel="stylesheet" type="text/css" href="jquery-easyui-1.4/themes/default/easyui.css"="jquery-easyui-1.4/themes/icon.css"script type="text/javascript" src="jquery-easyui-1.4/jquery.min.js"></script="jquery-easyui-1.4/jquery.easyui.min.js">

bodytable id="dataTable"  style="width:400px;height:250px">
        theadtr>
            th data-options="field:'id'">IDth="field:'name'">姓名="field:'age'">年龄tablea href="/ssm">回到首页a>
    $(document).ready(function() {
        page_init();
    });
     page_init() {

        $(#dataTable).datagrid({
            url: listUserWithPageForJson,//actionName
            queryParams:{pageNumber:210},1)">查询参数
            loadMsg:正在加载数据...true查询结果在表格中显示行号
            fitColumns:列的宽度填满表格，防止下方出现滚动条。
            pageNumber:初始页码，得在这设置才效果，pagination设置没效果。
            pagination: 分页控件
            如果后端返回的json的格式直接是data={total:xx,rows:{xx}},不需要设置loadFilter了，
            如果有多层封装，比如data.jsonMap = {total:xx,rows:{xx}}，则需要在loadFilter处理一下。
            /*
            loadFilter: function(data){
                if(data.jsonMap) {
                    return data.jsonMap;
                }
            }*/
        });

        var p  $(').datagrid(getPager);
        $(p).pagination({
            pageSize: 每页显示的记录条数，默认为10
            pageList: [51520],1)">可以设置每页记录条数的列表
            beforePageText: 第页数文本框前显示的汉字
            afterPageText: 页    共 {pages} 页共 {total} 条记录 (pageNumber,pageSize) {分页触发
                find(pageNumber,pageSize);
            }
        });

    }

     find(pageNumber,pageSize)
    {
            $().pagination({pageSize : pageSize,pageNumber : pageNumber});重置
            $(loading); 加屏蔽
            $.ajax({
                type : POSTjson(data) {
                    $(loadDataloaded移除屏蔽
                },error : (err) {
                    $.messager.alert(操作提示获取信息失败...请联系管理员!error);
                    $(                }
            });

    }


>

UserController.java

package com.ssm.controller;

import com.alibaba.fastjson.JSONObject;
 com.ssm.common.PageModel;
 com.ssm.dao.UserDao;
 com.ssm.entity.JsonEntity;
 com.ssm.entity.User;
 com.ssm.service.UserService;
 com.ssm.tools.BlankUtil;
 org.springframework.stereotype.Controller;
 org.springframework.ui.ModelMap;
 org.springframework.web.bind.annotation.RequestMapping;
 org.springframework.web.bind.annotation.RequestParam;
 org.springframework.web.bind.annotation.ResponseBody;
 org.springframework.web.servlet.mvc.support.RedirectAttributes;

 javax.annotation.Resource;
 javax.servlet.http.HttpServletRequest;
 javax.servlet.http.HttpServletResponse;
 java.io.IOException;
 java.util.ArrayList;
 java.util.HashMap;
 java.util.List;
 java.util.Map;

/**
 * Created by Administrator on 2015-10-15.
 */
@Controller
public class UserController {


    @Resource
    private UserService userService;

    @RequestMapping(value = "listUserWithPageForJson")
    @ResponseBody
    public Object listUserWithPageForJson(PageModel pageModel,User user) {
        Object jsonObject = null;
        try {
            pageModel.setQueryObj(user);
            userService.listUserWithPage(pageModel);
            jsonObject = JSONObject.toJSON(pageModel);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return jsonObject;
    }


}

PageModel.java

 com.ssm.common;

 java.util.List;


 * Created by hbd on 2015/10/22.
 */
class PageModel<T> {

    private Integer pageNumber; //当前页数
    private Integer pageSize;   一页显示数量
    private Integer startRow;   查询起始行
    private Integer total;      总记录行数
    private List<T> rows;       查询结果数据
    private T queryObj;         查询对象

     Integer getStartRow() {
        if(pageNumber!=null && pageSize!=) {
            return (pageNumber - 1) * pageSize;
        } else {
            return 0;
        }
    }

     Integer getPageNumber() {
         pageNumber;
    }

    void setPageNumber(Integer pageNumber) {
        this.pageNumber = Integer getPageSize() {
         pageSize;
    }

     setPageSize(Integer pageSize) {
        this.pageSize = Integer getTotal() {
         total;
    }

     setTotal(Integer total) {
        this.total =public List<T> getRows() {
         rows;
    }

    void setRows(List<T> rows) {
        this.rows = setQueryObj(T queryObj) {
        this.queryObj = queryObj;
    }

     T getQueryObj() {
         queryObj;
    }
}

UserServiceImpl.java

 com.ssm.service.impl;

 org.springframework.stereotype.Service;


 * Created by Administrator on 2015-10-16.
 
@Service("userService")
class UserServiceImpl implements UserService {

    @Resource
     UserDao userDao;
    
    @Override
    public User getUserById(int userId) {
         userDao.findUserById(userId);
    }

    @Override
    void listUserWithPage(PageModel<User> pageModel) {
        pageModel.setRows(userDao.selectUserListWithPage(pageModel));
        pageModel.setTotal(userDao.selectUserCountWithPage(pageModel));
    }

}

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"<!--这块等于dao接口的实现 namespace必须和接口的类路径一样-->
mapper namespace="com.ssm.dao.UserDao">

    sql ="sql_count">
        SELECT COUNT(*)
    sql="sql_select"
        SELECT *
    ="sql_where"
        FROM USER
        whereif test="queryObj != null">
                ="queryObj.name != null and queryObj.name != ''"
                    AND name like CONCAT('%',#{queryObj.name},'%')
                if="queryObj.age != null"
                    AND age = #{queryObj.age}
                select ="selectUserListWithPage" parameterType="com.ssm.common.PageModel" resultType="User"include refidinclude="pageNumber != null and  pageSize!= null"
            limit #{startRow},#{pageSize}
        select="selectUserCountWithPage"="Integer">

    

mapper>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!