常用的Mybatis-Plus方法,让你的数据库增删改查(CRUD)一键实现
以下方法全部亲测可用
@Test
public void testSelectAll(){
List<User> users = userMapper.selectList(null);
users.forEach(System.out::println);
}
@Test
public void testInsert(){
User user = new User();
user.setName("***");
user.setAge(21);
user.setEmail("222@qq.com");
int result = userMapper.insert(user);
System.out.println(result);
System.out.println(user);
}
@Test public void testUpdate(){
User user = new User();
user.setId(1423176922753409025L);
user.setName("DZY");
user.setAge(18);
int i = userMapper.updateById(user);
System.out.println(i);
}
@Test
public void testOptimisticLocker(){
User user = userMapper.selectById(1423176922753409025L);
user.setName("测试乐观锁");
user.setEmail("22222@qq.com");
userMapper.updateById(user);
}
@Test
public void testOptimisticLocker2(){
User user = userMapper.selectById(1423176922753409025L);
user.setName("测试乐观锁1");
user.setEmail("222@qq.com");
User user2 = userMapper.selectById(1423176922753409025L);
user2.setName("测试乐观锁2");
user2.setEmail("222@qq.com");
userMapper.updateById(user2);
userMapper.updateById(user);
}
@Test
public void testSelectById() {
User user = userMapper.selectById(1L);
System.out.println(user);
}
@Test
public void testSelectByBatchId(){
List<User> users = userMapper.selectBatchIds(Arrays.asList(1L, 2L, 3L));
users.forEach(System.out::println);
}
@Test
public void testSelectByBatchIds(){
HashMap<String, Object> map = new HashMap<>();
map.put("name","Tom");
map.put("age",28);
List<User> users = userMapper.selectByMap(map);
users.forEach(System.out::println);
}
@Test
public void testPage(){
Page<User> page = new Page<>(2,5);
userMapper.selectPage(page,null);
page.getRecords().forEach(System.out::println);
System.out.println(page.getTotal());
}
@Test
public void testDeleteById(){
userMapper.deleteById(1L);
}
@Test
public void testDeleteBatchId(){
userMapper.deleteBatchIds(Arrays.asList(2L,3L));
}
@Test
public void testDeleteMap(){
HashMap<String, Object> map = new HashMap<>();
map.put("id",1423176922753409025L);
userMapper.deleteByMap(map);
}