[Android]_ch8.10_SQLiteDB更新語法2(物件導向)

[Android]_ch8.10_SQLiteDB更新語法2(物件導向)



public void updateDB(DBData data){

SQLiteDatabase db=getWritableDatabase();

String id=data.getId();

String name=data.getName();

String phoneNo=data.getPhoneNo();

String address=data.getAddress();

db.execSQL("UPDATE teacher SET id='"+id+"',name='"+name+"',phoneNo='"+phoneNo+"',address='"+address+"' WHERE id='"+id+"';");

}



btn9.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);

dbhp.updateDB(data);

Toast.makeText(MainActivity.this, "更新成功!", Toast.LENGTH_SHORT).show();

AL=dbhp.queryAll();

showData(0);

}

});