版权声明:本文为博主原创文章,欢迎大家转载!
但是转载请标明出处: https://blog.csdn.net/t000818/article/details/84289212 ,本文出自:【唐宏宇的博客】
在Room persistence library 的2.1.0及更高版本中提供了对SQLite数据库视图的支持,允许将查询封装到类中。 Room将这些查询支持的类称为视图,使用它们时和DAO中简单数据对象相同。
注意:与实体一样,您可以针对视图运行SELECT语句。但是,您无法对视图运行INSERT,UPDATE或DELETE语句。
创建视图
要创建视图,请将DatabaseView
注解添加到类中。并且将注释的值设置为该类所代表的查询操作。
以下代码段提供了一个视图示例:
Kotlin写法:
@DatabaseView("SELECT user.id, user.name, user.departmentId," +
"department.name AS departmentName FROM user " +
"INNER JOIN department ON user.departmentId = department.id")
data class UserDetail(
var id: Long,
var name: String?,
var departmentId: Long,
var departmentName: String?
)
Java写法:
@DatabaseView("SELECT user.id, user.name, user.departmentId," +
"department.name AS departmentName FROM user " +
"INNER JOIN department ON user.departmentId = department.id")
public class UserDetail {
public long id;
public String name;
public long departmentId;
public String departmentName;
}
将视图与数据库关联
要将此视图作为应用数据库的一部分,请在你的应用@Database注解中添加views
属性
Kotlin写法:
@Database(entities = arrayOf(User::class),
views = arrayOf(UserDetail::class), version = 1)
abstract class AppDatabase : RoomDatabase() {
abstract fun userDao(): UserDao
}
Java写法:
@Database(entities = {User.class}, views = {UserDetail.class},
version = 1)
public abstract class AppDatabase extends RoomDatabase {
public abstract UserDao userDao();
}