@Override public String getSqlWithValues() { final StringBuilder sb = new StringBuilder(); for (Map.Entry<String, Value> entry : resultMap.entrySet()) { if (sb.length() > 0) { sb.append(", "); } sb.append(entry.getKey()); sb.append(" = "); sb.append(entry.getValue() != null ? entry.getValue().toString() : new Value().toString()); } return sb.toString(); }
/** * Generates the query for the prepared statement with all parameter placeholders * replaced with the actual parameter values * * @return the SQL */ @Override public String getSqlWithValues() { final StringBuilder sb = new StringBuilder(); final String statementQuery = getStatementQuery(); // iterate over the characters in the query replacing the parameter placeholders // with the actual values int currentParameter = 0; for( int pos = 0; pos < statementQuery.length(); pos ++) { char character = statementQuery.charAt(pos); if( statementQuery.charAt(pos) == '?' && currentParameter <= parameterValues.size()) { // replace with parameter value Value value = parameterValues.get(currentParameter); sb.append(value != null ? value.toString() : new Value().toString()); currentParameter++; } else { sb.append(character); } } return sb.toString(); }
@Override public String getSqlWithValues() { final StringBuilder sb = new StringBuilder(); for (Map.Entry<String, Value> entry : resultMap.entrySet()) { if (sb.length() > 0) { sb.append(", "); } sb.append(entry.getKey()); sb.append(" = "); sb.append(entry.getValue() != null ? entry.getValue().toString() : new Value().toString()); } return sb.toString(); }
/** * Generates the query for the prepared statement with all parameter placeholders * replaced with the actual parameter values * * @return the SQL */ @Override public String getSqlWithValues() { final StringBuilder sb = new StringBuilder(); final String statementQuery = getStatementQuery(); // iterate over the characters in the query replacing the parameter placeholders // with the actual values int currentParameter = 0; for( int pos = 0; pos < statementQuery.length(); pos ++) { char character = statementQuery.charAt(pos); if( statementQuery.charAt(pos) == '?' && currentParameter <= parameterValues.size()) { // replace with parameter value Value value = parameterValues.get(currentParameter); sb.append(value != null ? value.toString() : new Value().toString()); currentParameter++; } else { sb.append(character); } } return sb.toString(); }