`
dwjun236
  • 浏览: 21961 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
文章分类
社区版块
存档分类
最新评论

导出文件

 
阅读更多
int pageSize = 20000;
                // 整数除
                int totalPage = total / pageSize;

                // 余数
                int surplus = total % pageSize;
                if (surplus > 0) {
                    ++totalPage;
                }
//创建文件
                ExportUtil.createFile(exportFilename);
                FileOutputStream fos = null;
                BufferedOutputStream bos = null;
                StringBuffer sb = new StringBuffer("");
//添加头标题
                ExportUtil.addTitle(sb);
                String filename = ExportUtil.getExportPath() + exportFilename;
                try {
                    fos = new FileOutputStream(filename);
                    bos = new BufferedOutputStream(fos);
                    for (int i = 1; i <= totalPage; i++) {
                        QueryResult<OmsAlarm> result =
                            historyService.queryHistoricalAlarm(cond,
                                    pageSize,
                                    i);
                        List<OmsAlarm> list = result.getObjectList();
                        ExportUtil.addToStringBuffer(list, sb);
                        IOUtils.write(sb, bos, ENCODING);
                        sb.delete(0, sb.length());
                        list.clear();
                        curAlarmList.clear();
                    }
                } catch (IOException e) {
                    LOGGER.error("export faild", e);
                } finally {
                    IOUtils.closeQuietly(bos);
                    IOUtils.closeQuietly(fos);
                }
                ExportUtil.downFile(export, exportFilename, filename);
                long endExport = System.currentTimeMillis();
                long timeExport = endExport - start;
                LOGGER.debug("history  export total time:" + timeExport);
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics