Birt动态设置sql中的?

最新推荐文章于 2025-07-08 10:18:13 发布

iteye_12456

最新推荐文章于 2025-07-08 10:18:13 发布

阅读量136

点赞数

CC 4.0 BY-SA版权

文章标签： SQL Eclipse JDBC

本文链接：https://blog.youkuaiyun.com/iteye_12456/article/details/82039638

本文介绍如何使用BIRT工具进行报告设计，包括数据源构建、SQL查询编写、参数设置及数据集创建等关键步骤，并展示了如何动态修改报告参数。

[b]1.build DataSource[/b]
[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();