返回查询总记录数
java1234_小锋 人气:0mybatis-plus返回查询总记录数
mp框架提供了selectCount方法,来查询总记录数;
需求:
查找薪水大于3500 名字里有“小”的 员工的个数
sql实现:
select count(*) from t_employee where salary>3500 and name like ‘%小%'
代码实现:
@Test public void selectCountByQueryWrapper11(){ QueryWrapper<Employee> queryWrapper=new QueryWrapper(); // QueryWrapper<Employee> queryWrapper2=Wrappers.<Employee>query(); queryWrapper.gt("salary",3500).like("name","小"); Integer count = employeeMapper.selectCount(queryWrapper); System.out.println(count); }
mybatis-plus分页查询,总条数为零的解决
package com.integration.config; import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor; import org.mybatis.spring.annotation.MapperScan; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; @Configuration @MapperScan("com.integration.mapper") public class MybatisPlusConfig { @Bean public PaginationInterceptor paginationInterceptor() { PaginationInterceptor page = new PaginationInterceptor(); return page; } }
以上为个人经验,希望能给大家一个参考,也希望大家多多支持。
加载全部内容