[Android]_ch8.16_SQLiteDB刪除語法2(物件方法)

[Android]_ch8.16_SQLiteDB刪除語法2(物件方法)



刪除資料的步驟如下：

1.呼叫getWritableDatabase()建立、開啟資料庫並回傳資料庫物件

SQLiteDatabase db = getWritableDatabase();

2.設定刪除的條件。

String whereClause="id='"+id+"'";

int count=db.delete(TABLE_NAME, whereClause, null);

呼叫delete()執行刪除後會回傳成功刪除筆數。

public int deleteDBMethod(DBData data){

SQLiteDatabase db=getWritableDatabase();

String whereClause="address='"+data.getAddress()+"'";

int count=db.delete("teacher", whereClause, null);

return count;

}

btn16.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

String id=et2.getText().toString();

String name=et3.getText().toString();

String phoneNo=et4.getText().toString();

String address=et5.getText().toString();

DBData data=new DBData(id, name, phoneNo, address);

int count=dbhp.deleteDBMethod(data);

Toast.makeText(MainActivity.this, "刪除"+count+"筆成功!", Toast.LENGTH_SHORT).show();

AL=dbhp.queryAll();

showData(0);

}

});