jasperreports 结合ireport生成html,word,excel,pdf

    开发报表使用ireport开发还是比较快和方便的，以下整理jsp将jasper文件生成html，word，excel，pdf格式的代码：

ireport的使用教程可以参见一下附件：

 

1、生成html格式：

 //输出html格式
  
    Map<String,String> parameters = new HashMap<String,String>();
    parameters.put("title","我们的产品");
    Connection con = null;
    try {
      con=Conmysql.getCon();
  
    //返回生成文件路径
    String file=JasperRunManager.runReportToHtmlFile(application.getRealPath     ("reports/test.jasper"), parameters, con);
   
    response.sendRedirect("reports/test.html");
   
     }
    catch (Exception e) {
      System.out.println(e);
     
    }finally{
      con.close();
    }

 

 

2、生成PDF格式文件

 //生成pdf格式
    Map<String,String> parameters = new HashMap<String,String>();
    parameters.put("title","我们的产品");
    Connection con = null;
    try {
      con=Conmysql.getCon();
      System.out.println("连接数据库成功");
  
    byte[] bytes = JasperRunManager.runReportToPdf(application.getRealPath("reports/test.jasper"), parameters, con);
    response.setContentType("application/pdf");
    response.setContentLength(bytes.length);
    ServletOutputStream ouputStream = response.getOutputStream();
    ouputStream.write(bytes, 0, bytes.length);
    ouputStream.flush();
    ouputStream.close();
     }
    catch (Exception e) {
      System.out.println(e);
    }finally{
      con.close();
    }

 

 

 

3、生成excel格式的文件

//生成excel格式
  
    Connection con=null;
    con=Conmysql.getCon();
    Map<String,String> parameters = new HashMap<String,String>();
    parameters.put("title","我们的产品");
 
    try{

     JasperPrint jasperPrint = JasperFillManager.fillReport(application.getRealPath("reports/test.jasper"),parameters,con);
  
     ByteArrayOutputStream oStream = new ByteArrayOutputStream();
 
      JRXlsExporter exporter = new JRXlsExporter(); 
   
      exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
      exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, oStream);
      exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE); // 删除记录最下面的空行
      exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);// 删除多余的ColumnHeader
      exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);// 显示边框
      exporter.exportReport();
   
     byte[] bytes = oStream.toByteArray();
  
     if(bytes != null && bytes.length > 0) {
      response.reset();
      response.setContentType("application/vnd.ms-excel");
      response.setContentLength(bytes.length);
      ServletOutputStream ouputStream = response.getOutputStream();
      ouputStream.write(bytes,0,bytes.length);
      ouputStream.flush();
      ouputStream.close();
 
     }else{
      out.print("bytes were null!");
     }
  
     }catch(JRException ex){
     out.print("Jasper Output Error:"+ex.getMessage());
     }finally{
      con.close();
     }

 

 

 

4、生成word格式的文件：

//生成word格式
  
    Map<String,String> parameters = new HashMap<String,String>();
    parameters.put("title","我们的产品");
    Connection con = null;
    try {
      con=Conmysql.getCon();
      System.out.println("连接数据库成功");
  
    JasperPrint jasperPrint = JasperFillManager.fillReport(application.getRealPath("reports/test.jasper"),parameters,con);
  
    ByteArrayOutputStream oStrEeam = new ByteArrayOutputStream();
 
    JRExporter exporter = new JRRtfExporter(); 
   
    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, oStrEeam);
    exporter.exportReport();
   
    byte[] bytes = oStrEeam.toByteArray();
  
    if(bytes != null && bytes.length > 0) {
    response.reset();
    response.setContentType("application/ms_word");
    response.setHeader("Content-disposition", "attachment; filename=zhiyou_erp.doc");
    response.setContentLength(bytes.length);
    ServletOutputStream ouputStream = response.getOutputStream();
    ouputStream.write(bytes, 0, bytes.length);
    ouputStream.flush();
    ouputStream.close();
    }
   
     }
    catch (Exception e) {
      System.out.println(e);
    }finally{
       con.close();
    }