How to create a SQLite database in a general java project (not specific to android) using Eclipse?

Question

I want to create a database for my android app.
At first, I want create it fully and then I will use it on my android project.
I can make sqlite database in SQLite IDE (sqlite database browser).
But I want to create it programmatically.
Because I will fetch data from a text file and push it to database.
It will be very fast and easier than IDE to make a database.
So my question, is there any way to make a SQLite database without SQLite database IDE in general java project (not specific to android) and what is that?
Thanks in advance.
Sorry for my bad English.

look at this http://stackoverflow.com/questions/4398575/sqlite-database-in-android-and-java — rajshree, Feb 13 '14 at 11:26

score 1 · Accepted Answer · answered Feb 13 '14 at 11:27

1

You basically would just need to include the appropriate connection jars in your project and implement your own C.R.U.D. operations. A quick google search comes up with a a bunch of good tutorials. Here's a basic one to start with.

answered Feb 13 '14 at 11:27

SBerg413

14,515
6
62
88

score 1 · Answer 2 · answered Feb 13 '14 at 12:04

1

You should look at this project https://bitbucket.org/xerial/sqlite-jdbc. I've used it in several projects. very good.

answered Feb 13 '14 at 12:04

rnkoaa

36
2
2

How to create a SQLite database in a general java project (not specific to android) using Eclipse?

2 Answers2