Mybatis实现分页
Mybatis实现分页
1.
public interface TbContentDubboService {
//分页
EasyUIDataGrid showPage(long cid, int page,int rows);
}
2.
public class EasyUIDataGrid implements Serializable {
private long total;
private List<?> rows;
public long getTotal() {
return total;
}
public void setTotal(long total) {
this.total = total;
}
public List<?> getRows() {
return rows;
}
public void setRows(List<?> rows) {
this.rows = rows;
}
}
3.
配置分页插件
<!-- 注册mybatis的PageHelper分页插件 -->
<plugins>
<plugin interceptor="com.github.pagehelper.PageHelper">
<property name="dialect" value="mysql"/>
</plugin>
</plugins>
4.实现分页
public EasyUIDataGrid showPage(int page, int row) {
//1.启动分页插件,并设置分页条件
PageHelper.startPage(page, row);
//2.查询分页数据
TbItemParamExample example=new TbItemParamExample();
List<TbItemParam> list=TbItemParamMapper.selectByExampleWithBLOBs(example);
//3.将查询出来的分页数据封装到PageInfo中
PageInfo<TbItemParam> pageInfo = new PageInfo<>(list);
EasyUIDataGrid dataGrid = new EasyUIDataGrid();
dataGrid.setTotal(pageInfo.getTotal());
dataGrid.setRows(pageInfo.getList());
return dataGrid;
}