java dbf导入mysql

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import com.linuxense.javadbf.DBFReader;

public class DBFToMySQL {
    public static void main(String[] args) {
        String dbfFilePath = "path/to/dbf/file.dbf";
        String jdbcUrl = "jdbc:mysql://localhost:3306/database_name";
        String username = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(jdbcUrl, username, password)) {
            DBFReader reader = new DBFReader(new File(dbfFilePath));
            String tableName = "table_name";
            String sql = "INSERT INTO " + tableName + " (column1, column2, column3) VALUES (?, ?, ?)";

            try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
                Object[] row;
                while ((row = reader.nextRecord()) != null) {
                    pstmt.setString(1, (String) row[0]);
                    pstmt.setInt(2, (Integer) row[1]);
                    pstmt.setDate(3, new java.sql.Date(((java.util.Date) row[2]).getTime()));
                    pstmt.executeUpdate();
                }
            }
        } catch (SQLException | java.io.IOException e) {
            e.printStackTrace();
        }
    }
}