1
2
3
4
5
6
7
8

@Target(ElementType.TYPE)
@Retention(RetentionPolicy.CLASS)
public @interface DatabaseView {
    //
    String value() default "";
    //
    String viewName() default "";
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

@DatabaseView(
        "SELECT id, name, release_year FROM Song " +
                "WHERE release_year >= 1990 AND release_year <= 1999")
public class SongFrom90s {

    long id;

    String name;

    @ColumnInfo(name = "release_year")
    private int releaseYear;
}