jasper 生成 csv文件

ttp://www.w3.org/TR/html4/loose.dtd">http://www.w3.org/TR/html4/loose.dtd">



CSVTest








  final String DATABASE_URL ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DataOperationPlatform";
  final String DATABASE_USER ="sa";
  final String DATABASE_PASSWORD ="";
  Connection conn=null;
  Statement stmt=null;
  ResultSet rs=null;
  String fileName="";
        JasperPrint jasperPrint=null;
 try
 {
  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

 }catch(ClassNotFoundException e)
 {
  out.println(e.getMessage());
 }
 try
 {
    
        conn=DriverManager.getConnection(DATABASE_URL,DATABASE_USER,DATABASE_PASSWORD);
        File reportFile = new File(application.getRealPath("DynamicCsvReport.jasper"));
       Map parameters = new HashMap();
       parameters.put("filename","ttt");
              jasperPrint=JasperFillManager.fillReport(reportFile.getPath(),parameters,conn);
              JRCsvExporter exporter=new JRCsvExporter();
              response.setContentType("application/x-msdownload");
              //response.setHeader("Content-Disposition", "attachment;filename=\"" + reportFile+ ".CSV\"");
              exporter.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);
              exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING, "GBK");
              exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,"c:\\report.csv");
              exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);
              exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);
              exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);
              exporter.exportReport();   

           } 
    catch(JRException e)
    {
  e.printStackTrace();
           }
    catch (Exception e)
    {
         e.printStackTrace();
    }
%>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14895197/viewspace-591068/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14895197/viewspace-591068/