房间里的安卓数据库视图

Question

我在房间的数据库视图中有一些sqlite错误：

@Entity(tableName = "customers")
data class Customer(@PrimaryKey val id: Int, val name : String, val add : String, val gen: 
String ="Hi")
@Entity(tableName = "gender")
data class Gender (@PrimaryKey val id:Int, val gen :String)

@DatabaseView("SELECT " +
"customers.id, " +
"customers.name, " +
"customers.add, "+
"gender.gen AS gen FROM customers " +
"LEFT JOIN gender ON customers.id = gender.id")
data class UserDetail(
val id: Int,
val name: String,
val add :String ="",
val gen: String
)

@Dao
interface  UserDAO
{
@Query("select * from UserDetail")
suspend fun getUSers() : List<UserDetail>
@Insert
suspend fun insertCustomer(customer: Customer)

@Insert
suspend fun  insetGender(gen: Gender)

}

日志猫显示此错误：

e：/Users/**

**/app/build/tmp/kapt3/stubs/debug/com/dexter/roompractice/UserDetail.java：7： error： [SQLITE_ERROR] SQL 错误或缺少数据库(接近"添加"：语法错误( 公共最终类用户详细信息 { ^ e：>/Users/****/app/build/tmp/kapt3/stubs/debug/com/dexter/roompractice/UserDAO.java：11： error： 查询有问题： [SQLITE_ERROR] SQL 错误或缺少数据库(没有这样的表：UserDetail( public abstract java.lang.Object getUSers(@org.jetbrains.annotations.NotNull((

Answer 1

>add是一个关键字。将其更改为address有效。