java - 如何通过字符串搜索sqlite中的列

Question

当字符串与 sqlite 的列匹配时，我想返回一个 true/false 值。如何实现搜索功能？

如何使用光标进行搜索？

public boolean searchLuggage(String code) {

 ArrayList<String> luggageCheck = new ArrayList<String>();
 SQLiteDatabase db = this.getReadableDatabase();

 try {
     Cursor cursor = db.query(true, TABLE_LUGGAGES, new String[] { your field list }, SearchColumnname + "='" + code + "'", null, null, null, null, null);

     if (cursor != null) {
         cursor.moveToFirst();
         for (int i = 0; i < cursor.getCount(); i++) {
            luggageCheck.add(cursor.getString(0));
            cursor.moveToNext();
         }
         cursor.close();
         return true;
     }
     return false;
} catch (Exception e) {
    e.printStackTrace();
}
   return true;
}




// Creating Tables
@Override
public void onCreate(SQLiteDatabase db) {
    String CREATE_LUGGAGE_TABLE = "CREATE TABLE " + TABLE_LUGGAGES + "(" + KEY_NAME + " TEXT NOT NULL," + KEY_CODE + " TEXT NOT NULL," + KEY_NUMBER + " TEXT NOT NULL );";
    db.execSQL(CREATE_LUGGAGE_TABLE);
}

Answer 1

替换这个

 Cursor cursor = db.query(true, TABLE_LUGGAGES, new String[] { your field list }, SearchColumnname + "='" + code + "'", null, null, null, null, null);

有了这个

 Cursor cursor = db.query(true, TABLE_LUGGAGES, null, SearchColumnname + "= ?", new String[] { code }, null, null, null, null);