An Android SQLite Project

---

This project demonstrates how to work with an SQLite database. There are normally two ways to manage SQLite data:

Data Access Object (DAO)

This application uses the DAO approach, which is responsible for handling the database connection and for accessing and modifying the data, so that the user interface code does not have to deal with the persistence layer.

Content Provider

An SQLite database is private to the application which creates it. A ContentProvider allows the data to be shared with other applications.

The following five components of this app will be detailed:

• Android manifest file (AndroidManifest.xml),


• Layout XML code (main.xml),


• Strings (strings.xml),


• The R file (R.java), and


• Java source code (
  • TestDatabase.java,
  • CommentsDataSource.java,
  • MySQLiteHelper.java, and
  • Comment.java).