使用JDBC模板处理100K插入和更新

import org.springframework.jdbc.core.BatchPreparedStatementSetter;
import org.springframework.jdbc.core.JdbcTemplate;

public class DatabaseHandler {
    private JdbcTemplate jdbcTemplate;

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public void insertAndUpdateData(final List<Data> dataList) {
        String insertSql = "INSERT INTO table_name (column1, column2) VALUES (?, ?)";
        String updateSql = "UPDATE table_name SET column1 = ? WHERE column2 = ?";

        jdbcTemplate.batchUpdate(insertSql, new BatchPreparedStatementSetter() {
            @Override
            public void setValues(PreparedStatement ps, int i) throws SQLException {
                Data data = dataList.get(i);
                ps.setString(1, data.getColumn1());
                ps.setString(2, data.getColumn2());
            }

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

        jdbcTemplate.batchUpdate(updateSql, new BatchPreparedStatementSetter() {
            @Override
            public void setValues(PreparedStatement ps, int i) throws SQLException {
                Data data = dataList.get(i);
                ps.setString(1, data.getUpdatedColumn1());
                ps.setString(2, data.getColumn2());
            }

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