android - json key value pairs to sqlite

Question

I am completely stuck on this and need help.

I need to get the value if another value is equal to something.

Lets say my array is:

"people":[
    {"name": "David", "age": "30"}, 
    {"name": "Bob", "age": "20"}, 
    {"name": "Bill", "age": "30"}
]

I need to return the age if the name is lets say Bob. I have attempted to do it this way but to no avail.

String People = jsonPart.getString("people");
JSONArray arr = new JSONArray(People);

for (int h = 0; h < arr.length(); h++) {

    JSONObject jsonPart = arr.getJSONObject(h);

    String name = jsonPart.getString("name");

    if (name == "Bob") {

        String age = jsonPart.getString("age");

        break;

    }
}

score 1 · Accepted Answer · answered Nov 30 '18 at 00:18

1

Your problem is that you cannot do String comparisons in Java using the == operator. You must use String#equals so replace this line:

if (name == "Bob") {

with

if(name.equals("Bob")) {

See this link for more info:

https://www.baeldung.com/java-compare-strings and https://docs.oracle.com/javase/tutorial/java/data/comparestrings.html

answered Nov 30 '18 at 00:18

Cody Caughlan

32,456
5
63
68

Now I feel very silly what worked perfectly. Thank you. – DavidG Nov 30 '18 at 00:22
@DavidG you should accept the question as it solves your problem – touhid udoy Nov 30 '18 at 00:25

score 1 · Answer 2 · answered Nov 30 '18 at 01:45

1

You can also do it like this:

If("Bob".equals(name))

to avoid NullPointerException if the name is null.

answered Nov 30 '18 at 01:45

Akef

339
3
13

android - json key value pairs to sqlite

2 Answers2