mybatisplus批量添加的方法
时间: 2024-01-20 14:16:57 浏览: 24
以下是三种MyBatisPlus批量插入的解决方案:
1. 方案一:使用原生方法saveBatch()
```java
@Slf4j
@Service
public class FlowMeterService extends BasicService<FlowMeterMapper, FlowMeter> {
@Resource
private FlowMeterMapper flowMeterMapper;
public boolean batchSave(ArrayList<FlowMeter> arrayList){
return saveBatch(arrayList);
}
}
```
2. 方案二:基于MyBatisPlus自定义SQL语句(支持一千条以上,需要配置XML文件)
```java
@Slf4j
@Service
public class FlowMeterService extends BasicService<FlowMeterMapper, FlowMeter> {
@Resource
private FlowMeterMapper flowMeterMapper;
public boolean batchSave(ArrayList<FlowMeter> arrayList){
// 自定义SQL语句,例如:
// flowMeterMapper.batchSave(arrayList);
return true;
}
}
```
3. 方案三:基于MyBatisPlus的批量插入(性能最优,但需要配置)
```java
@Slf4j
@Service
public class FlowMeterService extends BasicService<FlowMeterMapper, FlowMeter> {
@Resource
private FlowMeterMapper flowMeterMapper;
public boolean batchSave(ArrayList<FlowMeter> arrayList){
// 使用MyBatisPlus的批量插入方法,例如:
// saveBatch(arrayList);
return true;
}
}
```