Android Room sample DAO

AddressDao.java

@Dao
public interface AddressDao {
    @Query("SELECT * FROM address")
    List<Address> getAll();

    @Query("SELECT * FROM address WHERE id IN (:addressIds)")
    List<Address> loadAllByIds(int[] addressIds);

    @Query("SELECT * FROM address WHERE city LIKE :city AND "
           + "street LIKE :street LIMIT 1")
    Address findByCityAndStreet(String city, String street);

    @Insert
    void insert(Address address);

    @Delete
    void delete(Address address);
}