mybatis下的分页支持所有的数据库.docxVIP

大 家都知道，mybatis的自带分页方法只是逻辑分 页，如果数据量很大，内存一定会溢出，不知道为什么开源组织不在里面集成hibernate的物理分页处理方法!在不修改mybatis源代码的情况下， 应该怎么使mybatis支持物理分页呢？参考了网上的一些信息，有了下面的解决方法：以oracle为例子?1.把hibernate下的dialect包全部拷贝到mybatis包的jdbc目录下，如下图所示：?2.定义一个ResultSetHandler? Interceptorpackage cn.machi.utils;import java.sql.Statement;import java.util.Properties;import org.apache.ibatis.executor.resultset.FastResultSetHandler;import org.apache.ibatis.executor.resultset.ResultSetHandler;import org.apache.ibatis.plugin.Interceptor;import org.apache.ibatis.plugin.Intercepts;import org.apache.ibatis.plugin.Invocation;import org.apache.ibatis.plugin.Plugin;import org.apache.ibatis.plugin.Signature;import org.apache.ibatis.session.RowBounds;@Intercepts(?{@Signature(type?= ResultSetHandler.class, method = handleResultSets, args = {Statement.class})})public class DiclectResultSetHandlerInterceptor implements Interceptor{? public Object intercept(Invocation invocation) throws Throwable { FastResultSetHandler resultSet = (FastResultSetHandler)invocation.getTarget();? RowBounds rowBounds = (RowBounds)ReflectUtil.getFieldValue(resultSet, rowBounds);? if (rowBounds.getLimit() 0 rowBounds.getLimit() RowBounds.NO_ROW_LIMIT) { ReflectUtil.setFieldValue(resultSet, rowBounds, new RowBounds()); } return invocation.proceed(); }? public Object plugin(Object target) { return Plugin.wrap(target, this); }? public void setProperties(Properties properties) { }}?3.定义一个StatementHandler的Interceptorpackage cn.machi.utils;import java.sql.Connection;import java.util.Properties;import org.apache.ibatis.executor.statement.PreparedStatementHandler;import org.apache.ibatis.executor.statement.RoutingStatementHandler;import org.apache.ibatis.executor.statement.StatementHandler;import org.apache.ibatis.jdbc.dialect.OracleDialect;import org.apache.ibatis.mapping.BoundSql;import org.apache.ibatis.plugin.Interceptor;import org.apache.ibatis.plugin.Intercepts;import org.apache.ibatis.plugin.Invocation;import org.apache.ibatis.plugin.Plugin;import org.apa