MyBatis3.2 使用Interceptor进行分页

本文主要介绍如何使用Mybaits的拦截器 对Sql进行改造，以便支持分页。

关于mybatis的拦截器使用以及原理可以参考我的另外一篇文章（http://www.cnblogs.com/daxin/p/3544188.html）。

首先说一下实现原理，就是当Mybatis查询数据的时候，利用Mybatis提供的Interceptor对查询方法进行拦截，动态修改SQL，把不带分页的SQL改造成带分页的SQL

比如在MySql数据库下面 正常查询的SQL 为 selelct id, name from user where name = ?  那么改造后的SQL 为 selelct id, name from user where name = ? limit 5 , 10

这样就支持分页了。

 

1、首先扩展mybatis提供的RowBounds

什么都没变，就是加了一个属性total 用来存放查询到的总记录数。另外加了setMeToDefault这个方法，目的是将这个类设置为初始状态，这样Mybatis底层就不会在去分页了。

 

package com.framework.core.mybatis;

import org.apache.ibatis.session.RowBounds;

public class PagingBounds extends RowBounds {
    
    //总记录数
    private int total;
    //查询的起始位置
    private int offset;
    //查询多少行记录
    private int limit;

    public PagingBounds() {
        this.offset = NO_ROW_OFFSET;
        this.limit = NO_ROW_LIMIT;
    }

    public PagingBounds(int offset, int limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public int getTotal() {
        return total;
    }

    public void setTotal(int total) {
        this.total = total;
    }

    public int getOffset() {
        return offset;
    }

    public int getLimit() {
        return limit;
    }

    public void setMeToDefault() {
        this.offset = NO_ROW_OFFSET;
        this.limit = NO_ROW_LIMIT;
    }
    
    public int getSelectCount() {
        return limit + offset;
    }
}

 

2、定义一个抽象类实现Mybatis的拦截器接口，将分页的核心逻辑抽离出来，这样可以针对不同的数据库进行扩展，这个类也是分页逻辑的核心，细节相对复杂。

可以看到有俩个抽象方法需要子类扩展

1：protected abstract String getSelectTotalSql(String targetSql);

这个方法是把目标SQL（这里的SQL就是你XML当中定义的，比如 select id, name from user where name = ?）传递给子类，子类可以针对不同数据库进行包装，并返回查询总数的SQL。

2：protected abstract String getSelectPagingSql(String targetSql, PagingBounds pagingBounds);

这个方法是把目标SQL改造成带分页的SQL，PagingBounds这个参数有分页的信息。

package com.framework.core.mybatis;

import java.lang.reflect.Field;
import java.lang.reflect.Modifier;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Properties;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import org.apache.ibatis.executor.parameter.ParameterHandler;
import org.apache.ibatis.executor.statement.RoutingStatementHandler;
import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.ParameterMapping;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.plugin.Invocation;
import org.apache.ibatis.plugin.Plugin;
import org.apache.ibatis.scripting.defaults.DefaultParameterHandler;
import org.apache.ibatis.session.RowBounds;

public abstract class AbstractPagingInterceptor implements Interceptor {

    private static final Pattern PATTERN_SQL_BLANK = Pattern.compile("\\s+");

    private static final String FIELD_DELEGATE = "delegate";
    
    private static final String FIELD_ROWBOUNDS = "rowBounds";
    
    private static final String FIELD_MAPPEDSTATEMENT = "mappedStatement";
    
    private static final String FIELD_SQL = "sql";
    
    private static final String BLANK = " ";

    public static final String SELECT = "select";
    
    public static final String FROM = "from";
    
    public static final String ORDER_BY = "order by";
    
    public static final String UNION = "union";
    
    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        Connection connection = (Connection) invocation.getArgs()[0];
        RoutingStatementHandler statementHandler = (RoutingStatementHandler) invocation.getTarget();

        StatementHandler handler = (StatementHandler) readField(statementHandler, FIELD_DELEGATE);
        PagingBounds pagingBounds = (PagingBounds) readField(handler, FIELD_ROWBOUNDS);
        MappedStatement mappedStatement = (MappedStatement) readField(handler, FIELD_MAPPEDSTATEMENT);
        BoundSql boundSql = handler.getBoundSql();

        //replace all blank
        String targetSql = replaceSqlBlank(boundSql.getSql());
        
        //paging
        getTotalAndSetInPagingBounds(targetSql, boundSql, pagingBounds, mappedStatement, connection);
        String pagingSql = getSelectPagingSql(targetSql, pagingBounds);
        writeDeclaredField(boundSql, FIELD_SQL, pagingSql);
        
        //ensure set to default
        pagingBounds.setMeToDefault(); 
        return invocation.proceed();
    }

    private void getTotalAndSetInPagingBounds(String targetSql, BoundSql boundSql, PagingBounds bounds, 
                            MappedStatement mappedStatement, Connection connection) throws SQLException {
        String totalSql = getSelectTotalSql(targetSql);
        List<ParameterMapping> parameterMappings = boundSql.getParameterMappings();
        Object parameterObject = boundSql.getParameterObject();
        BoundSql totalBoundSql = new BoundSql(mappedStatement.getConfiguration(), totalSql, parameterMappings, parameterObject);
        ParameterHandler parameterHandler = new DefaultParameterHandler(mappedStatement, parameterObject, totalBoundSql);
        
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            pstmt = connection.prepareStatement(totalSql);
            parameterHandler.setParameters(pstmt);
            rs = pstmt.executeQuery();
            if(rs.next()) {
                int totalRecord = rs.getInt(1);
                bounds.setTotal(totalRecord);
            }
        } finally {
            if(rs != null) {
                rs.close();
            }
            if(pstmt != null) {
                pstmt.close();
            }
        }
    }

    protected abstract String getSelectTotalSql(String targetSql);
    
    protected abstract String getSelectPagingSql(String targetSql, PagingBounds pagingBounds);

    private String replaceSqlBlank(String originalSql) {
        Matcher matcher = PATTERN_SQL_BLANK.matcher(originalSql);
        return matcher.replaceAll(BLANK);
    }

    @Override
    public Object plugin(Object target) {
        if (target instanceof RoutingStatementHandler) {
            try {
                Field delegate = getField(RoutingStatementHandler.class, FIELD_DELEGATE);
                StatementHandler handler = (StatementHandler) delegate.get(target);
                RowBounds rowBounds = (RowBounds) readField(handler, FIELD_ROWBOUNDS);
                if (rowBounds != RowBounds.DEFAULT && rowBounds instanceof PagingBounds) {
                    return Plugin.wrap(target, this);
                }
            } catch (IllegalAccessException e) {
                // ignore
            }
        }
        return target;
    }

    private void writeDeclaredField(Object target, String fieldName, Object value) 
            throws IllegalAccessException {
        if (target == null) {
            throw new IllegalArgumentException("target object must not be null");
        }
        Class<?> cls = target.getClass();
        Field field = getField(cls, fieldName);
        if (field == null) {
            throw new IllegalArgumentException("Cannot locate declared field " + cls.getName() + "." + fieldName);
        }
        field.set(target, value);
    }

    private Object readField(Object target, String fieldName)
            throws IllegalAccessException {
        if (target == null) {
            throw new IllegalArgumentException("target object must not be null");
        }
        Class<?> cls = target.getClass();
        Field field = getField(cls, fieldName);
        if (field == null) {
            throw new IllegalArgumentException("Cannot locate field " + fieldName + " on " + cls);
        }
        if (!field.isAccessible()) {
            field.setAccessible(true);
        }
        return field.get(target);
    }

    private static Field getField(final Class<?> cls, String fieldName) {
        for (Class<?> acls = cls; acls != null; acls = acls.getSuperclass()) {
            try {
                Field field = acls.getDeclaredField(fieldName);
                if (!Modifier.isPublic(field.getModifiers())) {
                    field.setAccessible(true);
                    return field;
                }
            } catch (NoSuchFieldException ex) {
                // ignore
            }
        }
        return null;
    }
    
    @Override
    public void setProperties(Properties properties) {

    }
}

 

3、针对不同数据库进行扩展，这里给出俩个例子。

MSSQL2008

package com.framework.core.mybatis;

import java.sql.Connection;

import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.plugin.Intercepts;
import org.apache.ibatis.plugin.Signature;

@Intercepts(@Signature(type=StatementHandler.class,method="prepare",args={Connection.class})) 
public class SqlServerPagingInterceptor extends AbstractPagingInterceptor {

    /**
     * 改造sql变成查询总数的sql
     * @param targetSql 正常查询数据的sql: select id, name from user where name = ?
     * @return select count(1) from user where name = ?
     */
    @Override
    protected String getSelectTotalSql(String targetSql) {
        String sql = targetSql.toLowerCase();
        StringBuilder sqlBuilder = new StringBuilder(sql);
        
        int orderByPos = 0;
        if((orderByPos = sqlBuilder.lastIndexOf(ORDER_BY)) != -1) {
            sqlBuilder.delete(orderByPos, sqlBuilder.length());
        }
        
        if(sqlBuilder.indexOf(UNION) != -1) {
            sqlBuilder.insert(0, "select count(1) as _count from ( ").append(" ) as _alias");
            return sqlBuilder.toString();
        }
        
        int fromPos = sqlBuilder.indexOf(FROM);
        if(fromPos != -1) {
            sqlBuilder.delete(0, fromPos);
            sqlBuilder.insert(0, "select count(1) as _count ");
        }
        
        return sqlBuilder.toString();
    }

    /**
     * 改造sql变成支持分页的sql
     * @param targetSql 正常查询数据的sql: select id, name from user where name = ?
     * @return WITH query AS (SELECT inner_query.*, ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) 
     * as __mybatis_row_nr__ FROM ( select id, name from user where name = ? ) inner_query ) 
     * SELECT * FROM query WHERE __mybatis_row_nr__ >= 3 AND __mybatis_row_nr__ <= 6 
     */
    @Override
    protected String getSelectPagingSql(String targetSql, PagingBounds bounds) {
        String sql = targetSql.toLowerCase();
        StringBuilder sqlBuilder = new StringBuilder(sql);
        
        if(sqlBuilder.indexOf(ORDER_BY) != -1) {
            int selectPos = sqlBuilder.indexOf(SELECT);
            sqlBuilder.insert(selectPos + SELECT.length(), " TOP(" + bounds.getSelectCount() + ")");
        }
        
        sqlBuilder.insert(0, "SELECT inner_query.*, ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) as __mybatis_row_nr__ FROM ( ");
        sqlBuilder.append(" ) inner_query ");
        
        sqlBuilder.insert(0, "WITH query AS (").append(") SELECT ").append("*").append(" FROM query ");
        sqlBuilder.append("WHERE __mybatis_row_nr__ >= " + (bounds.getOffset() + 1) + " AND __mybatis_row_nr__ <= " + bounds.getSelectCount());
        
        return sqlBuilder.toString();
    }

}

 

Oracle10G的

package com.framework.core.mybatis;

import java.sql.Connection;

import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.plugin.Intercepts;
import org.apache.ibatis.plugin.Signature;

@Intercepts(@Signature(type=StatementHandler.class,method="prepare",args={Connection.class})) 
public class OraclePagingInterceptor extends AbstractPagingInterceptor {

    @Override
    protected String getSelectTotalSql(String targetSql) {
        String sql = targetSql.toLowerCase();
        StringBuilder sqlBuilder = new StringBuilder(sql);
        
        int orderByPos = 0;
        if((orderByPos = sqlBuilder.lastIndexOf(ORDER_BY)) != -1) {
            sqlBuilder.delete(orderByPos, sqlBuilder.length());
        }
        sqlBuilder.insert(0, "select count(1) as _count from ( ").append(" )");
        
        return sqlBuilder.toString();
    }

    @Override
    protected String getSelectPagingSql(String targetSql, PagingBounds bounds) {
        String sql = targetSql.toLowerCase();
        StringBuilder sqlBuilder = new StringBuilder(sql);
        
        sqlBuilder.insert(0, "select * from ( select table_alias.*, rownum mybatis_rowNo from (");
        sqlBuilder.append(") ");
        sqlBuilder.append("table_alias where rownum <= " + bounds.getSelectCount()).append(")");
        sqlBuilder.append("where mybatis_rowNo >= " + (bounds.getOffset() + 1));
        
        return sqlBuilder.toString();
    }

}

 

4、就是将拦截器注册到mybatis的配置文件当中去。你使用什么数据库就注册那个类就行了。

<configuration>
    <settings>
        <setting name="logImpl" value="LOG4J" />
        <!-- <setting name="cacheEnabled" value="false"/> -->
    </settings>

    <plugins>
        <plugin interceptor="com.framework.core.mybatis.SqlServerPagingInterceptor" />
    </plugins>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="net.sourceforge.jtds.jdbc.Driver" />
                <property name="url"
                    value="jdbc:jtds:sqlserver://127.0.0.1/FDK2" />
                <property name="username" value="sa" />
                <property name="password" value="sql2008" />
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="com/framework/code/mapper/ConnectMapper.xml" />
    </mappers>
</configuration>

 

 

5、接下来写个DEMO测试一下吧。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.framework.code.mapper.ConnectMapper" >
  <resultMap id="BaseResultMap" type="com.framework.code.domain.Connect" >
    <id column="Id" property="id" jdbcType="VARCHAR" />
    <result column="Pid" property="pid" jdbcType="VARCHAR" />
    <result column="Number" property="number" jdbcType="VARCHAR" />
    <result column="NumberType" property="numbertype" jdbcType="VARCHAR" />
    <result column="NumberTypeName" property="numbertypename" jdbcType="VARCHAR" />
    <result column="PreviousReceiveUser" property="previousreceiveuser" jdbcType="VARCHAR" />
    <result column="PreviousReceiveUserName" property="previousreceiveusername" jdbcType="VARCHAR" />
    <result column="ReceiveUser" property="receiveuser" jdbcType="VARCHAR" />
    <result column="ReceiveUserName" property="receiveusername" jdbcType="VARCHAR" />
    <result column="HappenTime" property="happentime" jdbcType="TIMESTAMP" />
    <result column="WhetherSuccess" property="whethersuccess" jdbcType="BIT" />
    <result column="SuccessTime" property="successtime" jdbcType="TIMESTAMP" />
    <result column="WhetherhHold" property="whetherhhold" jdbcType="BIT" />
  </resultMap>
  <sql id="Base_Column_List" >
    Id, Pid, Number, NumberType, NumberTypeName, PreviousReceiveUser, PreviousReceiveUserName, 
    ReceiveUser, ReceiveUserName, HappenTime, WhetherSuccess, SuccessTime, WhetherhHold
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from Connect
    where Id = #{id,jdbcType=VARCHAR}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from Connect
    where Id = #{id,jdbcType=VARCHAR}
  </delete>
  <insert id="insert" parameterType="com.framework.code.domain.Connect">
    insert into Connect (Id, Pid, Number, 
      NumberType, NumberTypeName, PreviousReceiveUser, 
      PreviousReceiveUserName, ReceiveUser, ReceiveUserName, 
      HappenTime, WhetherSuccess, SuccessTime, 
      WhetherhHold)
    values (#{id,jdbcType=VARCHAR}, #{pid,jdbcType=VARCHAR}, #{number,jdbcType=VARCHAR}, 
      #{numbertype,jdbcType=VARCHAR}, #{numbertypename,jdbcType=VARCHAR}, #{previousreceiveuser,jdbcType=VARCHAR}, 
      #{previousreceiveusername,jdbcType=VARCHAR}, #{receiveuser,jdbcType=VARCHAR}, #{receiveusername,jdbcType=VARCHAR}, 
      #{happentime,jdbcType=TIMESTAMP}, #{whethersuccess,jdbcType=BIT}, #{successtime,jdbcType=TIMESTAMP}, 
      #{whetherhhold,jdbcType=BIT})
  </insert>
  <insert id="insertSelective" parameterType="com.framework.code.domain.Connect" >
    insert into Connect
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        Id,
      </if>
      <if test="pid != null" >
        Pid,
      </if>
      <if test="number != null" >
        Number,
      </if>
      <if test="numbertype != null" >
        NumberType,
      </if>
      <if test="numbertypename != null" >
        NumberTypeName,
      </if>
      <if test="previousreceiveuser != null" >
        PreviousReceiveUser,
      </if>
      <if test="previousreceiveusername != null" >
        PreviousReceiveUserName,
      </if>
      <if test="receiveuser != null" >
        ReceiveUser,
      </if>
      <if test="receiveusername != null" >
        ReceiveUserName,
      </if>
      <if test="happentime != null" >
        HappenTime,
      </if>
      <if test="whethersuccess != null" >
        WhetherSuccess,
      </if>
      <if test="successtime != null" >
        SuccessTime,
      </if>
      <if test="whetherhhold != null" >
        WhetherhHold,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=VARCHAR},
      </if>
      <if test="pid != null" >
        #{pid,jdbcType=VARCHAR},
      </if>
      <if test="number != null" >
        #{number,jdbcType=VARCHAR},
      </if>
      <if test="numbertype != null" >
        #{numbertype,jdbcType=VARCHAR},
      </if>
      <if test="numbertypename != null" >
        #{numbertypename,jdbcType=VARCHAR},
      </if>
      <if test="previousreceiveuser != null" >
        #{previousreceiveuser,jdbcType=VARCHAR},
      </if>
      <if test="previousreceiveusername != null" >
        #{previousreceiveusername,jdbcType=VARCHAR},
      </if>
      <if test="receiveuser != null" >
        #{receiveuser,jdbcType=VARCHAR},
      </if>
      <if test="receiveusername != null" >
        #{receiveusername,jdbcType=VARCHAR},
      </if>
      <if test="happentime != null" >
        #{happentime,jdbcType=TIMESTAMP},
      </if>
      <if test="whethersuccess != null" >
        #{whethersuccess,jdbcType=BIT},
      </if>
      <if test="successtime != null" >
        #{successtime,jdbcType=TIMESTAMP},
      </if>
      <if test="whetherhhold != null" >
        #{whetherhhold,jdbcType=BIT},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.framework.code.domain.Connect" >
    update Connect
    <set >
      <if test="pid != null" >
        Pid = #{pid,jdbcType=VARCHAR},
      </if>
      <if test="number != null" >
        Number = #{number,jdbcType=VARCHAR},
      </if>
      <if test="numbertype != null" >
        NumberType = #{numbertype,jdbcType=VARCHAR},
      </if>
      <if test="numbertypename != null" >
        NumberTypeName = #{numbertypename,jdbcType=VARCHAR},
      </if>
      <if test="previousreceiveuser != null" >
        PreviousReceiveUser = #{previousreceiveuser,jdbcType=VARCHAR},
      </if>
      <if test="previousreceiveusername != null" >
        PreviousReceiveUserName = #{previousreceiveusername,jdbcType=VARCHAR},
      </if>
      <if test="receiveuser != null" >
        ReceiveUser = #{receiveuser,jdbcType=VARCHAR},
      </if>
      <if test="receiveusername != null" >
        ReceiveUserName = #{receiveusername,jdbcType=VARCHAR},
      </if>
      <if test="happentime != null" >
        HappenTime = #{happentime,jdbcType=TIMESTAMP},
      </if>
      <if test="whethersuccess != null" >
        WhetherSuccess = #{whethersuccess,jdbcType=BIT},
      </if>
      <if test="successtime != null" >
        SuccessTime = #{successtime,jdbcType=TIMESTAMP},
      </if>
      <if test="whetherhhold != null" >
        WhetherhHold = #{whetherhhold,jdbcType=BIT},
      </if>
    </set>
    where Id = #{id,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.framework.code.domain.Connect" >
    update Connect
    set Pid = #{pid,jdbcType=VARCHAR},
      Number = #{number,jdbcType=VARCHAR},
      NumberType = #{numbertype,jdbcType=VARCHAR},
      NumberTypeName = #{numbertypename,jdbcType=VARCHAR},
      PreviousReceiveUser = #{previousreceiveuser,jdbcType=VARCHAR},
      PreviousReceiveUserName = #{previousreceiveusername,jdbcType=VARCHAR},
      ReceiveUser = #{receiveuser,jdbcType=VARCHAR},
      ReceiveUserName = #{receiveusername,jdbcType=VARCHAR},
      HappenTime = #{happentime,jdbcType=TIMESTAMP},
      WhetherSuccess = #{whethersuccess,jdbcType=BIT},
      SuccessTime = #{successtime,jdbcType=TIMESTAMP},
      WhetherhHold = #{whetherhhold,jdbcType=BIT}
    where Id = #{id,jdbcType=VARCHAR}
  </update>
  
  <select id="selectPaging" parameterType="hashmap" resultMap="BaseResultMap">
      select 
    <include refid="Base_Column_List" />
    from Connect
    <where>
      <if test="pid != null" >
        AND Pid = #{pid,jdbcType=VARCHAR}
      </if>
      <if test="number != null" >
        AND Number = #{number,jdbcType=VARCHAR}
      </if>
      <if test="numbertype != null" >
        AND NumberType = #{numbertype,jdbcType=VARCHAR}
      </if>
      <if test="numbertypename != null" >
        AND NumberTypeName = #{numbertypename,jdbcType=VARCHAR}
      </if>    
    </where>
  </select>
</mapper>

 

public class Demo {

    
    public static void main(String[] args) throws NoSuchMethodException, SecurityException, IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        DefaultSqlSessionFactory sqlSessionFactory = (DefaultSqlSessionFactory) new SqlSessionFactoryBuilder().build(inputStream);
        DefaultSqlSession session = (DefaultSqlSession) sqlSessionFactory.openSession();
        ConnectMapper mapper = (ConnectMapper)session.getMapper(ConnectMapper.class);
        
        //创建一个PagingBounds 设置起始位置2 查询4调记录
        PagingBounds bounds = new PagingBounds(2, 4);
        HashMap<String, Object> params = new HashMap<String, Object>();
        
        //返回结果
        List<Connect> list = mapper.selectPaging(bounds, params);
        System.out.println(list);
        //总记录数
        System.out.println(bounds.getTotal());
        
        session.commit();
        session.close();
    }
    
}

 

 

看一下日志输出 已经分页了。

DEBUG 2014-07-23 11:25:47,216 org.apache.ibatis.logging.jdbc.BaseJdbcLogger: ==>  Preparing: select count(1) as _count from connect 
DEBUG 2014-07-23 11:25:47,259 org.apache.ibatis.logging.jdbc.BaseJdbcLogger: ==> Parameters: 
DEBUG 2014-07-23 11:25:47,290 org.apache.ibatis.logging.jdbc.BaseJdbcLogger: ==>  Preparing: WITH query AS (SELECT inner_query.*, ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) as __mybatis_row_nr__ FROM ( select id, pid, number, numbertype, numbertypename, previousreceiveuser, previousreceiveusername, receiveuser, receiveusername, happentime, whethersuccess, successtime, whetherhhold from connect ) inner_query ) SELECT * FROM query WHERE __mybatis_row_nr__ >= 3 AND __mybatis_row_nr__ <= 6 
DEBUG 2014-07-23 11:25:47,290 org.apache.ibatis.logging.jdbc.BaseJdbcLogger: ==> Parameters: 
[com.framework.code.domain.Connect@c26dd5, com.framework.code.domain.Connect@b8cab9]
4