如何从Firebase数据库检索同名子节点的slot等字段值？

Hey there, let's work through this Firebase data retrieval issue together. It sounds like you're trying to pull matching slot, available_count, and total_count fields from two different child nodes in your Firebase database, but your current setup with AreaViewHolder and ComplexModel isn't returning the values you expect. Let's break down the most common fixes and steps to get this working:

First, double-check that your data is structured in a way that lets you link entries across the two nodes. For example, if you're matching entries by a shared slot name or unique key, your structure might look like this:

Example structure (adjust to match your actual data):

{
  "sports_complexes": {
    "complex_001": {
      "slot": "9AM-11AM",
      "available_count": 4,
      "total_count": 10
    },
    "complex_002": {
      "slot": "1PM-3PM",
      "available_count": 2,
      "total_count": 8
    }
  },
  "community_centers": {
    "center_001": {
      "slot": "9AM-11AM",
      "available_count": 6,
      "total_count": 10
    },
    "center_002": {
      "slot": "6PM-8PM",
      "available_count": 8,
      "total_count": 15
    }
  }
}

Ensure there's a shared identifier (like the slot value or a unique key) that lets you match entries between the two nodes.

Firebase relies on proper field mapping and deserialization rules. Make sure your model class matches the database fields exactly, or uses annotations to map mismatched names:

public class ComplexModel {
    // Field names must match database keys, or use @PropertyName if they differ
    private String slot;
    private int available_count;
    private int total_count;

    // *Required empty constructor* for Firebase to deserialize data
    public ComplexModel() {}

    // Constructor for manual object creation
    public ComplexModel(String slot, int available_count, int total_count) {
        this.slot = slot;
        this.available_count = available_count;
        this.total_count = total_count;
    }

    // Getters and setters are mandatory for Firebase to populate fields
    public String getSlot() {
        return slot;
    }

    public void setSlot(String slot) {
        this.slot = slot;
    }

    public int getAvailable_count() {
        return available_count;
    }

    public void setAvailable_count(int available_count) {
        this.available_count = available_count;
    }

    public int getTotal_count() {
        return total_count;
    }

    public void setTotal_count(int total_count) {
        this.total_count = total_count;
    }
}

If you use camelCase in Java (e.g., availableCount) but snake_case in the database, add @PropertyName("available_count") to the corresponding getter/setter.

To retrieve matching entries across two nodes, use one of these two approaches:

Option 1: Fetch Both Nodes and Match Locally #

If you need all matching entries, fetch data from both nodes first, then filter matches on the client:

// References to your two target nodes
DatabaseReference complexRef = FirebaseDatabase.getInstance().getReference("sports_complexes");
DatabaseReference centerRef = FirebaseDatabase.getInstance().getReference("community_centers");

// Fetch data from the first node
complexRef.addValueEventListener(new ValueEventListener() {
    @Override
    public void onDataChange(@NonNull DataSnapshot snapshot) {
        // Store first node data in a map keyed by slot name
        Map<String, ComplexModel> complexSlotMap = new HashMap<>();
        for (DataSnapshot childSnap : snapshot.getChildren()) {
            ComplexModel model = childSnap.getValue(ComplexModel.class);
            if (model != null) {
                complexSlotMap.put(model.getSlot(), model);
            }
        }

        // Fetch second node data and find matches
        centerRef.addListenerForSingleValueEvent(new ValueEventListener() {
            @Override
            public void onDataChange(@NonNull DataSnapshot snapshot) {
                List<ComplexModel> matchedSlots = new ArrayList<>();
                for (DataSnapshot childSnap : snapshot.getChildren()) {
                    ComplexModel centerModel = childSnap.getValue(ComplexModel.class);
                    // Check if this slot exists in the first node's data
                    if (centerModel != null && complexSlotMap.containsKey(centerModel.getSlot())) {
                        matchedSlots.add(centerModel);
                        // Optional: Combine data from both models here
                    }
                }

                // Update your RecyclerView with the matched data
                yourAdapter.submitList(matchedSlots);
            }

            @Override
            public void onCancelled(@NonNull DatabaseError error) {
                Log.e("Firebase", "Failed to fetch community center data", error.toException());
            }
        });
    }

    @Override
    public void onCancelled(@NonNull DatabaseError error) {
        Log.e("Firebase", "Failed to fetch sports complex data", error.toException());
    }
});

Option 2: Query for Specific Matching Slots #

If you only need data for a specific slot, filter the query first:

String targetSlot = "9AM-11AM";

// Query first node for the target slot
complexRef.orderByChild("slot").equalTo(targetSlot).addListenerForSingleValueEvent(new ValueEventListener() {
    @Override
    public void onDataChange(@NonNull DataSnapshot snapshot) {
        if (snapshot.exists()) {
            ComplexModel complexModel = snapshot.getChildren().iterator().next().getValue(ComplexModel.class);
            // Now fetch the same slot from the second node
            centerRef.orderByChild("slot").equalTo(targetSlot).addListenerForSingleValueEvent(new ValueEventListener() {
                @Override
                public void onDataChange(@NonNull DataSnapshot snapshot) {
                    if (snapshot.exists()) {
                        ComplexModel centerModel = snapshot.getChildren().iterator().next().getValue(ComplexModel.class);
                        // You now have both matching models - update your UI
                    }
                }

                @Override
                public void onCancelled(@NonNull DatabaseError error) {
                    // Handle error
                }
            });
        }
    }

    @Override
    public void onCancelled(@NonNull DatabaseError error) {
        // Handle error
    }
});

Make sure your ViewHolder correctly binds the model data to your UI elements:

public class AreaViewHolder extends RecyclerView.ViewHolder {
    private TextView slotName;
    private TextView availableCount;
    private TextView totalCount;

    public AreaViewHolder(@NonNull View itemView) {
        super(itemView);
        // Match these IDs to your layout file's view IDs
        slotName = itemView.findViewById(R.id.tv_slot_name);
        availableCount = itemView.findViewById(R.id.tv_available_count);
        totalCount = itemView.findViewById(R.id.tv_total_count);
    }

    public void bind(ComplexModel model) {
        slotName.setText(model.getSlot());
        // Convert integers to strings for TextView
        availableCount.setText(String.valueOf(model.getAvailable_count()));
        totalCount.setText(String.valueOf(model.getTotal_count()));
    }
}

Double-check that the view IDs match your XML layout, and that you're converting numeric values to strings properly.

• Enable Firebase debug logging to see raw data being fetched: FirebaseDatabase.getInstance().setLogLevel(Logger.Level.DEBUG);
• Add log statements in onDataChange to print snapshot.getValue() and confirm your model is being populated correctly.
• Verify your Firebase security rules allow read access to the nodes (use temporary public rules for testing, then lock them down for production).

内容的提问来源于stack exchange，提问作者Satha Sivam