java将xml文件导入mysql数据库

import org.w3c.dom.*;
import javax.xml.parsers.*;
import java.io.*;
import java.sql.*;

public class XMLToMySQL {
    public static void main(String[] args) {
        String xmlFilePath = "path/to/your/file.xml";
        String jdbcUrl = "jdbc:mysql://localhost:3306/yourdatabase";
        String username = "yourusername";
        String password = "yourpassword";

        try {
            // 解析XML文件
            DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
            DocumentBuilder builder = factory.newDocumentBuilder();
            Document document = builder.parse(new File(xmlFilePath));

            // 连接数据库
            Connection connection = DriverManager.getConnection(jdbcUrl, username, password);
            Statement statement = connection.createStatement();

            // 遍历XML节点并插入数据
            NodeList nodeList = document.getElementsByTagName("yourElement");
            for (int i = 0; i < nodeList.getLength(); i++) {
                Node node = nodeList.item(i);
                if (node.getNodeType() == Node.ELEMENT_NODE) {
                    Element element = (Element) node;
                    String value = element.getTextContent();

                    // 插入数据到数据库
                    String sql = "INSERT INTO yourTable (yourColumn) VALUES ('" + value + "')";
                    statement.executeUpdate(sql);
                }
            }

            // 关闭连接
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}