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