0

I want to connect my java program to the SQLite db. What are necessary steps that I have to follow. I want to install sqlite database on my system to access the database.

Lukas Knuth
  • 25,449
  • 15
  • 83
  • 111
mayur rahatekar
  • 4,410
  • 12
  • 37
  • 51

3 Answers3

4

From the SQLite Homepage:

SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. [...]

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.

So you don't actually install SQLite. To create and work with SQLite Databases, you can use the provided sqlite-shell, which is a command-line tool. If you are familiar with SQL, this should not be a problem.

Although, there are also some GUI-tools out there to work with SQLite...

If you want your Java-application to access and work with an SQLite Database, you'll need the necessary drivers. A nice topic on this can be found here.

Community
  • 1
  • 1
Lukas Knuth
  • 25,449
  • 15
  • 83
  • 111
1

Hello mayur rahatekar,

Here's a quick tutorial for creating a sqlitedb on your computer, its explained from the ground of: SQLiteDB with some Androidflavour

Best Regards

safari

safari
  • 7,565
  • 18
  • 56
  • 82
  • Thanks a lot to your reply. I want to connect SQLite database to the Pure java program.So Can I have to Install SQLite database on my system. Is their any exe file which will Install SQL Lite database on the System. – mayur rahatekar Oct 10 '11 at 07:09
  • 1
    yes there is use the sqllite browser: http://sourceforge.net/projects/sqlitebrowser/ if you found the answer good please +1 and the green tick ;) – safari Oct 10 '11 at 07:14
1

You can take the help of mozilla firefox browser.If you have then you can search on google how to integrate sqlite with mozilla.it's very easy.Click here to see the link.

Android Killer
  • 18,174
  • 13
  • 67
  • 90