sqlite database android get all column values into string array

Question

I have a sqlite database in android , for example :

Table 1 person:

column 1: id
column 2: name
column 3: friends

Table 2 friends:

column 1: id
column 2: allFriends

the id is the same in both tables, id in table1 == id in table2 i want to get all the values from table2 in specific column "allFriends" by the id and insert all the String values from the column into String array / arrayList.

Seems very simple, so what have you tried?

user1425689
– user1425689

2016-07-25 08:51:52 +00:00
Commented Jul 25, 2016 at 8:51 — user1425689
– user1425689, Commented Jul 25, 2016 at 8:51

Pramod Waghmare · Accepted Answer · 2016-07-25 09:00:25Z

2

Try this,

  public ArrayList<String> getAllFriends(int id) {
    ArrayList<String> friendsNames = new ArrayList<>();
    SQLiteDatabase sqLiteDatabase = null;
    try {
        String query = "select * from person P join friends F on F.id = P.id where P.id = " + id;
        Cursor cursor = sqLiteDatabase.rawQuery(query, null);
        while (cursor.moveToNext()) {
            friendsNames.add(cursor.getString(cursor.getColumnIndex("allFriends")));
        }
    }catch(Exception ex){
        Log.e(TAG,"Erro in geting friends "+ex.toString());
    }
    return friendsNames;
  }

answered Jul 25, 2016 at 9:00

Pramod Waghmare

1,28313 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Daniel Levi Over a year ago

what is the person P and friends F ?

Pramod Waghmare Over a year ago

Its an Aliases. Read more from w3schools.com/sql/sql_alias.asp

Phantômaxx Over a year ago

SELECT * should be always avoided. Use field lists instead.

Community · Accepted Answer · 2017-05-23 12:14:50Z

0

Your SQL query:

SELECT allFriends FROM friends where id == Id_from_person

Id_from_person - id of person who friends you want to recieve from DB.
For executing query read this.

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Jul 25, 2016 at 8:45

Stanislav Parkhomenko

4895 silver badges18 bronze badges

1 Comment

Stanislav Parkhomenko Over a year ago

Ofc. It is not copy-paste answer. You need to figure out a little bit by yourself to solve your question.

Collectives™ on Stack Overflow

sqlite database android get all column values into string array

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related