批量新增采用预编译的jdbcTemplate .batchUpdate插入分析

@RestController
@Slf4j
public class SyncController implements ISyncController {
    @Resource
    PortfolioPositionMapper portfolioPositionMapper;
    @Resource
    JdbcTemplate jdbcTemplate;


    @Override
    public TResponse<Object> valuationDataSync(ValuationDataSyncREQVO req) {
        jdbcTemplate.execute("delete from RMS_PORTFOLIOPOSITION where fadate = 20211220");
        List<RmsPortfolioPosition> list = new ArrayList<>();
        int j = req.getDate();
        List<Long> seqIdList = SequenceManager.getBatchSequenceNum(SequenceConstant.RMS_PORTFOLIO_POSITION, false, j);
        Long version = SequenceManager.getSingleSequenceNum(SequenceConstant.RMS_PORTFOLIO_POSITION_VERSION, false);
        RmsPortfolioPosition position;
        String Time = DateUtils.getCurrentDateTime();
        log.info("正常插入开始时间：{}", DateUtils.getCurrentDateTime());
        for (int i = 0; i < s