public PreparedStatementCreatorImpl(String actualSql, List<?> parameters) { this.actualSql = actualSql; Assert.notNull(parameters, "Parameters List must not be null"); this.parameters = parameters; if (this.parameters.size() != declaredParameters.size()) { // Account for named parameters being used multiple times Set<String> names = new HashSet<>(); for (int i = 0; i < parameters.size(); i++) { Object param = parameters.get(i); if (param instanceof SqlParameterValue) { names.add(((SqlParameterValue) param).getName()); } else { names.add("Parameter #" + i); } } if (names.size() != declaredParameters.size()) { throw new InvalidDataAccessApiUsageException( "SQL [" + sql + "]: given " + names.size() + " parameters but expected " + declaredParameters.size()); } } }
protected List<SqlParameterValue[]> getParams(Bean[] beans,SqlParameterValue[] values) { List<SqlParameterValue[]> params = new ArrayList<SqlParameterValue[]>(); params.add(values); for (int i = 1; i < beans.length; i++) { Bean bean=beans[i]; SqlParameterValue[] param=new SqlParameterValue[values.length]; for (int j = 0; j < values.length; j++) { SqlParameterValue value=values[j]; param[j]=new SqlParameterValue(value,bean.getProperty(value.getName())); } params.add(param); } return params; }
public PreparedStatementCreatorImpl(String actualSql, List<?> parameters) { this.actualSql = actualSql; Assert.notNull(parameters, "Parameters List must not be null"); this.parameters = parameters; if (this.parameters.size() != declaredParameters.size()) { // Account for named parameters being used multiple times Set<String> names = new HashSet<>(); for (int i = 0; i < parameters.size(); i++) { Object param = parameters.get(i); if (param instanceof SqlParameterValue) { names.add(((SqlParameterValue) param).getName()); } else { names.add("Parameter #" + i); } } if (names.size() != declaredParameters.size()) { throw new InvalidDataAccessApiUsageException( "SQL [" + sql + "]: given " + names.size() + " parameters but expected " + declaredParameters.size()); } } }
public PreparedStatementCreatorImpl(String actualSql, List parameters) { this.actualSql = actualSql; Assert.notNull(parameters, "Parameters List must not be null"); this.parameters = parameters; if (this.parameters.size() != declaredParameters.size()) { // account for named parameters being used multiple times Set<String> names = new HashSet<String>(); for (int i = 0; i < parameters.size(); i++) { Object param = parameters.get(i); if (param instanceof SqlParameterValue) { names.add(((SqlParameterValue) param).getName()); } else { names.add("Parameter #" + i); } } if (names.size() != declaredParameters.size()) { throw new InvalidDataAccessApiUsageException( "SQL [" + sql + "]: given " + names.size() + " parameters but expected " + declaredParameters.size()); } } }
protected List<SqlParameterValue[]> getParams(Bean[] beans, SqlParameterValue[] values) { List<SqlParameterValue[]> params = new ArrayList<SqlParameterValue[]>(); params.add(values); for (int i = 1; i < beans.length; i++) { Bean bean = beans[i]; SqlParameterValue[] param = new SqlParameterValue[values.length]; for (int j = 0; j < values.length; j++) { SqlParameterValue value = values[j]; param[j] = new SqlParameterValue(value, bean.getProperty(value .getName())); } params.add(param); } return params; }