@Override public String toString() { return convertToString(this.value); }
/** * Qoutes the passed {@code stringValue} if it's needed. * * @param stringValue * @param obj * @return */ private String quoteIfNeeded(String stringValue, Object obj) { if (stringValue == null) { return null; } /* * The following types do not get quoted: numeric, boolean * * It is tempting to use ParameterMetaData.getParameterType() for this * purpose as it would be safer. However, this method will fail with some * JDBC drivers. * * Oracle: Not supported until ojdbc7 which was released with Oracle 12c. * https://forums.oracle.com/thread/2584886 * * MySQL: The method call only works if service side prepared statements are * enabled. The URL parameter 'useServerPrepStmts=true' enables. */ if (Number.class.isAssignableFrom(obj.getClass()) || Boolean.class.isAssignableFrom(obj.getClass())) { return stringValue; } else { return "'" + escape(stringValue) + "'"; } }
result = "[binary]"; } else { result = toHexString((byte[]) value); result = quoteIfNeeded(result, value);
/** * Records the value of a parameter. * * @param name the name of the parameter * @param value the value of the parameter */ public void setParameterValue(final String name, final Object value) { namedParameterValues.put(name, new Value(value)); } }
result = "[binary]"; } else { result = toHexString((byte[]) value); result = quoteIfNeeded(result, value);
/** * Records the value of a parameter. * @param position the position of the parameter (starts with 1 not 0) * @param value the value of the parameter */ public void setParameterValue(final int position, final Object value) { parameterValues.put(position - 1, new Value(value)); }
@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(); }
public void setColumnValue(String columnName, Object value) { resultMap.put(columnName, new Value(value)); }
@Override public String toString() { return convertToString(this.value); }
/** * Qoutes the passed {@code stringValue} if it's needed. * * @param stringValue * @param obj * @return */ private String quoteIfNeeded(String stringValue, Object obj) { if (stringValue == null) { return null; } /* * The following types do not get quoted: numeric, boolean * * It is tempting to use ParameterMetaData.getParameterType() for this * purpose as it would be safer. However, this method will fail with some * JDBC drivers. * * Oracle: Not supported until ojdbc7 which was released with Oracle 12c. * https://forums.oracle.com/thread/2584886 * * MySQL: The method call only works if service side prepared statements are * enabled. The URL parameter 'useServerPrepStmts=true' enables. */ if (Number.class.isAssignableFrom(obj.getClass()) || Boolean.class.isAssignableFrom(obj.getClass())) { return stringValue; } else { return "'" + escape(stringValue) + "'"; } }
/** * 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(); }
/** * Records the value of a parameter. * @param position the position of the parameter (starts with 1 not 0) * @param value the value of the parameter */ public void setParameterValue(final int position, final Object value) { parameterValues.put(position - 1, new Value(value)); }
/** * Records the value of a parameter. * * @param name the name of the parameter * @param value the value of the parameter */ public void setParameterValue(final String name, final Object value) { namedParameterValues.put(name, new Value(value)); } }
@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(); }
public void setColumnValue(String columnName, Object value) { resultMap.put(columnName, new Value(value)); }
/** * 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(); }