@Test
void testQueryWrapper(){
//select id, username, balance from user where username like ? and balance >= ?
QueryWrapper<User> queryWrapper = new QueryWrapper<User>();
queryWrapper.select("id","username","info","balance")
.like("username","o")
.ge("balance",1000);
List<User> users = userMapper.selectList(queryWrapper);
System.out.println(users);
}
@Test
void testByQueryWrapper(){
User user = new User();
user.setBalance(2000);
QueryWrapper<User> userQueryWrapper = new QueryWrapper<>();
userQueryWrapper.eq("username","Jack");
userMapper.update(user,userQueryWrapper);
}
@Test
void testUpdateWrapper(){
ArrayList<Long> userIds = new ArrayList<>();
userIds.add(1L);
userIds.add(2L);
userIds.add(4L);
UpdateWrapper<User> updateWrapper = new UpdateWrapper<User>();
updateWrapper.setSql("balance = balance - 200");
updateWrapper.in("id",userIds);
userMapper.update(null, updateWrapper);
}
mybatisplus
于 2024-03-05 00:40:30 首次发布