BIRT使用xml動態(tài)數(shù)據(jù)源總結(jié)

-.zBIRT使用*ml動態(tài)數(shù)據(jù)源總結(jié)博客分類：Java&Eclipse*ML數(shù)據(jù)構(gòu)造EclipseWebworkMySQL因為系統(tǒng)需要，添加報表功能，瞄上了birt，學(xué)習(xí)之，入門教程看了一大堆，還好，多種數(shù)據(jù)源支持，對于sql還沒精通，看著一大堆sql還有點犯難，所以，*ml數(shù)據(jù)源成了我的首選，仔細(xì)研究之下，發(fā)現(xiàn)原來birt提供的初級功能原來很少，報表經(jīng)常需要替換數(shù)據(jù)源來顯示其不同的內(nèi)容，而傳統(tǒng)的設(shè)置*ml數(shù)據(jù)源只是事前指定好*ml文件，或url，google了一下，根本沒有發(fā)現(xiàn)可用的例子，郁悶之，自己琢磨了一周幾乎，更郁悶的是其實問題早有了答案，就載在acegi的權(quán)限控制之上一直未看到勝利的曙光下面把自己動態(tài)修改*ml數(shù)據(jù)源的成功發(fā)上來我用的是webwork，其他用戶請酌情修改相應(yīng)參數(shù)這個是用來view報表的action需要傳入的參數(shù)是

reban.reportName=報表文件的文件名

rbean.*mlDataUrl=報表*mldatasourceurl，可以是stream，或***.*ml之類的，輸入瀏覽器能顯示*ml即可

BirtReportViewer.javaJava代碼package.morepower.controller.birt;importjava.io.ByteArrayInputStream;importjava.io.ByteArrayOutputStream;importjava.io.InputStream;importjava*.servlet.ServletConte*t;importjava*.servlet..ServletRequest;importorg.eclipse.birt.report.engine.api.EngineConstants;importorg.eclipse.birt.report.engine.api.HTMLRenderOption;importorg.eclipse.birt.report.engine.api.HTMLServerImageHandler;importorg.eclipse.birt.report.engine.api.IHTMLRenderOption;importorg.eclipse.birt.report.engine.api.IRenderOption;importorg.eclipse.birt.report.engine.api.IReportEngine;importorg.eclipse.birt.report.engine.api.IReportRunnable;importorg.eclipse.birt.report.engine.api.IRunAndRenderTask;importorg.eclipse.birt.report.model.api.DataSourceHandle;importorg.eclipse.birt.report.model.api.ElementFactory;importorg.eclipse.birt.report.model.api.OdaDataSetHandle;importorg.eclipse.birt.report.model.api.OdaDataSourceHandle;importorg.eclipse.birt.report.model.api.ReportDesignHandle;importorg.eclipse.birt.report.model.api.TableHandle;importorg.eclipse.birt.report.model.api.activity.SemanticE*ception;import.morepower.controller.AbstractAction;import.morepower.util.BirtEngine;import.morepower.view.BirtReporterBean;import.opensymphony.webwork.ServletActionConte*t;erceptor.ServletRequestAware;publicclassBirtReportViewere*tendsAbstractActionimplementsServletRequestAware

{

/****/privatestaticfinallongserialVersionUID=1L;privatestaticStringREPORT_DIR="birt-reportors";privatestaticStringREPORT_IMAGE_DIR="images";privateIReportEnginebirtReportEngine=null;privateServletRequestrequest;privateBirtReporterBeanrbean;privateInputStreamreportStream;privatestaticStringDATASOURCE_NAME="DataSource";privatestaticStringDATASET_NAME="DataSet";privatestaticStringQueryTe*t=";publicInputStreamgetReportStream()

{

returnthis.reportStream;

}

OverridepublicStringe*ecute()throwsE*ception

{

//getreportnameandlaunchtheengine//resp.setContentType("te*t/html");//resp.setContentType("application/pdf");//resp.setHeader("Content-Disposition","inline;filename=test.pdf");StringreportName=rbean.getReportName();ServletConte*tsc=ServletActionConte*t.getServletConte*t();birtReportEngine=BirtEngine.getBirtEngine(sc);IReportRunnabledesign=birtReportEngine.openReportDesign(sc.getReal+REPORT_DIR)++reportName);ReportDesignHandlereport=(ReportDesignHandle)design.getDesignHandle();//只是動態(tài)更換數(shù)據(jù)源即可，不需改變報表的其他構(gòu)造//暫時不支持動態(tài)創(chuàng)立表格//createtasktorunandrenderreportbuildReport(report);IRunAndRenderTasktask=birtReportEngine.createRunAndRenderTask(design);task.getAppConte*t().put(EngineConstants.APPCONTE*T_CLASSLOADER_KEY,BirtReportViewer.class.getClassLoader());//setoutputoptionsHTMLRenderOptionoptions=newHTMLRenderOption();options.setImageHandler(newHTMLServerImageHandler());options.setImageDirectory(sc.getRealPath(java.io.File.separator+REPORT_IMAGE_DIR));options.setBaseImageURL(request.getConte*tPath()+r+REPORT_IMAGE_DIR);options.setOutputFormat(HTMLRenderOption.OUTPUT_FORMAT_HTML);options.setOption(IRenderOption.HTML_PAGINATION,Boolean.TRUE);options.setOption(IHTMLRenderOption.MASTER_PAGE_CONTENT,newBoolean(true));//options.setOutputFormat(HTMLRenderOption.OUTPUT_FORMAT_PDF);options.setOption(HTMLRenderOption.HTML_ENABLE_METADATA,Boolean.FALSE);ByteArrayOutputStreambout=newByteArrayOutputStream();//Stringrenderstr=bout.toString("utf-8");options.setOutputStream(bout);task.setRenderOption(options);/**另外一種方案，直接在action中構(gòu)造inputStream對像，但這樣*可能導(dǎo)致你的報表viewer與具體業(yè)務(wù)類耦合！*task.getAppConte*t().put(org.eclipse.datatools.enablement.oda.*ml.Constants.APPCONTE*T_INPUTSTREAM,reportStream);T_CLOSEINPUTSTREAM,Boolean.TRUE);*///runreporttask.run();task.close();reportStream=newByteArrayInputStream(bout.toByteArray());returnSUCCESS;

}

/***去除原有的數(shù)據(jù)源*/protectedvoidclearDataSource(ReportDesignHandledesignHandle)

{

//DataSourceHandledsh=designHandle.findDataSource(DATASOURCE_NAME);//dsh.drop();intcount=designHandle.getDataSources().getCount();try

{

for(inti=0;i<count;i++)designHandle.getDataSources().drop(i);

}

catch(SemanticE*ceptione)

{

log.error(e);e.printStackTrace();

}

}

/***去除原有的數(shù)據(jù)集*/protectedvoidclearDataSet(ReportDesignHandledesignHandle)

{

getQueryTe*t(designHandle);intcount=designHandle.getDataSets().getCount();try

{

for(inti=0;i<count;i++)designHandle.getDataSets().drop(i);

}

catch(SemanticE*ceptione)

{

log.error(e);e.printStackTrace();

}

}

/****/protectedvoidgetQueryTe*t(ReportDesignHandledesignHandle)

{

QueryTe*t=(String)designHandle.getDataSets().get(0).getProperty("queryTe*t");

}

protectedvoidbuildReport(ReportDesignHandledesignHandle)

{

try

{

ElementFactorydesignFactory=designHandle.getElementFactory();buildDataSource(designFactory,designHandle);buildDataSet(designFactory,designHandle);TableHandletable=(TableHandle)designHandle.getBody().get(0);table.setDataSet(designHandle.findDataSet(DATASET_NAME));

}

catch(SemanticE*ceptione)

{

log.error(e);e.printStackTrace();

}

}

protectedvoidbuildDataSource(ElementFactorydesignFactory,ReportDesignHandledesignHandle)throwsSemanticE*ception

{

clearDataSource(designHandle);OdaDataSourceHandledsHandle=designFactory.newOdaDataSource(DATASOURCE_NAME,"org.eclipse.birt.report.data.oda.*ml");/*dsHandle.setProperty("odaDriverClass",".mysql.jdbc.Driver");dsHandle.setProperty("odaURL","jdbc:mysql://localhost/stat");dsHandle.setProperty("odaUser","root");dsHandle.setProperty("odaPassword",");*/dsHandle.setProperty("FILELIST",rbean.get*mlDataUrl());designHandle.getDataSources().add(dsHandle);

}

protectedvoidbuildDataSet(ElementFactorydesignFactory,ReportDesignHandledesignHandle)throwsSemanticE*ception

{

clearDataSet(designHandle);OdaDataSetHandledsHandle=designFactory.newOdaDataSet(DATASET_NAME,//"org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet");/*OdaDataSetHandledsHandle=designFactory.newOdaDataSet(DATASET_NAME,*/"org.eclipse.birt.report.data.oda.*ml.dataSet");dsHandle.setPrivateDriverProperty("*ML_FILE",rbean.get*mlDataUrl());dsHandle.setPrivateDriverProperty("MA*_ROW","-1");dsHandle.setQueryTe*t(QueryTe*t);dsHandle.setDataSource(DATASOURCE_NAME);designHandle.getDataSets().add(dsHandle);

}

OverridepublicvoidsetServletRequest(ServletRequestarg0)

{

request=arg0;

}

Overridepublicvoiddestory()

{

BirtEngine.destroyBirtEngine();

}

publicBirtReporterBeangetRbean()

{

returnrbean;

}

publicvoidsetRbean(BirtReporterBeanrbean)

{

this.rbean=rbean;

}

Overridepublicvoidinitilize()

{

try

{

("報表系統(tǒng)初始化中");BirtEngine.initBirtConfig();REPORT_DIR=BirtEngine.getBirtReportorProperty("report_dir");REPORT_IMAGE_DIR=BirtEngine.getBirtReportorProperty("report_image_dir");DATASOURCE_NAME="DataSource";DATASET_NAME="DataSet";

}

catch(E*ceptione)

{

e.printStackTrace();log.error(e);

}

}

}

BirtEngine.javaJava代碼package.morepower.util;importjava.io.InputStream;importjava.io.IOE*ception;importjava.util.Properties;importjava.util.logging.Level;importorg.apache.mons.logging.Log;importorg.apache.mons.logging.LogFactory;importorg.eclipse.birt.report.engine.api.EngineConfig;importorg.eclipse.birt.report.engine.api.IReportEngine;importjava*.servlet.*;importorg.eclipse.birt.core.framework.PlatformServletConte*t;importorg.eclipse.birt.core.framework.IPlatformConte*t;importorg.eclipse.birt.core.framework.Platform;importtion;importorg.eclipse.birt.report.engine.api.IReportEngineFactory;publicclassBirtEngine

{

privatestaticIReportEnginebirtEngine=null;privatestaticPropertiesconfigProps=newProperties();privatefinalstaticStringconfigFile="BirtCperties";protectedfinalstaticLoglog=LogFactory.getLog(BirtEngine.class);publicstaticsynchronizedvoidinitBirtConfig()

{

loadEngineProps();

}

publicstaticsynchronizedIReportEnginegetBirtEngine(ServletConte*tsc)

{

if(birtEngine==null)

{

EngineConfigconfig=newEngineConfig();if(configProps!=null)

{

StringlogLevel=configProps.getProperty("logLevel");Levellevel=Level.OFF;if("SEVERE".equalsIgnoreCase(logLevel))

{

level=Level.SEVERE;

}

elseif("WARNING".equalsIgnoreCase(logLevel))

{level=Level.WARNING;

}

elseif("INFO".equalsIgnoreCase(logLevel))

{

level=Level.INFO;

}

elseif("CONFIG".equalsIgnoreCase(logLevel))

{

level=Level.CONFIG;

}

elseif("FINE".equalsIgnoreCase(logLevel))

{

level=Level.FINE;

}

elseif("FINER".equalsIgnoreCase(logLevel))

{

level=Level.FINER;

}

elseif("FINEST".equalsIgnoreCase(logLevel))

{

level=Level.FINEST;

}

elseif("OFF".equalsIgnoreCase(logLevel))

{

level=Level.OFF;

}

config.setLogConfig(configProps.getProperty("logDirectory"),level);

}

//sc.getRealPath(")+java.io.File.separator+configProps.getProperty("engine_home")config.setEngineHome(");IPlatformConte*tconte*t=newPlatformServletConte*t(sc);(conte*t.getPlatform());config.setPlatformConte*t(conte*t);try

{

Platform.startup(config);

}

catch(BirtE*ceptione)

{

e.printStackTrace();

}