BIRT使用xml动态数据源总结

BIRT使用xml动态数据源总结XML数据结构EclipseWebworkMySQL因为系统需要，添加报表功能，瞄上了birt，学习之，入门教程看了一大堆，还好，多种数据源支持，对于sql还没精通，看着一大堆sql还有点犯难，所以，xml数据源成了我的首选，仔细研究之下，发现原来 birt 提供的初级功能原来很少，报表经常需要替换数据源来显示其不同的内容，而传统的设置 xml数据源只是事前指定好 xml文件，或url，google了一下，基本没有发现可用 的例子，郁闷之，自己琢磨了一周几乎，更郁闷的是其实问题早有了答案，就载在acegi的权限控制之上一直未看到胜利的曙光下面把自己动态修改 xml数据源的成功发上来我用的是 webwork，其他用户请酌情修改相应参数这个是用来view报表的action 需要传入的参数是reban.reportName= 报表文件的文件名rbean.xmlDataUrl= 报表xmldatasourceurl ，可以是stream，或xxx.xml之类的，输入浏览器能显示 xml即可BirtReportViewer.javaJava代码3.importjava.io.ByteArrayInputStream;4.importjava.io.ByteArrayOutputStream;5.importjava.io.InputStream;6.7.importjavax.servlet.ServletContext;8.importjavax.servlet.http.HttpServletRequest;9.10.importorg.eclipse.birt.report.engine.api.EngineConstants;11.importorg.eclipse.birt.report.engine.api.HTMLRenderOption;12.importorg.eclipse.birt.report.engine.api.HTMLServerImageHandler;13.importorg.eclipse.birt.report.engine.api.IHTMLRenderOption;14.importorg.eclipse.birt.report.engine.api.IRenderOption;15.importorg.eclipse.birt.report.engine.api.IReportEngine;16.import 17.import 18.import 19.import 20.import 21.import 22.import 23.import 24.import25.26.27.importcom.morepower.controller.AbstractAction;28.importcom.morepower.util.BirtEngine;29.importcom.morepower.view.BirtReporterBean;30.importcom.opensymphony.webwork.ServletActionContext;31.erceptor.ServletRequestAware;32.33.publicclassBirtReportViewerextendsAbstractActionimplements34.ServletRequestAware{35./**36.*37.*/38.privatestaticfinallongserialVersionUID=1L;39.privatestaticStringREPORT_DIR="birt-reportors";40.privatestaticStringREPORT_IMAGE_DIR="images";41.privateIReportEnginebirtReportEngine=null;42.privateHttpServletRequestrequest;43.privateBirtReporterBeanrbean;44.privateInputStreamreportStream;45.privatestaticStringDATASOURCE_NAME="DataSource";46.privatestaticStringDATASET_NAME="DataSet";47.privatestaticStringQueryText="";48.49.publicInputStreamgetReportStream(){50.returnthis.reportStream;51.}52.53.@Override54.publicStringexecute()throwsException{55.//getreportnameandlaunchtheengine56.//resp.setContentType("text/html");57.//resp.setContentType("application/pdf");58.//resp.setHeader("Content-Disposition","inline;filename=test.pdf");59.StringreportName=rbean.getReportName();60.ServletContextsc=ServletActionContext.getServletContext();61.birtReportEngine=BirtEngine.getBirtEngine(sc);62. IReportRunnabledesign=birtReportEngine.openReportDesign(sc63. ator+REPORT_DIR)64.+java.io.File.separator+reportName);65.66.ReportDesignHandlereport=(ReportDesignHandle)design67..getDesignHandle();68.69.//只是动态更换数据源即可，不需改变报表的其他结构70.//暂时不支持动态创建表格71.72.//createtasktorunandrenderreport73.buildReport(report);74.IRunAndRenderTasktask=birtReportEngine75. .createRunAndRenderTask(design);76. task.getAppContext().put(EngineConstants.APPCONTEXT_CLASSLOADER_KEY,77. 78.79. // set output options80. HTMLRenderOptionoptions = new HTMLRenderOption();81. options.setImageHandler(newHTMLServerImageHandler());82. 83.+REPORT_IMAGE_DIR));84.options.setBaseImageURL(request.getContextPath()85.+java.io.File.separator+REPORT_IMAGE_DIR);86.options.setOutputFormat(HTMLRenderOption.OUTPUT_FORMAT_HTML);87.options.setOption(IRenderOption.HTML_PAGINATION,Boolean.TRUE);88. options.setOption(IHTMLRenderOption.MASTER_PAGE_CONTENT,newBoolean(89.true));90.91.//options.setOutputFormat(HTMLRenderOption.OUTPUT_FORMAT_PDF);92.options.setOption(HTMLRenderOption.HTML_ENABLE_METADATA,Boolean.FALSE);93.ByteArrayOutputStreambout=newByteArrayOutputStream();94.//Stringrenderstr=bout.toString("utf-8");95.options.setOutputStream(bout);96.task.setRenderOption(options);97.98./*99.*另外一种方案，直接在action中构造inputStream对像，但这样100.*可能导致你的报表viewer与具体业务类耦合！101.102.reportStream);103.task.getAppContext().put(org.eclipse.datat104.Boolean.TRUE);*/105.106.//runreport107.108.task.run();109.task.close();110.reportStream=newByteArrayInputStream(bout.toByteArray());111.112.returnSUCCESS;113.}114.115./**116.*清除原有的数据源117.*/118.protectedvoidclearDataSource(ReportDesignHandledesignHandle){119.//DataSourceHandledsh=designHandle.findDataSource(DATASOURCE_NAME);120.//dsh.drop();121.intcount=designHandle.getDataSources().getCount();122.123.try{124.for(inti=0;i<count;i++)125.designHandle.getDataSources().drop(i);126.}catch(SemanticExceptione){127.log.error(e);128.e.printStackTrace();129.}130.}131.132./**133.*清除原有的数据集134.*/135.protectedvoidclearDataSet(ReportDesignHandledesignHandle){136.getQueryText(designHandle);137.intcount=designHandle.getDataSets().getCount();138.try{139.for(inti=0;i<count;i++)140.designHandle.getDataSets().drop(i);141.}catch(SemanticExceptione){142.log.error(e);143.e.printStackTrace();144.}145.}146.147./**148.*149.*/150.protectedvoidgetQueryText(ReportDesignHandledesignHandle){151.QueryText=(String)designHandle.getDataSets().get(0).getProperty(152."queryText");153.}154.155.protectedvoidbuildReport(ReportDesignHandledesignHandle){156.try{157.ElementFactorydesignFactory=designHandle.getElementFactory();158.buildDataSource(designFactory,designHandle);159.buildDataSet(designFactory,designHandle);160.TableHandletable=(TableHandle)designHandle.getBody().get(0);161.table.setDataSet(designHandle.findDataSet(DATASET_NAME));162.163.}catch(SemanticExceptione){164.log.error(e);165.e.printStackTrace();166.}167.168.}169.170.protectedvoidbuildDataSource(ElementFactorydesignFactory,171.ReportDesignHandledesignHandle)throwsSemanticException{172.clearDataSource(designHandle);173.OdaDataSourceHandledsHandle=designFactory.newOdaDataSource(174.DATASOURCE_NAME,175."org.eclipse.birt.report.data.oda.xml");176./*dsHandle.setProperty("odaDriverClass",177."com.mysql.jdbc.Driver");178.dsHandle.setProperty("odaURL","jdbc:mysql://localhost/stat");179.dsHandle.setProperty("odaUser","root");180.dsHandle.setProperty("odaPassword","");*/181.dsHandle.setProperty("FILELIST",rbean.getXmlDataUrl());182.designHandle.getDataSources().add(dsHandle);183.}184.185.protectedvoidbuildDataSet(ElementFactorydesignFactory,186.ReportDesignHandledesignHandle)throwsSemanticException{187.188.clearDataSet(designHandle);189.OdaDataSetHandledsHandle=designFactory.newOdaDataSet(DATASET_NAME,190.//"org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet");191./*OdaDataSetHandledsHandle=designFactory.newOdaDataSet(DATASET_NAME,*/192."org.eclipse.birt.report.data.oda.xml.dataSet");193.dsHandle.setPrivateDriverProperty("XML_FILE", rbean.getXmlDataUrl());194.dsHandle.setPrivateDriverProperty("MAX_ROW","-1");195.dsHandle.setQueryText(QueryText);196.dsHandle.setDataSource(DATASOURCE_NAME);197.designHandle.getDataSets().add(dsHandle);198.199.}200.201.@Override202.publicvoidsetServletRequest(HttpServletRequestarg0){203.request=arg0;204.205.}206.207.@Override208.publicvoiddestory(){209.BirtEngine.destroyBirtEngine();210.}211.212.publicBirtReporterBeangetRbean(){213.returnrbean;214.}215.216.publicvoidsetRbean(BirtReporterBeanrbean){217.this.rbean=rbean;218.}219.220.@Override221.publicvoidinitilize(){222.try{223.("报表系统初始化中");224.BirtEngine.initBirtConfig();225.REPORT_DIR=BirtEngine.getBirtReportorProperty("report_dir");226.REPORT_IMAGE_DIR=BirtEngine227..getBirtReportorProperty("report_image_dir");228.DATASOURCE_NAME="DataSource";229.DATASET_NAME="DataSet";230.}catch(Exceptione){231.e.printStackTrace();232.log.error(e);233.}234.}235.}BirtEngine.javaJava代码6.7.mons.logging.Log;8.mons.logging.LogFactory;9.importorg.eclipse.birt.report.engine.api.EngineConfig;10.importorg.eclipse.birt.report.engine.api.IReportEngine;11.importjavax.servlet.*;12.importorg.eclipse.birt.core.framework.PlatformServletContext;13.importorg.eclipse.birt.core.framework.IPlatformContext;14.importorg.eclipse.birt.core.framework.Platform;15.importorg.eclipse.birt.core.exception.BirtException;16.importorg.eclipse.birt.report.engine.api.IReportEngineFactory;17.18.publicclassBirtEngine{19.privatestaticIReportEnginebirtEngine=null;20.privatestaticPropertiesconfigProps=newProperties();21.privatefinalstaticStringconfigFile="BirtCperties";22.protectedfinalstaticLoglog=LogFactory.getLog(BirtEngine.class);23. public static synchronized void initBirtConfig() {24.25. loadEngineProps();26. }27.28. public static synchronized IReportEngine getBirtEngine(ServletContext sc) {29.if(birtEngine==null){30.EngineConfigconfig=newEngineConfig();31.if(configProps!=null){32.StringlogLevel=configProps.getProperty("logLevel");33.Levellevel=Level.OFF;34.if("SEVERE".equalsIgnoreCase(logLevel)){35.level=Level.SEVERE;36.}elseif("WARNING".equalsIgnoreCase(logLevel)){37.level=Level.WARNING;38.}elseif("INFO".equalsIgnoreCase(logLevel)){39.level=Level.INFO;40.}elseif("CONFIG".equalsIgnoreCase(logLevel)){41.level=Level.CONFIG;42.}elseif("FINE".equalsIgnoreCase(logLevel)){43.level=Level.FINE;44.}elseif("FINER".equalsIgnoreCase(logLevel)){45.level=Level.FINER;46.}elseif("FINEST".equalsIgnoreCase(logLevel)){47.level=Level.FINEST;48.}elseif("OFF".equalsIgnoreCase(logLevel)){49.level=Level.OFF;50.}51.52..getProperty("logDirectory"),config.setLogConfig(configProps53.level);54.}55.//sc.getRealPath("")+java.io.File.separator+configProps.getProperty("engine_home")56.config.setEngineHome("");57.IPlatformContextcontext=newPlatformServletContext(sc);58.(context.getPlatform());59.config.setPlatformContext(context);60.61.try{62.Platform.startup(config);63.}catch(BirtExceptione){64.e.printStackTrace();65.}66.67.IReportEngineFactoryfactory=(IReportEngineFactory)Platform68