批量导出Excel并压缩为ZIP文件的Java代码示例

public void exportMatch(String type, int year, OutputStream out)
            throws IOException {
        List<SportAgeGroup> deleteAgeGroups = new ArrayList<SportAgeGroup>();
        List<SportAgeGroup> ageGroups = sportAgeGroupDao.findAll();
        Map<Long, List<SportEventRound>> ageGroupRounds = getAgeGroupRounds(
                type, year, ageGroups);
        ZipOutputStream zip = new ZipOutputStream(out);
        DataOutputStream data = new DataOutputStream(zip);
        try {
            for (SportAgeGroup ageGroup : ageGroups) {
                FileOutputStream f = new FileOutputStream("c:/"
                        + ageGroup.getName() + ".xls");
                String filename = ageGroup.getName() + ".xls";
                List<SportEventRound> eventRounds = ageGroupRounds.get(ageGroup
                        .getId());
                if (eventRounds.size() > 0) {
                    deleteAgeGroups.add(ageGroup);
                    HSSFWorkbook workBook = new HSSFWorkbook();
                    workBook = exportMatchTest(workBook, f, eventRounds, type,
                            year);
                    ZipEntry entry = new ZipEntry(filename);
                    zip.putNextEntry(entry);
                    zip.setEncoding("GBK");
                    FileInputStream inputStream = new FileInputStream("c:/"
                            + ageGroup.getName() + ".xls");
                    byte[] buf = new byte[1024];
                    while (inputStream.read(buf) > 0) {
                        data.write(buf);
                    }
                    zip.closeEntry();