CODEWITHSUNDEEP
androidsqlite
vrkpt
vrkpt

Reputation: 47

Should I explicitly create SQLite tables in my app?

I am a novice, and am creating a simple app that just reads data from a table in an SQLite database and displays on the GUI. (Just select operation )

During development, I created the database and the table from the tool "SQLite Database browser". And I inserted all data into the table through the tool.

Now, my doubt is ..

1) In java code, should I have some method that creates database and table ?? (For now, I have methods to do the select operation alone)

2) The database I created is located in my local drive. When the apk file gets created would the database also be included in the apk file ??

Pls help !! Thanks in advance !!

Upvotes: 1

Views: 87

Answers (2)

user370305
user370305

Reputation: 109237

1) In Java code, should I have some method that creates database and table ?? (For now, I have methods to do the select operation alone)

No, You have to just copy your database file from /asset directory to /data/data/<package_name>/database directory. And only use select operation alone. You don't need to use create Database and table operation..

2) The database I created is located in my local drive. When the apk file gets created would the database also be included in the apk file?

For this, as I mentioned above you have to first put your database file into application's /asset directory, then copy it to internal storage (when your application start), then it works.

Look at this SO question How to ship an Android application with a database?. It answered what you needed.

Upvotes: 1

ibraheemkhalil
ibraheemkhalil

Reputation: 33

try below link http://www.higherpass.com/Android/Tutorials/Accessing-Data-With-Android-Cursors/

Upvotes: 0

Related Questions