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