mybatis分页的方式有哪些

ListqueryStudentsByArray();

select*fromstudent

ListqueryStudentsByArray(intcurrPage,intpageSize);

@Override
publicListqueryStudentsByArray(intcurrPage,intpageSize){
Liststudents=studentMapper.queryStudentsByArray();
//从第几条数据开始
intfirstIndex=(currPage-1)*pageSize;
//到第几条数据结束
intlastIndex=currPage*pageSize;
returnstudents.subList(firstIndex,lastIndex);
}

@ResponseBody
@RequestMapping("/student/array/{currPage}/{pageSize}")
publicListgetStudentByArray(@PathVariable("currPage")intcurrPage,@PathVariable("pageSize")intpageSize){
Liststudent=StuServiceIml.queryStudentsByArray(currPage,pageSize);
returnstudent;
}

ListqueryStudentsBySql(Mapdata);

select*fromstudentlimit#{currIndex},#{pageSize}

ListqueryStudentsBySql(intcurrPage,intpageSize);

@Override
publicListqueryStudentsBySql(intcurrPage,intpageSize){
Mapdata=newHashedMap();
data.put("currIndex",(currPage-1)*pageSize);
data.put("pageSize",pageSize);
returnstudentMapper.queryStudentsBySql(data);
}

packagecom.cbg.interceptor;

importorg.apache.ibatis.executor.Executor;
importorg.apache.ibatis.executor.parameter.ParameterHandler;
importorg.apache.ibatis.executor.resultset.ResultSetHandler;
importorg.apache.ibatis.executor.statement.StatementHandler;
importorg.apache.ibatis.mapping.MappedStatement;
importorg.apache.ibatis.plugin.*;
importorg.apache.ibatis.reflection.MetaObject;
importorg.apache.ibatis.reflection.SystemMetaObject;

importjava.sql.Connection;
importjava.util.Map;
importjava.util.Properties;

/**
*Createdbychenbogeon2017/5/7.
*
*Email:baigegechen@gmail.com*
*description:*//***@Intercepts说明是一个拦截器*@Signature拦截器的签名*type拦截的类型四大对象之一(Executor,ResultSetHandler,ParameterHandler,StatementHandler)*method拦截的方法*args参数*/@Intercepts({@Signature(type=StatementHandler.class,method="prepare",args={Connection.class,Integer.class})})publicclassMyPageInterceptorimplementsInterceptor{//每页显示的条目数privateintpageSize;//当前现实的页数privateintcurrPage;privateStringdbType;@OverridepublicObjectintercept(Invocationinvocation)throwsThrowable{//获取StatementHandler，默认是RoutingStatementHandlerStatementHandlerstatementHandler=(StatementHandler)invocation.getTarget();//获取statementHandler包装类MetaObjectMetaObjectHandler=SystemMetaObject.forObject(statementHandler);//分离代理对象链while(MetaObjectHandler.hasGetter("h")){Objectobj=MetaObjectHandler.getValue("h");MetaObjectHandler=SystemMetaObject.forObject(obj);}while(MetaObjectHandler.hasGetter("target")){Objectobj=MetaObjectHandler.getValue("target");MetaObjectHandler=SystemMetaObject.forObject(obj);}//获取连接对象//Connectionconnection=(Connection)invocation.getArgs()[0];//object.getValue("delegate");获取StatementHandler的实现类//获取查询接口映射的相关信息MappedStatementmappedStatement=(MappedStatement)MetaObjectHandler.getValue("delegate.mappedStatement");StringmapId=mappedStatement.getId();//statementHandler.getBoundSql().getParameterObject();//拦截以.ByPage结尾的请求，分页功能的统一实现if(mapId.matches(".+ByPage$")){//获取进行数据库操作时管理参数的handlerParameterHandlerparameterHandler=(ParameterHandler)MetaObjectHandler.getValue("delegate.parameterHandler");//获取请求时的参数MapparaObject=(Map)parameterHandler.getParameterObject();//也可以这样获取//paraObject=(Map)statementHandler.getBoundSql().getParameterObject();//参数名称和在service中设置到map中的名称一致currPage=(int)paraObject.get("currPage");pageSize=(int)paraObject.get("pageSize");Stringsql=(String)MetaObjectHandler.getValue("delegate.boundSql.sql");//也可以通过statementHandler直接获取//sql=statementHandler.getBoundSql().getSql();//构建分页功能的sql语句StringlimitSql;sql=sql.trim();limitSql=sql+"limit"+(currPage-1)*pageSize+","+pageSize;//将构建完成的分页sql语句赋值个体'delegate.boundSql.sql'，偷天换日MetaObjectHandler.setValue("delegate.boundSql.sql",limitSql);}//调用原对象的方法，进入责任链的下一级returninvocation.proceed();}//获取代理对象@OverridepublicObjectplugin(Objecto){//生成object对象的动态代理对象returnPlugin.wrap(o,this);}//设置代理对象的参数@OverridepublicvoidsetProperties(Propertiesproperties){//如果项目中分页的pageSize是统一的，也可以在这里统一配置和获取，这样就不用每次请求都传递pageSize参数了。参数是在配置拦截器时配置的。Stringlimit1=properties.getProperty("limit","10");this.pageSize=Integer.valueOf(limit1);this.dbType=properties.getProperty("dbType","mysql");}}

privatefinalStatementHandlerdelegate;

publicRoutingStatementHandler(Executorexecutor,MappedStatementms,Objectparameter,RowBoundsrowBounds,ResultHandlerresultHandler,BoundSqlboundSql){
switch(RoutingStatementHandler.SyntheticClass_1.$SwitchMap$org$apache$ibatis$mapping$StatementType[ms.getStatementType().ordinal()]){
case1:
this.delegate=newSimpleStatementHandler(executor,ms,parameter,rowBounds,resultHandler,boundSql);
break;
case2:
this.delegate=newPreparedStatementHandler(executor,ms,parameter,rowBounds,resultHandler,boundSql);
break;
case3:
this.delegate=newCallableStatementHandler(executor,ms,parameter,rowBounds,resultHandler,boundSql);
break;
default:
thrownewExecutorException("Unknownstatementtype:"+ms.getStatementType());
}

}

publicabstractclassBaseStatementHandlerimplementsStatementHandler{
protectedfinalConfigurationconfiguration;
protectedfinalObjectFactoryobjectFactory;
protectedfinalTypeHandlerRegistrytypeHandlerRegistry;
protectedfinalResultSetHandlerresultSetHandler;
protectedfinalParameterHandlerparameterHandler;
protectedfinalExecutorexecutor;
protectedfinalMappedStatementmappedStatement;
protectedfinalRowBoundsrowBounds;
protectedBoundSqlboundSql;

protectedBaseStatementHandler(Executorexecutor,MappedStatementmappedStatement,ObjectparameterObject,RowBoundsrowBounds,ResultHandlerresultHandler,BoundSqlboundSql){
this.configuration=mappedStatement.getConfiguration();
this.executor=executor;
this.mappedStatement=mappedStatement;
this.rowBounds=rowBounds;
this.typeHandlerRegistry=this.configuration.getTypeHandlerRegistry();
this.objectFactory=this.configuration.getObjectFactory();
if(boundSql==null){
this.generateKeys(parameterObject);
boundSql=mappedStatement.getBoundSql(parameterObject);
}

this.boundSql=boundSql;
this.parameterHandler=this.configuration.newParameterHandler(mappedStatement,parameterObject,boundSql);
this.resultSetHandler=this.configuration.newResultSetHandler(executor,mappedStatement,rowBounds,this.parameterHandler,resultHandler,boundSql);
}

//获取进行数据库操作时管理参数的handler
ParameterHandlerparameterHandler=(ParameterHandler)MetaObjectHandler.getValue("delegate.parameterHandler");
//获取请求时的参数
MapparaObject=(Map)parameterHandler.getParameterObject();
//也可以这样获取
//paraObject=(Map)statementHandler.getBoundSql().getParameterObject();

//读取配置的代理对象的参数
@Override
publicvoidsetProperties(Propertiesproperties){
Stringlimit1=properties.getProperty("limit","10");
this.pageSize=Integer.valueOf(limit1);
this.dbType=properties.getProperty("dbType","mysql");
}

方法
ListqueryStudentsByPage(Mapdata);

xml文件的select语句

select*fromstudent

方法：
ListqueryStudentsByPage(intcurrPage,intpageSize);

实现：
@Override
publicListqueryStudentsByPage(intcurrPage,intpageSize){
Mapdata=newHashedMap();
data.put("currPage",currPage);
data.put("pageSize",pageSize);
returnstudentMapper.queryStudentsByPage(data);
}

@ResponseBody
@RequestMapping("/student/page/{currPage}/{pageSize}")
publicListgetStudentByPage(@PathVariable("currPage")intcurrPage,@PathVariable("pageSize")intpageSize){
Liststudent=StuServiceIml.queryStudentsByPage(currPage,pageSize);
returnstudent;
}

//加入RowBounds参数
publicListqueryUsersByPage(StringuserName,RowBoundsrowBounds);

@Override
@Transactional(isolation=Isolation.READ_COMMITTED,propagation=Propagation.SUPPORTS)
publicListqueryRolesByPage(StringroleName,intstart,intlimit){
returnroleDao.queryRolesByPage(roleName,newRowBounds(start,limit));
}

publicclassRowBounds{
publicstaticfinalintNO_ROW_OFFSET=0;
publicstaticfinalintNO_ROW_LIMIT=2147483647;
publicstaticfinalRowBoundsDEFAULT=newRowBounds();
privateintoffset;
privateintlimit;

publicRowBounds(){
this.offset=0;
this.limit=2147483647;
}

publicRowBounds(intoffset,intlimit){
this.offset=offset;
this.limit=limit;
}

publicintgetOffset(){
returnthis.offset;
}

publicintgetLimit(){
returnthis.limit;
}
}