How to display the columns based on select query dynamically

package xxdynmcdata.oracle.apps.pos.project.webu;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Connection;

import java.sql.SQLException;
import java.sql.Statement;

import oracle.apps.fnd.common.VersionInfo;
import oracle.apps.fnd.framework.OAApplicationModule;
import oracle.apps.fnd.framework.OAViewObject;
import oracle.apps.fnd.framework.server.OADBTransaction;
import oracle.apps.fnd.framework.server.OAViewDef;

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.webui.beans.message.OAMessageStyledTextBean;
import oracle.apps.fnd.framework.webui.beans.table.OATableBean;

import oracle.jbo.AttributeDef;

import xxdynmcdata.oracle.apps.pos.project.server.XXDynmcDataAMImpl;

/**
* Controller for …
*/
public class XXDynmcCO 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 voquery = “”;
AttributeDef[] attrdef = null;
voquery = “select * from DBMEMO_STATUS_NEW”;
int NumOfCol=0;
int i=0;
XXDynmcDataAMImpl oam=(XXDynmcDataAMImpl)pageContext.getApplicationModule(webBean);
if(oam!=null)
{
OAViewDef viewdef=(OAViewDef)oam.getOADBTransaction().createViewDef();
viewdef.setSql(voquery);
OAViewObject vo=(OAViewObject)oam.createViewObject(“xxVO”,viewdef);
vo.executeQuery();
attrdef = vo.getAttributeDefs();
String quer=”SELECT * FROM DBMEMO_STATUS_NEW”;
Connection conn = pageContext.getApplicationModule(webBean).getOADBTransaction().getJdbcConnection();
PreparedStatement stmt1;

try {
stmt1 = conn.prepareStatement(quer);
ResultSet resultset = stmt1.executeQuery();
ResultSetMetaData rsmd = resultset.getMetaData();

NumOfCol=rsmd.getColumnCount();
System.out.println(“Query Executed!! No of Colm=”+NumOfCol);
} catch (SQLException e)
{
// TODO
}

OATableBean tabbean = (OATableBean)createWebBean(pageContext,TABLE_BEAN,null,”table”);
tabbean.setID(“TableBN”);
tabbean.setNumberOfRowsDisplayed(10);
tabbean.setWidth(“50%”);
tabbean.setUserCustomizable(true);
tabbean.setViewUsageName(“xxVO”);
while (i<NumOfCol)
{
String colprompt = attrdef[i].getName();
OAMessageStyledTextBean beans = (OAMessageStyledTextBean)createWebBean(pageContext,MESSAGE_STYLED_TEXT_BEAN,null,”beans”);
beans.setID(“col”+colprompt+”0”);
beans.setViewUsageName(“xxVO”);
beans.setViewAttributeName(colprompt);
beans.setLabel(colprompt);
beans.setUserCustomizable(true);
beans.setWrapEnabled(true);
beans.setDataType(“VARCHAR2”);

tabbean.addIndexedChild(beans);
webBean.addIndexedChild(tabbean);
i=i+1;
}

}
}

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

}