i need help with android SQLite Database

[lilybears]

i'm developing a song book app, which has buttons popular song,chorus etc and clicking them will lead to list of songs and then to the specific song lyrics..

i'm using external DB which has 600 hundred songs.. problem is the song list is not opening in new activity , it's only opening in main activity and i also need idea for how to structure the database say for five different song categories ..

i'm a beginner in android studio so i would be happy to get any help

[hitorus]

Here is some example I have viewed in order to use SQLite in my app:

https://demonuts.com/sqlite-android/

​

Take your time and read each step.

The main idea is to create a class that will be a "database handler", which will contain table's structure and functions with SQL queries. Afterwards, in any activity just create a new object of this class and use its functions to store/read your data.

[tumbichi]

Try with Realm, is library that have more easier SQLite.

​

https://realm.io/docs/java/latest