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

来源：互联网发布：数据库查询怎么保存编辑：程序博客网时间：2024/06/07 03:46

 // 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( )

阅读全文

0 0