@Override public SELF value(String colName, Long value) { return addValue(colName, new ParamLong(next(), value)); }
@Override public SELF value(String colName, String value) { return addValue(colName, new ParamString(next(), value)); }
@Override public SELF value(String colName, Boolean value) { return addValue(colName, new ParamBoolean(next(), value)); }
@Override public SELF value(String colName, Double value) { return addValue(colName, new ParamDouble(next(), value)); }
@Override public SELF value(String colName, Long value) { return addValue(colName, new ParamLong(next(), value)); }
public String toUpdate(PrimaryKey primaryKey) { int insertValueListSize = insertValueList.size(); List<String> columnNameList = new ArrayList<>(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.toUpdate()); } String columns = columnNameList.stream().collect(Collectors.joining(",")); String keyColumn = primaryKey.columnName(); Object val = primaryKey.value(); addValue(keyColumn, paramValue(next(), val)); return String.format("update %s set %s where `%s`=?", table, columns, primaryKey.columnName()); }
@Override public SELF value(String colName, BigDecimal value) { return addValue(colName, new ParamBigDecimal(next(), value)); }
@Override public SELF value(String colName, java.util.Date value) { return addValue(colName, new ParamDate(next(), value)); }
@Override public SELF value(String colName, LocalDateTime value) { return addValue(colName, new ParamLocalDateTime(next(), value)); }
@Override public SELF value(String colName, Integer value) { return addValue(colName, new ParamInt(next(), value)); }
@Override public SELF value(String colName, BigDecimal value) { return addValue(colName, new ParamBigDecimal(next(), value)); }
@Override public SELF value(String colName, java.util.Date value) { return addValue(colName, new ParamDate(next(), value)); }
@Override public SELF value(String colName, Double value) { return addValue(colName, new ParamDouble(next(), value)); }
@Override public SELF value(String colName, Float value) { return addValue(colName, new ParamFloat(next(), value)); }
public String toUpdate(PrimaryKey primaryKey) { int insertValueListSize = insertValueList.size(); List<String> columnNameList = new ArrayList<>(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.toUpdate()); } String columns = columnNameList.stream().collect(Collectors.joining(",")); String keyColumn = primaryKey.columnName(); Object val = primaryKey.value(); addValue(keyColumn, paramValue(next(), val)); return String.format("update %s set %s where `%s`=?", table, columns, primaryKey.columnName()); }
@Override public SELF value(String colName, String value) { return addValue(colName, new ParamString(next(), value)); }
@Override public SELF value(String colName, Boolean value) { return addValue(colName, new ParamBoolean(next(), value)); }
@Override public SELF value(String colName, Integer value) { return addValue(colName, new ParamInt(next(), value)); }
@Override public SELF value(String colName, LocalDate value) { return addValue(colName, new ParamLocalDate8(next(), value)); }
@Override public SELF value(String colName, LocalDateTime value) { return addValue(colName, new ParamLocalDateTime(next(), value)); }