jasperreport中可以使用List作为数据源

来源：互联网发布：里约奥运周琦数据编辑：程序博客网时间：2024/05/16 23:01

jasperreport中可以使用List作为数据源，使用格式如下.
List list=this.customerDao.getAllCustomer(); //得到所有客户
JRBeanCollectionDataSource ds = new JRBeanCollectionDataSource(list);
   JasperPrint jasperPrint = JasperFillManager.fillReport(
     reportFilePath, parameters, ds);
得填充数据后，即可输出显示到PDF,Excel,Html
到PDF:
public byte[] generatePDF(String begCustNo, String endCustNo,
   String reportTitle, String reportFilePath) throwsDemoException {
  // TODO Auto-generated method stub
//begCustNo,endCustNo分别为查询传入的开始编号，结束编号.
  jdbcCustomerDao = new JdbcCustomerDao();
  Map parameters = new HashMap();
  parameters.put("ReportTitle", reportTitle);//报表标题
  List list = jdbcCustomerDao.getAllCustomer(begCustNo, endCustNo);
   try {
   JRBeanCollectionDataSource ds = newJRBeanCollectionDataSource(list);
   JasperPrint jasperPrint = JasperFillManager.fillReport(
     reportFilePath, parameters,ds);   returnJasperExportManager.exportReportToPdf(jasperPrint);
  } catch (JRException e) {
   throw new DemoException("Report Export Failed.");
  }
}
到Html:
public byte[] generateHtml(String begCustNo, String endCustNo,
   String reportTitle, String reportFilePath) throwsDemoException {
  jdbcCustomerDao = new JdbcCustomerDao();
  Map parameters = new HashMap();
  parameters.put("ReportTitle", reportTitle);
  List list = jdbcCustomerDao.getAllCustomer(begCustNo, endCustNo);
  System.out.println("list size is :" + list.size());
  JRHtmlExporter exporter = new JRHtmlExporter();
  ByteArrayOutputStream oStream = new ByteArrayOutputStream();
  try {
   JRBeanCollectionDataSource ds = newJRBeanCollectionDataSource(list);
   JasperPrint jasperPrint = JasperFillManager.fillReport(
     reportFilePath, parameters, ds);
   exporter.setParameter(
     JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN,
     Boolean.FALSE);
   exporter
     .setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);
   exporter
     .setParameter(JRExporterParameter.CHARACTER_ENCODING,"GBK");
   exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,oStream);
   exporter.exportReport();
   byte[] bytes = oStream.toByteArray();
   return bytes;
  } catch (JRException e) {
   throw new DemoException("Report Export Failed.");
  }
}
到Excel:
public byte[] generateExcel(String begCustNo, String endCustNo,
   String reportTitle, String reportFilePath) throwsDemoException {
  jdbcCustomerDao = new JdbcCustomerDao();
  Map parameters = new HashMap();
  parameters.put("ReportTitle", reportTitle);
  List list = jdbcCustomerDao.getAllCustomer(begCustNo, endCustNo);
  System.out.println("list size is :" + list.size());
  JRXlsExporter exporter = new JRXlsExporter(); // Excel
  ByteArrayOutputStream oStream = new ByteArrayOutputStream();
  try {
   JRBeanCollectionDataSource ds = newJRBeanCollectionDataSource(list);
   JasperPrint jasperPrint = JasperFillManager.fillReport(
     reportFilePath, parameters, ds);
   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);
   exporter.setParameter(
     JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,
     Boolean.FALSE);
   exporter.exportReport();
   byte[] bytes = oStream.toByteArray();
   return bytes;

  } catch (JRException e) {
   throw new DemoException("Report Export Failed.");
  }
}

jsp调用方法：
<%


StringfilePath=getServletContext().getRealPath("/")+"report.jasper";

CustomerServiceImpl custs=new CustomerServiceImpl();
    byte[] bytes=null;
String begNo=request.getParameter("beginCustNo");
String endNo=request.getParameter("endCustNo");
String type=request.getParameter("type");

if(type.equals("Pdf")){
      bytes= custs.generatePDF(begNo,endNo,"客户资料明细表",filePath);
}else if(type.equals("Excel")){
   bytes=custs.generateExcel(begNo,endNo,"客户资料明细表",filePath);
}else
     bytes=custs.generateHtml(begNo,endNo,"客户资料明细表",filePath);

if(bytes!=null){
  if(type.equals("Pdf")){
        response.setContentType("application/pdf");
  }else if(type.equals("Excel")){
    response.setContentType("application/vnd.ms-excel");
  }else
   response.setContentType("text/html");
    response.setContentLength(bytes.length);
    ServletOutputStream ouputStream =response.getOutputStream();
    ouputStream.write(bytes,0,bytes.length);
    ouputStream.flush();
    ouputStream.close();
}else
{
  out.println("error");
}