1. insert(T):int

  1. @Test
  2. public void insert(){
  3. User user = new User();
  4. user.setId(new Long(9));
  5. user.setName("haibaraguo");
  6. user.setAge(21);
  7. user.setEmail("1156544355@qq.com");
  8. userMapper.insert(user);
  9. System.out.println(userMapper.selectById(9).toString());
  10. }

image.png

2. deleteById(Serialzable):int

  1. @Test
  2. public void deleteById(){
  3. userMapper.deleteById(9);
  4. System.out.println(userMapper.selectById(9));
  5. }

image.png

3. deleteByMap(Map):int

  1. @Test
  2. public void deleteByMap(){
  3. Map<String, Object> columnMap = new HashMap<String, Object>();
  4. columnMap.put("name", "我日你哥");
  5. int result=userMapper.deleteByMap(columnMap);
  6. System.out.println("*******************\n"+result);
  7. }

image.png
image.png

4. delete(Wrapper):int

  1. @Test
  2. public void delete(){
  3. int result = userMapper.delete(new QueryWrapper<User>().eq("id",7));
  4. System.out.println("*******************\n"+result);
  5. }

image.png

5. deleteBatchIds(Collection<? extends Serializable>):int

  1. @Test
  2. public void deleteBatchIds(){
  3. List<Long> ids = new ArrayList<>();
  4. ids.add(new Long(4));
  5. ids.add(new Long(5));
  6. int result = userMapper.deleteBatchIds(ids);
  7. System.out.println("*******************\n"+result);
  8. }

image.png
image.png

6. updateById(T):int

  1. @Test
  2. public void updateById(){
  3. User user = userMapper.selectById(3);
  4. user.setName("我爱你");
  5. int result = userMapper.updateById(user);
  6. System.out.println("*******************\n"+result);
  7. }

image.png
image.png

7. update(T,Wrapper):int

  1. @Test
  2. public void update(){
  3. int result = userMapper.update(null,new UpdateWrapper<User>().set("name","我爱你").set("age",38).le("age",20));
  4. System.out.println("*******************\n"+result);
  5. }

image.png
image.png

8.selectById(Serializable):T

  1. @Test
  2. public void selectById(){
  3. User user = userMapper.selectById(2);
  4. System.out.println("*******************\n"+user.toString());
  5. }

image.png

9. selectBatchIds(Collection<? extends Serializable>):List

  1. @Test
  2. public void selectBatchIds(){
  3. List<Long> ids = new ArrayList<>();
  4. ids.add(new Long(1));
  5. ids.add(new Long(2));
  6. List<User> users = userMapper.selectBatchIds(ids);
  7. users.forEach(System.out::println);
  8. }

image.png

10. selectByMap(Map):List

  1. @Test
  2. public void selectByMap(){
  3. Map<String,Object> map = new HashMap<>();
  4. map.put("name","我爱你");
  5. List<User> users = userMapper.selectByMap(map);
  6. users.forEach(System.out::println);
  7. }

image.png

11