Package org.springframework.jdbc.object

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

43
44
45
46
47
48
49
50
51
52
53
        + " values (?,?,?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("lastfm_user", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.INTEGER));
    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);
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("lastfm_user", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.INTEGER));
    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(),
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("lastfm_user", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.INTEGER));
    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())});
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
        sourceArtist.getName());

    String sql = "insert into music.artistrelation_import (source_id, target_artist_name, weight) values (?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    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[]{
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
    String sql = "insert into music.artistrelation_import (source_id, target_artist_name, weight) values (?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    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()});
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
    String sql = "insert into music.artistrelation_import (source_id, target_artist_name, weight) values (?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    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()});
    }
View Full Code Here
20
21
22
23
24
25
26
27
28
29
30
  @Override
  public void createTagInfo(List<TagInfo> tagInfos) {
    String sql = "insert into music.taginfo_import (tag_name, summary, content) values (?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    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(),
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
  public void createTagInfo(List<TagInfo> tagInfos) {
    String sql = "insert into music.taginfo_import (tag_name, summary, content) values (?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    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()});
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
    String sql = "insert into music.taginfo_import (tag_name, summary, content) values (?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    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()});
    }
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
  @Override
  public void deleteSubdirectories(String directory, Set<String> subDirectories) {
    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();
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.