public class MyHelper extends SQLiteOpenHelper {比如说我想上面这样定义一个MyHelper 类继承SQLiteOpenHelper ,那么我在其他的地方用到MyHelper这个类的时候,public static final String DB_NAME = "schedule.db"; public static final int VERSION = 1; public static final String DATABASE_CREATE = "这里是创建表的语句"; public MyHelper(Context context) { super(context, DB_NAME, null, VERSION); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL(DATABASE_CREATE); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL("drop table if exists " + TABLE_NAME); onCreate(db); }
}
public class DbAdapter {private final Context mCtx; private MyHelper helper; private SQLiteDatabase db; public DbAdapter(Context ctx) { this.mCtx = ctx; } public DbAdapter open() throws SQLException { helper = new MyHelper(mCtx); db = helper.getWritableDatabase(); return this; } public void close() { helper.close(); }
}
创建MyHelper对象的时候只是创建了一个SQLiteOpenHelper对象,用于管理数据库,调用getWritableDatabase()方法时才会执行onCreate方法,并且onCreate方法只会执行一次(第一次调用getWritableDatabase时,数据库不存在时执行)。