Question

Android SQLite 数据库查询问题，紧急！~在线等~~

查询数据库的写法如下：String where = “字段1 = XX and 字段2 <> 'YY ' ";Cursor cursor = mDatabase.query (TABLE_NAME, COLUMNS, where, null, null, null, null);明明数据库里有符合条件的数据，却怎么也查不出来，不知道怎么回事，还请哪位高人指点一下啊~~~

Answer 1

表结构是这样的：String TABLE_NAME = "OrderEntryInfo"; //table name String ORDER_ID = "OrderId"; String TABLE_NO = "TableNo"; String ITEM_ID = "ItemId"; String ITEM_ORDER_TIMES = "ItemOrderTimes"; String STAFF_ID = "StaffId"; String CUSTOMER_NUMBER = "CustomerNumber"; String CUSTOMER_AGE_LEVEL = "CustomerAgeLevel"; String ORDER_TIME = "OrderTime"; String ORDER_TYPE = "OrderType"; String ORDER_PAY_STATUS = "OrderPayStatus"; String SQL_CREATE_ORDERENTRYINFO = "CREATE TABLE " + TABLE_NAME + "(" + ORDER_ID + " INTEGER PRIMARY KEY, " + TABLE_NO + " INTEGER NOT NULL , " + ITEM_ID + " INTEGER NOT NULL , " + ITEM_ORDER_TIMES + " INTEGER NOT NULL , " + STAFF_ID + " TEXT NOT NULL, " + CUSTOMER_NUMBER + " TEXT NOT NULL, " + CUSTOMER_AGE_LEVEL + " TEXT NOT NULL, " + ORDER_TIME + " TEXT NOT NULL, " + ORDER_TYPE + " TEXT, " + ORDER_PAY_STATUS + " TEXT)";

Answer 2

你 OrderPayStatus 字段是 null 用这个查下试试select * from OrderEntryInfo where OrderPayStatus <> 'yes' or OrderPayStatus is null

Answer 3

你给这么点信息 谁也不好给你解决问题啊！