在JAVA中读取XML文件并建立数据库

import org.jdom2.Document;
import org.jdom2.Element;
import org.jdom2.input.SAXBuilder;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class XMLToDatabase {
    public static void main(String[] args) {
        String xmlFilePath = "path/to/xml/file.xml";
        String dbUrl = "jdbc:mysql://localhost:3306/database";
        String dbUser = "username";
        String dbPassword = "password";

        try {
            // 创建XML解析器
            SAXBuilder builder = new SAXBuilder();
            // 解析XML文件
            Document document = builder.build(xmlFilePath);
            // 获取XML根元素
            Element rootElement = document.getRootElement();

            // 建立数据库连接
            Connection connection = DriverManager.getConnection(dbUrl, dbUser, dbPassword);

            // 创建数据库表
            String createTableQuery = "CREATE TABLE IF NOT EXISTS table_name (column1 datatype, column2 datatype, ...)";
            PreparedStatement createTableStatement = connection.prepareStatement(createTableQuery);
            createTableStatement.executeUpdate();

            // 将数据插入数据库
            String insertQuery = "INSERT INTO table_name (column1, column2, ...) VALUES (?, ?, ...)";
            PreparedStatement insertStatement = connection.prepareStatement(insertQuery);

            // 遍历XML元素，提取数据并插入数据库
            // 这里假设XML的元素结构为：<item><column1>value1</column1><column2>value2</column2>...</item>
            for (Element item : rootElement.getChildren("item")) {
                insertStatement.setString(1, item.getChildText("column1"));
                insertStatement.setString(2, item.getChildText("column2"));
                // ...
                insertStatement.executeUpdate();
            }

            // 关闭数据库连接
            insertStatement.close();
            createTableStatement.close();
            connection.close();

            System.out.println("XML data imported to database successfully!");

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}