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

Class org.springframework.jdbc.object.BatchSqlUpdate

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("tag_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.INTEGER));


    for (int i = 0; i < artists.size(); i++) {
      batchUpdate.update(new Object[]{tagName, artists.get(i).getName(), i});
    }
    batchUpdate.flush();
  }


  private void updateUserTopArtists() {

View Full Code Here

    batchUpdate.declareParameter(new SqlParameter("contextartist1_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("contextartist2_name", Types.VARCHAR));
    
    for (int i = 0; i < artists.size(); i++) {
      RecommendedArtist rec = artists.get(i);
      batchUpdate.update(new Object[]{user.getLastFmUsername(), rec.getArtist().getName(), 
          i, name(rec.getContextArtist1()), name(rec.getContextArtist2())});
    }
    batchUpdate.flush();
  }

View Full Code Here

    batchUpdate.declareParameter(new SqlParameter("source_id", Types.INTEGER));
    batchUpdate.declareParameter(new SqlParameter("target_artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("weight", Types.FLOAT));


    for (ArtistRelation ar : ArtistRelations) {
      batchUpdate.update(new Object[]{
          sourceArtistId, ar.getTarget().getName(), ar.getMatch()});
    }
    batchUpdate.flush();
  }

View Full Code Here

    batchUpdate.declareParameter(new SqlParameter("tag_name", VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("summary", VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("content", VARCHAR));
    
    for (TagInfo ti : tagInfos) {
      batchUpdate.update(new Object[]{ti.getTagName(), 
          ti.getSummary(), ti.getContent()});
    }
    batchUpdate.flush();


    jdbcTemplate.execute("select music.update_taginfo()");

View Full Code Here

    String sql = "insert into library.directory_delete (path) values (?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.declareParameter(new SqlParameter("path", Types.VARCHAR));
    
    for (String subDirectory : subDirectories) {
      batchUpdate.update(new Object[]{subDirectory});
    }
    batchUpdate.flush();
  }


  @Override

View Full Code Here

    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.declareParameter(new SqlParameter("path", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("filename", Types.VARCHAR));
    
    for (File file : files) {
      batchUpdate.update(new Object[]{file.getDirectory(), file.getFilename()});
    }
    batchUpdate.flush();
  }


  @Override

View Full Code Here

    batchUpdate.declareParameter(new SqlParameter("lastfmgroup_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("playcount", Types.INTEGER));
    
    for (ArtistPlayCount apc : artistChart.getArtistPlayCounts()) {
      batchUpdate.update(new Object[]{artistChart.getGroupName(), 
          apc.getArtist().getName(), apc.getPlayCount()});
    }
    batchUpdate.flush();
  }

View Full Code Here

    batchUpdate.declareParameter(new SqlParameter("artist_id", Types.INTEGER));
    batchUpdate.declareParameter(new SqlParameter("tag_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("tag_count", Types.SMALLINT));


    for (Tag tag : tags) {
      batchUpdate.update(new Object[]{sourceArtistId, tag.getName(), tag.getCount()});
    }
    batchUpdate.flush();
  }


  private void updateTopTags() {

View Full Code Here

    batchUpdate.declareParameter(new SqlParameter("playcount", Types.INTEGER));
    batchUpdate.declareParameter(new SqlParameter("biosummary", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("biocontent", Types.VARCHAR));
    
    for (ArtistInfo ai : artistInfos) {
      batchUpdate.update(new Object[]{ai.getArtist().getName(),
          ai.getSmallImageUrl(), ai.getMediumImageUrl(), ai.getLargeImageUrl(),
          ai.getExtraLargeImageUrl(), ai.getListeners(), ai.getPlayCount(),
          ai.getBioSummary(), ai.getBioContent()});
    }
    batchUpdate.flush();

View Full Code Here

    String sql = "insert into music.lastfmgroup_import (group_name) values (?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("group_name", Types.VARCHAR));
    for (LastFmGroup group : lastFmGroups) {
      batchUpdate.update(new Object[]{group.getName()});
    }
    batchUpdate.flush();
    
    jdbcTemplate.execute("select music.update_lastfmgroup()");
  }

View Full Code Here

0 1 2

TOP

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.