Spring整合Mybatis的BaseMapper与分页插件

通用mapper和分页插件

在原来的基础上添加pom依赖

<!-- https://mvnrepository.com/artifact/tk.mybatis/mapper -->
    <dependency>
      <groupId>tk.mybatis</groupId>
      <artifactId>mapper</artifactId>
      <version>4.1.5</version>
    </dependency>

将spring-bean.xml的mybatis配置进行修改

原先的配置

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.study.wjm.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

修改后的配置

	<bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.study.wjm.mapper"/>
        <property name="properties">
            <value>
                mappers=tk.mybatis.mapper.common.Mapper
            </value>
        </property>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
    </bean>

通用mapper配置完成，然后配置分页插件

添加依赖

<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>5.1.10</version>
    </dependency>

在mybatis-config中进行配置

    <plugins>
        <!-- 配置分页插件  -->
        <plugin interceptor="com.github.pagehelper.PageInterceptor">
        </plugin>
    </plugins>

分页功能简单的使用

        //开始进行分页，页数和页数大小
        PageHelper.startPage(pageNum,pageSize);

        //构建查询条件
        Example example = new Example(Goods.class);
        Example.Criteria criteria = example.createCriteria();

        criteria.andLike("name","%"+name+"%");

        //进行条件查询
        List<Goods> list = goodsMapper.selectByExample(example);

        //将查询的数据放入Page Info中进行分页
        PageInfo<Goods> p = new PageInfo<>(list);
        //获取list数据
        List<Goods> goodsList = p.getList();
        //获取总数
        long total = p.getTotal();

        HashMap<String, Object> map = new HashMap<>();
        map.put("data", goodsList);
        map.put("total",total);

        redisTemplate.opsForHash().put("goodMap",rHashK,map);
        redisTemplate.expire("goodMap", 12, TimeUnit.HOURS);

        return map;