Package org.springframework.jdbc.support

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
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
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
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
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
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
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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
      jdbcTemplate.update(UPDATE_LEADER, leaderData.getName(), leaderData.getBio(), leaderData.getPersonalUrl(), leaderData.getTwitterId(), leaderId);
      logger.info("Updated leader (ID = " + leaderId + ")");
      return leaderId;
    } catch (IncorrectResultSizeDataAccessException e) {
      // insert if it doesn't exist
      KeyHolder keyHolder = new GeneratedKeyHolder();
      jdbcTemplate.update(new PreparedStatementCreatorFactory(INSERT_LEADER, new int[] {VARCHAR, VARCHAR, VARCHAR, VARCHAR})
          .newPreparedStatementCreator(new Object[] {leaderData.getName(), leaderData.getBio(), leaderData.getPersonalUrl(), leaderData.getTwitterId()}), keyHolder);
      long leaderId = keyHolder.getKey().longValue();
      jdbcTemplate.update(INSERT_EXTERNAL_LEADER, leaderId, leaderData.getSourceId(), leaderData.getSource(), new Date());
      logger.info("Created leader (ID = " + leaderId + ")");
      return leaderId;
    }
  };
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
120
121
      jdbcTemplate.update(UPDATE_TIMESLOT, timeSlotData.getEventId(), timeSlotData.getLabel(), timeSlotData.getStartTime(), timeSlotData.getEndTime(), timeSlotId);
      logger.info("Updated timeslot (ID = " + timeSlotId + ")");
      return timeSlotId;
    } catch (IncorrectResultSizeDataAccessException e) {
      // insert if it doesn't exist
      KeyHolder keyHolder = new GeneratedKeyHolder();
      jdbcTemplate.update(new PreparedStatementCreatorFactory(INSERT_TIMESLOT, new int[] {BIGINT, VARCHAR, TIMESTAMP, TIMESTAMP})
        .newPreparedStatementCreator(new Object[] {timeSlotData.getEventId(), timeSlotData.getLabel(), timeSlotData.getStartTime(), timeSlotData.getEndTime()}), keyHolder);
      long timeSlotId = keyHolder.getKey().longValue();
      jdbcTemplate.update(INSERT_EXTERNAL_TIMESLOT, timeSlotId, timeSlotData.getSourceId(), timeSlotData.getSource(), new Date());
      logger.info("Created timeslot (ID = " + timeSlotId + ")");
      return timeSlotId;     
    }
  }
View Full Code Here
414
415
416
417
418
419
420
421
422
423
424
425
426
  /**
   * Method to execute the insert generating single key
   */
  private Number executeInsertAndReturnKeyInternal(final List<Object> values) {
    KeyHolder kh = executeInsertAndReturnKeyHolderInternal(values);
    if (kh != null && kh.getKey() != null) {
      return kh.getKey();
    }
    else {
      throw new DataIntegrityViolationException(
          "Unable to retrieve the generated key for the insert: " + getInsertString());
    }
View Full Code Here
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
    • Copyright © 2018 www.massapicom. 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.