Learning Android™ Application Programming: A Hands-On Guide to Building Android Applications

Updating the Model

Now you will update the trip model to insert, update, and delete trips.

1. Open the Trip model class in com.androiddevcom.onyourbike.chapter7.model. Add insert, update, and delete methods, all returning nothing and taking a single parameter named database of type SQLiteDatabase. The insert method takes an extra parameter of type long named route_id (see Listing 7.37).

Listing 7.37 Creating the Methods to Insert, Update, and Delete Trips

Click here to view code image

public void insert(SQLiteDatabase database, long route_id) {}public void update(SQLiteDatabase database) {}public void delete(SQLiteDatabase database) {}

2. In the insert method, create a local variable named insertRow, and assign it the SQL to add a trip to the ...