This article contains examples about how to operate SQLite database table data via android ListView control. It shows how to load, add, edit, delete and refresh rows in android ListView while save the modified result data back to SQLite database table.
This example will tell you how to encapsulate android SQLite database operations in java class, then you can reuse them to operate different SQLite database and tables.
This article contains example about how to create SQLite database, how to create table and how to insert, update, delete, query SQLite table. You can read article Android SQLite Database Introduction for general SQLite concepts.
Android use SQLite as it’s default built-in database. SQLite is a light weight relational database. The database operation speed is very fast and it occupied disk space is small. Usually it only need some hundred KB disk space to run.