android 如何遍历Cursor

最新推荐文章于 2021-05-28 22:04:58 发布

原创最新推荐文章于 2021-05-28 22:04:58 发布 · 450 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Android

android 专栏收录该内容

66 篇文章

订阅专栏

本文介绍了一个Android应用程序中从SQLite数据库查询数据并显示查询结果的方法。通过使用Cursor遍历查询结果，并将其内容追加到StringBuilder对象中，最后通过Notification将查询结果通知用户。

private void showItems() {

        SQLiteDatabase db = mOpenHelper.getReadableDatabase();
        String col[] = { TITLE, BODY };
        Cursor cur = db.query(TABLE_NAME, col, null, null, null, null, null);
        int title = cur.getColumnIndex(TITLE);
        int body = cur.getColumnIndex(BODY);
        for(cur.moveToFirst();!cur.isAfterLast();cur.moveToNext())
        {
        String name = cur.getString(title);
        String phoneNumber = cur.getString(body);
        sb.append(name+" "+phoneNumber+"\n");
        Log.i("title", name);
        Log.i("body",phoneNumber);
        }
        setNotification();

        Integer num = cur.getCount();
        setTitle(Integer.toString(num) + " 条记录");
    }

public void setNotification()
    {
        NotificationManager nmanager = (NotificationManager)getSystemService(NOTIFICATION_SERVICE);
        Notification notification = new Notification(R.drawable.icon, "数据库查询结果", System.currentTimeMillis());
        PendingIntent pi = PendingIntent.getActivity(this, 0, new Intent(this,ActivityMain.class), 0);

        notification.setLatestEventInfo(this, "查询结果" , sb.toString(), pi);
        nmanager.notify(1, notification);
    }