protected void writeRow(ResultSet set, T item) throws java.sql.SQLException, IllegalAccessException { for (FieldConverter field : fields) { if (field.getField().getType().equals(Integer.class)) { field.getField().set(item, set.getInt(field.getName())); } if (field.getField().getType().equals(String.class)) { field.getField().set(item, set.getString(field.getName())); } } }
public String generateSelectOneByPrimaryKeyCommand(Object key) throws NotImplementedTypesException { return "select * from " + tableName + " where " + primaryKeyFieldConverter.getName() + " = " + stringValueOf(key); }
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(); }