package com.ruoyi.demo.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.ruoyi.common.core.controller.BaseController; import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.demo.domain.TestDemo; import com.ruoyi.demo.service.ITestDemoService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.RequiredArgsConstructor; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.DeleteMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.ArrayList; import java.util.List; /** * æµ‹è¯•æ‰¹é‡æ–¹æ³• * * @author Lion Li * @date 2021-05-30 */ @Api(value = "æµ‹è¯•æ‰¹é‡æ–¹æ³•", tags = {"æµ‹è¯•æ‰¹é‡æ–¹æ³•"}) @RequiredArgsConstructor(onConstructor_ = @Autowired) @RestController @RequestMapping("/demo/batch") public class TestBatchController extends BaseController { private final ITestDemoService iTestDemoService; /** * æ–°å¢žæ‰¹é‡æ–¹æ³• å¯å®Œç¾Žæ›¿ä»£ saveBatch 秒级æ’å…¥ä¸Šä¸‡æ•°æ® (对mysqlè´Ÿè·è¾ƒå¤§) */ @ApiOperation(value = "æ–°å¢žæ‰¹é‡æ–¹æ³•") @PostMapping("/add") // @DataSource(DataSourceType.SLAVE) public AjaxResult<Void> add() { List<TestDemo> list = new ArrayList<>(); for (int i = 0; i < 1000; i++) { list.add(new TestDemo().setOrderNum(-1L).setTestKey("æ‰¹é‡æ–°å¢ž").setValue("测试新增")); } return toAjax(iTestDemoService.saveAll(list) ? 1 : 0); } /** * 新增或更新 å¯å®Œç¾Žæ›¿ä»£ saveOrUpdateBatch 高性能 */ @ApiOperation(value = "æ–°å¢žæˆ–æ›´æ–°æ‰¹é‡æ–¹æ³•") @PostMapping("/addOrUpdate") // @DataSource(DataSourceType.SLAVE) public AjaxResult<Void> addOrUpdate() { List<TestDemo> list = new ArrayList<>(); for (int i = 0; i < 1000; i++) { list.add(new TestDemo().setOrderNum(-1L).setTestKey("æ‰¹é‡æ–°å¢ž").setValue("测试新增")); } iTestDemoService.saveAll(list); for (int i = 0; i < list.size(); i++) { TestDemo testDemo = list.get(i); testDemo.setTestKey("æ‰¹é‡æ–°å¢žæˆ–修改").setValue("æ‰¹é‡æ–°å¢žæˆ–修改"); if (i % 2 == 0) { testDemo.setId(null); } } return toAjax(iTestDemoService.saveOrUpdateAll(list) ? 1 : 0); } /** * åˆ é™¤æ‰¹é‡æ–¹æ³• */ @ApiOperation(value = "åˆ é™¤æ‰¹é‡æ–¹æ³•") @DeleteMapping() // @DataSource(DataSourceType.SLAVE) public AjaxResult<Void> remove() { return toAjax(iTestDemoService.remove(new LambdaQueryWrapper<TestDemo>() .eq(TestDemo::getOrderNum, -1L)) ? 1 : 0); } }