How to display results of a sql query on screen

Question

I am trying to write a simple app just to display on screen the results on a sql query.

public class ContactLookup extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.main);
         Cursor c = getContentResolver().query(ContactsContract.Contacts.CONTENT_URI, 
                null, null, null, null
                );
    }
}

How exactly do I print the results of the cursor? Everything I find goes into to way more detail then I need at the moment... I just want to know how to get that variable printed on screen.

Lukas Knuth · Accepted Answer · 2011-07-17 18:38:14Z

1

You'll need to have something that shows text (or whatever you get from your DB). Most likely this will be a simple TextView (you can do this in the XML-Layout or in Java-Code).

If you declared your TextView in the XML-Layout, then you'll need to find the TextView in order to set it's text.

After that, you'll want to move the Cursor to the first set of data in it so you can read your results from it.

After that, you can simply use the Cursor's getXX()-methods to get your values form the result-set.

answered Jul 17, 2011 at 18:38

Lukas Knuth

25.8k16 gold badges88 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

trey85stang Over a year ago

Thanks Lukas, you have pointed me in the correct direction... I was able to get all the contact names printed on the screen. I appreciate the help.

Collectives™ on Stack Overflow

How to display results of a sql query on screen

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related