如何在Jetpack Compose的LazyColumn中展示Room数据库内容？

DevOps 小满

2026-8-18

解决方案

要在LazyColumn中展示Room数据并实现自动刷新，按以下步骤修改：

1. 修改Dao返回Flow

Room支持通过Flow监听数据变化，将getAll()方法改为返回Flow<List<User>>，这样数据库数据更新时会自动通知UI：

@Dao
interface UserDao {
    @Query("SELECT * FROM user_table")
    fun getAll(): Flow<List<User>> // 修改为Flow类型

    // 其余方法保持不变
    @Query("SELECT * FROM user_table WHERE uid IN (:userIds)")
    suspend fun loadAllByIds(userIds: IntArray): List<User>

    @Query(
        "SELECT * FROM user_table WHERE last_name LIKE :last AND " + "age LIKE :age LIMIT 1"
    )
    suspend fun findByNameAge(last: String, age: Int): User

    @Insert
    suspend fun insertAll(vararg users: User)

    @Delete
    suspend fun delete(user: User)
}

2. 在Compose中收集数据并展示

在MainActivity的Compose代码里，找到// Showing a LazyColumn of our Database Content Here注释的位置，替换为以下代码：

// 收集用户列表数据，initial设为空列表作为初始值
val userList by appDB.userDao().getAll().collectAsState(initial = emptyList())

LazyColumn(modifier = Modifier.fillMaxWidth()) {
    items(userList) { user ->
        Card(
            modifier = Modifier
                .fillMaxWidth()
                .padding(horizontal = 16.dp, vertical = 8.dp),
            elevation = 2.dp
        ) {
            Column(modifier = Modifier.padding(16.dp)) {
                Text(text = "姓氏: ${user.lastName ?: "未填写"}", fontSize = 16.sp)
                Text(text = "年龄: ${user.age ?: "未设置"}", fontSize = 14.sp, color = Color.Gray)
                Text(text = "用户ID: ${user.uid ?: 0}", fontSize = 12.sp, color = Color.LightGray)
            }
        }
    }
}