文章目录

通用mapper和分页插件

通用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;