1. 首页首页
  2. 编程汇总编程汇总

Mybatis分页插件使用的详解[通俗易懂]

编程汇总 • • 阅读 19

Mybatis分页插件使用的详解[通俗易懂]前言 关于分页 一般来说 rowBounds 这种假分页都上不了台面 我们往往都选哟真分页 那么还不想搞得很麻烦 Mybatis 的分页插件就为后端程序员解决了这个问题 例子 首先需要导入依赖 没错 pagehelper com github pagehelper pagehelper 5 2 0 pre p 看看怎么用 首先我们不要条件 直接分

前言

关于分页,一般来说rowBounds 这种假分页都上不了台面,我们往往都选哟真分页,那么还不想搞得很麻烦,Mybatis的分页插件就为后端程序员解决了这个问题

例子

首先需要导入依赖, 没错pagehelper

    

      com.github.pagehelper

      pagehelper

      5.2.0

    
/pre>
p>看看怎么用,首先我们不要条件,直接分

当然了我喜欢自己事先写一个page的实体类👇
/p>
pre class='language-javascript'>
public class page { 



private int pageNumber;

private int pageSize;

private int total;

private List rows;

private int pageCount;

private int pre;

private int next;

private int start; //limit ?,?

private boolean first;

private boolean last;

public int getPageCount() { 



return (getTotal()+getPageSize()-1)/getPageSize();

}

public int getPre() { 



if(getPageNumber()==1)

return 1;

return getPageNumber()-1;

}

public int getNext() { 



if(getPageNumber()==getPageCount())

return getPageCount();

return getPageNumber()+1;

}

public int getStart() { 



return (getPageNumber()-1)*pageSize;

}

public boolean isFirst() { 



return getPageNumber()==1;

}

public boolean isLast() { 



return getPageNumber()==getPageCount();

}

public int getPageNumber() { 



return pageNumber;

}

public void setPageNumber(int pageNumber) { 



this.pageNumber = pageNumber;

}

public int getPageSize() { 



return pageSize;

}

public void setPageSize(int pageSize) { 



this.pageSize = pageSize;

}

public int getTotal() { 



return total;

}

public void setTotal(int total) { 



this.total = total;

}

public List getRows() { 



return rows;

}

public void setRows(List rows) { 



this.rows = rows;

}

}

Controller👇

    @RequestMapping(value = "/querySome", method = RequestMethod.POST)

@ResponseBody

public ETResponse querySome(int pageNumber, int pageSize) { 



List rows = service.querySome(pageNumber, pageSize);

PageInfo info = new PageInfo<>(rows);//Pageinfo 是个Mybatis写的page

page pa = new page<>();

pa.setRows(info.getList());

pa.setTotal(Integer.parseInt(info.getTotal() + ""));

pa.setPageSize(pageSize);

pa.setPageNumber(pageNumber);

return sr.setResponse(pa,"200");

}

流程就是


#mermaid-svg-Bl4P8VZjQwzLp1Ld .label{font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family);fill:#333;color:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .label text{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .node rect,#mermaid-svg-Bl4P8VZjQwzLp1Ld .node circle,#mermaid-svg-Bl4P8VZjQwzLp1Ld .node ellipse,#mermaid-svg-Bl4P8VZjQwzLp1Ld .node polygon,#mermaid-svg-Bl4P8VZjQwzLp1Ld .node path{fill:#ECECFF;stroke:#9370db;stroke-width:1px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .node .label{text-align:center;fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .node.clickable{cursor:pointer}#mermaid-svg-Bl4P8VZjQwzLp1Ld .arrowheadPath{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edgePath .path{stroke:#333;stroke-width:1.5px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .flowchart-link{stroke:#333;fill:none}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edgeLabel{background-color:#e8e8e8;text-align:center}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edgeLabel rect{opacity:0.9}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edgeLabel span{color:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .cluster rect{fill:#ffffde;stroke:#aa3;stroke-width:1px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .cluster text{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family);font-size:12px;background:#ffffde;border:1px solid #aa3;border-radius:2px;pointer-events:none;z-index:100}#mermaid-svg-Bl4P8VZjQwzLp1Ld .actor{stroke:#ccf;fill:#ECECFF}#mermaid-svg-Bl4P8VZjQwzLp1Ld text.actor>tspan{fill:#000;stroke:none}#mermaid-svg-Bl4P8VZjQwzLp1Ld .actor-line{stroke:grey}#mermaid-svg-Bl4P8VZjQwzLp1Ld .messageLine0{stroke-width:1.5;stroke-dasharray:none;stroke:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .messageLine1{stroke-width:1.5;stroke-dasharray:2, 2;stroke:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld #arrowhead path{fill:#333;stroke:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .sequenceNumber{fill:#fff}#mermaid-svg-Bl4P8VZjQwzLp1Ld #sequencenumber{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld #crosshead path{fill:#333;stroke:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .messageText{fill:#333;stroke:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .labelBox{stroke:#ccf;fill:#ECECFF}#mermaid-svg-Bl4P8VZjQwzLp1Ld .labelText,#mermaid-svg-Bl4P8VZjQwzLp1Ld .labelText>tspan{fill:#000;stroke:none}#mermaid-svg-Bl4P8VZjQwzLp1Ld .loopText,#mermaid-svg-Bl4P8VZjQwzLp1Ld .loopText>tspan{fill:#000;stroke:none}#mermaid-svg-Bl4P8VZjQwzLp1Ld .loopLine{stroke-width:2px;stroke-dasharray:2, 2;stroke:#ccf;fill:#ccf}#mermaid-svg-Bl4P8VZjQwzLp1Ld .note{stroke:#aa3;fill:#fff5ad}#mermaid-svg-Bl4P8VZjQwzLp1Ld .noteText,#mermaid-svg-Bl4P8VZjQwzLp1Ld .noteText>tspan{fill:#000;stroke:none}#mermaid-svg-Bl4P8VZjQwzLp1Ld .activation0{fill:#f4f4f4;stroke:#666}#mermaid-svg-Bl4P8VZjQwzLp1Ld .activation1{fill:#f4f4f4;stroke:#666}#mermaid-svg-Bl4P8VZjQwzLp1Ld .activation2{fill:#f4f4f4;stroke:#666}#mermaid-svg-Bl4P8VZjQwzLp1Ld .mermaid-main-font{font-family:"trebuchet ms", verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .section{stroke:none;opacity:0.2}#mermaid-svg-Bl4P8VZjQwzLp1Ld .section0{fill:rgba(102,102,255,0.49)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .section2{fill:#fff400}#mermaid-svg-Bl4P8VZjQwzLp1Ld .section1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .section3{fill:#fff;opacity:0.2}#mermaid-svg-Bl4P8VZjQwzLp1Ld .sectionTitle0{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .sectionTitle1{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .sectionTitle2{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .sectionTitle3{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .sectionTitle{text-anchor:start;font-size:11px;text-height:14px;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .grid .tick{stroke:#d3d3d3;opacity:0.8;shape-rendering:crispEdges}#mermaid-svg-Bl4P8VZjQwzLp1Ld .grid .tick text{font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .grid path{stroke-width:0}#mermaid-svg-Bl4P8VZjQwzLp1Ld .today{fill:none;stroke:red;stroke-width:2px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .task{stroke-width:2}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskText{text-anchor:middle;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskText:not([font-size]){font-size:11px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskTextOutsideRight{fill:#000;text-anchor:start;font-size:11px;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskTextOutsideLeft{fill:#000;text-anchor:end;font-size:11px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .task.clickable{cursor:pointer}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskText.clickable{cursor:pointer;fill:#003163 !important;font-weight:bold}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskTextOutsideLeft.clickable{cursor:pointer;fill:#003163 !important;font-weight:bold}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskTextOutsideRight.clickable{cursor:pointer;fill:#003163 !important;font-weight:bold}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskText0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskText1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskText2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskText3{fill:#fff}#mermaid-svg-Bl4P8VZjQwzLp1Ld .task0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .task1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .task2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .task3{fill:#8a90dd;stroke:#534fbc}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskTextOutside0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskTextOutside2{fill:#000}#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskTextOutside1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .taskTextOutside3{fill:#000}#mermaid-svg-Bl4P8VZjQwzLp1Ld .active0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .active1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .active2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .active3{fill:#bfc7ff;stroke:#534fbc}#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeText0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeText1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeText2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeText3{fill:#000 !important}#mermaid-svg-Bl4P8VZjQwzLp1Ld .done0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .done1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .done2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .done3{stroke:grey;fill:#d3d3d3;stroke-width:2}#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneText0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneText1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneText2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneText3{fill:#000 !important}#mermaid-svg-Bl4P8VZjQwzLp1Ld .crit0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .crit1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .crit2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .crit3{stroke:#f88;fill:red;stroke-width:2}#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeCrit0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeCrit1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeCrit2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeCrit3{stroke:#f88;fill:#bfc7ff;stroke-width:2}#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneCrit0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneCrit1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneCrit2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneCrit3{stroke:#f88;fill:#d3d3d3;stroke-width:2;cursor:pointer;shape-rendering:crispEdges}#mermaid-svg-Bl4P8VZjQwzLp1Ld .milestone{transform:rotate(45deg) scale(0.8, 0.8)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .milestoneText{font-style:italic}#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneCritText0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneCritText1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneCritText2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .doneCritText3{fill:#000 !important}#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeCritText0,#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeCritText1,#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeCritText2,#mermaid-svg-Bl4P8VZjQwzLp1Ld .activeCritText3{fill:#000 !important}#mermaid-svg-Bl4P8VZjQwzLp1Ld .titleText{text-anchor:middle;font-size:18px;fill:#000;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.classGroup text{fill:#9370db;stroke:none;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family);font-size:10px}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.classGroup text .title{font-weight:bolder}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.clickable{cursor:pointer}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.classGroup rect{fill:#ECECFF;stroke:#9370db}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.classGroup line{stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld .classLabel .box{stroke:none;stroke-width:0;fill:#ECECFF;opacity:0.5}#mermaid-svg-Bl4P8VZjQwzLp1Ld .classLabel .label{fill:#9370db;font-size:10px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .relation{stroke:#9370db;stroke-width:1;fill:none}#mermaid-svg-Bl4P8VZjQwzLp1Ld .dashed-line{stroke-dasharray:3}#mermaid-svg-Bl4P8VZjQwzLp1Ld #compositionStart{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld #compositionEnd{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld #aggregationStart{fill:#ECECFF;stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld #aggregationEnd{fill:#ECECFF;stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld #dependencyStart{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld #dependencyEnd{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld #extensionStart{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld #extensionEnd{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld .commit-id,#mermaid-svg-Bl4P8VZjQwzLp1Ld .commit-msg,#mermaid-svg-Bl4P8VZjQwzLp1Ld .branch-label{fill:lightgrey;color:lightgrey;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .pieTitleText{text-anchor:middle;font-size:25px;fill:#000;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .slice{font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.stateGroup text{fill:#9370db;stroke:none;font-size:10px;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.stateGroup text{fill:#9370db;fill:#333;stroke:none;font-size:10px}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.statediagram-cluster .cluster-label text{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.stateGroup .state-title{font-weight:bolder;fill:#000}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.stateGroup rect{fill:#ECECFF;stroke:#9370db}#mermaid-svg-Bl4P8VZjQwzLp1Ld g.stateGroup line{stroke:#9370db;stroke-width:1}#mermaid-svg-Bl4P8VZjQwzLp1Ld .transition{stroke:#9370db;stroke-width:1;fill:none}#mermaid-svg-Bl4P8VZjQwzLp1Ld .stateGroup .composit{fill:white;border-bottom:1px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .stateGroup .alt-composit{fill:#e0e0e0;border-bottom:1px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .state-note{stroke:#aa3;fill:#fff5ad}#mermaid-svg-Bl4P8VZjQwzLp1Ld .state-note text{fill:black;stroke:none;font-size:10px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .stateLabel .box{stroke:none;stroke-width:0;fill:#ECECFF;opacity:0.7}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edgeLabel text{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .stateLabel text{fill:#000;font-size:10px;font-weight:bold;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-Bl4P8VZjQwzLp1Ld .node circle.state-start{fill:black;stroke:black}#mermaid-svg-Bl4P8VZjQwzLp1Ld .node circle.state-end{fill:black;stroke:white;stroke-width:1.5}#mermaid-svg-Bl4P8VZjQwzLp1Ld #statediagram-barbEnd{fill:#9370db}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-cluster rect{fill:#ECECFF;stroke:#9370db;stroke-width:1px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-cluster rect.outer{rx:5px;ry:5px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-state .divider{stroke:#9370db}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-state .title-state{rx:5px;ry:5px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-cluster.statediagram-cluster .inner{fill:white}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-cluster.statediagram-cluster-alt .inner{fill:#e0e0e0}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-cluster .inner{rx:0;ry:0}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-state rect.basic{rx:5px;ry:5px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-state rect.divider{stroke-dasharray:10,10;fill:#efefef}#mermaid-svg-Bl4P8VZjQwzLp1Ld .note-edge{stroke-dasharray:5}#mermaid-svg-Bl4P8VZjQwzLp1Ld .statediagram-note rect{fill:#fff5ad;stroke:#aa3;stroke-width:1px;rx:0;ry:0}:root{--mermaid-font-family:'"trebuchet ms", verdana, arial';--mermaid-font-family:"Comic Sans MS", "Comic Sans", cursive}#mermaid-svg-Bl4P8VZjQwzLp1Ld .error-icon{fill:#522}#mermaid-svg-Bl4P8VZjQwzLp1Ld .error-text{fill:#522;stroke:#522}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edge-thickness-normal{stroke-width:2px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edge-thickness-thick{stroke-width:3.5px}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edge-pattern-solid{stroke-dasharray:0}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edge-pattern-dashed{stroke-dasharray:3}#mermaid-svg-Bl4P8VZjQwzLp1Ld .edge-pattern-dotted{stroke-dasharray:2}#mermaid-svg-Bl4P8VZjQwzLp1Ld .marker{fill:#333}#mermaid-svg-Bl4P8VZjQwzLp1Ld .marker.cross{stroke:#333}

:root{--mermaid-font-family:"trebuchet ms", verdana, arial;}#mermaid-svg-Bl4P8VZjQwzLp1Ld{color:rgba(0, 0, 0, 0.75);font:;}

查出结果集

创建Pageinfo的对象

组装我们自己的page对象

发送page

当然了,有没有简化版?这我还得自己建个类,有
Controller

    @RequestMapping(value = "/querySome", method = RequestMethod.POST)

@ResponseBody

public ETResponse querySome(int pageNumber, int pageSize) { 



List rows = service.querySome(pageNumber, pageSize);

PageInfo info = new PageInfo<>(rows);//Pageinfo 是个Mybatis写的page

return sr.setResponse(info,"200");//负责向前台发送response.data.data的方法

}

是的没错,直接把pageinfo的对象传给前台也不是不行,因为它本身就是一个page对象,只是它里面的一些属性我们不是很清楚,
下面是pageInfo源码中的属性

private int pageNum;

private int pageSize;

private int size;

private long startRow;

private long endRow;

private int pages;

private int prePage;

private int nextPage;

private boolean isFirstPage;

private boolean isLastPage;

private boolean hasPreviousPage;

private boolean hasNextPage;

private int navigatePages;

private int[] navigatepageNums;

private int navigateFirstPage;

private int navigateLastPage;

我们发现好像没有我们的要的list结果集
我找了找在它父类中呢


很明显了吧,所以以后需要什么属性直接get也好
ok说了这么多,看看Service

 public List querySome(int pageNumber, int pageSize) { 



PageHelper.startPage(pageNumber,pageSize);//负责分页

return dao.querySome();//传空参给dao层

}

Dao层+mapper.xml文件

 List querySome();

那有条件查询的分页呢?
很简单我们只需要在Service中把条件给dao层就ok了

 public List querySome(String name,int pageNumber, int pageSize) { 



PageHelper.startPage(pageNumber,pageSize);//负责分页

return dao.querySome(name);//传空参给dao层

}
 List querySome(String name);

总结

ok了MyBatis的分页插件学会了的话,记得给个赞哦~

编程小号
上一篇 2025-01-25 12:21
下一篇 2025-02-06 15:17

相关推荐

版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
如需转载请保留出处：https://bianchenghao.cn/hz/143068.html