public String generateDeleteCommand(T item) throws NotImplementedTypesException { StringBuilder builder = new StringBuilder().append("delete from ").append(tableName).append(" where "); return "delete from " + tableName + " where " + primaryKeyFieldConverter.getName() + " = " + primaryKeyFieldConverter.stringValueOf(item); }
public String generateUpdateCommand(T item) throws NotImplementedTypesException { StringBuilder builder = new StringBuilder().append("update ").append(tableName).append(" set "); for (int i = 0; i + 1 < fields.size(); i++) { builder .append(fields.get(i).getName()) .append(" = ") .append(fields.get(i).stringValueOf(item)) .append(", "); } builder .append(fields.get(fields.size() - 1).getName()) .append(" = ") .append(fields.get(fields.size() - 1).stringValueOf(item)); builder.append(" where "); builder .append(primaryKeyFieldConverter.getName()) .append(" = ") .append(primaryKeyFieldConverter.stringValueOf(item)); return builder.toString(); }