Android Application Development For Dummies, 2nd Edition

Creating and Editing Tasks with SQLite

After you have a ContentProvider, you can create a task for it: Insert a record, and then list all tasks on the ReminderListFragment. The user can then tap a task to edit it, or long-press the task to delete it. These user interactions cover the create, read, update, and delete(CRUD) operations needed to make the Task Reminder application work.

Inserting a task entry

Inserting tasks is simple, after you get the hang of it. To insert your first task into the SQLite database, build the Save button click listener to:

1. Retrieve values from EditText views.

2. Store the values to the ReminderProvider database using a ContentResolver.

3. Update the user interface by displaying a toast and closing the edit activity.

After inserting your first task, you should have enough of a grasp on the ReminderProvider class interaction to perform more tasks. The next sections introduce you to the entire implementation of ReminderProvider, which outlines the CRUD operations.

Saving values from the screen to the database

When the user creates a task, it takes place in the OnClickListener of the mConfirmButton of ReminderEditFragment. There, the app responds to the user’s Save button click. If the mRowId for the fragment is 0, the user wants to add a new task. If the mRowId is greater than 0, the user wants to edit an existing task. You first set up some parameters, ask a ContentResolver to complete a create or update, and then process the result and notify ...