文章目录
1. 实战删除
package com.gblfy.springboot.mybatisplus.mapper;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;
import com.gblfy.springboot.mybatisplus.entity.User;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import java.util.Arrays;
import java.util.HashMap;
import java.util.Map;
@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest
@Slf4j
public class UserDelTest {
@Autowired
private UserMapper userMapper;
/**
* 根据 ID 删除
*/
@Test
public void delById() {
int rows = userMapper.deleteById(1094592041087729666L);
log.info("删除条数: {}", rows);
}
/**
* 根据 columnMap 条件，删除记录
*/
@Test
public void delByMap() {
Map<String, Object> columnMap = new HashMap<>();
columnMap.put("name", "向后");
columnMap.put("age", 25);
int rows = userMapper.deleteByMap(columnMap);
log.info("删除条数: {}", rows);
}
/**
* 删除（根据ID 批量删除）
* <p>
* 主键ID列表(不能为 null 以及 empty)
*/
@Test
public void deleteBatchIds() {
int rows = userMapper.deleteBatchIds(Arrays.asList(109459204108772966L, 1088250446457389058L, 1088250446457389059L));
log.info("删除条数: {}", rows);
}
@Test
public void deleteByWrapper() {
LambdaQueryWrapper<User> lambdaQuery = Wrappers.<User>lambdaQuery();
lambdaQuery.eq(User::getAge, 27)
.gt(User::getAge, 41);
int rows = userMapper.delete(lambdaQuery);
log.info("删除条数: {}", rows);
}
}
