layui分页快速使用

项目需要用layui的分页功能，但没工夫去学原理等等，直接拿来用。

1.建ResultBean类，用来返回前端表格需要的数据。

 代码

package com.example.mybatisdemo.pojo;



public class ResultBean {
    
    private int code;
    
    private String msg;
    
    private int count;
    
    private Object data;

    public ResultBean() {
    }

    public ResultBean(int code, String msg, int count, Object data) {
        super();
        this.code = code;
        this.msg = msg;
        this.count = count;
        this.data = data;
    }

    @Override
    public String toString() {
        return "R [code=" + code + ", msg=" + msg + ", count=" + count + ", data=" + data + "]";
    }

    public int getCode() {
        return code;
    }

    public void setCode(int code) {
        this.code = code;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public int getCount() {
        return count;
    }

    public void setCount(int count) {
        this.count = count;
    }

    public Object getData() {
        return data;
    }

    public void setData(Object data) {
        this.data = data;
    }
}

2.controller层

 代码示例

注意关于uname的判断

@ResponseBody
public ResultBean get_orgallbill(int page, int limit,String uname,HttpServletResponse Response, HttpServletRequest Request) throws Exception {
    int offset = (page - 1) * limit;
    Page page1 = new Page(offset, limit);
    Integer id = (Integer) Request.getSession().getAttribute("organize_id");
    page1.setComplain_id(id);
    if (uname == null || uname.isEmpty() == true) {
        int count = billService.corgbill(page1).size();
        ResultBean result = new ResultBean(0, "查询成功", count, billService.orgbill(page1));
        return result;
    } else {
        Integer use = Integer.parseInt(uname);
        page1.setComplain_vido(use);
        int count = billService.cuorgbill(page1).size();
        ResultBean result = new ResultBean(0, "查询成功", count, billService.uorgbill(page1));
        return result;
    }
}

Page类中的offset和limit是关于分页，其他是我方便查询添加到类里面的，uname是后来添加的查询条件（后面有示例oname）

page类代码演示

package com.example.mybatisdemo.pojo;

public class Page {
    private int offset;
    private int num;
    private String use_number;
    private String organize_name;
    private Integer complain_vido;
    private Integer complain_id;

    public Page(int offset, int num) {
        this.offset = offset;
        this.num = num;
    }

    public int getOffset() {
        return offset;
    }

    public void setOffset(int offset) {
        this.offset = offset;
    }

    public int getNum() {
        return num;
    }

    public void setNum(int num) {
        this.num = num;
    }

    public String getUse_number() {
        return use_number;
    }

    public void setUse_number(String use_number) {
        this.use_number = use_number;
    }

    public String getOrganize_name() {
        return organize_name;
    }

    public void setOrganize_name(String organize_name) {
        this.organize_name = organize_name;
    }

    public Integer getComplain_vido() {
        return complain_vido;
    }

    public void setComplain_vido(Integer complain_vido) {
        this.complain_vido = complain_vido;
    }

    public Integer getComplain_id() {
        return complain_id;
    }

    public void setComplain_id(Integer complain_id) {
        this.complain_id = complain_id;
    }
}

3.dao层的SQL语句 

//    管理员审核浏览所有视频分页
@Select("select * from `vido` s, `organize` where s.vido_organize=organize_id and s.vido_yn='yes' limit #{offset},#{num}")
public List> usegetallvidos(Page page);
//  管理员审核浏览所有视频统计数量
@Select("select * from `vido` s, `organize` where s.vido_organize=organize_id and s.vido_yn='yes'")
public List> cusegetallvidos(Page page);

4.前端页面代码

 学习用Layui table模块，数据操作和左右列固定 - 在线演示http://layui.swimafish.com/demo/table/operate.html