public static void deleteByColumnValue(final CConnection connection,final String tableName,final String columnName,final int columnValue) throws CouldntDeleteException {
  Preconditions.checkNotNull(connection,"IE00487: Connection argument can not be null");
  Preconditions.checkNotNull(tableName,"IE00499: Table name argument can not be null");
  Preconditions.checkNotNull(columnName,"IE00593: Column name argument can not be null");
  Preconditions.checkArgument(columnValue >= 0,"IE00594: Column value argument can not be smaller then zero");
  try {
    connection.executeUpdate(String.format("DELETE FROM %s WHERE %s = %d",tableName,columnName,columnValue),true);
  }
 catch (  final SQLException exception) {
    throw new CouldntDeleteException(exception);
  }
}

public static void deleteByColumnValue ( final CConnection connection , final String tableName , final String columnName , final int columnValue ) throws CouldntDeleteException { Preconditions . checkNotNull ( connection , "IE00487: Connection argument can not be null" ) ; Preconditions . checkNotNull ( tableName , "IE00499: Table name argument can not be null" ) ; Preconditions . checkNotNull ( columnName , "IE00593: Column name argument can not be null" ) ; Preconditions . checkArgument ( columnValue >= 0 , "IE00594: Column value argument can not be smaller then zero" ) ; try { connection . executeUpdate ( String . format ( "DELETE FROM %s WHERE %s = %d" , tableName , columnName , columnValue ) , true ) ; } catch ( final SQLException exception ) { throw new CouldntDeleteException ( exception ) ; } }
deletes all rows in the specified table column matching the column value specified .
