[b]1.build DataSource[/b]
[b]2.String sql[/b]
String sql = "select * from test where time between ? and ?";
[b]3.build Parameter[/b]
[b]4.build DataSet [创建数据集(即:某些执行sql语句)][/b]
[b]5.build DataSetParameter [创建数据集合的参数][/b]
[b]6.modify report parameter[/b]
若修改完后,打开或导出,则:
reportEngine.shutdown();
Platform.shutdown();
[b]2.String sql[/b]
String sql = "select * from test where time between ? and ?";
[b]3.build Parameter[/b]
int timeStart = xxx;
int timeEnd = xxx;
void buildParameters() throws SemanticException
{
ScalarParameterHandle startTimeHandle = efactory.newScalarParameter("startTimeStr");
startTimeHandle.setDefaultValue(timeStart+"");
startTimeHandle.setAllowNull(false);
startTimeHandle.setAllowBlank(false);
startTimeHandle.setHidden(true);
startTimeHandle.setValueType(DesignChoiceConstants.PARAM_VALUE_TYPE_STATIC);
startTimeHandle.setDataType(DesignChoiceConstants.PARAM_TYPE_STRING);//PARAM_TYPE_INTEGER
ScalarParameterHandle endTimeHandle = efactory.newScalarParameter("endTimeStr");
endTimeHandle.setDefaultValue(timeEnd+"");
endTimeHandle.setAllowNull(false);
endTimeHandle.setAllowBlank(false);
endTimeHandle.setHidden(true);
startTimeHandle.setValueType(DesignChoiceConstants.PARAM_VALUE_TYPE_STATIC);
endTimeHandle.setDataType(DesignChoiceConstants.PARAM_TYPE_STRING);//float
designHandle.getParameters().add(startTimeHandle);
designHandle.getParameters().add(endTimeHandle);
}
[b]4.build DataSet [创建数据集(即:某些执行sql语句)][/b]
void buildDataSet(String sql,String dataSourceName,String dataSetName) throws SemanticException
{
OdaDataSetHandle dsHandle = efactory.newOdaDataSet( dataSetName,
"org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" );
dsHandle.setDataSource( dataSourceName);
dsHandle.setQueryText( sql );
designHandle.getDataSets( ).add( dsHandle );
buildDataSetParameter(dsHandle);
}
[b]5.build DataSetParameter [创建数据集合的参数][/b]
private void buildDataSetParameter(OdaDataSetHandle dsHandle) throws SemanticException{
OdaDataSetParameter dataSetStartTimeParam = StructureFactory.createOdaDataSetParameter();
dataSetStartTimeParam.setName("param1");
dataSetStartTimeParam.setParamName("startTimeStr");
dataSetStartTimeParam.setPosition(1);
dataSetStartTimeParam.setDataType(DesignChoiceConstants.PARAM_TYPE_STRING);
dataSetStartTimeParam.setAllowNull(false);
dataSetStartTimeParam.setDefaultValue(System.currentTimeMillis()/1000 - 1000+"");
dataSetStartTimeParam.setIsInput(true);
dataSetStartTimeParam.setIsOutput(false);
dataSetStartTimeParam.setIsOptional(false);
OdaDataSetParameter dataSetEndTimeParam = StructureFactory.createOdaDataSetParameter();
dataSetEndTimeParam.setName("param2");
dataSetEndTimeParam.setParamName("endTimeStr");
dataSetEndTimeParam.setPosition(2);
dataSetEndTimeParam.setDataType(DesignChoiceConstants.PARAM_TYPE_STRING);
dataSetEndTimeParam.setAllowNull(false);
dataSetEndTimeParam.setDefaultValue(System.currentTimeMillis()+"");
dataSetEndTimeParam.setIsInput(true);
dataSetEndTimeParam.setIsOutput(false);
dataSetEndTimeParam.setIsOptional(false);
PropertyHandle parameterHandle = dsHandle.getPropertyHandle(DataSetHandle.PARAMETERS_PROP);
// parameterHandle.insertItem(dataSetStartTimeParam, 0);
// parameterHandle.insertItem(dataSetEndTimeParam, 1);
parameterHandle.addItem(dataSetStartTimeParam);
parameterHandle.addItem(dataSetEndTimeParam);
}
[b]6.modify report parameter[/b]
int timeStart = xxx;
int timeEnd = xxx;
void setReportParameterValue(ReportDesignHandle designHandle) throws SemanticException, IOException{
((ScalarParameterHandle) designHandle.findParameter("startTimeStr"))
.setDefaultValue(timeStart+ "");
((ScalarParameterHandle) designHandle.findParameter("endTimeStr"))
.setDefaultValue(timeEnd+ "");
designHandle.save();
}
若修改完后,打开或导出,则:
reportEngine.shutdown();
Platform.shutdown();