xml文件导入mysql

import javax.xml.bind.JAXBContext;
import javax.xml.bind.JAXBException;
import javax.xml.bind.Unmarshaller;
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class XMLToMySQL {
    public static void main(String[] args) {
        try {
            // 解析XML文件
            JAXBContext jaxbContext = JAXBContext.newInstance(YourXMLClass.class);
            Unmarshaller unmarshaller = jaxbContext.createUnmarshaller();
            YourXMLClass xmlData = (YourXMLClass) unmarshaller.unmarshal(new File("path/to/your/file.xml"));

            // 连接MySQL数据库
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdb", "username", "password");

            // 插入数据
            String sql = "INSERT INTO your_table (column1, column2) VALUES (?, ?)";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1, xmlData.getColumn1());
            preparedStatement.setString(2, xmlData.getColumn2());
            preparedStatement.executeUpdate();

            // 关闭连接
            preparedStatement.close();
            connection.close();
        } catch (JAXBException | SQLException e) {
            e.printStackTrace();
        }
    }
}

String sql = "INSERT INTO your_table (column1, column2) VALUES (?, ?)";
PreparedStatement preparedStatement = connection.prepareStatement(sql);

for (YourXMLClass data : xmlDataList) {
    preparedStatement.setString(1, data.getColumn1());
    preparedStatement.setString(2, data.getColumn2());
    preparedStatement.addBatch();
}

preparedStatement.executeBatch();