在 Android 中从 Firebase 实时数据库中检索数据

问题描述

我是 Firebase 和 NoSQL 的新手.我有一个 Android 演示，其中有一个城市自动完成文本字段，我想在其中填充来自 Firebase 数据库的城市，同时键入.

I'm new to Firebase and NoSQL. I have an Android Demo, with a City Autocomplete Text Field in which I want to populate the cities I have from my Firebase DB, while typing.

{   "cities":{
        "Guayaquil":true,
        "Gualaceo":true,
        "Quito":true,
        "Quevedo":true,
        "Cuenca":true,
        "Loja":true,
        "Ibarra":true,
        "Manta":true
    }
}

这是我目前所拥有的.

如何从以字母开头的 DB 城市中检索(从键盘输入)?如果我开始输入G"，我希望收到Guayaquil"和Gualaceo".

How can I retrieve from the DB cities that start with a letter (input from keyboard)? If I start typing "G", I want to receive "Guayaquil" and "Gualaceo".

如果我使用 orderByValue 总是返回一个空的快照.

If I use orderByValue always returns an empty snapshot.

如果我使用 orderByKey 返回整个列表.

If I use orderByKey return the whole list.

    Query citiesQuery = databaseRef.child("cities").startAt(input).orderByValue();
    citiesQuery.addValueEventListener(new ValueEventListener() {
        @Override
        public void onDataChange(DataSnapshot dataSnapshot) {
            List<String> cities = new ArrayList<String>();
            for (DataSnapshot postSnapshot: dataSnapshot.getChildren()) {
                cities.add(postSnapshot.getValue().toString());
            }

注意:如果你能推荐更好的数据结构，欢迎你.

Note: If you can recommend a better data structure, you're welcome.

推荐答案

@NicholasChen 已确定问题.但这是您使用 3.x SDK 实现的方式:

@NicholasChen has identified the problem. But here's the way you'd implement using the 3.x SDK:

DatabaseReference cities = databaseRef.child("cities")
Query citiesQuery = cities.orderByKey().startAt(input).endAt(input+"uf8ff");
citiesQuery.addValueEventListener(new ValueEventListener() {
    @Override
    public void onDataChange(DataSnapshot dataSnapshot) {
        List<String> cities = new ArrayList<String>();
        for (DataSnapshot postSnapshot: dataSnapshot.getChildren()) {
            cities.add(postSnapshot.getValue().toString());
        }

从用户输入开始到最后一个以用户输入开始的字符串结束，你会得到所有匹配的项目

By starting at the user input and ending at the last string that starts with the user input, you get all matching items

对于相对较短的项目列表，Ryan 的方法也可以正常工作.但是上面的 Firebase 查询将过滤服务器端.

For relatively short lists of items Ryan's approach will also work fine. But the above Firebase query will filter server-side.

我刚刚运行了这段代码:

I just ran this code:

    DatabaseReference databaseRef = FirebaseDatabase.getInstance().getReference("39714936");

    String input = "G";

    DatabaseReference cities = databaseRef.child("cities");
    Query citiesQuery = cities.orderByKey().startAt(input).endAt(input + "uf8ff");
    citiesQuery.addValueEventListener(new ValueEventListener() {
        @Override
        public void onDataChange(DataSnapshot dataSnapshot) {
            List<String> cities = new ArrayList<String>();

            for (DataSnapshot postSnapshot : dataSnapshot.getChildren()) {
                cities.add(postSnapshot.getValue().toString());
            }
            System.out.println(cities);
        }

        @Override
        public void onCancelled(DatabaseError databaseError) {

        }
    });

它打印出来:

真实

真实

所以很明显地匹配了两个城市.

So clearly matches two cities.

随意对我的数据库进行测试:https://stackoverflow.firebaseio.com/39714936

Feel free to test against my database: https://stackoverflow.firebaseio.com/39714936

这篇关于在 Android 中从 Firebase 实时数据库中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！