test java

public Forward export(HttpServletRequest request,HttpServletResponse response)
        throws Exception{
        String orgCode = request.getParameter("orgCode");
        String begin = request.getParameter("begin");
        String end = request.getParameter("end");
        Page<Object[]> page = BdtDaoFactory.createLLDao().getJY(orgCode, begin, end, 0, 30);
        int[] widths = new int[]{10*512,14*512,14*512,12*512,7*512,7*512,15*512};
        ExportWriter out = new POIExcelExportWriter(response.getOutputStream(),widths);
        String[] sx = new String[]{"jg","khzh","khmc","zjhm","qyrq","zhzl","msg"};
        String[] mc = new String[]{"开户机构","客户账号","客户中文名","证件号码","签约日期","账户种类"    ,"校验错误信息"};
        ExportDescriptor ed = new ExportDescriptor("校验表", sx,mc);
        ed.setConverters(new ExportConverter[] {
                ConverterFactory.createDefaultConverter,
                ConverterFactory.createDefaultConverter,
                ConverterFactory.createDefaultConverter,
                ConverterFactory.createDefaultConverter,
                ConverterFactory.createDefaultConverter,
                ConverterFactory.createDefaultConverter,
                ConverterFactory.createDefaultConverter
        });
        response.reset(); // 非常重要
        String fileName = URLEncoder.encode(DateUtil.dateToString(new Date(), "yyyyMMddhhmmsss")+".xls", "UTF-8");
        response.setContentType("application/x-msdownload");
        response.setHeader("Content-Disposition", "attachment; filename="
                + fileName);
        new ExportServiceImpl().export(out, page, ed);
        return null;
    }
posted @ 2016-01-07 15:50  上古应龙  阅读(257)  评论(0)    收藏  举报