将存储过程中的多个结果集生成到Excel中不同选项卡的最佳方法/实践

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileOutputStream;
import java.sql.*;

public class ExcelExport {
    public static void main(String[] args) {
        String jdbcUrl = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        try (Connection connection = DriverManager.getConnection(jdbcUrl, username, password)) {
            String sql = "{call my_stored_procedure()}";
            CallableStatement statement = connection.prepareCall(sql);
            boolean hasResults = statement.execute();

            try (Workbook workbook = new XSSFWorkbook()) {
                int sheetIndex = 0;

                do {
                    if (hasResults) {
                        ResultSet resultSet = statement.getResultSet();
                        String sheetName = "Sheet" + sheetIndex;
                        Sheet sheet = workbook.createSheet(sheetName);
                        writeResultSetToSheet(resultSet, sheet);
                        resultSet.close();
                        sheetIndex++;
                    }

                    hasResults = statement.getMoreResults();
                } while (hasResults);

                String outputFile = "output.xlsx";
                try (FileOutputStream fileOutputStream = new FileOutputStream(outputFile)) {
                    workbook.write(fileOutputStream);
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private static void writeResultSetToSheet(ResultSet resultSet, Sheet sheet) throws SQLException {
        ResultSetMetaData metaData = resultSet.getMetaData();
        int columnCount = metaData.getColumnCount();

        Row headerRow = sheet.createRow(0);
        for (int i = 1; i <= columnCount; i++) {
            Cell cell = headerRow.createCell(i - 1);
            cell.setCellValue(metaData.getColumnName(i));
        }

        int rowIndex = 1;
        while (resultSet.next()) {
            Row dataRow = sheet.createRow(rowIndex);
            for (int i = 1; i <= columnCount; i++) {
                Cell cell = dataRow.createCell(i - 1);
                cell.setCellValue(resultSet.getString(i));
            }
            rowIndex++;
        }
    }
}