本文转自:http://code.google.com/p/androidlearn/wiki/SQLiteOpenHelper
继承SQLiteOpenHelper类,在构造方法中分别需要传入Context,数据库名称,CursorFactory(一般传入null,为默认数据库),数据库版本号(不能为负数)。在SQLiteOpenHelper中首先执行的是onCreate方法(当shujk第一次被创建时)。在构造函数时并没有真正创建数据库,而在调用getWritableDatabase或者getReadableDatabase方法时才真正去创建数据库,返回一个SQLiteDatabase对象。
TAG
KEY_ID
KEY_NUM
KEY_DATA
DB_NAME
DB_TABLE
DB_VERSION
mContext
DB_CREATE DB_TABLE KEY_ID KEY_NUM KEY_DATA
mSQLiteDatabase
mDatabaseHelper
context
context DB_NAME DB_VERSION
onCreate db
dbexecSQLDB_CREATE
onUpgrade db oldVersion newVersion
dbexecSQL
onCreatedb
context
mContext context
open
mDatabaseHelper mContext
mSQLiteDatabase mDatabaseHelpergetWritableDatabase
close
mDatabaseHelperclose
insertData num data
initialValues
initialValuesputKEY_NUM num
initialValuesputKEY_DATA data
mSQLiteDatabaseinsertDB_TABLE KEY_ID initialValues
deleteData rowId
mSQLiteDatabaseDB_TABLE KEY_ID rowId
fetchAllData
mSQLiteDatabasequeryDB_TABLE KEY_ID KEY_NUM KEY_DATA
fetchData rowId
mCursor mSQLiteDatabasequery DB_TABLE KEY_ID KEY_NUM KEY_DATA KEY_ID rowId
mCursor
mCursormoveToFirst
mCursor
updateData rowId num data
args
argsputKEY_NUM num
argsputKEY_DATA data
mSQLiteDatabaseupdateDB_TABLE args KEY_ID rowId