Android:获取Room数据库中具有特定代码的项目计数

implementation "androidx.room:room-runtime:2.4.0"
annotationProcessor "androidx.room:room-compiler:2.4.0"

@Entity(tableName = "Projects")
public class Project {
    @PrimaryKey
    public int id;
    public String code;
    // 其他字段...
}

@Dao
public interface ProjectDao {
    @Query("SELECT COUNT(*) FROM Projects WHERE code = :code")
    int getProjectCountByCode(String code);
}

@Database(entities = {Project.class}, version = 1)
public abstract class AppDatabase extends RoomDatabase {
    public abstract ProjectDao projectDao();
}

AppDatabase db = Room.databaseBuilder(getApplicationContext(), AppDatabase.class, "my-database").build();
int projectCount = db.projectDao().getProjectCountByCode("your_code");