SQLite is a great standalone SQL database engine – not ideal for every situation (particularly large websites), but more than good enough to have already made its way into desktop projects. Recently I use it in my integration project to record transaction data like Id, name, date, etc. It’s small and easy.

Two ways wrapper Java JDBC driver for use. I adopt the SQLiteJDBC. You can look at from A Quick Note on using SQLite in Processing

Another is Christian Werner’s SQLite Java Wrapper/JDBC Driver. You can read this, SQLite 3 and Java, and Using Sqlite in .Net and Java.

Tool instead of CLP:
1. SQLiteSpy is a fast and compact GUI database manager for SQLite
2. SQLite Database Browser

1. Java and SQLite
2. Using SQLite for Simple Database Storage
3. An Introduction to SQLite