OAF开发笔记.docx

OAF学习笔记-不基于EO的数据处理纯属觉得好玩,试验一下….主要功能:手工建立PAGE及上面的ITEM,所有ITEM均为普通的ITEM,非VO的ATTRIBUTE.然后在ITEM中输入信息,并保存到表中.主要使用的包及方法:包Import oracle.apps.fnd.framework.OAApplicationModule;方法getTransaction().executeCommand(“string”)作用:提交SQL语句,可为任意…getTransaction().commit()作用:执行COMMIT动作.pageContext.getparameter()作用:获取ITEM中的值pageContext.getuserid()作用:获取USER ID,做为WHO信息pageContext.getCurrentDBDate()作用:获取当前时间,做为WHO信息代码流程:在ROOT REGION中建立CODE:??捕获按钮是否被点击语句:if (pageContext.getParameter(Save) != null)实例化AM,因无EO,我没建AM,用的是ORACLE默认的那个AM.语句:OAApplicationModule am = pageContext.getApplicationModule(webBean);组合SQL语句:String?sqlstr = “ insert into….”注意:时间型的东东可能要先获取字符串,然后加上TO_DATETIME转换…提交SQL语句:am.getTransaction().executeCommand(sqlstr);执行COMMIT:am.getTransaction().commit();返回信息:pageContext.putDialogMessage(new OAException(Save successfully!,OAException.INFORMATION));OAF学习笔记-MessageChoice(Poplist)的级联显示下拉列表的级联显示是非常常用的一种界面显示效果,在FORMS中我常作,作法也很简单,可OAF中显然有点麻烦了…现假定有张表,里面有两个字段,一个是Province(省),一个是City(市).??现需要在页面上放置两个下拉列表字段,一个选择省,一个选择市,当然,选择市的下拉列表值需要根据省的下拉列表的选择进行筛选.实现思路:实际上很简单,与FORMS差不多,就是要动态的指定选择市的下拉列表的查询.当选择完省后,立即更新市的查询…实现步骤如下:新建一个Project(方法略):Name :?OAPoplistPath:?????abeam.oracle.apps.icx.poplist新建一个Business Component Package(For AM and VO)新建BC:Package Name:??abeam.oracle.apps.icx.poplist.server新建AM:AM Name:?????????PoplistAMAM Path:???????????abeam.oracle.apps.icx.poplist.server新建省的VO(基于SQL):VO Name:??????????ProvinceVOVO Path:????????????abeam.oracle.apps.icx.poplist.serverSQL:???????????????????vince?fromtest_lovlist t新建市的VO(基于SQL):VO Name:??????????CityVOVO Path:?????????????abeam.oracle.apps.icx.poplist.serverSQL:????????????????????select?t.city?fromtest_lovlist t关联AM与VO(方法略)新建Web Page及Item新建Page:Page Name:??PoplistPGPage Path:?????abeam.oracle.apps.icx.poplist.webuiRoot Region:?PageLayoutRNRoot Region Type: pagelayoutAM??Definition:?PoplistAM新建Item:Provincelist :PropertyValueItem styleMessageChoiceRequiredYes(optional)Add blank valueFalsePicklist view DefinitionAbeam.oracle.apps.icx.poplist.server.Provi