Package com.github.hakko.musiccabinet.dao.jdbc.rowmapper

Examples of com.github.hakko.musiccabinet.dao.jdbc.rowmapper.TrackWithArtistRowMapper

74
75
76
77
78
79
80
  public Track getTrack(int trackId) {
    String sql = "select a.artist_name_capitalization, t.track_name_capitalization"
        + " from music.artist a inner join music.track t on t.artist_id = a.id"
        + " where t.id = " + trackId;

    return jdbcTemplate.queryForObject(sql, new TrackWithArtistRowMapper());
  }
View Full Code Here
440
441
442
443
444
445
446
        + " mt.track_name_capitalization from library.track lt"
        + " inner join music.track mt on lt.track_id = mt.id"
        + " inner join music.artist ma on mt.artist_id = ma.id"
        + " where lt.id = " + trackId;

    return jdbcTemplate.queryForObject(sql, new TrackWithArtistRowMapper());
  }
View Full Code Here
63
64
65
66
67
68
69
        + " inner join music.artist a on t.artist_id = a.id"
        + " inner join music.lastfmuser u on lt.lastfmuser_id = u.id"
        + " where u.lastfm_user = upper(?)";

    return jdbcTemplate.query(sql, new Object[]{lastFmUsername},
        new TrackWithArtistRowMapper());
  }
View Full Code Here
64
65
66
67
68
69
70
      + " inner join music.artist a on att.artist_id = a.id"
      + " inner join music.track t on att.track_id = t.id"
      + " where a.id = ? order by att.rank";
   
    return jdbcTemplate.query(sql, new Object[]{artistId},
        new TrackWithArtistRowMapper());
  }
View Full Code Here
TOP

Related Classes of com.github.hakko.musiccabinet.dao.jdbc.rowmapper.TrackWithArtistRowMapper

  • com.github.hakko.musiccabinet.dao.jdbc.JdbcArtistTopTracksDao
  • com.github.hakko.musiccabinet.dao.jdbc.JdbcLibraryBrowserDao
  • com.github.hakko.musiccabinet.dao.jdbc.JdbcMusicDao
  • com.github.hakko.musiccabinet.dao.jdbc.JdbcUserLovedTracksDao
  • com.github.hakko.musiccabinet.domain.model.music.Track
    • Copyright © 2018 www.massapicom. 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.