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

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

public void insertDB(DBData data){

SQLiteDatabase db=getWritableDatabase();

String id=data.getId();

String name=data.getName();

String phoneNo=data.getPhoneNo();

String address=data.getAddress();

db.execSQL("INSERT INTO teacher VALUES('"+id+"','"+name+"','"+phoneNo+"','"+address+"');");

}



btn7.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.insertDB(data);

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

AL=dbhp.queryAll();

showData(index);

}

});