public static void deleteExisitingRows(String table,String filter,Connection connection){
  table=table.replace(";","");
  filter=filter.replace(";","");
  StringBuilder deleteRowsQuery=new StringBuilder();
  deleteRowsQuery.append("DELETE FROM ");
  deleteRowsQuery.append(table);
  deleteRowsQuery.append(" WHERE USED_FILTER='");
  deleteRowsQuery.append(filter);
  deleteRowsQuery.append("'");
  LOG.info("Delete rows: ");
  LOG.info(deleteRowsQuery);
  executeStatementIfExists(deleteRowsQuery.toString(),connection);
}

public static void deleteExisitingRows ( String table , String filter , Connection connection ) { table = table . replace ( ";" , "" ) ; filter = filter . replace ( ";" , "" ) ; StringBuilder deleteRowsQuery = new StringBuilder ( ) ; deleteRowsQuery . append ( "DELETE FROM " ) ; deleteRowsQuery . append ( table ) ; deleteRowsQuery . append ( " WHERE USED_FILTER='" ) ; deleteRowsQuery . append ( filter ) ; deleteRowsQuery . append ( "'" ) ; LOG . info ( "Delete rows: " ) ; LOG . info ( deleteRowsQuery ) ; executeStatementIfExists ( deleteRowsQuery . toString ( ) , connection ) ; }
deletes existing rows from a given table , conditions are passed in as well
