Mybatisplus条件构造器
//条件构造器
@Test
public void testSelect() {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
/**
* gt: greater than 大于
* lt: less than 小于
* e:equal
*/
//queryWrapper.ge("age",21);
//eq、ne
//queryWrapper.eq("name","Tom");
//between、notBetween
//queryWrapper.between("age",24,28);
//like、notLike、likeLeft、likeRight
//queryWrapper.like("name","张");
//orderBy、orderByDesc、orderByAsc
queryWrapper.orderByDesc("id");
List<User> users = userMapper.selectList(queryWrapper);
System.out.println(users);
}
//条件构造器
@Test
public void testSelect3() {
LambdaQueryWrapper<User> userLambdaQueryWrapper = new LambdaQueryWrapper<>();
userLambdaQueryWrapper.eq(User::getName,"Tom");
User user1 = userMapper.selectOne(userLambdaQueryWrapper);
System.out.println("user1"+user1);
System.out.println("-----------------------------------");
User user2 = userMapper.selectOne(new LambdaQueryWrapper<User>().eq(User::getName, "Tom"));
System.out.println("user2"+user2);
System.out.println("-----------------------------------");
User user3 = userMapper.selectOne(Wrappers.<User>lambdaQuery().eq(User::getName,"Tom"));
System.out.println("user3"+user3);
}
道阻且长,行则将至