Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.JdbcTemplate.update()

126
127
128
129
130
131
132
133
134
135
136
                    parent == null ? null : parent.getId(), user } );
            id = Integer.valueOf( template.queryForInt( "SELECT MAX(ID) FROM SETTINGS" ) );
        } else {
            for( Iterator iter = remove.iterator(); iter.hasNext(); ) {
                String key = (String) iter.next();
                template.update( "REMOVE FROM SETTINGS_VALUES WHERE SETTINGS_ID=? AND KEY=?", new Object[] { id, key } );
            }
            for( Iterator iter = update.iterator(); iter.hasNext(); ) {
                String key = (String) iter.next();
                template.update( "UPDATE SETTINGS_VALUES SET VALUE=? WHERE SETTINGS_ID=? AND KEY=?", new Object[] {
                        values.get( key ), id, key } );
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
                String key = (String) iter.next();
                template.update( "REMOVE FROM SETTINGS_VALUES WHERE SETTINGS_ID=? AND KEY=?", new Object[] { id, key } );
            }
            for( Iterator iter = update.iterator(); iter.hasNext(); ) {
                String key = (String) iter.next();
                template.update( "UPDATE SETTINGS_VALUES SET VALUE=? WHERE SETTINGS_ID=? AND KEY=?", new Object[] {
                        values.get( key ), id, key } );
            }
        }

        for( Iterator iter = add.iterator(); iter.hasNext(); ) {
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
            }
        }

        for( Iterator iter = add.iterator(); iter.hasNext(); ) {
            String key = (String) iter.next();
            template.update( "INSERT INTO SETTINGS_VALUES (SETTINGS_ID, KEY, VALUE) VALUES (?, ?, ?)", new Object[] {
                    id, key, values.get( key ) } );
        }

        remove.clear();
        update.clear();
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
                String handle = Long.toHexString(_random.nextLong());

                Association association =
                        Association.generate(type, handle, expiryIn);

                int cnt = jdbcTemplate.update(sql,
                        new Object[] {
                                association.getHandle(),
                                association.getType(),
                                new String(Base64.encodeBase64(
                                        association.getMacKey().getEncoded())),
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
        {
            String sql = "DELETE FROM " + _tableName + " WHERE handle=?";

            JdbcTemplate jdbcTemplate = getJdbcTemplate();

            int cnt = jdbcTemplate.update(sql, new Object[] { handle } );

            if (cnt == 1 && DEBUG)
                _log.debug("Removed association, handle: " + handle);

            if (cnt != 1)
View Full Code Here
225
226
227
228
229
230
231
232
233
234
235
        String value = jdbcTemplate.queryForObject(
                "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
        assertEquals("virattrcache", value);

        jdbcTemplate.update("UPDATE testsync set USERNAME='virattrcache2' WHERE ID=?", actual.getId());

        value = jdbcTemplate.queryForObject(
                "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
        assertEquals("virattrcache2", value);
        // ----------------------------------------
View Full Code Here
383
384
385
386
387
388
389
390
391
392
393
        String value = jdbcTemplate.queryForObject(
                "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
        assertEquals("virattrcache", value);

        jdbcTemplate.update("UPDATE testsync set USERNAME='virattrcache2' WHERE ID=?", actual.getId());

        value = jdbcTemplate.queryForObject(
                "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
        assertEquals("virattrcache2", value);
        // ----------------------------------------
View Full Code Here
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
            String value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
            assertEquals("virattrcache", value);

            jdbcTemplate.update("UPDATE testsync set USERNAME='virattrcache2' WHERE ID=?", userTO.getId());

            value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, userTO.getId());
            assertEquals("virattrcache2", value);
View Full Code Here
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
            String value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
            assertEquals("virattrcache", value);

            jdbcTemplate.update("UPDATE testsync set USERNAME='virattrcache2' WHERE ID=?", userTO.getId());

            value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, userTO.getId());
            assertEquals("virattrcache2", value);
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
        getTransactionTemplate().execute(new TransactionCallbackWithoutResult() {
            protected void doInTransactionWithoutResult(TransactionStatus status) {
                JdbcTemplate jt = getJdbcTemplate();
                String insertMDRequest = _handler.getRequest("insert");
                if (insertMDRequest!=null) {
                    jt.update(insertMDRequest, getInsertParameters(uak, md));
                    addChecksums(md, md5s, "md5", jt);
                    addChecksums(md, sha1, "sha1", jt);
                  LOGGER.info("Module " + md + " has been inserted in db with " + md5s.length + " md5s and " + sha1.length + "sha1");     
                } else {
                    throw new UnsupportedOperationException("no insert request for md");
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.