将ResultSet结果集中的数据导入到Excel表

Java代码
public static boolean DB2Excel(ResultSet rs, String fileName) {
            boolean flag = false;
            WritableWorkbook workBook = null;
            WritableSheet sheet = null;
            Label label = null;

            try {
                // 创建Excel表
                String path = AutoStatisticUser.class.getResource("").getPath()
                        + fileName;
                workBook = Workbook.createWorkbook(new File(path));
                // 创建Excel表中的sheet
                sheet = workBook.createSheet("First Sheet", 0);
                // 向Excel中添加数据
                ResultSetMetaData rsmd = rs.getMetaData();
                int columnCount = rsmd.getColumnCount();
                String columnName = null;
                int row = 0;
                // 添加标题
                for (int i = 0; i < columnCount; i++) {
                    columnName = rsmd.getColumnName(i + 1);
                    label = new Label(i, row, columnName);
                    System.out.println("标题：" + i + "---" + row + "---"
                            + columnName);
                    sheet.addCell(label);
                }
                row++;
                System.out.println("写入标题成功");
                while (rs.next()) {
                    for (int i = 0; i < columnCount; i++) {
                        label = new Label(i, row, rs.getString(i + 1));
                        System.out.println("标题：" + i + "---" + row + "---"
                                + rs.getString(i + 1));
                        sheet.addCell(label);
                    }
                    row++;
                }
                System.out.println("写入内容成功");
                // 关闭文件
                workBook.write();
                System.out.println("数据成功写入Excel");
                flag = true;
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                try {
                    workBook.close();
                } catch (Exception e2) {
                    e2.printStackTrace();
                }
            }
            return flag;
        }

补充：软件开发 , Java ,