1. 操作demo
@RunWith(SpringRunner.class)
@SpringBootTest
@Slf4j
public class UserMapperTest {
@Resource
private UserMapper dao;
@Test
public void testInsert(){
User user = new User();
user.setName("李晓明");
user.setPassword("1234134");
user.setPhone("13770845467");
user.setSex(1);
user.setCreateTime(LocalDateTime.now());
user.setUpdateTime(LocalDateTime.now());
dao.insert(user);
}
@Test
public void testSelect(){
User user = dao.selectById(1);
log.info(user.toString());
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("name", "张三丰");
User user01 = dao.selectOne(queryWrapper);
log.info(user01.toString());
List<User> list01 = dao.selectList(null);
List<String> ids = new ArrayList<String>();
ids.add("1");
ids.add("2");
List<User> list02 = dao.selectBatchIds(ids);
HashMap<String, Object> map = new HashMap<>(16);
map.put("email", "6786756755@qq.com");
map.put("sex", "1");
List<User> list = dao.selectByMap(map);
log.info("return selectByMap value = " + list);
QueryWrapper<User> queryWrapper01 = new QueryWrapper<>();
queryWrapper01.eq("name","张三丰");
queryWrapper01.like("introduction","%故事%");
queryWrapper01.orderByAsc("create_time");
int count = dao.selectCount(queryWrapper01);
log.info("result count = " + count);
queryWrapper01.select("id","name","phone","sex","create_time");
List<User> users = dao.selectList(queryWrapper01);
for (User u : users) {
log.info(u.toString());
}
Page<User> page = new Page<>(1, 5);
QueryWrapper<User> queryWrapper02 = new QueryWrapper<>();
IPage<User> userIPage = dao.selectPage(page, queryWrapper02);
log.info(userIPage.toString());
}
@Test
public void testUpdate(){
User user = dao.selectById(1);
user.setUpdateTime(LocalDateTime.now());
dao.updateById(user);
User user01 = new User();
user01.setStatus("1");
user01.setName("李维斯");
UpdateWrapper<User> updateWrapper = new UpdateWrapper<>();
updateWrapper.eq("name", "王菲菲");
int update = dao.update(user01, updateWrapper);
}
@Test
public void testDelete(){
int result = dao.deleteById(4);
List<String> ids = new ArrayList<String>();
ids.add("1");
ids.add("2");
QueryWrapper<User> userQueryWrapper = new QueryWrapper<>();
userQueryWrapper
.isNull("name")
.ge("status","1")
.in("id",ids)
.isNotNull("email");
int delete = dao.delete(userQueryWrapper);
log.info("delete return count = " + delete);
}
}
2. 参考使用文档