android - 如何从 SQLite 数据库转储结果

Question

我从昨天开始一直坚持这个。研究并没有太大帮助，因为我刚接手这个项目，而且我对 Android 一无所知。

        myDB = null;
        try {
            File dir = new File(Environment.getExternalStorageDirectory().getAbsolutePath());
            File file = new File(dir, "database.db");
            myDB = SQLiteDatabase.openDatabase(file.toString(), null, SQLiteDatabase.NO_LOCALIZED_COLLATORS|SQLiteDatabase.OPEN_READONLY);

            String q = "SELECT * FROM companies";
            Cursor mCursor = myDB.rawQuery(q, null);

            Context context = getActivity().getApplicationContext();
            CharSequence text = mCursor.toString();
            int duration = Toast.LENGTH_SHORT;

            Toast toast = Toast.makeText(context, text, duration);
            toast.show();

            myDB.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

从 toast 我得到 android.database.sqlite.SQLiteCursor@2f95e49b

如何转储所有数据库结果？

Answer 1

我不是专家，但试试这个。你的 toast 应该一个接一个地抛出名字。确保将名称更改为您自己的字段。

String q = "SELECT * FROM companies";
            Cursor mCursor = myDB.rawQuery(q, null);
            mCursor.moveToFirst();
            while ( !mCursor.isAfterLast()) {
                String name= mCursor.getString(mCursor.getColumnIndex("name"));
                mCursor.moveToNext();

                Context context = getActivity().getApplicationContext();
                CharSequence text = name;
                int duration = Toast.LENGTH_SHORT;

                Toast toast = Toast.makeText(context, text, duration);
                toast.show();

            }