Two ways to assign detail view

import oracle.jbo.client.Configuration;
import oracle.jbo.*;
import oracle.jbo.domain.Number;
public class Test { public static void main(String[] args) {
String _am = "test.TestModule", _cf = "TestModuleLocal";
ApplicationModule am = Configuration.createRootApplicationModule(_am,_cf);
ViewObject lines = am.findViewObject("TopLevelLineItemView");
/* * You can use createAndInitRow() to supply the needed
* foreign key value to order at line row create time. */
Row newLine = lines.createAndInitRow(new NameValuePairs(new String[]{"Orderid"}, newObject[]{new Number(12345)}));
newLine.setAttribute("Itemid", "CRU-1234");
newLine.setAttribute("Quantity", new Number(1));
lines.insertRow(newLine);
/* * Or else, you can get a row of the parent view */
ViewObject orders = am.findViewObject("OrderView");
/* * Just use the first order in the view as an example */
Row existingOrder = orders.first();
/* * Then get the details iterator via the View Link attribute accessor */
RowIterator linesIter = (RowIterator)existingOrder.getAttribute("LinesItemsForOrder");
/* * Then use this iterator to create the new Line */
newLine = linesIter.createRow();
linesIter.insertRow(newLine);
newLine.setAttribute("Itemid", "XYZ-1234");
newLine.setAttribute("Quantity", new Number(4));
am.getTransaction().postChanges();
/* * Everything worked, so rollback so we don't actually create the new rows */ am.getTransaction().rollback();
Configuration.releaseRootApplicationModule(am,true);
}
}

Message Box In ADF & Validators

FacesMessage fm = new FacesMessage("Format of officel Email is incorrect"); FacesContext Context = FacesContext.getCurrentInstance(); Context.addMessage(null,fm);


public void checkEmail1(FacesContext facesContext, UIComponent uIComponent, Object object) {
// Add event code here...
String email=(String)object;
if(email.indexOf("@")<=0 email.indexOf(".")<=0) {
FacesMessage fm = new FacesMessage("Format of officel Email is incorrect"); FacesContext Context = FacesContext.getCurrentInstance(); Context.addMessage(null,fm);
//checkEmailFormat(facesContext,uIComponent,object,"Invalid office email");
}

ADF:Display Selected table row

public void ChangeListener(SelectionEvent selectionEvent) {
// Add event code here...
String amDef = "parameter.AppModule";
String config = "AppModuleLocal";
ApplicationModule am = Configuration.createRootApplicationModule(amDef, config); ViewObject vo = am.findViewObject("ParamMastView1");
ArrayList rows = new ArrayList();
Object[] ss=table1.getSelectedRowKeys().toArray();
RowKeySet rr=table1.getSelectedRowKeys();
Iterator it=rr.iterator
Object ky=it.next();
List kk=(List)ky;
ListIterator LItr = kk.listIterator();
Key kk1=(Key)LItr.next();
System.out.println(kk1);
Row[] selectedRows = vo.findByKey(kk1,1);
Row voRow = selectedRows[0];
System.out.println(" ["+voRow.getAttribute("ParamId")+"] "+ voRow.getAttribute("ParamName")+": "+
voRow.getAttribute("ParamValue"));
Object o = table1.getSelectedRowData();
JUCtrlHierNodeBinding rowData = (JUCtrlHierNodeBinding)o;
Row row = rowData.getRow();
System.out.println(row.getAttribute(0));
RowKeySet rowSet = table1.getSelectedRowKeys();
Iterator rowSetIter = rowSet.iterator();
//DCBindingContainer bindings = this.getBindingContainer();
// DCIteratorBinding iter = bindings.findIteratorBinding("DeptView1Iterator");
DCBindingContainer dcBindings = (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
DCIteratorBinding iter = dcBindings.findIteratorBinding("MenuView1Iterator");
while (rowSetIter.hasNext()) {
List l = (List)rowSetIter.next();
Key key = (Key)l.get(0);
iter.setCurrentRowWithKey(key.toStringFormat(true));
Row r = iter.getCurrentRow();
System.out.println("selected dept " + r.getAttribute("MenuName"));
}

ADF:Calling PLSQL Package using jdbc connection

ArrayList rows = new ArrayList();
private static String connectUrl = "jdbc:oracle:thin:@10.201.1.32:1521:XE";
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection(connectUrl, "HR", "oracle");
//Statement s = con.createStatement();
//ResultSet rs = s.executeQuery("Select * from employees");
//while (rs.next()){
//System.out.println(rs.getString(2)); //}
oracle.jdbc.OracleCallableStatement ocs = null;
oracle.sql.StructDescriptor structDesc = StructDescriptor.createDescriptor("EMP_REC", con);
oracle.sql.ArrayDescriptor arrayDesc = ArrayDescriptor.createDescriptor("EMP_TABLE", con);
ArrayList arr = new ArrayList();
String[] objName;
ListIterator LItr = rows.listIterator();
while (LItr.hasNext()) {
// objName=(String[])LItr.next();
// Object [] singleobj = {
// objName[0],objName[1],objName[2]
// };
oracle.sql.STRUCT p1struct = new STRUCT(structDesc, con, (Object[])LItr.next()); //singleobj);
arr.add(p1struct);
}
oracle.sql.ARRAY newArray = new ARRAY(arrayDesc, con, arr.toArray());
ocs =
//(OracleCallableStatement)con.prepareCall("begin PK_PROD.INSERT_PROD1; end;");
(OracleCallableStatement)con.prepareCall("begin PK_PROD.INSERT_PROD(:1); end;"); ocs.setARRAY(1, newArray);
ocs.execute();
con.commit();
con.close();
ocs.close();

Changing view Objects & refreshing coresponding controls

FacesContext fctx = FacesContext.getCurrentInstance();
ValueBinding vb1 = fctx.getApplication().createValueBinding("#{bindings.ViewObj1Iterator}");
DCIteratorBinding UserListView = (DCIteratorBinding)vb1.getValue(fctx);
ViewObject vo = UserListView.getViewObject
vo.setNamedWhereClauseParam("PRole_id",1);
vo.executeQuery();

ADF Page Load event & post back

@PostConstruct

protected void OnLoad(){

if(!isPostback()){

System.out.println("test");

} }

private boolean isPostback() {

return Boolean.TRUE.equals(resolveExpression("#{adfFacesContext.postback}"));

}

private Object resolveExpression(String expression) {

FacesContext ctx = FacesContext.getCurrentInstance(); Application app = ctx.getApplication();

ValueBinding bind = app.createValueBinding(expression); return bind.getValue(ctx);

}