前端页面下载服务端DB数据以EXCEL格式下载到本土

前端页面下载服务端DB数据以EXCEL格式下载到本地
简单描述过程：访问jsp页面，调用后台url(.do);调用相应*.java,再调用DB，返回数据；最终下载到本地，存为.xls（EXCEL）文件。

一、JSP页面

二、java代码（*.java）    先配一个.do和testDownLoad.java文件的映射
    &lt;!--下载信息--&gt;
   ......//此为调用DB获取数据代码，省略String fileName = ""+System.currentTimeMillis()+".xls";//定义文件名称//设置responseresponse.setContentType("application/vnd.ms-excel");//设置文件格式response.setHeader("Content-Disposition","attachment;filename="+fileName);OutputStream os = response.getOutputStream();List&lt;HomePageInfosDTO&gt; retList = (List&lt;HomePageInfosDTO&gt;)retMap.get("APP_INFO");//DB返回的数据     WritableWorkbook wwb=null;WritableSheet ws=null;        try {            wwb = Workbook.createWorkbook(os);            ws=wwb.createSheet("sheet_01",0);            ws.getSettings().setDefaultColumnWidth(15);            //创建表头            logger.info("开始创建表头~~~~~~~~~~");            WritableFont wfc = new WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD,false,UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLACK);            WritableCellFormat wcfFC = new WritableCellFormat(wfc);            wcfFC.setBackground(jxl.format.Colour.GREY_25_PERCENT);//设置表头背景颜色            Label appIDHeadLabel = new Label(0,0,"应用名称",wcfFC);            Label AppConsoleHeadLabel = new Label(1,0,"应用平台",wcfFC);            Label appNameHeadLabel = new Label(2,0,"最新版本",wcfFC);            Label cerNameHeadLabel = new Label(3,0,"应用状态",wcfFC);            Label cerPswHeadLabel = new Label(4,0,"今日新增用户",wcfFC);            Label summaryUserHeadLabel = new Label(5,0,"累计用户",wcfFC);            ws.setColumnView(0, 30);            ws.addCell(appIDHeadLabel);            ws.addCell(AppConsoleHeadLabel);            ws.addCell(appNameHeadLabel);            ws.addCell(cerNameHeadLabel);            ws.addCell(cerPswHeadLabel);            ws.addCell(summaryUserHeadLabel);            logger.info("创建表头完成~~~~~~~~~~");            Label appIdLabel = null;            Label appConsoleLabel = null;            Label appNameLabel = null;            Label cerNameLabel = null;            Label cerPswLabel = null;            Label summaryUserLabel = null;            logger.info("开始写表体~~~~~~~~~~");            for(int i=1;i&lt;retList.size();i++) {            HomePageInfosDTO dto = (HomePageInfosDTO)retList.get(i);                String appId = dto.getAppName(); //应用名称                String appConsole = dto.getAppConsole(); //应用平台                String appName = dto.getNewestVersion();//最新版本                String cerName = dto.getAppState();//应用状态                String cerPsw = dto.getTodayNewUser();//今日新增用户                String summaryUser = dto.getTotalUser();    //累计用户                appIdLabel = new Label(0,i,appId);                appConsoleLabel = new Label(1,i,appConsole);                appNameLabel = new Label(2,i,appName);                cerNameLabel = new Label(3,i,cerName);                cerPswLabel = new Label(4,i,cerPsw);                summaryUserLabel = new Label(5,i,summaryUser);                ws.addCell(appIdLabel);                ws.addCell(appConsoleLabel);                ws.addCell(appNameLabel);                ws.addCell(cerNameLabel);                ws.addCell(cerPswLabel);                ws.addCell(summaryUserLabel);            }            logger.info("表体写入完成~~~~~~~~~~");        } catch (Exception e) {            logger.error("输出Excel失败:"+e.getMessage(),e);        } finally {            try {                wwb.write();                wwb.close();            } catch (WriteException e) {            logger.error("关闭WritableWorkbook出错:"+e.getMessage(),e);            } catch (IOException e) {            logger.error("关闭WritableWorkbook出错:"+e.getMessage(),e);            }        }        logger.info("下载成功~~~~~");
前端页面下载服务端DB数据以EXCEL格式

热点推荐
