手写mybatis分页插件

package golden.interceptor;


import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.plugin.*;
import org.apache.ibatis.reflection.MetaObject;
import org.apache.ibatis.reflection.SystemMetaObject;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.sql.Connection;
import java.util.Properties;

//由于Mybatis原生不支持分页
//解法1：自己手动书写mybatis sql代码
//解法2：引入PageHelper插件，但由于此工程不是maven工程，有些麻烦
//解法3：模仿pagehelper书写拦截器
@Intercepts({@Signature(type = StatementHandler.class, method = "prepare", args = {Connection.class, Integer.class})})
public class PaginationInterceptor implements Interceptor {
    private static final Logger logger = LoggerFactory.getLogger(PaginationInterceptor.class);
    private static int page = -1;
    private static int size = -1;

    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        StatementHandler statementHandler = (StatementHandler) invocation.getTarget();
        MetaObject metaObject = SystemMetaObject.forObject(statementHandler);
//        while (metaObject.hasGetter("h")) {
//            Object object = metaObject.getValue("h");
//            metaObject = SystemMetaObject.forObject(object);
//        }
//        while (metaObject.hasGetter("target")) {
//            Object object = metaObject.getValue("target");
//            metaObject = SystemMetaObject.forObject(object);
//        }
        MappedStatement mappedStatement = (MappedStatement) metaObject.getValue("delegate.mappedStatement");
//        String mapId = mappedStatement.getId();
//        if (mapId.matches(".+ByPage$")) {
        if (page != -1 && size != -1) {
//            ParameterHandler parameterHandler = (ParameterHandler) metaObject.getValue("delegate.parameterHandler");
//            Map<String, Object> params = (Map<String, Object>) parameterHandler.getParameterObject();
//            int page = (int) params.get("page");
//            int size = (int) params.get("size");
            String sql = (String) metaObject.getValue("delegate.boundSql.sql");
//            sql += " limit " + (page - 1) * size + ", " + size;
            if (page <= 0) {
                page = 1;
            }
            sql += " limit " + size + " offset " + (page - 1) * size;
            metaObject.setValue("delegate.boundSql.sql", sql);
        }
//        }
        page = -1;
        size = -1;
        return invocation.proceed();
    }

    @Override
    public Object plugin(Object target) {
        return Plugin.wrap(target, this);
    }

    @Override
    public void setProperties(Properties properties) {
        logger.info("加载分页插件");
        page = -1;
        size = -1;
//        String limit = properties.getProperty("limit", "10");
//        page = Integer.parseInt(limit);
//        dbType = properties.getProperty("dbType", "mysql");
    }

    public static void startPage(int offset_, int size_) {
        page = offset_;
        size = size_;
    }
}

    <bean id="paginationInterceptor" class="golden.interceptor.PaginationInterceptor"/>

<!--sqlSessionFactory设置plugin属性-->
<property name="plugins" ref="paginationInterceptor"/>