[Android]_ch8.19_SQLiteDB模糊查詢LIKE

[Android]_ch8.19_SQLiteDB模糊查詢LIKE

public ArrayList<DBData> likeQuery(DBData data){

SQLiteDatabase db=getWritableDatabase();

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

Cursor cursor=db.rawQuery("SELECT * FROM teacher WHERE address LIKE?", 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;

}