sqlite查询相关问题

发布于 2024-10-21 13:14:31 字数 692 浏览 1 评论 0原文

我有某些具有特定代码的 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;

}

原文

I have certain sqlite data having the certain code.

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 ");

and i want to fetch the rows where duration column having not null data.
i have certain code but it fetch the all data in it.

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;

}

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

八巷 2024-10-28 13:14:31

尝试类似的方法：

Cursor cursor = sqlitedb.rawQuery(
    "SELECT * FROM " + ContactsDatabaseHelper.TABEL + " WHERE " +
    ContactsDatabaseHelper.DURATION + " NOT NULL", null);

Try something like:

Cursor cursor = sqlitedb.rawQuery(
    "SELECT * FROM " + ContactsDatabaseHelper.TABEL + " WHERE " +
    ContactsDatabaseHelper.DURATION + " NOT NULL", null);

回复收藏 0 原文

~没有更多了~