Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Viewing an Android database cursor

Tags:

android

cursor

debugging

Would anyone know how I can view what a cursor has in it during debugging so that I can determine the functionality of my database helper?

It keeps acting like it's returning data, but then when I attempt to use the cursor.isNull(0) method, I keep getting NullPointerException thrown and not being able to see what the cursor has in it while stepping through the execution is really frustrating me.

Any help would be extremely appreciated.

Thanks.

like image 397
Skittles Avatar asked Nov 21 '10 01:11

Skittles

People also ask

What is Android database cursor?

Cursors are what contain the result set of a query made against a database in Android. The Cursor class has an API that allows an app to read (in a type-safe manner) the columns that were returned from the query as well as iterate over the rows of the result set.

What is cursor SQLite?

It is an object that is used to make the connection for executing SQL queries. It acts as middleware between SQLite database connection and SQL query. It is created after giving connection to SQLite database.

What is the use of Contentvalues in Android?

This class is used to store a set of values that the ContentResolver can process.

How can I retrieve single data from SQLite database in Android?

We can retrieve anything from database using an object of the Cursor class. We will call a method of this class called rawQuery and it will return a resultset with the cursor pointing to the table. We can move the cursor forward and retrieve the data. This method return the total number of columns of the table.

1 Answers

Android has provided a specific class just for debugging Cursors. It is called DatabaseUtils.

Call the method DatabaseUtils.dumpCursorToString(cursor) to view the contents of your cursor.

This helper loops through and prints out the content of the Cursor for you, and returns the cursor to its original position so that it doesn't mess up your iterating logic.

like image 82
Some Noob Student Avatar answered Oct 12 '22 02:10

Some Noob Student
Sign in to Comment

Related questions

Android Raw folders - creation and reference
Android: java.lang.ClassCastException: android.widget.imageView cannot be cast to android.widget.textView
Eclipse: won't let me use Android SDK, wrongly claims my ADT is out of date
TimePickerDialog and AM or PM
Remove all items from RecyclerView
failed to resolve com.android.support:appcompat-v7:22 and com.android.support:recyclerview-v7:21.1.2
onRequestPermissionsResult not being called in dialog fragment
Check if color is dark or light in Android
Can't resolve Android databinding class
EditText request focus
How to turn off Wifi via ADB?
Android refresh current activity [duplicate]
Android keyboard next button issue on EditText
android:actionBarStyle requires API level 11
Rounded corners on material button
How to finish an activity from an Adapter..?
java.lang.RuntimeException: WakeLock under-locked C2DM_LIB
How to get the timezone offset in GMT(Like GMT+7:00) from android device?
Recyclerview not call any Adapter method :onCreateViewHolder,onBindViewHolder,
no cached version available for offline mode

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!