[Android]_ch8.14_SQLiteDB條件查詢query方法

[Android]_ch8.14_SQLiteDB條件查詢query方法

public ArrayList<DBData> queryAll(DBData data){

SQLiteDatabase db=getWritableDatabase();

String[] columns={"id","name","phoneNo","address"};

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

Cursor cursor=db.query("teacher", columns, selection, null, null, null, null);

ArrayList<DBData> list=new ArrayList<DBData>();

while (cursor.moveToNext()) {

String s[]=new String[cursor.getColumnCount()];

for(int i=0;i<cursor.getColumnCount();i++){

s[i]=cursor.getString(i);

}

DBData dbdata=new DBData(s[0], s[1], s[2], s[3]);

list.add(dbdata);

}

return list;

}



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

AL=dbhp.queryAll(data);

showData(0);

}

});