时间戳

首页 > 解决方案 > Sqlite DB 游标问题

android - Sqlite DB 游标问题

问题描述

每次“无法从 CursorWindow 读取第 0 行，col -1 行。请确保在从中访问数据之前正确初始化光标。” 我尝试了一切，但没有任何效果。我的代码如下：

val selectQuery = "SELECT * FROM "+TABLE_POS_ORDERS
val db = this.readableDatabase

var cursor = db.rawQuery(selectQuery,null)
cursor.moveToFirst()
 if (cursor.moveToFirst()) {
           do {
               id = cursor.getInt(cursor.getColumnIndex(PosOrderKeys.ID))
               orderId = cursor.getInt(cursor.getColumnIndex(PosOrderKeys.ORDER_ID))
               dateandtime = cursor.getString(cursor.getColumnIndex(PosOrderKeys.DATE_AND_TIME))
               restaurant_id = cursor.getInt(cursor.getColumnIndex(PosOrderKeys.RESTAURANT_ID))
               restaurant_name =
                   cursor.getString(cursor.getColumnIndex(PosOrderKeys.RESTAURANT_NAME))
               deliveryType_decription =
                   cursor.getString(cursor.getColumnIndex(PosOrderKeys.DELIVERY_TYPE_DESCRIPTION))
               paymentType_decription =
                   cursor.getString(cursor.getColumnIndex(PosOrderKeys.PAYMENT_TYPE_DESCRIPTION))
               totalAmount = cursor.getDouble(cursor.getColumnIndex(PosOrderKeys.TOTAL_AMOUNT))
               process_order = cursor.getInt(cursor.getColumnIndex(PosOrderKeys.PROCESS_ORDER))
        
               val posOrder = PosOrderData(id,orderId,dateandtime,restaurant_id,restaurant_name)
               posOrderList.add(posOrder)

           } while (cursor.moveToNext())
            cursor.close()

标签： androidkotlinkotlin-android-extensions

解决方案

推荐阅读