selectCount方法,查询记录数
例子:
- 需求:查找薪水大于3500 名字里有“小”的 员工的个数
- sql实现:select count(*) from t_employee where salary>3500 and name like ‘%小%’
代码:
public void selectCountByQueryWrapper11(){
QueryWrapper<Employee> queryWrapper=new QueryWrapper();
queryWrapper.gt("salary",3500).like("name","小");
Integer count = employeeMapper.selectCount(queryWrapper);
System.out.println(count);
}
其中,queryWrapper常用方法总结: