net.kemitix.itunes.medialibrary.AlbumDao Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of itunes-medialibrary Show documentation

Java library for reading/writing to the iTunes MediaLibrary SQLite database

The newest version!

package net.kemitix.itunes.medialibrary;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;

@Repository
public class AlbumDao extends LibraryDao {

    private final String SELECT_ALL_SQL = "select * from album";
    private final String SELECT_BY_ID = "select * from album where album_pid = ?";

    @Autowired
    public AlbumDao(
            JdbcTemplate jdbcTemplate,
            RowMapper rowMapper) {
        super(jdbcTemplate, rowMapper);
    }

    @Override
    String getSelectAllSql() {
        return SELECT_ALL_SQL;
    }

    @Override
    String getSelectByIdSql() {
        return SELECT_BY_ID;
    }

}