MAP524/DPS924 Lab 6

From CDOT Wiki
Jump to: navigation, search

Due: in the lab period, need professor sign-off.

Part A

  1. 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.
  2. 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.
  3. 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
  4. When the user clicks on the name of a friend, the email address and phone number should be displayed.
  5. 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