Package org.springframework.jdbc.support

Examples of org.springframework.jdbc.support.GeneratedKeyHolder

25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
 
  @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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
      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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
      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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
      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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
      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
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
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
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
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
  private <S extends T> S createWithAutoGeneratedKey(S entity, Map<String, Object> columns) {
    removeIdColumns(columns);
    final String createQuery = sqlGenerator.create(table, columns);
    final Object[] queryParams = columns.values().toArray();
    final GeneratedKeyHolder key = new GeneratedKeyHolder();
    jdbcOperations.update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
        final String idColumnName = table.getIdColumns().get(0);
        final PreparedStatement ps = con.prepareStatement(createQuery, new String[]{idColumnName});
        for (int i = 0; i < queryParams.length; ++i) {
          ps.setObject(i + 1, queryParams[i]);
        }
        return ps;
      }
    }, key);
    return postCreate(entity, key.getKey());
  }
View Full Code Here
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
TOP

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

  • br.com.cwi.tnt.rfp.arquitetura2.repository.SingleRowEntityDataRepository
  • com.jpoweredcart.admin.model.design.impl.BannerAdminModelImpl
  • com.reflectiondao.dao.Dao
  • com.skyline.base.dao.impl.BaseDaoImpl
  • com.springsource.greenhouse.events.load.JdbcEventLoaderRepository
  • net.paoding.rose.jade.statement.UpdateQuerier
  • nl.clockwork.mule.ebms.dao.AbstractEbMSDAO
  • org.butor.dao.AbstractDao
  • org.geoserver.jdbcconfig.internal.ConfigDatabase
  • org.geoserver.jdbcconfig.internal.DbMappings
    • 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.