Mybatis其他-PageHelper

• PageHelper介绍
  
  PageHelper是一款犀利的Mybatis分页插件，使用了这个插件之后，分页开发起来更加简单容易。
  本知识点讲解如何使用该插件
• jar包
  
  因为是第三方插件，所以需要额外的jar包，
  pagehelper-5.1.0-beta2.jar，jsqlparser-1.0.jar
• 数据设置为100条
  
  为了观察分页查询的效果，把分类表里的数据都删除掉，然后新增100个数据
  

  package com.how2java;
      
  import java.io.IOException;
  import java.io.InputStream;
  import java.util.List;
   
  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 com.how2java.pojo.Category;
      
  public class TestMybatis {
      
      public static void main(String[] args) throws IOException {
          String resource = "mybatis-config.xml";
          InputStream inputStream = Resources.getResourceAsStream(resource);
          SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
          SqlSession session = sqlSessionFactory.openSession();
          List<Category> cs = session.selectList("listCategory");
          for (Category c : cs) {
              session.delete("deleteCategory", c);
          }
          for (int i = 0; i < 100; i++) {
              Category c = new Category();
              c.setName("category name " + i);
              session.insert("addCategory", c);
          }
          List<Category> cs2 = session.selectList("listCategory");
          for (Category c : cs2) {
              System.out.println(c.getName());
          }
   
          session.commit();
          session.close();
   
      }
  }

• 配置插件
  
  在mybatis-config.xml中，添加15-19行的代码，表示开启PageHelper插件
  

   <plugins>
          <plugin interceptor="com.github.pagehelper.PageInterceptor">
               
          </plugin>
      </plugins>   

  
  

  <?xml version="1.0" encoding="UTF-8" ?>
  <!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
  <configuration>
      <settings> 
              <!-- 打开延迟加载的开关 --> 
              <setting name="lazyLoadingEnabled" value="true" /> 
              <!-- 将积极加载改为消息加载即按需加载 --> 
              <setting name="aggressiveLazyLoading" value="false"/> 
          </settings>   
      <typeAliases>
        <package name="com.how2java.pojo"/>
      </typeAliases>
      <plugins>
          <plugin interceptor="com.github.pagehelper.PageInterceptor">
               
          </plugin>
      </plugins>     
      <environments default="development">
          <environment id="development">
              <transactionManager type="JDBC"/>
              <dataSource type="POOLED">
              <property name="driver" value="com.mysql.jdbc.Driver"/>
              <property name="url" value="jdbc:mysql://localhost:3306/how2java?characterEncoding=UTF-8"/>
              <property name="username" value="root"/>
              <property name="password" value="admin"/>
              </dataSource>
          </environment>
      </environments>
      <mappers>
          <mapper resource="com/how2java/pojo/Category.xml"/>
          <mapper class="com.how2java.mapper.CategoryMapper"/> 
          <mapper class="com.how2java.mapper.ProductMapper"/> 
      </mappers>
     
  </configuration>

• Category.xml
  
  24-26行的limit注释掉，因为分页相关工作，会由PageHelper去做掉，不需要自己去写了
  

  <?xml version="1.0" encoding="UTF-8"?>
  <!DOCTYPE mapper
      PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
   
      <mapper namespace="com.how2java.pojo">
          <insert id="addCategory" parameterType="Category" >
              insert into category_ ( name ) values (#{name})   
          </insert>
           
          <delete id="deleteCategory" parameterType="Category" >
              delete from category_ where id= #{id}  
          </delete>
           
          <select id="getCategory" parameterType="_int" resultType="Category">
              select * from   category_  where id= #{id}   
          </select>
   
          <update id="updateCategory" parameterType="Category" >
              update category_ set name=#{name} where id=#{id}   
          </update>
          <select id="listCategory" resultType="Category">
              select * from   category_
  <!--                 <if test="start!=null and count!=null"> -->
  <!--                     limit #{start},#{count} -->
  <!--                 </if> -->
          </select>    
      </mapper>

• 分页查询
  
  查询很有意思，只需要在执行查询所有的调用之前，执行一条语句即可：
  

  PageHelper.offsetPage(0, 5);

  这就表示查出第一页的数据，每页5条
  
  

  package com.how2java;
     
  import java.io.IOException;
  import java.io.InputStream;
  import java.util.List;
   
  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 com.github.pagehelper.PageHelper;
  import com.how2java.pojo.Category;
     
  public class TestMybatis {
      public static void main(String[] args) throws IOException, InterruptedException {
          String resource = "mybatis-config.xml";
          InputStream inputStream = Resources.getResourceAsStream(resource);
          SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
          SqlSession session = sqlSessionFactory.openSession();
        
          PageHelper.offsetPage(0, 5);
   
          List<Category> cs = session.selectList("listCategory");
          for (Category c : cs) {
              System.out.println(c.getName());
          }
   
          session.commit();
          session.close();
      }
  }

• 获取总数
  
  通过第31行的代码
  

  PageInfo page= new PageInfo<>(cs);

  就可以获取分页信息，包括总数以及其他的
  
  

  package com.how2java;
     
  import java.io.IOException;
  import java.io.InputStream;
  import java.util.List;
   
  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 com.github.pagehelper.PageHelper;
  import com.github.pagehelper.PageInfo;
  import com.how2java.pojo.Category;
     
  public class TestMybatis {
      public static void main(String[] args) throws IOException, InterruptedException {
          String resource = "mybatis-config.xml";
          InputStream inputStream = Resources.getResourceAsStream(resource);
          SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
          SqlSession session = sqlSessionFactory.openSession();
        
          PageHelper.offsetPage(0, 5);
   
          List<Category> cs = session.selectList("listCategory");
          for (Category c : cs) {
              System.out.println(c.getName());
          }
           
          PageInfo pageInfo = new PageInfo<>(cs);
          System.out.println("总数："+pageInfo.getTotal());
          System.out.println(pageInfo);
   
          session.commit();
          session.close();
      }
  }