Iat 381 Lec 6

Front 1

Syntax for inserting something in the database

Back 1

Front 2

T/F you need a constants class

Back 2

false, you don't need one, you can put in a string name on your own (its just better to have a constants class tho)

Front 3

what is in the database class?

Back 3

- SQLiteDatabase instance and helper

Front 4

what 2 important methods are in the SQLiteOpenHelper

Back 4

onCreate() and onUpgrade()

Front 5

what is in the constants class? (if you make one)

Back 5

holds all the string constants (e.g table names, column names, etc.)

Front 6

T/F - we want to keep the UI code separate from the database code

Back 6

true (i have no idea why this is so important rn)

Front 7

what is this syntax doing?

private static final String CREATE_TABLE = "CREATE TABLE" + Constants.TABLE_NAME + "(" +Constants.UID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + Constants.COLUMN_NAME1 + "TEXT, " +Constants.COMUM_NAME2 + "TEXT);" ;

Back 7

creating/setting up a table

Front 8

what is wrong with this:

private static final String CREATE_TABLE = "CREATE TABLE" + Constants.TABLE_NAME + "(" +

Constants.COLUMN_NAME1 + "TEXT, "+

Constants.COMUM_NAME2 + "TEXT);" ;

Back 8

missing: Constants.UID + " INTEGER PRIMARY KEY AUTOINCREMENT, "

Front 9

whats wrong with this?

private static final String CREATE_TABLE = "CREATE TABLE" + Constants.TABLE_NAME + "(" +Constants.UID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + Constants.COLUMN_NAME1 + "TEXT, " +Constants.COMUM_NAME2 + "TEXT)" ;

Back 9

missing a semicolon before the last semicolon >):

private static final String CREATE_TABLE = "CREATE TABLE" + Constants.TABLE_NAME + "(" +Constants.UID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + Constants.COLUMN_NAME1 + "TEXT, " +Constants.COMUM_NAME2 + "TEXT) ; " ;

Front 10

what are the two things passed into the query method when reading data from the database?

Back 10

selection criteria and the desired columns

Front 11

what are the results in the query returned in?

Back 11

a cursor object

Front 12

what is a cursor?

Back 12

gives us access to the results returned from a database query and allows navigation through the result set

Front 13

what is the syntax of the query method?

Back 13

public Cursor query (boolean distinct,

String[] columns,

String selection,

String[] selectionArgs,

String groupBy,

String having,

String orderBy,

String limit){...}

Front 14

what is the parameter boolean distinct for in the query method?

Back 14

make true if you want each row to be unique

Front 15

what is the parameter String having for in the query method?

Back 15

a filter to declare what groups to include in the cursor

Front 16

what is a SimpleCursorAdapter?

Back 16

an adapter to map columns from a cursor to TextViews or ImageViews defined in an XML file

Front 17

what is a way to link the database to UI?

Back 17

use a ListView - basically anything that will show the contents of the database

Front 18

what are the advantages of using a SimpleCursorAdapter

Back 18

- don't need to process the data from the cursor

- is a simplified getData() method