This article contains examples of 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 saving the modified result data back to the SQLite database table.
This example will tell you how to encapsulate android SQLite database operations in the java class, then you can reuse them to operate different SQLite databases and tables.
This article contains examples about how to create an SQLite database, how to create a table, and how to insert, update, delete, query SQLite tables. You can read the article Android SQLite Database Introduction for general SQLite concepts.
Android uses SQLite as it’s default built-in database. SQLite is a lightweight relational database. The database operation speed is very fast and its occupied disk space is small. Usually, it only needs some hundred KB of disk space to run.