Birt动态设置sql中的?
1.build DataSource
2.String sql
String sql = "select * from test where time between ? and ?";
3.build Parameter
5.build DataSetParameter [创建数据集合的参数]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();