研究MyBatis分页插件的设计理念

public class Page {
    private int pageNo; // 当前页码
    private int pageSize; // 每页大小
    private int total; // 总记录数

    // 省略getter和setter方法
}

@Intercepts({
    @Signature(type = StatementHandler.class, method = "prepare", args = {Connection.class, Integer.class})
})
public class CustomPaginationInterceptor implements Interceptor {
    
    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        if (invocation.getTarget() instanceof StatementHandler) {
            StatementHandler statementHandler = (StatementHandler) invocation.getTarget();
            MetaObject metaObject = SystemMetaObject.forObject(statementHandler);
            
            while (metaObject.hasGetter("h")) {
                Object obj = metaObject.getValue("h");
                metaObject = SystemMetaObject.forObject(obj);
            }
            
            MappedStatement mappedStatement = (MappedStatement) metaObject.getValue("delegate.mappedStatement");
            if ("SELECT".equals(mappedStatement.getSqlCommandType().name())) {
                BoundSql boundSql = (BoundSql) metaObject.getValue("delegate.boundSql");
                String originalSql = boundSql.getSql();
                Page page = PageHelper.getPage();

                if (page != null) {
                    String limitSql = String.format("%s LIMIT %s OFFSET %s",
                            originalSql, page.getPageSize(), (page.getPageNo() - 1) * page.getPageSize());
                    metaObject.setValue("delegate.boundSql.sql", limitSql);
                }
            }
        }
        
        return invocation.proceed();
    }

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

    @Override
    public void setProperties(Properties properties) {
        // 空实现
    }
}

<plugins>
    <plugin interceptor="com.example.CustomPaginationInterceptor">
</plugins>

public interface UserMapper {
    List<User> selectByPage(Page page);
}

<select id="selectByPage" resultMap="userResultMap">
    SELECT * FROM user
</select>

Page page = new Page(1, 10);
List<User> userList = userMapper.selectByPage(page);