Mybatis拦截器实现分页

最新推荐文章于 2022-06-07 12:53:44 发布
最新推荐文章于 2022-06-07 12:53:44 发布
阅读量137 收藏
点赞数
文章标签： java
原文链接：https://my.oschina.net/popfei/blog/1837088
版权

30522ccea3ac6c0d66e631aeef81f14b3c6.jpg

5a6ddf4c50a8d185a76624fa3ea695279dd.jpg

2b49afe29271f4f6a77a6fdcf824232e863.jpg

28ab9b8e0f087f2b7d74a5dffa919271e1b.jpg

9b04ac781f4f8facfb6b869f870c74a3047.jpg

import org.apache.ibatis.executor.resultset.ResultSetHandler;
import org.apache.ibatis.plugin.*;

import java.sql.Statement;
import java.util.Properties;

/**
 * 插件签名，告诉mybaits单线插件用来拦截哪个插件对象的哪个方法
 */
@Intercepts({
        @Signature(type= ResultSetHandler.class,
                    method = "handleResultSets",
                    args = Statement.class)
})
public class MyFirstInterceptor1 implements Interceptor {
    //拦截目标对象的目标方法的
    public Object intercept(Invocation invocation) throws Throwable {

        System.out.println("拦截的目标对象："+invocation.getTarget());
        System.out.println("拦截的目标方法："+invocation.getMethod());
        System.out.println("拦截的目标参数："+invocation.getArgs());
        Object object=invocation.proceed();

        return object;
    }
    //包装目标对象 为目标对象创建代理对象的
    public Object plugin(Object o) {
        System.out.println("将要包装的目标对象"+o);
        return Plugin.wrap(o,this);
    }

    public void setProperties(Properties properties) {
        System.out.println("插件配置的初始化参数"+properties);
    }
}
<!--mybatis-config.xml-->
   <plugins>
      <plugin interceptor="com.mooc.mybatis.interceptor.MyFirstInterceptor">
         <property name="hello" value="world"></property>
      </plugin>
public void testCollection()
{
    SqlSession sqlSession = this.getSqlSessionFactory().openSession();
    PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
    Person person=personMapper.getPersonByCollection(new int[]{1,2});
    System.out.println(person);

f79071dcc6c6288d15ec0fbaa01c8eab7e7.jpg

b62018447ca95ba2d13320067808707dd60.jpg

16c315403d1afc8d6d36c63a36d45aa18df.jpg

af1e566531650245eb3cc64be6e31d63edf.jpg

5482666bcb1a0905531da19258e11a3ccbe.jpg

9ff8cc20169b6ecb6fdaf7e44e6fc894dc9.jpg

public List<Person> getAllPersons();
<select id="getAllPersons" resultType="person">
  SELECT  * from person
</select>
public  void getAllPersons()
{

   SqlSession sqlSession = this.getSqlSessionFactory().openSession();

   PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);

   Page<Object> page= PageHelper.startPage(1,10);

   List<Person> persons=personMapper.getAllPersons();

   PageInfo pageInfo=new PageInfo(persons,9);
   for (Person person:persons)
   {
      System.out.println(person.getId());
   }

   System.out.println(page.getPageNum());//current page
   System.out.println(page.getTotal());//total
   System.out.println(page.getPageSize());//page size

   System.out.println(pageInfo.isIsFirstPage());

   System.out.println(pageInfo.getPages());// total pages

   int[] nums=pageInfo.getNavigatepageNums();

   for (int i = 0; i < nums.length; i++) {
      System.out.println(nums[i]);
   }
}

===================传统分页===========

package com.imooc.project.util;

import java.util.List;

/**
 * create by imooc
 */
public class PageUtil {
   
   private int currentPageNum; //当前要看哪一页
   
   private int pageSize=10;//每页显示的条数
   
   private int totalSize;//总记录条数
   
   private int startIndex;//查询开始记录的索引 limit ? ?
   
   private int totalPageNum;//总页数
   
   private int prePageNum;//上一页
   
   private int nextPageNum;//下一页
   
   private List  records;//当前页的记录集
   
   
   //用于显示页面上的导航的页号  用户可自定义
   private int startPageNum;
   private int endPageNum;
   private String url;
   
   //使用构造方法，传递必要的两个参数.第一个是页码，第二个总记录条数
   public PageUtil(int currentPageNum,int totalrecords)
   {
      this.currentPageNum=currentPageNum;
      this.totalSize=totalrecords;
      //计算开始记录索引
      startIndex=(currentPageNum-1)*pageSize;
      //计算总页数
      totalPageNum=totalSize%pageSize==0?totalSize/pageSize:totalSize/pageSize+1;
      //计算开始和结束页号  这个根据自身可设计
      if(totalPageNum>9)
      {
         startPageNum=currentPageNum-4;
         endPageNum=currentPageNum+4;

         if(startPageNum<1)
         {
            startPageNum=1;
            endPageNum=startPageNum+8;
         }
         if(endPageNum>totalPageNum)
         {
            endPageNum=totalPageNum;
            startPageNum=endPageNum-8;
         }
      }
      else
      {
         startPageNum=1;
         endPageNum=totalPageNum;
      } 
   }
   
     public int getStartPageNum() {
      return startPageNum;
   }

   public void setStartPageNum(int startPageNum) {
      this.startPageNum = startPageNum;
   }

   public int getEndPageNum() {
      return endPageNum;
   }

   public void setEndPageNum(int endPageNum) {
      this.endPageNum = endPageNum;
   }

   public int getPrePageNum() {
      prePageNum=currentPageNum-1;
      
      if(prePageNum<=0)
      {
         prePageNum=1;
      }
      return prePageNum;
   }

   public int getNextPageNum() {
      
      nextPageNum=currentPageNum+1;
      
      if(nextPageNum>totalPageNum)
      {
         nextPageNum=totalPageNum;
      }
      return nextPageNum;
   }
   public int getCurrentPageNum() {
      return currentPageNum;
   }
   public void setCurrentPageNum(int currentPageNum) {
      this.currentPageNum = currentPageNum;
   }
   public int getPageSize() {
      return pageSize;
   }
   public void setPageSize(int pageSize) {
      this.pageSize = pageSize;
   }
   public int getTotalSize() {
      return totalSize;
   }
   public void setTotalSize(int totalSize) {
      this.totalSize = totalSize;
   }
   public int getStartIndex() {
      return startIndex;
   }
   public void setStartIndex(int startIndex) {
      this.startIndex = startIndex;
   }
   public int getTotalPageNum() {
      return totalPageNum;
   }
   public void setTotalPageNum(int totalPageNum) {
      this.totalPageNum = totalPageNum;
   }
   public List  getRecords() {
      return records;
   }
   public void setRecords(List  records) {
      this.records = records;
   }

   public void setPrePageNum(int prePageNum) {
      this.prePageNum = prePageNum;
   }
   public void setNextPageNum(int nextPageNum) {
      this.nextPageNum = nextPageNum;
   }
   public String getUrl() {
      return url;
   }
   public void setUrl(String url) {
      this.url = url;
   } 
}
package com.imooc.project.web;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.imooc.project.service.UserService;
import com.imooc.project.service.impl.UserServiceImpl;
import com.imooc.project.util.PageUtil;

@WebServlet("/servlet/UserServlet")
public class UserServlet extends HttpServlet {

   private UserService userService=new UserServiceImpl();

   public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
      this.doGet(request, response);
 
      }
   public void doGet(HttpServletRequest request, HttpServletResponse response)
         throws ServletException, IOException {
      String method=request.getParameter("method");

      if(method.equals("all"))
     {
       selectAllUsers(request,response);
     }

   }

    //获取所有的用户信息
   private void selectAllUsers(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
   {

        String num=request.getParameter("num");

        if(null==num)
      {
         num="1";
      }

      PageUtil page=null;

      try {
         page=userService.getAllUsers(num);
      } catch (Exception e) {
         e.printStackTrace();
      }
      request.setAttribute("page",page);
      request.getRequestDispatcher("/users.jsp").forward(request,response);

   }

}
package com.imooc.project.service.impl;

import com.imooc.project.dao.PersonMapper;
import com.imooc.project.dao.UserDao;
import com.imooc.project.dao.impl.UserDaoImpl;
import com.imooc.project.entity.Person;
import com.imooc.project.entity.User;
import com.imooc.project.service.UserService;
import com.imooc.project.util.PageUtil;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.Reader;
import java.util.List;

/**
 * Created by imooc
 */
public class UserServiceImpl  implements UserService {

     private UserDao userDao=new UserDaoImpl();

    public static SqlSessionFactory sqlSessionFactory = null;

    public static SqlSessionFactory getSqlSessionFactory() {
        if (sqlSessionFactory == null) {
            String resource = "mybatis-config.xml";
            try {
                Reader reader = Resources.getResourceAsReader(resource);
                sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return sqlSessionFactory;
    }

/**
    @Override
    public List<Person> getAllUsersBypageHelper() {

        SqlSession sqlSession=this.getSqlSessionFactory().openSession();

        PersonMapper personMapper=sqlSession.getMapper(PersonMapper.class);

        List<Person> persons=personMapper.getAllPersons();


        return persons;
    }
**/
    @Override
    public PageUtil getAllUsers(String num) throws Exception {

        int currentPageNum=1;

        if(null!=num&&!num.trim().equals(""))
        {
            currentPageNum=Integer.parseInt(num);
        }

        int totalRecords=userDao.totalRecords();

        PageUtil pu=new PageUtil(currentPageNum,totalRecords);

        List<User> users= userDao.getAllUsers(pu.getStartIndex(),pu.getPageSize());

        pu.setRecords(users);

        return pu;
    }
}
package com.imooc.project.dao.impl;

import com.imooc.project.dao.BaseDao;
import com.imooc.project.dao.UserDao;
import com.imooc.project.entity.User;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.ibatis.executor.ReuseExecutor;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.sql.PreparedStatement;


/**
 * Created by imooc
 */
public class UserDaoImpl extends BaseDao implements UserDao {

    QueryRunner queryRunner=new QueryRunner();

    @Override
    public List<User> getAllUsers(int startIndex, int pageSize) throws Exception {

        String sql="select * from t_user limit ?,?";

        List<User> users=null;

        users=queryRunner.query(this.getConnection(),sql,new BeanListHandler<User>(User.class),new Object[]{startIndex,pageSize});

        return users;
    }

    @Override
    public int totalRecords() throws Exception {
        int result=0;

        Connection conn=this.getConnection();
        PreparedStatement ps=null;

        ResultSet rs=null;

        String sql="select count(*)  count from t_user";
        ps=conn.prepareStatement(sql);
        rs=ps.executeQuery();

        if(rs.next())
        {
            result=rs.getInt("count");
        }

        return result;

    }
}

===============pageHelper============

<!--mybatis-config.xml-->
   <plugins>
      <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
   </plugins>
package com.imooc.project.web;

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.imooc.project.entity.Person;
import com.imooc.project.service.UserService;
import com.imooc.project.service.impl.UserServiceImpl;
import com.imooc.project.util.PageUtil;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

@WebServlet("/servlet/UserServlet2")
public class UserServlet2 extends HttpServlet {

   private UserService userService=new UserServiceImpl();

   public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
      this.doGet(request, response);
 
      }
   public void doGet(HttpServletRequest request, HttpServletResponse response)
         throws ServletException, IOException {

      String method=request.getParameter("method");

      if(method.equals("all"))
     {
       selectAllUsers(request,response);
     }

   }

    //获取所有的用户信息
   private void selectAllUsers(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
   {

        String num=request.getParameter("num");

        if(null==num)
      {
         num="1";
      }

      // Page PageInfo

      Page<?> page=PageHelper.startPage(Integer.parseInt(num),5);

      List<Person> persons=userService.getAllUsersBypageHelper();

      PageInfo<?> pageHelper=page.toPageInfo();

      request.setAttribute("persons",persons);
      request.setAttribute("pagehelper",pageHelper);

        request.getRequestDispatcher("/persons.jsp").forward(request,response);

      /*PageUtil page=null;

      try {
         page=userService.getAllUsers(num);
      } catch (Exception e) {
         e.printStackTrace();
      }
      request.setAttribute("page",page);
      request.getRequestDispatcher("/users.jsp").forward(request,response);*/

   }
   
}
@Override
public List<Person> getAllUsersBypageHelper() {

    SqlSession sqlSession=this.getSqlSessionFactory().openSession();

    PersonMapper personMapper=sqlSession.getMapper(PersonMapper.class);

    List<Person> persons=personMapper.getAllPersons();


    return persons;
}
public List<Person> getAllPersons();
<select id="getAllPersons" resultType="person">
  SELECT  * from person
</select>

转载于:https://my.oschina.net/popfei/blog/1837088

chihanjue1993
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MyBatis--拦截器实现分页
Java小白的自学之路
05-08 724
主要内容： MyBatis四大对象及插件原理： MyBatis插件开发： 测试：定义一个插件类： MyFirstInterceptor ：一定继承自Interceptor类，重写里面的方法 package com.mooc.mybatis.interceptor; import org.apache.ibatis.executor.resultset....
MyBatis实现拦截器分页功能
唯二
03-09 253
MyBatis实现拦截器分页功能 1.原理 在mybatis使用拦截器（interceptor），截获所执行方法的sql语句与参数。 （1）修改sql的查询结果：将原sql改为查询count(*) 也就是条数 （2）将语句sql进行拼接 limit(MySql)或rownum(...
mybatis使用拦截器实现分页操作
08-12
使用mybatis的拦截器功能实现分页操作，使分页代码在整个项目中通用，减少代码冗余。
mybatis高级应用系列一：分页功能
weixin_30745641的博客
08-09 113
Mybatis分页插件请使用这位帅哥开发的, 看起来不错.https://github.com/miemiedev/mybatis-paginator Mybatis3.0出来已有段时间了，其实自己挺喜欢这样的一个持久化框架的，因为它简单实用，学习成本低。Mybatis3.0在整体结构上和ibatis2.X差不多，改进特性如下： 1. 解析xml引进...
long mode 分页_Mybatis拦截器实现分页
weixin_39576066的博客
12-21 58
packagecn.com.common.page;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.List;importjava.util.regex.Matcher;importjava....
MyBatis拦截器实现分页功能的实现方法
09-09
总结来说，MyBatis拦截器实现分页功能需要定义一个分页对象来存储分页参数，然后通过实现Interceptor接口并重写intercept方法来修改原始SQL语句，最后在MyBatis配置中正确注册拦截器。这样就可以在不侵入原有业务...
spring+springMVC+mybatis拦截器分页 源码
10-15
spring+springMVC+mybatis拦截器分页
SpringBoot项目实战（005）mybatis拦截器实现分页
IT老吴的博客
04-18 938
之前几章，介绍了一个mybatis的增删改查、分页、异常处理、测试的demo。 本章仿照之前的mybatis插件，实现一下mybatis拦截器，实现分页功能。
MyBatis拦截器实现分页
wqh8522的博客
01-04 1892
原文地址：MyBatis拦截器实现分页 拦截器的作用就是拦截某些方法的调用，我们可以在方法执行前后为方法加上某些逻辑，也可以只执行拦截的逻辑代码而不执行被拦截的方法。Mybatis拦截器设计的一个初衷就是为了供用户在某些时候可以实现自己的逻辑而不必去动Mybatis固有的逻辑。 拦截器分页原理 Mybatis拦截器常常会被用来进行分页处理。我们知道要利用JDBC对数据库进行操作就必须要
mybatis 拦截器分页
ZYG_Go的博客
10-02 479
public class Pager { // 一 这是一个分页工具类（没有写全） private List resultList; //用于封装返回的结果 private int currentPage = 1; //默认第一页 private int pages; private int pageSize = 20; // 页面大小默认为20
mybatis拦截器实现分页功能的示例讲解
weixin_33950035的博客
06-06 100
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 org.apache....
mybatis的拦截器实现简单分页功能
Mr_Dai的博客
12-03 371
使用ThreadLocal和Interceptor实现mybatis的分页功能，这里只是简单的了解一下mybatis的Interceptor接口。 package com.dwl.mybatis.mysql; import org.apache.ibatis.cache.CacheKey; import org.apache.ibatis.executor.Executor; import ...
SpringBoot: 自定义MyBatis拦截器来实现分页
amadeus_liu2的博客
06-07 1794
springboot mybatis
MyBatis 分页之拦截器实现
weixin_30508309的博客
02-19 107
　　分页是WEB程序中常见的功能，mybatis分页实现与hibernate不同，相比hibernate，mybatis实现分页更为麻烦。mybatis实现分页需要自己编写（非逻辑分页RowBounds），以mysql为例，使用分页时需要自己在mapper中的sql语句中添加LIMIT #{xx},#{xx}。这种方式不具备可重用性与可拓展性。 　　mybatis提供了plugins，plugi...
mybatis 分页实现方式之分页拦截器
astray的博客
04-29 1154
查看我的代码结构 ** ** 创建简单分页实体 import java.io.Serializable; import java.util.List; /** * Created by IntelliJ IDEA. * 简单分页对象 * @Author : WangCong * @create 2020/4/21 13:09 */ public class SimplePage imp...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值