OAF 页面初始化的基本代码形式一览

 // Initialize and execute the query  

public void initQuery(String name, String onHold, String number) {
StringBuffer whereClause = new StringBuffer(100);
Vector parameters = new Vector(3);
int clauseCount = 0; int bindCount = 0;
setWhereClauseParams(null);
// Always reset
if ((name != null) && (!(“”.equals(name.trim())))){
whereClause.append(” NAME like :”);
whereClause.append(++bindCount);
parameters.addElement(name + “%”);
}
if ((number != null) && (!(“”Equals(number.trim())))){
Number supplierId = null;
try{
supplierId = new Number(number);

           }         
   if (clauseCount > 0){ 
      whereClause.append(" AND "); 
          }   
      whereClause.append(" SUPPLIER_ID = :");    
      whereClause.append(++bindCount);       
      parameters.addElement(supplierId);   
      clauseCount++;  
               }  
 if ((onHold != null) && (!(""Equals(onHold.trim())))){   
   if (clauseCount > 0){    
          whereClause.append(" AND ");     
          whereClause.append(" ON_HOLD_FLAG = :"); 
          whereClause.append(++bindCount);    
          parameters.addElement("Y");   
         clauseCount++;      }      
         setWhereClause(whereClause.toString());  
   if (bindCount > 0){      
     parameters.copyInto(params);        
     setWhereClauseParams(params);  
     executeQuery();  } // end initQuery( )