import android.content.ContentValues; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase;  /**  * 對表的增刪改查的操作。這里的表里只有uid一列作為舉例。  */ public class DemoDBUtil {   //要操作的表名  public static final String DEMO_DB_NAME = "demo_db_name";  //SQLiteDatabase對象  private SQLiteDatabase sqLiteDatabase;    /**   * 帶參構(gòu)造方法，初始化SQLiteDatabase。   * @param sqLiteDatabase SQLiteDatabase實(shí)例   */  public DemoDBUtil(SQLiteDatabase sqLiteDatabase){   this.sqLiteDatabase = sqLiteDatabase;  }    /**   * 增加數(shù)據(jù)。   * @param uid 要新增的uid   */  public void add(String uid){   ContentValues values = new ContentValues();   values.put("uid", uid);   sqLiteDatabase.insert(DEMO_DB_NAME, null, values);  }    /**   * 刪除表里所有數(shù)據(jù)。   */  public void delete(){   sqLiteDatabase.delete(DEMO_DB_NAME, null, null);  }    /**   * 刪除表里與uid對應(yīng)的數(shù)據(jù)。   * @param uid 某個(gè)uid   */  public void delete(String uid){   sqLiteDatabase.delete(DEMO_DB_NAME, "uid = ? ", new String[]{uid});  }    /**   * 更新表，將表所有uid替換為newUid。   */  public void update(){   ContentValues values = new ContentValues();   values.put("uid", "newUid");   sqLiteDatabase.update(DEMO_DB_NAME, values, null, null);  }    /**   * 將表里對應(yīng)的uid替換為newUid。   * @param uid 表里的某個(gè)uid   */  public void update(String uid){   ContentValues values = new ContentValues();   values.put("uid", "newUid");   sqLiteDatabase.update(DEMO_DB_NAME, values, "uid = ? ", new String[]{uid});  }    /**   * 查詢表里所有數(shù)據(jù)，取得uid對應(yīng)的值。   */  public void query(){   Cursor cursor = sqLiteDatabase.query(DEMO_DB_NAME, null, null, null, null, null, null);   while (cursor.moveToNext()) {    String uid = cursor.getString(cursor.getColumnIndex("uid"));   }   if (null != cursor) {    cursor.close();   }  }    /**   * 取得對應(yīng)uid的值。   * @param uid 表里的某個(gè)uid   */  public void query(String uid){   Cursor cursor = sqLiteDatabase.query(DEMO_DB_NAME, null, "uid = ? ", new String[]{uid}, null, null, null);   while (cursor.moveToNext()) {    String queryUid = cursor.getString(cursor.getColumnIndex("uid"));   }   if (null != cursor) {    cursor.close();   }  }    /**   * 取得最后一條記錄。   */  public void queryLastRecord(){   String lastTimeSql = "select * from demo_db_name order by id desc LIMIT 1";   Cursor cursor = sqLiteDatabase.rawQuery(lastTimeSql, null);   while (cursor.moveToNext()) {    String queryUid = cursor.getString(cursor.getColumnIndex("uid"));   }   if (null != cursor) {    cursor.close();   }  } }