Package org.springframework.jdbc.core

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

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 ( ) - 1000L * _maxAgeSeconds ) ;
        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
138
139
140
141
142
143
144
145
146
147
148
    final String createStatement = Dao.createStatements.get(type);

    KeyHolder holder = new GeneratedKeyHolder();
    try {
      // Create a prepared statement.
      insert.update(new PreparedStatementCreator() {

        @Override
        public PreparedStatement createPreparedStatement(
            Connection connection) throws SQLException {
View Full Code Here
259
260
261
262
263
264
265
266
267
268
269
      deleteAllStatementToUse = strat.createDeleteAllStatement();

      Dao.deleteAllStatements.put(type, deleteAllStatementToUse);
    }

    delete.update(deleteAllStatementToUse);
  }

  /**
   * Deletes an instance of T from the database based on the Key.
   *
 
View Full Code Here
285
286
287
288
289
290
291
292
293
294
295
      deleteStatementToUse = strat.createDeleteStatement(t);

      Dao.deleteStatements.put(type, deleteStatementToUse);
    }

    delete.update(deleteStatementToUse,
        new Object[] { strat.getPrimaryKeyValue(t) });
  }

  /**
   * Update.
 
View Full Code Here
313
314
315
316
317
318
319
320
321
322
323
      updateStatementToUse = strat.createUpdateStatement();

      Dao.updateStatements.put(type, updateStatementToUse);
    }

    update.update(updateStatementToUse, strat.createUpdateObject(t));

    T tNew = select((Integer) strat.getPrimaryKeyValue(t));

    return tNew;
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
  @Before
  public void init() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    maxId = jdbcTemplate.queryForObject("SELECT MAX(ID) from T_FOOS", Integer.class);
    for (int i = ITEM_COUNT; i > maxId; i--) {
      jdbcTemplate.update("INSERT into T_FOOS (ID,NAME,VALUE) values (?, ?, ?)", i, "foo" + i, i);
    }
    assertEquals(ITEM_COUNT, JdbcTestUtils.countRowsInTable(jdbcTemplate, "T_FOOS"));
  }

  @After
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
  }

  @After
  public void destroy() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("DELETE from T_FOOS where ID>?", maxId);
  }

  @Test
  public void testAsyncReader() throws Throwable {
    List<Throwable> throwables = new ArrayList<Throwable>();
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
  public void init() {
    Assert.notNull(dataSource);
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    maxId = jdbcTemplate.queryForObject("SELECT MAX(ID) from T_FOOS", Integer.class);
    for (int i = ITEM_COUNT; i > maxId; i--) {
      jdbcTemplate.update("INSERT into T_FOOS (ID,NAME,VALUE) values (?, ?, ?)", i, "foo" + i, i);
    }
    assertEquals(ITEM_COUNT, JdbcTestUtils.countRowsInTable(jdbcTemplate, "T_FOOS"));
  }

  @After
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
  }

  @After
  public void destroy() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("DELETE from T_FOOS where ID>?", maxId);
  }

  @Test
  public void testAsyncReader() throws Throwable {
    List<Throwable> throwables = new ArrayList<Throwable>();
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.