Birt动态设置sql中的?

1.build DataSource
2.String sql
    
String sql = "select * from test where time between ? and ?";
    
3.build Parameter

             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);  
	     }

4.build DataSet  [创建数据集（即：某些执行sql语句）]

 	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);		
 	}

5.build DataSetParameter  [创建数据集合的参数]

	  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);
	  }

6.modify report parameter

	      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();