Package org.springframework.jdbc.core

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

2245
2246
2247
2248
2249
2250
2251
2252
2253
2254
2255
            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
113
114
115
116
117
118
119
120
121
122
123
      cleanupAged ( ) ;
      JdbcTemplate jdbcTemplate = getJdbcTemplate ( ) ;

      try
      {
        jdbcTemplate.update ( _insertSQL, new Object[]
          { opUrl, nonce, now } ) ;
        return OK ;
      }
      catch ( DataIntegrityViolationException e )
      {
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
    {
      try
      {
        Date boundary = new Date ( System.currentTimeMillis ( ) - _maxAgeSeconds * 1000 ) ;
        JdbcTemplate jdbcTemplate = getJdbcTemplate ( ) ;
        int cnt = jdbcTemplate.update ( _deleteSQL, new Object[]
          { boundary } ) ;

        if ( _log.isDebugEnabled ( ) ) _log.debug ( "Client nonce cleanup removed " + cnt + " entries" ) ;
      }
      catch ( Exception e )
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
                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
178
179
180
181
182
183
184
185
186
187
188
        {
            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
85
86
87
88
89
90
91
92
93
94
95
                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
184
185
186
187
188
189
190
191
192
193
194
        {
            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 +
                           " from table: " + _tableName);
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
        String sql = "DELETE FROM " + _tableName + " WHERE expdate<?";

            JdbcTemplate jdbcTemplate = getJdbcTemplate();

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

            _log.debug("Cleaned " + cnt + " expired associations from table: "
                          + _tableName);

            _lastCleanup = System.currentTimeMillis();
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
  {   
    try
    {
      JdbcTemplate jdbcTemplate = getJdbcTemplate ( ) ;

      int cnt = jdbcTemplate.update ( _sqlDelete, new Object[]
        { opUrl, handle } ) ;
    }
    catch ( Exception e )
    {
      _log.error (  "Error removing association from table: "
View Full Code Here
226
227
228
229
230
231
232
233
234
235
236
   
    try
    {
      JdbcTemplate jdbcTemplate = getJdbcTemplate ( ) ;

      int cnt = jdbcTemplate.update ( _sqlInsert,
                      new Object[]
                        {
                           opUrl,
                          association.getHandle ( ),
                          association.getType ( ),
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.