[Android]_ch8.13_SQLiteDB更新語法3(物件方法)

[Android]_ch8.13_SQLiteDB更新語法3(物件方法)



public int updateDBMethod(DBData data){

SQLiteDatabase db=getWritableDatabase();

String id=data.getId();

String name=data.getName();

String phoneNo=data.getPhoneNo();

String address=data.getAddress();

ContentValues values=new ContentValues();

values.put("id", id);

values.put("name", name);

values.put("phoneNo", phoneNo);

values.put("address", address);

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

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

return count;

}



 btn12.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

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

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

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

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

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

int count=dbhp.updateDBMethod(data);

Toast.makeText(MainActivity.this, "更新"+count+"筆資料", Toast.LENGTH_SHORT).show();

AL=dbhp.queryAll();

showData(0);

}

});