1: 原符号:<,<=,>,>=,<>
对应函数 lt(),le(),gt(),ge(),ne()
Mybatis-plus写法: queryWrapper.ge("create_time", localDateTime);
Mybatis写法: where create_time >= #{localDateTime}
2:mybatis-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);
}