基于Andriod平台的安卓记事本源码研讨.docVIP

DatabaseHelper.java package com.notepad.namespace; import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteOpenHelper; public class DatabaseHelper extends SQLiteOpenHelper { private String tableName = record; private Context mContext = null; private String sql = create table if not exists + tableName + (_id integer primary key autoincrement, + title varchar, + content text, + time varchar); public DatabaseHelper(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); // TODO Auto-generated constructor stub } @Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub //创建表 db.execSQL(sql); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub } } DatabaseManage.java package com.notepad.namespace; import java.util.Date; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteException; import android.util.Log; public class DatabaseManage { private Context mContext = null; private SQLiteDatabase mSQLiteDatabase = null;//用于操作数据库的对象 private DatabaseHelper dh = null;//用于创建数据库的对象 private String dbName = notepad.db; private int dbVersion = 1; public DatabaseManage(Context context){ mContext = context; } /** * 打开数据库 */ public void open(){ try{ dh = new DatabaseHelper(mContext, dbName, null, dbVersion); if(dh == null){ Log.v(msg, is null); return ; } mSQLiteDatabase = dh.getWritableDatabase(); //dh.onOpen(mSQLiteDatabase); }catch(SQLiteException se){ se.printStackTrace(); } } /** * 关闭数据库 */ public void close(){ mSQLiteDatabase.close(