Examples of org.springframework.jdbc.support.KeyHolder

Package org.springframework.jdbc.support

Examples of org.springframework.jdbc.support.KeyHolder

org.springframework.jdbc.support.KeyHolder
Interface for retrieving keys, typically used for auto-generated keys as potentially returned by JDBC insert statements.
Implementations of this interface can hold any number of keys. In the general case, the keys are returned as a List containing one Map for each row of keys.
Most applications only use on key per row and process only one row at a time in an insert statement. In these cases, just call getKey to retrieve the key. The returned value is a Number here, which is the usual type for auto-generated keys. @author Thomas Risberg @since 1.1 @see org.springframework.jdbc.core.JdbcTemplate @see org.springframework.jdbc.object.SqlUpdate


  
  @Transactional
  @Override
  public void create(final TaxRate taxRate) {
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getJdbcOperations().update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con)
          throws SQLException {
        String sql = "INSERT INTO "+quoteTable("tax_rate")+"(name, rate, type, geo_zone_id, date_added, date_modified) VALUES(?,?,?,?,?,?)";
        PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
        ps.setString(1, taxRate.getName());
        ps.setBigDecimal(2, taxRate.getRate());
        ps.setString(3, taxRate.getType());
        ps.setInt(4, taxRate.getGeoZoneId());
        Timestamp timestamp = new Timestamp(new Date().getTime());
        ps.setTimestamp(5, timestamp);
        ps.setTimestamp(6, timestamp);
        return ps;
      }
    }, keyHolder);
    
    int taxRateId = keyHolder.getKey().intValue();
    
    addCustomerGroupIds(taxRateId, taxRate.getCustomerGroupIds());
    
  }

View Full Code Here

  
  @Transactional
  @Override
  public void create(final WeightClass weightClass) {
    
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getJdbcOperations().update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con)
          throws SQLException {
        String sql = "INSERT INTO " +quoteTable("weight_class")+ "(value) VALUES(?) ";
        PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
        ps.setBigDecimal(1, weightClass.getValue());
        return ps;
      }
    }, keyHolder);
    Integer weightClassId = keyHolder.getKey().intValue();
    addDescsToWeightClass(weightClassId, weightClass.getDescs());
  }

View Full Code Here

      if(stockStatusId!=null){
        String sql = "INSERT INTO "+quoteTable("stock_status")+"(stock_status_id, language_id, name) VALUES(?, ?, ?)";
        getJdbcOperations().update(sql, stockStatusId, 
            stockStatus.getLanguageId(), stockStatus.getName());
      }else{
        KeyHolder keyHolder = new GeneratedKeyHolder();
        getJdbcOperations().update(new PreparedStatementCreator() {
          @Override
          public PreparedStatement createPreparedStatement(Connection con)
              throws SQLException {
            String sql = "INSERT INTO "+quoteTable("stock_status")+"(language_id, name) VALUES(?, ?)";
            PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            ps.setInt(1, stockStatus.getLanguageId());
            ps.setString(2, stockStatus.getName());
            return ps;
          }
        }, keyHolder);
        stockStatusId = keyHolder.getKey().intValue();
      }
    }
  }

View Full Code Here

      if(returnStatusId!=null){
        String sql = "INSERT INTO "+quoteTable("return_status")+"(return_status_id, language_id, name) VALUES(?, ?, ?)";
        getJdbcOperations().update(sql, returnStatusId, 
            returnStatus.getLanguageId(), returnStatus.getName());
      }else{
        KeyHolder keyHolder = new GeneratedKeyHolder();
        getJdbcOperations().update(new PreparedStatementCreator() {
          @Override
          public PreparedStatement createPreparedStatement(Connection con)
              throws SQLException {
            String sql = "INSERT INTO "+quoteTable("return_status")+"(language_id, name) VALUES(?, ?)";
            PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            ps.setInt(1, returnStatus.getLanguageId());
            ps.setString(2, returnStatus.getName());
            return ps;
          }
        }, keyHolder);
        returnStatusId = keyHolder.getKey().intValue();
      }
    }
  }

View Full Code Here

  
  @Transactional
  @Override
  public void create(final VoucherThemeForm vtForm) {
    
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getJdbcOperations().update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con)
          throws SQLException {
        String sql = "INSERT INTO "+quoteTable("voucher_theme")+" SET image = ?";
        PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
        ps.setString(1, vtForm.getImage());
        return ps;
      }
    }, keyHolder);
    Integer attrId = keyHolder.getKey().intValue();
    vtForm.setId(attrId);
    setAdditionalFormValues(vtForm);
  }

View Full Code Here

      if(returnReasonId!=null){
        String sql = "INSERT INTO "+quoteTable("return_reason")+"(return_reason_id, language_id, name) VALUES(?, ?, ?)";
        getJdbcOperations().update(sql, returnReasonId, 
            returnReason.getLanguageId(), returnReason.getName());
      }else{
        KeyHolder keyHolder = new GeneratedKeyHolder();
        getJdbcOperations().update(new PreparedStatementCreator() {
          @Override
          public PreparedStatement createPreparedStatement(Connection con)
              throws SQLException {
            String sql = "INSERT INTO "+quoteTable("return_reason")+"(language_id, name) VALUES(?, ?)";
            PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            ps.setInt(1, returnReason.getLanguageId());
            ps.setString(2, returnReason.getName());
            return ps;
          }
        }, keyHolder);
        returnReasonId = keyHolder.getKey().intValue();
      }
    }
  }

View Full Code Here

      if(returnActionId!=null){
        String sql = "INSERT INTO "+quoteTable("return_action")+"(return_action_id, language_id, name) VALUES(?, ?, ?)";
        getJdbcOperations().update(sql, returnActionId, 
            returnAction.getLanguageId(), returnAction.getName());
      }else{
        KeyHolder keyHolder = new GeneratedKeyHolder();
        getJdbcOperations().update(new PreparedStatementCreator() {
          @Override
          public PreparedStatement createPreparedStatement(Connection con)
              throws SQLException {
            String sql = "INSERT INTO "+quoteTable("return_action")+"(language_id, name) VALUES(?, ?)";
            PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            ps.setInt(1, returnAction.getLanguageId());
            ps.setString(2, returnAction.getName());
            return ps;
          }
        }, keyHolder);
        returnActionId = keyHolder.getKey().intValue();
      }
    }
  }

View Full Code Here

  
  @Transactional
  @Override
  public void create(final CustomerGroupForm cgForm) {
    
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getJdbcOperations().update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con)
          throws SQLException {
        String sql = "INSERT INTO "+quoteTable("customer_group")+" SET approval = ?, sort_order = ?";
        PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
        ps.setInt(1, cgForm.getApproval());
        ps.setInt(2, cgForm.getSortOrder());
        return ps;
      }
    }, keyHolder);
    Integer attrId = keyHolder.getKey().intValue();
    cgForm.setId(attrId);
    setAdditionalFormValues(cgForm);
  }

View Full Code Here

  
  @Transactional
  @Override
  public void create(final LengthClassForm lc) {
    
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getJdbcOperations().update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con)
          throws SQLException {
        String sql = "INSERT INTO " +quoteTable("length_class")+ "(value) VALUES(?) ";
        PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
        ps.setBigDecimal(1, lc.getValue());
        return ps;
      }
    }, keyHolder);
    Integer lcId = keyHolder.getKey().intValue();
    addDescsToLengthClass(lcId, lc.getDescs());
    lc.setId(lcId);
  }

View Full Code Here

    }
    
    protected String storeSerializedState(HttpServletRequest request, final byte[] state) throws Exception
    {
        final int rnd = random.nextInt();
        KeyHolder keyHolder = new GeneratedKeyHolder();
        jdbcOperations.update(
                new PreparedStatementCreator()
                {
                    public PreparedStatement createPreparedStatement(Connection con)
                    throws SQLException
                    {
                        PreparedStatement statement = con.prepareStatement(
                                insertQuery, Statement.RETURN_GENERATED_KEYS);
                        statement.setBytes(1, state);
                        statement.setInt(2, rnd);
                        return statement;
                    };
                }, keyHolder);
        return rnd + (SEPARATOR + keyHolder.getKey().toString());
    }

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of org.springframework.jdbc.support.KeyHolder

br.com.cwi.tnt.rfp.arquitetura2.repository.GridEntityDataRepository

br.com.cwi.tnt.rfp.arquitetura2.repository.SingleRowEntityDataRepository

com.cardence.lawshelf.model.impl.JdbcCodeCollectionDao

com.cardence.lawshelf.model.impl.JdbcCodeDao

com.cardence.lawshelf.model.impl.JdbcContentFullDao

com.cardence.lawshelf.model.impl.JdbcContentPartDao

com.cardence.lawshelf.model.impl.JdbcSectionDao

com.jpoweredcart.admin.model.catalog.impl.AttributeAdminModelImpl

com.jpoweredcart.admin.model.catalog.impl.AttributeGroupAdminModelImpl

com.jpoweredcart.admin.model.catalog.impl.CategoryAdminModelImpl

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.