Retrieve data from DB

shank586 · by **shank586** » Thu Aug 07, 2008 6:34 am

hi all,

I need any one of your help, my question is this "Tell me the way to retrieve data from DB to an Array?"

I used the following way to get data from DB but I get error

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

            String[] from=new String[]{myDB.query(true, MY_DATABASE_NAME, "name","num", "num", "name", null, null, "num")};
Parsed in 0.031 seconds,  using GeSHi 1.0.8.4

please any on help me out

Thanks in advance
with regards
Shank586

borya · by **borya** » Fri Aug 08, 2008 10:23 pm

You could try using query to return a cursor, then go through the values of the cursor to put them into your array, or alternatively, just skip the array and use the cursor.

ych.tiger · by **ych.tiger** » Mon Aug 11, 2008 3:15 am

It's a example for querying ContactMethod information.
Cursor is better than Arrary.

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

public ContactMethodBean queryById(String _id) {
 
                // init
 
                String selection = People.ContactMethods.CONTENT_DIRECTORY + "." + 
 
                        ContactMethods._ID + "=?";
 
                String args[] = new String[] { _id };
 
                // query
 
                Cursor cursor = cr.query(Contacts.ContactMethods.CONTENT_URI,
 
                                projection, selection, args, null);
 
                ContactMethodBean cm = null;
 
                if (cursor.next()) {
 
                        // convert cursor to bean
 
                        cm = new ContactMethodBean();
 
                        cm._id = cursor.getString(0);
 
                        cm.person = cursor.getString(1);
 
                        cm.type = cursor.getString(2);
 
                        cm.kind = cursor.getString(3);
 
                        cm.data = cursor.getString(4);
 
                        cm.aux_data = cursor.getString(5);
 
                        cm.label = cursor.getString(6);
 
                }
 
                return cm;
 
        }
Parsed in 0.033 seconds,  using GeSHi 1.0.8.4

plusminus · by **plusminus** » Mon Aug 11, 2008 10:46 am

This is how I usually do it:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

               Cursor c = myDB.query(...);
 
               /* Check if our result was valid. */
 
               if (c != null) {
 
                    /* Get the indices of the Columns we will need */
 
                    final int firstNameColumn = c.getColumnIndex("FirstName"); 
 
                    /* Check if at least one Result was returned. */
 
                    if (c.first()) {
 
                         int i = 0;
 
                         /* Loop through all Results */
 
                         do {
 
                              i++;
 
                              /* Retrieve the values of the Entry
 
                               * the Cursor is pointing to. */
 
                              String firstName = c.getString(firstNameColumn);
 
                              /* Add current Entry to results. */
 
                              results.add("#" + i + ": " + firstName);
 
                         } while (c.next());
 
                    }
 
               }
Parsed in 0.037 seconds,  using GeSHi 1.0.8.4

Retrieve data from DB

Retrieve data from DB

Re: Retrieve data from DB

Who is online