Mybatis如何实现分页

Mybatis如何实现分页

关键字limit实现分页

Interceptor Plugin实现分页

首先定一个拦截器,拦截器会拦截所有以ByPage结尾的方法，然后拼接sql 语句的limit关键字实现分页

@Intercepts({
   @Signature(type = StatementHandler.class, method = "prepare", args = {
   Connection.class, Integer.class})})
public class MyPageInterceptor implements Interceptor {
   

    private int page;
    private int size;
    @SuppressWarnings("unused")
    private String dbType;

    @SuppressWarnings("unchecked")
    @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.f
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20