News »Browse Articles » SQLJet: Working With SQLite Databases in Pure Java

SQLJet is an independent pure Java open source implementation of the SQLite RDBMS core functionality. SQLJet provides API to create, read and modify SQLite databases. Below you`ll find simple tutorial demonstrating how one could use SQLJet Library to perform basic operations with the database in the SQLite format.

SQLJet first major version (1.0.0) has been just released. For more information and most recent updates please visit SQLJet home page at http://sqljet.com/.

Tutorial Contents
This is a very simple tutorial on how to use SQLJet API to work with the database in SQLite format. The following operations are described:

Create new database and configure options
Create table and indices
Insert records
Select records in order specified by index
Lookup records matching scope or exact value
Update and delete records
Drop table and index
Full working source code of this example is available as part of SQLJet project in Subversion repository at Tutorial.java.

Create new database

Source:
http://java.dzone.com/articles/sqljet-pure-java-way-work

No Comments For This News

Post a link to something interesting from another site, or submit your own original writing for the Java community to read.