4数据存储研讨.ppt

delete示例 private void delete(SQLiteDatabase db){ String sql = delete from UserTbl where _id=2 ; db.execSQL(sql); } // 删除2 private void delete2(SQLiteDatabase db){ String whereClause = _id=?; String[] whereArgs = {String.valueOf(1)}; db.delete(UserTbl, whereClause, whereArgs); } update public int update (String table, ContentValues values, String whereClause, String[] whereArgs) Convenience method for updating rows in the database. table the table to update in values a map from column names to new column values. null is a valid value that will be translated to NULL. whereClause the optional WHERE clause to apply when updating. Passing null will update all rows. Returns the number of rows affected update示例 private void update(SQLiteDatabase db){ String sql = update UserTbl set password=888 where _id=1 ; db.execSQL(sql); } // 修改2 private void update2(SQLiteDatabase db){ ContentValues values = new ContentValues(); values.put(password, 999); String whereClause = _id=?; String[] whereArgs = {String.valueOf(1)}; db.update(UserTbl, values, whereClause, whereArgs); } SQLiteOpenHelper SQLiteOpenHelper是SQLiteDatabase的一个帮助类，用来管理数据库的创建和版本更新。 一般用法是定义一个类继承自SQLiteOpenHelper ，并实现其中的两个抽象方法onCreate和onUpdate来创建和更新数据库。 SQLiteOpenHelper常用方法 SQLiteOpenHelper(Context context, String name, CursorFactory factory,int version) 构造方法，一般是传递一个要创建的数据库名称onCreate(SQLiteDatabase db)创建数据库时调用 onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)版本更新时调用 getWritableDatabase()创建或打开一个读写数据库 getReadableDatabase()创建或打开一个只读数据库 public class DBHelper extends SQLiteOpenHelper { private static final String DB_NAME = coll.db; private static final String TBL_NAME = CollTbl; private static final String CREATE_TBL = create table + CollTbl(_id integer primary key autoincrement,name text,url text, desc text) ; private SQLiteDatabase db; DBHelper(Context c) { super(c, DB_NAME, null, 2); } public void onCreate(SQLiteDatabase