框架介绍
jqGrid :是一个在jquery基础上做的一个表格控件,以ajax的方式和服务器端通信。支持json和xml数据和服务器交互,有很多自定义的功能,具体可以去看文档:http://blog.mn886.net/jqGrid/ 。
MybatisPlus:这个框架是国内的大神编写的,我个人认为这就是一个mybatis的一个增强工具包,好处请大家自行去官方文档查阅,这里就不再赘述了。文档链接:http://mp.baomidou.com/docs/index.html 。
如果之前没有用过的同学也可以看我的项目来学到这两个框架的实际用法。
·······················································································································································
此项目下载地址:https://git.oschina.net/z77z/springboot_mybatisplus
·······················································································································································
我是在之前项目上来进行开发的,所以已经完成了mybatisPlus的搭建,具体mybatisPlus的配置可以去看我之前美女图片爬虫的那篇博文。
分页查询
下面我就以角色表的分页排序为例:
由于数据层mybatisPlus已经对分页进行了封装,直接在controller层调用分页方法:
//获取角色分页对象
@RequestMapping(value="getRoleListWithPager")
@ResponseBody
public String getRoleListWithPager(FrontPage<SysRole> page) {
//获取page对象
Page<SysRole> pageList = sysRoleService.selectPage(page.getPagePlus());
CustomPage<SysRole> customPage = new CustomPage<SysRole>(pageList);
return JSON.toJSONString(customPage);
}
FrontPage对象是用来接受前台jqGrid传来的对象。
package io.z77z.entity;
import com.baomidou.mybatisplus.plugins.Page;
/**
* 用来接收页面传过来的查询字段 对象
* @author z77z
*
*/
public class FrontPage<T> {
//是否是查询
private boolean _search;
//时间戳(毫秒)
private String nd;
//每页显示条数
private int rows;
//当前页数
private int page;
//排序的字段
private String sidx;
//排序方式 asc升序 desc降序
private String sord;