Android: Store data from MySQL Database in an ArrayList

Question

How can I retrieve data from MySQL database and store it in an ArrayList? I have already used php scripts to connect to database and get all the data that I want. The data is sent to the webserver in Json format.
Let's say:
1) I have a table in my database based called users.
2) I have a class in Android Studio also called users that provides all the necessary fields for users. (such as id, name, surname, etc.)
3) I want to create an ArrayList (usersList< users>) that contains all the users from the database. How can I do that?

You can retrieve MySQL data to Android array list via a web service by adding the proxy to android references. — M_K
– M_K, Commented Dec 28, 2017 at 14:05
I actualy have a php file that gets data from the database and sends it at webserver in JSON format — Sonap Tseazmi
– Sonap Tseazmi, Commented Dec 28, 2017 at 15:00

Ankit kumar singh · Accepted Answer · 2017-12-28 14:38:50Z

1

Use json parsing to convert data from json to array list.

According to your requirement list will contain the different user object after parsing.

json parsing sample code

answered Dec 28, 2017 at 14:38

Ankit kumar singh

211 silver badge2 bronze badges

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

Collectives™ on Stack Overflow

Android: Store data from MySQL Database in an ArrayList

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related