How to implement the paging function of MyBatis interceptor

/**
 * Entity class corresponding to paging */
public class Page {
  /**
   * Total number of entries*/
  private int totalNumber;
  /**
   * Current page */
  private int currentPage;
  /**
   * Total Pages*/
  private int totalPage;
  /**
   * Number of entries per page*/
  private int pageNumber = 5;
  /**
   * The limit parameter in the database, from which entry should be taken*/
  private int dbIndex;
  /**
   * The limit parameter in the database, how many entries are taken in total*/
  private int dbNumber;

  /**
   * Calculate and set related attribute values ​​according to the attribute values ​​in the current object*/
  public void count() {
    // Calculate the total number of pages int totalPageTemp = this.totalNumber / this.pageNumber;
    int plus = (this.totalNumber % this.pageNumber) == 0 ? 0 : 1;
    totalPageTemp = totalPageTemp + plus;
    if(totalPageTemp <= 0) {
      totalPageTemp = 1;
    }
    this.totalPage = totalPageTemp;

    // Set the current page number // The total number of pages is less than the current number of pages, the current page number should be set to the total number of pages if (this.totalPage < this.currentPage) {
      this.currentPage = this.totalPage;
    }
    // If the current page number is less than 1, set it to 1
    if(this.currentPage < 1) {
      this.currentPage = 1;
    }

    //Set limit parameters this.dbIndex = (this.currentPage - 1) * this.pageNumber;
    this.dbNumber = this.pageNumber;
  }

  public int getTotalNumber() {
    return totalNumber;
  }

  public void setTotalNumber(int totalNumber) {
    this.totalNumber = totalNumber;
    this.count();
  }

  public int getCurrentPage() {
    return currentPage;
  }

  public void setCurrentPage(int currentPage) {
    this.currentPage = currentPage;
  }

  public int getTotalPage() {
    return totalPage;
  }

  public void setTotalPage(int totalPage) {
    this.totalPage = totalPage;
  }

  public int getPageNumber() {
    return pageNumber;
  }

  public void setPageNumber(int pageNumber) {
    this.pageNumber = pageNumber;
    this.count();
  }

  public int getDbIndex() {
    return dbIndex;
  }

  public void setDbIndex(int ​​dbIndex) {
    this.dbIndex = dbIndex;
  }

  public int getDbNumber() {
    return dbNumber;
  }

  public void setDbNumber(int dbNumber) {
    this.dbNumber = dbNumber;
  }
}

package com.imooc.interceptor;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Map;
import java.util.Properties;

import org.apache.ibatis.executor.parameter.ParameterHandler;
import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.mapping.MappedStatement;
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.reflection.DefaultReflectorFactory;
import org.apache.ibatis.reflection.MetaObject;
import org.apache.ibatis.reflection.SystemMetaObject;

import com.imooc.entity.Page;

/**
 * Paging Blocker * 
 * @author Skye
 *
 */
@Intercepts({
    @Signature(type = StatementHandler.class, method = "prepare", args = { Connection.class, Integer.class }) })
public class PageInterceptor implements Interceptor {

  public Object intercept(Invocation invocation) throws Throwable {
    StatementHandler statementHandler = (StatementHandler) invocation.getTarget();
    MetaObject metaObject = MetaObject.forObject(statementHandler, SystemMetaObject.DEFAULT_OBJECT_FACTORY,
        SystemMetaObject.DEFAULT_OBJECT_WRAPPER_FACTORY, new DefaultReflectorFactory());
    MappedStatement mappedStatement = (MappedStatement) metaObject.getValue("delegate.mappedStatement");
    //Get the method name id through MetaObject metadata: com.XXX.queryMessageListByPage
    String id = mappedStatement.getId();
    //Match the query ID related to paging defined in mybatis
    if (id.matches(".+ByPage$")) {
      //BoundSql contains the original SQL statement and the corresponding query parameters BoundSql boundSql = statementHandler.getBoundSql();
      Map<String, Object> params = (Map<String, Object>) boundSql.getParameterObject();
      Page page = (Page) params.get("page");
      String sql = boundSql.getSql();
      String countSql = "select count(*)from (" + sql + ")a";
      Connection connection = (Connection) invocation.getArgs()[0];
      PreparedStatement countStatement = connection.prepareStatement(countSql);
      ParameterHandler parameterHandler = (ParameterHandler) metaObject.getValue("delegate.parameterHandler");
      parameterHandler.setParameters(countStatement);
      ResultSet rs = countStatement.executeQuery();
      if (rs.next()) {
        //Why getInt(1)? Because the columns of the data table start counting from 1 page.setTotalNumber(rs.getInt(1));
        System.out.println("The interceptor learns that the total number of records in the page is: " + page.getTotalNumber());
      }
      String pageSql = sql + " limit " + page.getDbIndex() + "," + page.getDbNumber();
      metaObject.setValue("delegate.boundSql.sql", pageSql);
    }
    return invocation.proceed();
  }

  /**
   * @param target
   * The object being intercepted */
  public Object plugin(Object target) {
    // If the interceptor class is likened to a company that buys tickets on behalf of others, then this is the agent who buys tickets on behalf of others (before entering the method, he is a agent without the ability to buy tickets on behalf of others, and after entering, he becomes a agent with the ability to buy tickets on behalf of others)
    // Get the information of the interception target through annotations. If it does not meet the interception requirements, return the original target. If it meets the requirements, use dynamic proxy to generate a proxy object. return Plugin.wrap(target, this);
  }

  public void setProperties(Properties properties) {
    // TODO Auto-generated method stub

  }

}

 <!-- Customized paging interceptor-->
  <plugins>
    <plugin interceptor="The full class name of the interceptor you wrote">
    </plugin>
  </plugins>

<!--Scripts required for pagination-->
<%
  // Get the request context String context = request.getContextPath();
%>
<link href="../css/pagination.css" rel="external nofollow" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="../js/jquery-1.11.3.js"></script>
<script type="text/javascript" src="../js/jquery.pagination.js"></script>
<script type="text/javascript">

//Action triggered after clicking the pagination button function handlePaginationClick(new_page_index, pagination_container) {
<!--Submit the parameters of the current page from the stuForm form. You can use the restful method to let springmvc use the parameters defined by the @PathVariable keyword to connect. These two parameters are provided by the paging control itself, so we don't need to find them ourselves. However, the count starts at 0, and our background paging count starts at 1, so we need to add 1 manually. -->
  $("#stuForm").attr("action", "The paging query url you defined/"+(new_page_index+1));
  $("#stuForm").submit();
  return false;
}

$(function(){
  $("#News-Pagination").pagination(${result.totalRecord}, ​​{
    items_per_page:${result.pageSize}, // How many records are displayed per page current_page:${result.currentPage} - 1, // Which page of data is currently displayed num_display_entries:8, // Number of entries displayed in pages next_text:"Next page",
    prev_text: "Previous page",
    num_edge_entries:2, //Connect to the pagination body, the number of entries displayed callback:handlePaginationClick(current page, id of the pagination div), //Callback function executed load_first_page:false //Prevent the page from being refreshed all the time (this is very important!)
  });
});
</script>
<!-- This part uses the c:forEach tag to print the query results table-->
<!--Paging control name-->
<div id="News-Pagination"></div>