解析XML并通过SQL查询生成新行

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

public class XMLParser {
    public static void main(String[] args) {
        try {
            // 解析XML文件
            DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
            DocumentBuilder builder = factory.newDocumentBuilder();
            Document document = builder.parse("data.xml");

            // 连接到数据库
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
            Statement statement = connection.createStatement();

            // 遍历解析后的XML数据
            NodeList nodeList = document.getElementsByTagName("item");
            for (int i = 0; i < nodeList.getLength(); i++) {
                Element element = (Element) nodeList.item(i);
                String name = element.getElementsByTagName("name").item(0).getTextContent();
                int quantity = Integer.parseInt(element.getElementsByTagName("quantity").item(0).getTextContent());

                // 使用SQL插入语句将数据插入到数据库中
                String sql = "INSERT INTO products (name, quantity) VALUES ('" + name + "', " + quantity + ")";
                statement.executeUpdate(sql);
            }

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

<items>
    <item>
        <name>Product 1</name>
        <quantity>10</quantity>
    </item>
    <item>
        <name>Product 2</name>
        <quantity>5</quantity>
    </item>
</items>