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

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


  @Override
  public List<Tag> getTags() {
    String sql = "select id, tag_name from music.tag";

    return jdbcTemplate.query(sql, new TagIdNameRowMapper());
  }
View Full Code Here


        + " left outer join (select tag_id from library.toptag) tt on t.id = tt.tag_id"
        + " where ((occ.count > 5 and pop.sum/occ.count > 50)"
        + " or t.id in (select tag_id from library.toptag))"
        + " and not exists (select 1 from music.tagtopartist where tag_id = t.id)";

    return jdbcTemplate.query(sql, new TagIdNameRowMapper());
  }
View Full Code Here

TOP

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

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.