Examples of KeyHolder

Examples of org.springframework.jdbc.support.KeyHolder

32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
 
  @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

Examples of org.springframework.jdbc.support.KeyHolder

35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
 
  @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

Examples of org.springframework.jdbc.support.KeyHolder

137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
    }
   
    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

Examples of org.springframework.jdbc.support.KeyHolder

122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
      }
      else if (entity.getId() != null) {
        returnCode = executeStatementSet(stmtSet);
      }
      else {
        KeyHolder keyHolder = new GeneratedKeyHolder();
        returnCode = jdbcTemplate.update(new PreparedStatementCreator() {
 
          public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
           
            LOG.info("Model INFO :" + stmtSet.getSql() + " param : " + Arrays.toString(stmtSet.getParams()));
            PreparedStatement ps = connection.prepareStatement(stmtSet.getSql(), new String[] { "id" });
            appendParam(ps, stmtSet.getParams());
            return ps;
          }
        }, keyHolder);
 
        long keyValue = keyHolder.getKey().longValue();
        entity.setId(keyValue);
      }
      LOG.info("INSERT returnCode : [" + returnCode + "]");
      entity.setTxnMode(TxnMode.UPDATE);
     
View Full Code Here

Examples of org.springframework.jdbc.support.KeyHolder

252
253
254
255
256
257
258
259
260
261
262
  private UpdateResult updateInternal(String procName, String sql, Object... args) throws DataAccessException {
    sql = checkAuthPlaceholder(sql);
    return new CallTemplate<UpdateResult>() {
      @Override
      UpdateResult doCall(String sql, MapSqlParameterSource params) {
        KeyHolder kh = new GeneratedKeyHolder();
        int rowsAffected = getJdbcTemplate().update(sql, params, kh);
        return new UpdateResult(kh, rowsAffected);
      }
    }.call(procName, sql, args);
  }
View Full Code Here

Examples of org.springframework.jdbc.support.KeyHolder

186
187
188
189
190
191
192
193
194
  ///// insert with start
  /**
   * 适用sqlserver,mysql 自动生成主键
   */
  protected void insertWithGeneratedKey(Object entity, String insertSql) {
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getNamedParameterJdbcTemplate().update(insertSql, new BeanPropertySqlParameterSource(entity) , keyHolder);
    setIdentifierProperty(entity, keyHolder.getKey().longValue());
  }
View Full Code Here

Examples of org.springframework.jdbc.support.KeyHolder

902
903
904
905
906
907
908
909
910
911
912
913
914
915
    return this.namedParameterJdbcTemplate.update(sql, param);
  }
  public Object executeSqlReturnKey(final String sql, Map<String, Object> param) {
    Object keyValue = null;
    try{
      KeyHolder keyHolder = new GeneratedKeyHolder();
      SqlParameterSource sqlp  = new MapSqlParameterSource(param);
      this.namedParameterJdbcTemplate.update(sql,sqlp, keyHolder);
      keyValue = keyHolder.getKey().longValue();
    }catch (Exception e) {
      keyValue = null;
    }
    return keyValue;
  }
View Full Code Here

Examples of org.springframework.jdbc.support.KeyHolder

111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
    if (debug) {
      logger.info("sql:" + sql);
      logger.info("object:" + object);
    }
    SqlParameterSource namedParam = new BeanPropertySqlParameterSource(object);
    KeyHolder keyHolder = new GeneratedKeyHolder();
    int ret = getNameParameterJdbcTemplate().update(sql, namedParam, keyHolder);
    if (ret <= 0)
      return ret;
    try {
      if (keyHolder.getKey() == null)
        return ret;
      ret = keyHolder.getKey().intValue();
      return ret;
    } catch (Exception e) {
      return ret;
    }
  }
View Full Code Here

Examples of org.springframework.jdbc.support.KeyHolder

220
221
222
223
224
225
226
227
228
229
230
      throws DataAccessException {
   
    return new CallTemplate<UpdateResult>() {
      @Override
      UpdateResult doCall(String sql, MapSqlParameterSource params) {
        KeyHolder kh = new GeneratedKeyHolder();
        int rowsAffected = getJdbcTemplate().update(sql,
            params, kh);
        return new UpdateResult(kh, rowsAffected);
      }
    }.call(sql_, args_); 
View Full Code Here

Examples of org.springframework.jdbc.support.KeyHolder

63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
      jdbcTemplate.update(UPDATE_VENUE, venueData.getName(), venueData.getPostalAddress(), venueData.getLatitude(), venueData.getLongitude(), venueData.getLocationHint(), 1, venueId);
      logger.info("Updated venue (ID = " + venueId + ")");
      return eventId;
    } catch (IncorrectResultSizeDataAccessException e) {
      // insert if it doesn't exist
      KeyHolder keyHolder = new GeneratedKeyHolder();
      jdbcTemplate.update(new PreparedStatementCreatorFactory(INSERT_EVENT, new int[] {VARCHAR, VARCHAR, VARCHAR, TIMESTAMP, TIMESTAMP, VARCHAR, BIGINT})
          .newPreparedStatementCreator(new Object[] {eventData.getName(), eventData.getDescription(), eventData.getTimeZone(), eventData.getFirstDay(), eventData.getLastDay(), eventData.getAbbreviation(), eventData.getMemberGroupId()}), keyHolder);
      Number eventId = keyHolder.getKey();
      logger.info("Created event (ID = " + eventId + ")");
      jdbcTemplate.update(new PreparedStatementCreatorFactory(INSERT_VENUE, new int[] {VARCHAR, VARCHAR, DOUBLE, DOUBLE, VARCHAR, BIGINT})
          .newPreparedStatementCreator(new Object[] {venueData.getName(), venueData.getPostalAddress(), venueData.getLatitude(), venueData.getLongitude(), venueData.getLocationHint(), 1}), keyHolder);
      Number venueId = keyHolder.getKey();
      logger.info("Created vanue (ID = " + venueId + ")");
      jdbcTemplate.update(INSERT_EVENT_VENUE, eventId, venueId);
      jdbcTemplate.update(INSERT_EXTERNAL_EVENT, eventId, eventData.getSourceId(), eventData.getSource(), new Date());
      return eventId.longValue();
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.