Java JDBC using SQLite/Introduction

This book deals with the problem of using Java to make connections to databases and successfully handle data in the databases. It assumes a basic understanding of Java concepts.

The example database used is freely available as a download from http://www.sqlite.org/; at time of writing the recommended version was Version 3.6.14.2. It is recommended that you download a copy of this if you intend to proceed with this tutorial since it will allow you to visit your databases independently of the Java programs to assess and evaluate the data structures and contents. In addition to this you will also need a functional Java JDK, optimally release 1.5 or higher since this gives support to the much improved JDBC 2.0 drivers; ideally you will have the very latest Java release. You will also need a downloaded copy of the JDBC jar file in order to connect your Java programs to the database. The JDBC jar files can be found at a number of locations (e.g. http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC). Most of what is said in here can equally well be applied to any other database connection; the reason SQLite is used is because of its exceedingly low and lightweight costs, and because there is a freely available front end for further investigation of data and data structures.

In summation then, you need:

• a reference copy of SQLite from http://www.sqlite.org/
• a JDK
• a SqLite jar file

A basic explanation of JDBC drivers and their usage is available on Wikipedia at [1].

Next Page: Preparation
Previous Page: Title Page