public final String evalSqlUpdate(final String pTable,
    final ColumnsValues pColumnsVals,
      final String pWhere) throws Exception {
    StringBuffer result = new StringBuffer("update "
      + pTable + " set \n");
    boolean isFirstField = true;
    ColumnsValues cv = filterCv(pColumnsVals, false);
    for (String key : cv.getIntegersMap().keySet()) {
      if (isFirstField) {
        isFirstField = false;
      } else {
        result.append(", ");
      }
      result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
    }
    for (String key : cv.getLongsMap().keySet()) {
      if (isFirstField) {
        isFirstField = false;
      } else {
        result.append(", ");
      }
      result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
    }
    for (String key : cv.getFloatsMap().keySet()) {
      if (isFirstField) {
        isFirstField = false;
      } else {
        result.append(", ");
      }
      result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
    }
    for (String key : cv.getDoublesMap().keySet()) {
      if (isFirstField) {
        isFirstField = false;
      } else {
        result.append(", ");
      }
      result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
    }
    for (String key : cv.getStringsMap().keySet()) {
      if (isFirstField) {
        isFirstField = false;
      } else {
        result.append(", ");
      }
      result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
    }
    if (pWhere != null) {
    result.append(" where " + pWhere);
    }
    result.append(";\n");
    return result.toString();
  }
public final String evalSqlUpdate ( final String pTable , final ColumnsValues pColumnsVals , final String pWhere ) throws Exception { StringBuffer result = new StringBuffer ( "update " + pTable + " set \n" ) ; boolean isFirstField = true ; ColumnsValues cv = filterCv ( pColumnsVals , false ) ; for ( String key : cv . getIntegersMap ( ) . keySet ( ) ) { if ( isFirstField ) { isFirstField = false ; } else { result . append ( ", " ) ; } result . append ( key . toUpperCase ( ) + "=" + cv . evalSqlValue ( key ) ) ; } for ( String key : cv . getLongsMap ( ) . keySet ( ) ) { if ( isFirstField ) { isFirstField = false ; } else { result . append ( ", " ) ; } result . append ( key . toUpperCase ( ) + "=" + cv . evalSqlValue ( key ) ) ; } for ( String key : cv . getFloatsMap ( ) . keySet ( ) ) { if ( isFirstField ) { isFirstField = false ; } else { result . append ( ", " ) ; } result . append ( key . toUpperCase ( ) + "=" + cv . evalSqlValue ( key ) ) ; } for ( String key : cv . getDoublesMap ( ) . keySet ( ) ) { if ( isFirstField ) { isFirstField = false ; } else { result . append ( ", " ) ; } result . append ( key . toUpperCase ( ) + "=" + cv . evalSqlValue ( key ) ) ; } for ( String key : cv . getStringsMap ( ) . keySet ( ) ) { if ( isFirstField ) { isFirstField = false ; } else { result . append ( ", " ) ; } result . append ( key . toUpperCase ( ) + "=" + cv . evalSqlValue ( key ) ) ; } if ( pWhere != null ) { result . append ( " where " + pWhere ) ; } result . append ( ";\n" ) ; return result . toString ( ) ; }
<p>Evaluate SQL update statement.
</p>
@param pTable table name
@param pColumnsVals type-safe map column name - column value
@param pWhere where conditions e.g. "itsId=2 AND itsVersion=2"
@return row count affected
@throws Exception - an exception