linux下使用jasper生成报表,jasper 生成 csv文件

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();

}

%>