Saturday, November 21, 2009

OAF : Set the Where Clause at Run Time.

Put the below code into xxxAMImpl.java
------------------------------------------------

public void empSearch(){

String ssn="1001";
String name="Neelmani";
EmployeesVOImpl empVO = getEmployeesVO3();
empVO.setWhereClause("EMP_SSN = :1 AND EMP_NAME = :2");
empVO.setWhereClauseParam(0,ssn);
empVO.setWhereClauseParam(1,name);
empVO.executeQuery();
}