[Android]_ch8.15_SQLiteDB條件查詢rawQuery方法

[Android]_ch8.15_SQLiteDB條件查詢rawQuery方法



public ArrayList<DBData> keyWordQuery(DBData data){

SQLiteDatabase db=getWritableDatabase();

String selectionArgs[]={data.getAddress()};

Cursor cursor=db.rawQuery("SELECT * FROM teacher WHERE address=?;", selectionArgs);

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;

}



btn14.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.keyWordQuery(data);

showData(0);

showOnTv1();

}

});



public void showOnTv1(){

    StringBuilder sb=new StringBuilder("條件查詢結果如下:\n");

    if(AL.size()>0){

    for(int i=0;i<AL.size();i++){

    String data=AL.get(i).getId()+"\t"+AL.get(i).getName()+"\t"+AL.get(i).getPhoneNo()+"\t"+AL.get(i).getAddress()+"\n";

    sb.append(data);

    }

    }else{

    sb.append("查詢不到資料!");

    }

    tv1.setText(sb);

    }