Android SQLite database into device

Question

I'm developing an android application which contains 2 tables. I saw the table under DDMS tab. These two table contains some important data for my application(For example: username and password for 2000 records). But When I install my application on device, I couldn't able to see the table.

Also, In device when I'm running my application it creates a new table. This table contains no records. So when I check for username and password, it return no rows, affect my application.

So I need to copy the two tables into the device at the time of installing apk file. Is there any ways to do this?

`when I'm running my application it creates a new table` how does it do that? Thats the point where you have to populate the table. — Henry, Feb 02 '13 at 06:19
if you not have any records it cant be show something to you. try to add one example recort to your db — hakki, Feb 02 '13 at 06:21
If I'm adding any records it will be added. But I need that table with those 2000 records — Linga, Feb 02 '13 at 06:25
Package the data into your application (for example as an asset file). When you create the DB, insert the records. — Henry, Feb 02 '13 at 06:31
Not possible. I need to copy the database onto the device. Is there no ways? — Linga, Feb 02 '13 at 06:39
You can use JSON or XML to store your information. Place this file into assets directory. And when your app created database you could fill it with your information. — Nolesh, Feb 02 '13 at 06:41
Yes it is possible: Refer to http://stackoverflow.com/questions/1951805/how-to-access-an-existing-sqlite-database-in-android — Skynet, Feb 02 '13 at 06:42
I faced with the same problem and I didn't find any solution for that. So I decided to store my data inside XML file and parsed it if necessary. — Nolesh, Feb 02 '13 at 06:45
Place your DB which contains your login information in assets and provide the path mate! — Skynet, Feb 02 '13 at 06:46
@Chronically Instance If I provided path to asset, will it accessible in device. I think the path may vary — Linga, Feb 02 '13 at 06:48
@Areas If I saved it as JSON, can I modify it in the future? How do i access that JSON in my code — Linga, Feb 02 '13 at 06:49
The path will not vary! How do you conclude a path can vary? Yes assets folder is meant for such type of access. Its the reason why you have an assets folder. — Skynet, Feb 02 '13 at 06:51
@Chronically Insane. You mean, I should copy my database and paste it on asset folder and give path in my code? — Linga, Feb 02 '13 at 06:53
There is a lot of code. You should read about working with XML and JSON. You can change XML nodes as well as in sqllite — Nolesh, Feb 02 '13 at 06:58
I have created it by my self. Note: do not store passwords and logins in database, xml and so on. It's not safe! — Nolesh, Feb 02 '13 at 07:06
check this.. http://stackoverflow.com/questions/14081085/database-not-being-copied-from-assets-folder-to-device — Deepzz, Feb 02 '13 at 07:40

score -2 · Answer 1 · answered Feb 02 '13 at 06:38

-2

You can fetching your database tables records using

SQLiteDatabase myDB = this.openOrCreateDatabase("test.sqlite",
          SQLiteDatabase.OPEN_READWRITE, null);
Cursor c = myDB.rawQuery("select a, b from abc", null);

answered Feb 02 '13 at 06:38

Ashish Jani

295
3
14

the answer is not eligible. You should read question more carefully – Nolesh Feb 02 '13 at 06:53

Android SQLite database into device

1 Answers1