Android sqlite database access

Question

I have made a sample.sql database with "SQL Lite Manager".

How can I access this in an Android project?

user370305 · Accepted Answer · 2012-01-17 07:16:26Z

1

Put your prebuild database file in /assets directory in your apk,
and on first use copy to "/data/data/<application_package>/databases/" directory.

Now use it with SQLite Database Helper class in your android application...

For more info look at this Article

answered Jan 17, 2012 at 7:16

user370305

109k23 gold badges167 silver badges153 bronze badges

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

Comments

Ted Hopp · Accepted Answer · 2012-01-17 07:16:52Z

0

There are several steps to using an existing SQLite data base in an Android project. They are nicely described in this blog post by Juan-Manuel Fluxà.

Basically, you need to make sure that the data base contains certain tables and column names, then when your program first runs, copy the data base from your assets or resources folder to the standard db location for your app. The latter step is best done by writing a DataBaseHelper class the way that Fluxà describes.

answered Jan 17, 2012 at 7:16

Ted Hopp

235k48 gold badges412 silver badges533 bronze badges

Collectives™ on Stack Overflow

Android sqlite database access

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related