[Android]_ch8.12_SQLiteDB新增語法3(物件方法)

[Android]_ch8.12_SQLiteDB新增語法3(物件方法)



public long insertDBMethod(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);

long rowId=db.insert("teacher", null, values);

return rowId;

}



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

long rowId=dbhp.insertDBMethod(data);

if(rowId==-1)

Toast.makeText(MainActivity.this, "很抱歉新增失敗!rowId="+rowId, Toast.LENGTH_SHORT).show();

else

Toast.makeText(MainActivity.this, "恭喜新增成功!rowId="+rowId, Toast.LENGTH_SHORT).show();

AL=dbhp.queryAll();

showData(0);

}

});