我想知道在使用录音表时如何从类别名称访问类别名称

Question

//我想在使用ExpreCord时访问适配器和ViewModel中的类别名称，而不必在ExpreCord类中添加名称

@Entity(tableName = "Category")
data class ExpCategory(
   @PrimaryKey(autoGenerate = true) val id: Int,
   @ColumnInfo(name = "category-name") val name: String )

@Entity(tableName = "Currency")
data class Currency(
   @PrimaryKey(autoGenerate = true) val id: Int,
    @ColumnInfo(name = "symbol") val symbol: String )


@Entity(tableName = "Record",
  foreignKeys = [ ForeignKey(
    entity = ExpCategory::class,
    parentColumns = arrayOf("id"),
    childColumns = arrayOf("expCategoryID"),
    onDelete = ForeignKey.SET_NULL),

    ForeignKey(
        entity = Currency::class,
        parentColumns = arrayOf("id"),
        childColumns = arrayOf("currencyID"),
        onDelete = ForeignKey.SET_NULL)])
data class ExpRecord (
  @PrimaryKey(autoGenerate = true) val recordNumber: Int,
  @ColumnInfo(name = "expCategoryID") val categoryId: Int,
  @ColumnInfo(name = "currencyID") val currencyId: Int,
  @ColumnInfo(name = "amount") val amount: Double,
  @ColumnInfo(name = "date") val date: String,
  @ColumnInfo(name = "notes") val note: String )

Answer 1

可以通过使用Daos查询多个表，从而可以。参见访问多个表数据