1.根據(jù)id刪除
package com.mp.delete;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.mp.dao.UserMapper;
import com.mp.entity.User;
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.SpringRunner;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
* @Description 測試,刪除方法
* @Author LL
* @Date 2020-03-24 22:53
*/
@SpringBootTest
@RunWith(SpringRunner.class)
public class DeleteTest {
@Autowired
private UserMapper userMapper;
/**
* 根據(jù)id刪除
*/
@Test
public void deleteById(){
int rows = userMapper.deleteById(1241614720021913633L);
System.out.println("刪除條數(shù):"+rows);
}
/**
* 根據(jù)多個id刪除
*/
@Test
public void deleteBatchIds(){
List<Long> ids = Arrays.asList(1241614720021913633L,1241614720021913667L);
int rows = userMapper.deleteBatchIds(ids);
System.out.println("刪除條數(shù):"+rows);
}
}
2.其它刪除方法
package com.mp.delete;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.mp.dao.UserMapper;
import com.mp.entity.User;
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.SpringRunner;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
* @Description 測試,刪除方法
* @Author LL
* @Date 2020-03-24 22:53
*/
@SpringBootTest
@RunWith(SpringRunner.class)
public class DeleteTest {
@Autowired
private UserMapper userMapper;
/**
* 根據(jù)map中的參數(shù)作為條件刪除
*/
@Test
public void deleteByMap(){
Map<String, Object> deleteMap = new HashMap<>();
deleteMap.put("name", "張1");
deleteMap.put("age", 33);
int rows = userMapper.deleteByMap(deleteMap);
System.out.println("刪除條數(shù):"+rows);
}
}
3.以條件構造器為參數(shù)的刪除方法
package com.mp.delete;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.mp.dao.UserMapper;
import com.mp.entity.User;
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.SpringRunner;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
* @Description 測試勤众,刪除方法
* @Author LL
* @Date 2020-03-24 22:53
*/
@SpringBootTest
@RunWith(SpringRunner.class)
public class DeleteTest {
@Autowired
private UserMapper userMapper;
/**
* 條件構造器為參數(shù)的刪除方法
*/
@Test
public void deleteWrapper(){
LambdaQueryWrapper<User> lambdaQuery = Wrappers.lambdaQuery();
lambdaQuery.eq(User::getAge, 38).or().gt(User::getAge, 45);
int rows = userMapper.delete(lambdaQuery);
System.out.println("影響行數(shù):"+rows);
}
}