java 导入csv到mysql

import java.io.BufferedReader;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class CSVToMySQL {
    public static void main(String[] args) {
        String csvFile = "path/to/your/file.csv";
        String jdbcUrl = "jdbc:mysql://localhost:3306/your_database";
        String username = "your_username";
        String password = "your_password";
        String tableName = "your_table";

        try (BufferedReader br = new BufferedReader(new FileReader(csvFile));
             Connection conn = DriverManager.getConnection(jdbcUrl, username, password)) {

            String line;
            while ((line = br.readLine()) != null) {
                String[] data = line.split(",");
                String sql = "INSERT INTO " + tableName + " (column1, column2, column3) VALUES (?, ?, ?)";
                try (PreparedStatement ps = conn.prepareStatement(sql)) {
                    ps.setString(1, data[0]);
                    ps.setString(2, data[1]);
                    ps.setString(3, data[2]);
                    ps.executeUpdate();
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}