Working with SQLite databases

Once you have created an SQLite database, you can use SQL statements to add data, retrieve data, and modify the database.

The list of supported SQL statements and their syntax is available on the SQLite web site. The Database API does not support the following SQLite statements: ATTACH DATABASE, DETACH DATABASE, and PRAGMA. In addition, FTS2 and RTREE are not supported.

The following steps outline the basic procedure for running statements:

  1. Create an SQL statement by invoking Database.createStatement().
  2. Prepare the statement to run by invoking Statement.prepare().
  3. Run the statement. If the statement might return results, run it by invoking Statement.getCursor(). Otherwise, use Statement.execute().
  4. If the statement returns a result set, retrieve the result set by iterating over the returned cursor row by row. Do this using the Cursor interface, which works in all circumstances but is forward-only. For birectional cursor movement, but only for small result sets, use the BufferedCursor class.

Was this information helpful? Send us your comments.