Examples of SqlParameter

cn.org.rapid_framework.generator.provider.db.sql.model.SqlParameter
org.springframework.jdbc.core.SqlParameter
Object to represent a SQL parameter definition.
Parameters may be anonymous, in which case "name" is null. However, all parameters must define a SQL type according to {@link java.sql.Types}. @author Rod Johnson @author Thomas Risberg @author Juergen Hoeller @see java.sql.Types

Examples of org.springframework.jdbc.core.SqlParameter

            return authority;
        }


        protected CustomAuthoritiesByUsernameMapping(DataSource ds) {
            super(ds, CustomJdbcDaoImpl.this.getAuthoritiesByUsernameQuery());
            declareParameter(new SqlParameter(Types.VARCHAR));
            declareParameter(new SqlParameter(Types.VARCHAR));
            declareParameter(new SqlParameter(Types.VARCHAR));
            compile();
        }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter


  class SelectByName extends AbstractSelect {


    public SelectByName(DataSource dataSource) {
      super(dataSource, SELECT_BY_NAME_SQL);
      declareParameter(new SqlParameter(Types.VARCHAR));
    }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

  }
  
  class Update extends SqlUpdate {
    public Update(DataSource dataSource) {
      super(dataSource, UPDATE_SQL);
      declareParameter(new SqlParameter(Types.VARCHAR));  // Name
      declareParameter(new SqlParameter(Types.INTEGER));  // TestId
    }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

  }
  
  class Delete extends SqlUpdate {
    public Delete(DataSource dataSource) {
      super(dataSource, DELETE_SQL);
      declareParameter(new SqlParameter(Types.INTEGER));  // TestId
    }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

  }


  class Insert extends SqlUpdate {
    public Insert(DataSource dataSource) {
      super(dataSource, INSERT_SQL);
      declareParameter(new SqlParameter(Types.VARCHAR));  // Name
    }

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

    List paramNames = parsedSql.getParameterNames();
    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

Examples of org.springframework.jdbc.core.SqlParameter

   */
  private static SqlParameter findParameter(List declaredParams, String paramName, int paramIndex) {
    if (declaredParams != null) {
      // First pass: Look for named parameter match.
      for (Iterator it = declaredParams.iterator(); it.hasNext();) {
        SqlParameter declaredParam = (SqlParameter) it.next();
        if (paramName.equals(declaredParam.getName())) {
          return declaredParam;
        }
      }
      // Second pass: Look for parameter index match.
      if (paramIndex < declaredParams.size()) {
        SqlParameter declaredParam = (SqlParameter) declaredParams.get(paramIndex);
        // Only accept unnamed parameters for index matches.
        if (declaredParam.getName() == null) {
          return declaredParam;
        }
      }
    }
    return null;

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

    List paramNames = parsedSql.getParameterNames();
    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

Examples of org.springframework.jdbc.core.SqlParameter

   */
  private static SqlParameter findParameter(List declaredParams, String paramName, int paramIndex) {
    if (declaredParams != null) {
      // First pass: Look for named parameter match.
      for (Iterator it = declaredParams.iterator(); it.hasNext();) {
        SqlParameter declaredParam = (SqlParameter) it.next();
        if (paramName.equals(declaredParam.getName())) {
          return declaredParam;
        }
      }
      // Second pass: Look for parameter index match.
      if (paramIndex < declaredParams.size()) {
        SqlParameter declaredParam = (SqlParameter) declaredParams.get(paramIndex);
        // Only accept unnamed parameters for index matches.
        if (declaredParam.getName() == null) {
          return declaredParam;
        }
      }
    }
    return null;

View Full Code Here

Examples of org.springframework.jdbc.core.SqlParameter

  public SqlParameter createDefaultOutParameter(String parameterName, CallParameterMetaData meta) {
    return new SqlOutParameter(parameterName, meta.getSqlType());
  }


  public SqlParameter createDefaultInParameter(String parameterName, CallParameterMetaData meta) {
    return new SqlParameter(parameterName, meta.getSqlType());    
  }

View Full Code Here

0 1 2 3 4 5

TOP

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.