将数据库中的数据导出成excel表格形式

[dgn19841028]

如何将数据库中的表导出成excel并保存？
用代码实现，谢谢了

[dgn19841028]

我看了下好多用poi的，弄了个例子还没搞出来。郁闷

[whetu]

在action里执行下面这个方法的效果，就是在页面上弹出一个下载窗口，

    //导出用户信息
    private void exportPriceFundTaxPayers(Collection col, HttpServletResponse response) throws Exception {
        String currentDate = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
        String fileName = "%E4%BA%BA" + currentDate + ".xls";
        response.setHeader("Content-disposition", "attachment;filename=" + fileName);
        response.setContentType("application/vnd.ms-excel;charset=GBK");
        WritableWorkbook book = Workbook.createWorkbook(response.getOutputStream());
        WritableSheet sheet = book.createSheet("sheet1", 0);
        WritableCellFormat wcf = new WritableCellFormat();
        wcf.setBorder(Border.ALL, BorderLineStyle.THIN);
        int counter = 0;
        int idx_sheet = 1;
        if (col != null && col.size() > 0) {
            for (Iterator it = col.iterator(); it.hasNext(); counter++) {
                if (counter == 10000) {
                    sheet = book.createSheet("sheet" + (idx_sheet + 1), idx_sheet);
                    idx_sheet++;
                    counter = 0;
                }
                User user = (User) it.next();
                sheet.addCell(new Label(0, counter, user.getName(), wcf));
                sheet.addCell(new Label(1, counter, user.getAge(), wcf));
                sheet.addCell(new Label(2, counter, user.getSex(), wcf));
            }
            book.write();
            book.close();
        } else {
            sheet.addCell(new Label(2, 3, "没有找到用户信息！", wcf));
            book.write();
            book.close();
        }
    }

网上有不少类似的例子，具体的你可以搜索一下。上面代码可以参考jxl.jar的API

[palm_civet]

用csv来保存就可以了，excel可以读出来的

网上有很多类，直接使用即可

http://www.google.com/search?hl=en&newwindow=1&q=java+csv&btnG=Search

[riseman]

简单的就用JXL吧,就二三十行代码