批量插入模板记录

package com.alphasta.xtjg.service.impl;

import com.alphasta.model.AlphaTable;
import com.alphasta.model.BaseQuery;
import com.alphasta.product.base.service.AlphaService;
import com.alphasta.utils.SetHaspMap;
import com.alphasta.xtjg.model.XtjgCluesVehicleAnnualAudit;
import com.alphasta.xtjg.model.enums.OrganEnum;
import com.alphasta.xtjg.model.enums.OrganLabelEnum;
import com.alphasta.xtjg.service.IXtjgCluesIllegalCheckService;
import com.alphasta.xtjg.util.UUIDKey;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BatchPreparedStatementSetter;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Service
@Transactional
public class XtjgCluesIllegalCheckServiceImpl extends AlphaService implements IXtjgCluesIllegalCheckService {

@Autowired
private JdbcTemplate jdbcTemplate;

/**
 * 定时任务新增
 *
 * @return java.lang.String
 * @Date 2024/2/7 10:29
 * @author Kevin
 */
@Override
@Transactional
public void addCarViolation() {
    String sql = " 这里写新增的数据，也可以是前端传输的数据";
    List<Map<String, Object>> list = findBySql(sql);

    //匹配更改需要插入的数据，这个不需要（我的业务）


    //存储（）
    String addSql = "INSERT INTO 表名 (ID,\n" +
            "字段名,\n" +
            "字段名,\n" +
            "字段名,\n" +
            "字段名,\n" +
            "字段名,\n" +
            "字段名,\n" +
            "字段名,\n" +
            "字段名,\n" +
            "字段名,\n" +
            "字段名) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    int[] result = jdbcTemplate.batchUpdate(addSql, new BatchPreparedStatementSetter() {
        @Override
        public void setValues(PreparedStatement ps, int i) throws SQLException {
            Map<String, Object> map = list.get(i);
            ps.setString(1, new UUIDKey().getKey());
            ps.setString(2, SetHaspMap.setString(map.get("key值")));
            ps.setString(3, SetHaspMap.setString(map.get("key值")));
            ps.setString(4, SetHaspMap.setString(map.get("key值")));
            ps.setString(5, SetHaspMap.setString(map.get("key值")));
            ps.setString(6, SetHaspMap.setString(map.get("key值")));
            ps.setString(7, SetHaspMap.setString(map.get("key值")));
            ps.setString(8, SetHaspMap.setString(map.get("key值")));
            ps.setString(9, new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()));
            ps.setString(10, "0");
            ps.setString(11, SetHaspMap.setString(map.get("key值")));
        }

        @Override
        public int getBatchSize() {
            return list.size();
        }
    });
}

}