sqlite查询相关问题
问题描述:
我有某些具有特定代码的sqlite数据。sqlite查询相关问题
String sql = "create table " + TABEL
+"(" + BaseColumns._ID+" integer PRIMARY KEY AUTOINCREMENT," + STARTTIME
+ " text," + ENDTIME + " text," + DURATION + " text,"
+ PHONEOPTION + " text," + MODE + " text);";
db.execSQL(sql);
Log.i("DATABASE ", "db created ");
我想获取持续时间列中没有空数据的行。 我有一定的代码,但它获取其中的所有数据。
public Cursor getData() {
SQLiteDatabase sqlitedb = contactsdbHelper.getReadableDatabase();
Cursor cursor = sqlitedb.query(ContactsDatabaseHelper.TABEL, null,null,null, null,null, BaseColumns._ID + " DESC");
startManagingCursor(cursor);
return cursor;
}
答
试着这么做:
Cursor cursor = sqlitedb.rawQuery(
"SELECT * FROM " + ContactsDatabaseHelper.TABEL + " WHERE " +
ContactsDatabaseHelper.DURATION + " NOT NULL", null);