OAF中从弹性域获取值的明细页面

在做项目时，有时会碰到一个页面跳转到另外一个明细页面，而且这个明细页面全部由一些弹性域字段组成的，下面是使用co代码动态创建出来的符合这种需求的明细页面，并且可以动态创建多个表格

/*===========================================================================+ | Copyright (c) 2001, 2005 Oracle Corporation, Redwood Shores, CA, USA | | All rights reserved. | +===========================================================================+ | HISTORY | +===========================================================================*/ package cux.oracle.apps.pa.statusreport.webui; import oracle.apps.fnd.common.VersionInfo; import oracle.apps.fnd.framework.webui.OAControllerImpl; import oracle.apps.fnd.framework.webui.OAPageContext; import oracle.apps.fnd.framework.webui.beans.OAWebBean; import oracle.apps.fnd.framework.OAApplicationModule; import oracle.apps.fnd.framework.OAViewObject; import oracle.apps.fnd.framework.server.OADBTransaction; import oracle.apps.fnd.framework.webui.beans.table.OATableBean; import oracle.apps.fnd.framework.webui.beans.OADescriptiveFlexBean; import oracle.apps.fnd.framework.webui.beans.layout.OASpacerBean; import oracle.apps.fnd.framework.webui.OAWebBeanConstants; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; /** * Controller for ... */ public class CuxReportDetailCO extends OAControllerImpl { public static final String RCS_ID = "$Header$"; public static final boolean RCS_ID_RECORDED = VersionInfo.recordClassVersion(RCS_ID, "%packagename%"); /** * Layout and page setup logic for a region. * @param pageContext the current OA page context * @param webBean the web bean corresponding to the region */ public void processRequest(OAPageContext pageContext, OAWebBean webBean) { super.processRequest(pageContext, webBean); String versionId = pageContext.getParameter("versionId"); String pageId = pageContext.getParameter("pageId"); renderDescFlex(pageContext, webBean, versionId, pageId); } /** * Procedure to handle form submissions for form elements in * a region. * @param pageContext the current OA page context * @param webBean the web bean corresponding to the region */ public void processFormRequest(OAPageContext pageContext, OAWebBean webBean) { super.processFormRequest(pageContext, webBean); } private void renderDescFlex(OAPageContext pageContext, OAWebBean webBean, String versionId, String pageId) { int flexCount = 1; OAApplicationModule am = pageContext.getApplicationModule(webBean); OADBTransaction txn = am.getOADBTransaction(); PreparedStatement ps = null; ResultSet rs = null; String sql = "SELECT pplr.region_source_code,ffc.descriptive_flex_context_name" + " FROM pa_page_layout_regions pplr," + " fnd_descr_flex_contexts_vl ffc" + " WHERE pplr.region_source_type = 'DFF'" + " AND pplr.region_source_code=ffc.descriptive_flex_context_code" + " AND ffc.descriptive_flexfield_name = 'PA_STATUS_REPORT_DESC_FLEX'" + " AND ffc.application_id = 275" + " AND page_id = :1" + " ORDER BY display_order"; try { ps = txn.createPreparedStatement(sql, 1); ps.setString(1, pageId); rs = ps.executeQuery(); while (rs.next()) { String regionSourceCode = rs.getString(1); String flexContextName = rs.getString(2); String voName = "DffVO" + flexCount; OAViewObject vo = (OAViewObject)am.findViewObject(voName); if (vo == null) { vo = (OAViewObject)am.createViewObject(voName, "cux.oracle.apps.pa.statusreport.server.ReportDetailVO"); } vo.setWhereClause(null); vo.setWhereClauseParams(null); vo.setWhereClause(" version_id=:1 AND region_code=:2"); vo.setWhereClauseParam(0, versionId); vo.setWhereClauseParam(1, regionSourceCode); vo.executeQuery(); int rowCount = vo.getRowCount(); OATableBean tableBean = (OATableBean)createWebBean(pageContext, TABLE_BEAN, null, "ResultTable" + flexCount); tableBean.setText(flexContextName); tableBean.setWidth("100%"); webBean.addIndexedChild(tableBean); tableBean.setNumberOfRowsDisplayed(rowCount); OADescriptiveFlexBean descFlex = (OADescriptiveFlexBean)createWebBean(pageContext, DESCRIPTIVE_FLEX_BEAN, null, "DescFF" + flexCount); descFlex.setAttributeValue(OAWebBeanConstants.VIEW_USAGE_NAME, voName); descFlex.setAttributeValue(OAWebBeanConstants.FLEXFIELD_APPLICATION_SHORT_NAME, "PA"); descFlex.setAttributeValue(OAWebBeanConstants.REGION_APPLICATION_ID, new Integer(275)); descFlex.setAttributeValue(OAWebBeanConstants.FLEXFIELD_NAME, "PA_STATUS_REPORT_DESC_FLEX"); descFlex.setFlexContextCode(pageContext, regionSourceCode); descFlex.setContextListRendered(false); descFlex.setReadOnly(true); tableBean.addIndexedChild(descFlex); OASpacerBean spacerBean = (OASpacerBean)createWebBean(pageContext, SPACER_BEAN, null, "SpaceBean" + flexCount); spacerBean.setHeight("15"); webBean.addIndexedChild(spacerBean); flexCount++; } rs.close(); ps.close(); } catch (SQLException se) { } } }