Examples of org.springframework.jdbc.core.SqlParameterValue

org.springframework.jdbc.core.SqlParameterValue
Object to represent a SQL parameter value, including parameter metadata such as the SQL type and the scale for numeric values.
Designed for use with {@link JdbcTemplate}'s operations that take an array of argument values: Each such argument value may be a SqlParameterValue, indicating the SQL type (and optionally the scale) instead of letting the template guess a default type. Note that this only applies to the operations with a 'plain' argument array, not to the overloaded variants with an explicit type array. @author Juergen Hoeller @since 2.0.5 @see java.sql.Types @see JdbcTemplate#query(String,Object[],ResultSetExtractor) @see JdbcTemplate#query(String,Object[],RowCallbackHandler) @see JdbcTemplate#query(String,Object[],RowMapper) @see JdbcTemplate#update(String,Object[])

    for (int i = 0; i < paramNames.size(); i++) {
      String paramName = (String) paramNames.get(i);
      try {
        Object value = paramSource.getValue(paramName);
        SqlParameter param = findParameter(declaredParams, paramName, i);
        paramArray[i] = (param != null ? new SqlParameterValue(param, value) : value);
      }
      catch (IllegalArgumentException ex) {
        throw new InvalidDataAccessApiUsageException(
            "No value supplied for the SQL parameter '" + paramName + "': " + ex.getMessage());
      }

View Full Code Here

    for (int i = 0; i < paramNames.size(); i++) {
      String paramName = (String) paramNames.get(i);
      try {
        Object value = paramSource.getValue(paramName);
        SqlParameter param = findParameter(declaredParams, paramName, i);
        paramArray[i] = (param != null ? new SqlParameterValue(param, value) : value);
      }
      catch (IllegalArgumentException ex) {
        throw new InvalidDataAccessApiUsageException(
            "No value supplied for the SQL parameter '" + paramName + "': " + ex.getMessage());
      }

View Full Code Here

   * @return the value object
   */
  public static Object getTypedValue(SqlParameterSource source, String parameterName) {
    int sqlType = source.getSqlType(parameterName);
    if (sqlType != SqlParameterSource.TYPE_UNKNOWN) {
      return new SqlParameterValue(sqlType, source.getValue(parameterName));
    }
    else {
      return source.getValue(parameterName);
    }
  }

View Full Code Here

    for (int i = 0; i < paramNames.size(); i++) {
      String paramName = paramNames.get(i);
      try {
        Object value = paramSource.getValue(paramName);
        SqlParameter param = findParameter(declaredParams, paramName, i);
        paramArray[i] = (param != null ? new SqlParameterValue(param, value) : value);
      }
      catch (IllegalArgumentException ex) {
        throw new InvalidDataAccessApiUsageException(
            "No value supplied for the SQL parameter '" + paramName + "': " + ex.getMessage());
      }

View Full Code Here

   */
  public static Object getTypedValue(SqlParameterSource source, String parameterName) {
    int sqlType = source.getSqlType(parameterName);
    if (sqlType != SqlParameterSource.TYPE_UNKNOWN) {
      if (source.getTypeName(parameterName) != null) {
        return new SqlParameterValue(sqlType, source.getTypeName(parameterName), source.getValue(parameterName));
      }
      else {
        return new SqlParameterValue(sqlType, source.getValue(parameterName));
      }
    }
    else {
      return source.getValue(parameterName);
    }

View Full Code Here

    for (int i = 0; i < paramNames.size(); i++) {
      String paramName = (String) paramNames.get(i);
      try {
        Object value = paramSource.getValue(paramName);
        SqlParameter param = findParameter(declaredParams, paramName, i);
        paramArray[i] = (param != null ? new SqlParameterValue(param, value) : value);
      }
      catch (IllegalArgumentException ex) {
        throw new InvalidDataAccessApiUsageException(
            "No value supplied for the SQL parameter '" + paramName + "': " + ex.getMessage());
      }

View Full Code Here

   */
  public static Object getTypedValue(SqlParameterSource source, String parameterName) {
    int sqlType = source.getSqlType(parameterName);
    if (sqlType != SqlParameterSource.TYPE_UNKNOWN) {
      if (source.getTypeName(parameterName) != null) {
        return new SqlParameterValue(sqlType, source.getTypeName(parameterName), source.getValue(parameterName));
      }
      else {
        return new SqlParameterValue(sqlType, source.getValue(parameterName));
      }
    }
    else {
      return source.getValue(parameterName);
    }

View Full Code Here

  private void doSetStatementParameters(Object[] values, PreparedStatement ps, int[] columnTypes) throws SQLException {
    int colIndex = 0;
    for (Object value : values) {
      colIndex++;
      if (value instanceof SqlParameterValue) {
        SqlParameterValue paramValue = (SqlParameterValue) value;
        StatementCreatorUtils.setParameterValue(ps, colIndex, paramValue, paramValue.getValue());
      }
      else {
        int colType;
        if (columnTypes == null || columnTypes.length < colIndex) {
          colType = SqlTypeValue.TYPE_UNKNOWN;

View Full Code Here

    for (int i = 0; i < paramNames.size(); i++) {
      String paramName = (String) paramNames.get(i);
      try {
        Object value = paramSource.getValue(paramName);
        SqlParameter param = findParameter(declaredParams, paramName, i);
        paramArray[i] = (param != null ? new SqlParameterValue(param, value) : value);
      }
      catch (IllegalArgumentException ex) {
        throw new InvalidDataAccessApiUsageException(
            "No value supplied for the SQL parameter '" + paramName + "': " + ex.getMessage());
      }

View Full Code Here


    replay();


    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(mockDataSource);
    Map params = new HashMap();
    params.put("perfId", new SqlParameterValue(Types.DECIMAL, new Integer(1)));
    params.put("priceId", new SqlParameterValue(Types.INTEGER, new Integer(1)));
    assertEquals("result", jt.execute(UPDATE_NAMED_PARAMETERS, params, new PreparedStatementCallback() {
      public Object doInPreparedStatement(PreparedStatement ps) throws SQLException {
        assertEquals(mockPreparedStatement, ps);
        ps.executeUpdate();
        return "result";

View Full Code Here

0 1 2 3

TOP

Related Classes of org.springframework.jdbc.core.SqlParameterValue

com.opengamma.masterdb.batch.AbstractDbBatchMasterWorkerTest

com.opengamma.masterdb.config.AbstractDbConfigMasterWorkerTest

com.opengamma.masterdb.exchange.AbstractDbExchangeMasterWorkerTest

com.skyline.energy.provider.spring.BatchPreparedStatementSetterCreator

com.skyline.energy.provider.spring.PreparedStatementCreatorFactory

com.taobao.tddl.common.jdbc.ArgPreparedStatementSetter

net.paoding.rose.jade.dataaccess.DataAccessImpl

org.springframework.jdbc.core.namedparam.MapSqlParameterSource

org.springframework.jdbc.core.namedparam.MapSqlParameterSourceTests

org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplateTests

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.