Package org.springframework.jdbc.support

Examples of org.springframework.jdbc.support.KeyHolder

379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
        Map<String, ?> params = params("type_id", typeId, "id", id, "blob", blob);
        final String statement = String.format("insert into object (oid, type_id, id, blob) values (%s, :type_id, :id, :blob)",
                dialect.nextVal("seq_OBJECT"));
        logStatement(statement, params);
        KeyHolder keyHolder = new GeneratedKeyHolder();
        int updateCount = template.update(statement, new MapSqlParameterSource(params), keyHolder, new String[] {"oid"});
        checkState(updateCount == 1, "Insert statement failed");
        // looks like some db's return the pk different than others, so lets try both ways
        Number key = (Number) keyHolder.getKeys().get("oid");
        if (key == null) {
            key = keyHolder.getKey();
        }
        addAttributes(info, key);

        cache.put(id, info);
        return getById(id, interf);
View Full Code Here
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
                    dialect.nextVal("seq_PROPERTY_TYPE"));

            params = params("target", targetPropertyOid, "type", typeId, "name", propertyName,
                    "collection", isCollection, "isText", isText);
            logStatement(insert, params);
            KeyHolder keyHolder = new GeneratedKeyHolder();
            template.update(insert, new MapSqlParameterSource(params), keyHolder, new String[] {"oid"});

            // looks like some db's return the pk different than others, so lets try both ways
            Number pTypeKey = (Number) keyHolder.getKeys().get("oid");
            if (pTypeKey == null) {
                pTypeKey = keyHolder.getKey();
            }
            pType = new PropertyType(pTypeKey.intValue(), targetPropertyOid, typeId, propertyName,
                    isCollection, isText);
        } else {
            log("Not adding property type ", infoClazz.getSimpleName(), ".", propertyName,
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
        }
    }
   
    public GridEntity salvar(final GridEntity entity) {
        if (entity.getId() == null) {
            KeyHolder keyHolder = new GeneratedKeyHolder();
            getJdbcTemplate().update(new PreparedStatementCreator() {
                @Override
                public PreparedStatement createPreparedStatement(Connection cnctn) throws SQLException {
                    PreparedStatement ps = cnctn.prepareStatement(
                            "insert into GridEntity (descricao, valor) values (?, ?)",
                            Statement.RETURN_GENERATED_KEYS);
                    ps.setString(1, entity.getDescricao());
                    if(entity.getValor() != null){
                        ps.setBigDecimal(2, entity.getValor());
                    }else{
                        ps.setNull(2, Types.NUMERIC);
                    }
                    return ps;
                }
            }, keyHolder);
            entity.setId(keyHolder.getKey().longValue());
        }else{
            getJdbcTemplate().update("update GridEntity set descricao = ?, valor = ? where id = ?",
                    entity.getDescricao(), entity.getValor(), entity.getId());
        }
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
                new BeanPropertyRowMapper<SingleRowEntity>(SingleRowEntity.class));
    }

    public SingleRowEntity salvar(final SingleRowEntity entity) {
        if (entity.getId() == null) {
            KeyHolder keyHolder = new GeneratedKeyHolder();
            getJdbcTemplate().update(new PreparedStatementCreator() {
                @Override
                public PreparedStatement createPreparedStatement(Connection cnctn) throws SQLException {
                    PreparedStatement ps = cnctn.prepareStatement(
                            "insert into SingleRowEntity (texto1, combo1, autocomplete, dateDate, dateTime) values (?, ?, ?, ?, ?)",
                            Statement.RETURN_GENERATED_KEYS);
                    ps.setString(1, entity.getTexto1());
                    ps.setString(2, entity.getCombo1());
                    if(entity.getAutocomplete() != null){
                        ps.setLong(3, entity.getAutocomplete());
                    }else{
                        ps.setNull(3, Types.INTEGER);
                    }
                    if(entity.getDateDate() != null){
                        ps.setDate(4, new Date(entity.getDateDate().getTime()));
                    }else{
                        ps.setNull(4, Types.DATE);
                    }
                    if(entity.getDateTime() != null){
                        ps.setTimestamp(5, new Timestamp(entity.getDateTime().getTime()));
                    }else{
                        ps.setNull(5, Types.TIMESTAMP);
                    }
                    return ps;
                }
            }, keyHolder);
            entity.setId(keyHolder.getKey().longValue());
        }else{
            getJdbcTemplate().update("update SingleRowEntity set texto1 = ?, combo1 = ?, autocomplete = ?, dateDate = ?, dateTime = ? where id = ?",
                    entity.getTexto1(), entity.getCombo1(), entity.getAutocomplete(), entity.getDateDate(), entity.getDateTime(), entity.getId());
        }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
90
        Number result;
        DataAccess dataAccess = dataAccessProvider.getDataAccess(//
                runtime.getMetaData(), runtime.getProperties());
        if (returnGeneratedKeys) {
            ArrayList<Map<String, Object>> keys = new ArrayList<Map<String, Object>>(1);
            KeyHolder generatedKeyHolder = new GeneratedKeyHolder(keys);
            dataAccess.update(runtime.getSQL(), runtime.getArgs(), generatedKeyHolder);
            if (keys.size() > 0) {
                result = generatedKeyHolder.getKey();
            } else {
                result = null;
            }
        } else {
            result = new Integer(dataAccess.update(runtime.getSQL(), runtime.getArgs(), null));
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.