读取csv文件数据，并使用spring框架将其存储在数据库中

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVParser;
import org.apache.commons.csv.CSVRecord;

import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class CsvToDatabase {
    public static void main(String[] args) {
        // 创建数据库连接
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/mydatabase");
        dataSource.setUsername("root");
        dataSource.setPassword("password");

        // 创建JdbcTemplate对象
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

        // 读取CSV文件数据
        try (FileReader reader = new FileReader("data.csv");
             CSVParser csvParser = new CSVParser(reader, CSVFormat.DEFAULT)) {

            // 遍历CSV文件的每一行数据
            for (CSVRecord csvRecord : csvParser) {
                String column1 = csvRecord.get(0);
                String column2 = csvRecord.get(1);
                // ...

                // 将数据插入数据库
                String sql = "INSERT INTO mytable (column1, column2) VALUES (?, ?)";
                jdbcTemplate.update(sql, column1, column2);
            }
        } catch (IOException | SQLException e) {
            e.printStackTrace();
        }
    }
}