chenzx.dataassistant.db.DBHelper,chenzx.dataassistant.db.NoteDB都模仿EOE源码了。
两个类之间的逻辑应该是 应用直接调用NoteDB,并将数据传给NoteDB,NoteDB调用DBHelper进行相关的数据库操作。如此来降低耦合性或实现MVC(是这么描述吧)?
package chenzx.dataassistant.db;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.provider.BaseColumns;
/**
* DBHelper,数据库操作类,首次使用建表,更新表结构。onUpgrade方法会删除所有表,并重新建立,原有数据会消失,
* @author chenzx
*
*/
public class DBHelper extends SQLiteOpenHelper {
private static final String DB_NAME = "dataassistant.db";
private static final int DB_VERSION = 2;
private SQLiteDatabase db;
private static DBHelper mdbHelper;
public static DBHelper getInstance(Context context)
{
if(mdbHelper==null)
{
mdbHelper=new DBHelper(context);
}
return mdbHelper;
}
private DBHelper(Context context) {
super(context, DB_NAME, null, DB_VERSION);
}
private DBHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, versi