android _Displaying a record from a sqlite database

Question

I am planning to build an app that lets the user select a record from a particular database such as:

               name    favorite_color       favorite_team  
               sue        red                  Dal
               mike       blue                 Mia
               sam        purple               Bal

My problem is that most of the tutorials that I have come across only demonstrates examples using a table with one column. What if my pre-populated database more then on column? What if it had 100 columns? Does anyone know how this is done?????

unclear ur question...plz explain

Richa
– Richa

2011-11-01 04:47:06 +00:00
Commented Nov 1, 2011 at 4:47 — Richa
– Richa, Commented Nov 1, 2011 at 4:47

Umang Mathur · Accepted Answer · 2013-06-22 08:37:24Z

Here's an example:

Step1:Declare SQLiteDatabase,Declare Databasehelper

Step2:Declare string or number which is to be used as key or get it as an intent(in this example 'rowid'

Step 3: In the OnCreate method add lines of code similar to following:

        String query="select * from my_table_name where _id="+rowid;
        Cursor myCursor = database.rawQuery(query,null);
        myCursor.moveToFirst();
        //This line implies i am getting data from column four of selected row
        String x=myCursor.getString(4);
        //This line implies i am getting data from column two of selected row
        String y=myCursor.getString(4);
        myCursor.close();

Note: a)Don't forget that your database size must not exceed 1.2mb

b)Also include a column with name _id which auto-increments in each table that you are using,you may use sqlite browser to do so

c)also create the following table in your database :

CREATE TABLE "android_metadata" ("locale" TEXT DEFAULT 'en_US')

Now insert a single row with the text 'en_US' in the "android_metadata" table

INSERT INTO "android_metadata" VALUES ('en_US')

Pedro Rainho · Accepted Answer · 2011-10-31 21:19:41Z

0

read this you will learn every thing you need to know. One other way to access db information is using an ORM like ormlite. I'm using it in various apps that i've developed, and it's simple to use.

answered Oct 31, 2011 at 21:19

Pedro Rainho

4,3141 gold badge22 silver badges22 bronze badges

Collectives™ on Stack Overflow

android _Displaying a record from a sqlite database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related