MAP524/DPS924 Lab 6
Due: in the lab period, need professor sign-off.
Part A
- Create a simple Android app, named MyFriends, that contains a database of your friends. The database should contain information about each of your friends; specifically, the name, email address and phone number for each friend. Your database should contain a minimum of 100 friends. Use generatedata.com to make your data for your sqlite database.
- The only function your database provides is the ability to scroll through all names in the database. i.e. No updating, no deleting and no adding of names - only scrolling.
- Your UI should contain the following items:
- EditText - user can enter the database name
- ListView - to show a scrollable list of only the names in the database
- When the user clicks on the name of a friend, the email address and phone number should be displayed.
- Also, your app should include an Action Bar menu for "About" and "Help" information.
Part B
Explain the purpose/function of each of the following in your own words (that means not someone else's words), in your labbook:
- Where exactly (give the full path name) is the database you created stored on your phone?
- SQLiteOpenHelper class
- SQLiteDatabase class
- Cursor class
- query() method
- rawQuery() method
- onUpgrade() method
- The db handler class you created which extends SQLiteOpenHelper