Examples of org.springframework.jdbc.object.BatchSqlUpdate.update()

org.springframework.jdbc.object.BatchSqlUpdate.update()

Overridden version of update that adds the given statement parameters to the queue rather than executing them immediately. All other update methods of the SqlUpdate base class go through this method and will thus behave similarly.

You need to call flush to actually execute the batch. If the specified batch size is reached, an implicit flush will happen; you still need to finally call flush to flush all statements. @param params array of parameter objects @return the number of rows affected by the update (always -1,meaning "not applicable", as the statement is not actually executed by this method) @see #flush

    batchUpdate.declareParameter(new SqlParameter("extraLargeimageurl", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("listeners", Types.INTEGER));
    batchUpdate.declareParameter(new SqlParameter("playcount", Types.INTEGER));
    
    for (AlbumInfo ai : albumInfos) {
      batchUpdate.update(new Object[]{ai.getAlbum().getArtist().getName(), ai.getAlbum().getName(),
          ai.getSmallImageUrl(), ai.getMediumImageUrl(), ai.getLargeImageUrl(),
          ai.getExtraLargeImageUrl(), ai.getListeners(), ai.getPlayCount()});
    }
    batchUpdate.flush();
  }

    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("track_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("play_count", Types.INTEGER));
    
    for (TrackPlayCount tpc : trackPlayCounts) {
      batchUpdate.update(new Object[]{tpc.getTrack().getArtist().getName(), 
          tpc.getTrack().getName(), tpc.getPlayCount()});
    }
    batchUpdate.flush();
  }

    batchUpdate.declareParameter(new SqlParameter("track_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.SMALLINT));
    
    short rank = 0;
    for (Track t : topTracks) {
      batchUpdate.update(new Object[]{sourceArtistId, t.getName(), ++rank});
    }
    batchUpdate.flush();
  }


  private void updateTopTracks() {

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.