How to get column value from database using query?

Question

I'm completely new in using sqlite databases with android. I want to get value from database using following SQL statement:

"SELECT description FROM games WHERE _id =" + categoryID

Where categoryID is the position of clicked element in listView (which is also the value of _id column).

listView.setOnItemClickListener(new OnItemClickListener() {
            public void onItemClick(AdapterView<?> parent, View view,

                String categoryID = new Integer(position).toString();

                final String SELECT_FROM = "SELECT description " + "FROM games "
                        + "WHERE _id = " + categoryID;
                database.query(SELECT_FROM);

                Intent intent = new Intent();
                intent.setClass(SqliteDbActivity.this, ViewAction.class);

                Bundle b = new Bundle();
                b.putString("categoryID", SELECT_FROM);
                intent.putExtras(b);

                startActivity(intent);

            }
        });

I know that I should use database.query() but how should I correctly write the previous sql statement to get value?

Table looks like:

_id description name
1    some1       name1
2    some2       name2       
3    some3       name3

Please, help.

What sort of Adapter are you using for your ListView?

Squonk
– Squonk

2012-04-09 19:18:06 +00:00
Commented Apr 9, 2012 at 19:18 — Squonk
– Squonk, Commented Apr 9, 2012 at 19:18
@MisterSquonk I'm using ArrayAdapter<String>

Sabre
– Sabre

2012-04-09 19:19:27 +00:00
Commented Apr 9, 2012 at 19:19 — Sabre
– Sabre, Commented Apr 9, 2012 at 19:19

Mohammed Azharuddin Shaikh · Accepted Answer · 2012-04-09 19:07:53Z

2

String categoryID = new Integer(position).toString();

            final String SELECT_FROM = "SELECT description " + "FROM games "
                    + "WHERE _id = " + categoryID;
            Cursor cursor = database.query(SELECT_FROM);
            cursor.moveToFirst();

            Intent intent = new Intent();
            intent.setClass(SqliteDbActivity.this, ViewAction.class);

            Bundle b = new Bundle();
            b.putString("categoryID", cursor.getString(cursor.getColumnIndex("fieldname"));
            intent.putExtras(b);

            startActivity(intent);

your database.query(SELECT_FROM) will return cursor, with the help of cursor you can do your work

answered Apr 9, 2012 at 19:07

Mohammed Azharuddin Shaikh

42.1k14 gold badges98 silver badges117 bronze badges

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

10 Comments

Sabre Over a year ago

Thaks, but can I pass this value to the next activity using bundle?

Sabre Over a year ago

Ok, what should be instead of "fieldname"?

Mohammed Azharuddin Shaikh Over a year ago

index either 0,1,2... depends on your number of column in your table. cursor.getString(0) will return 1st column value.

Sabre Over a year ago

So if I have table as at the question index will be 1? Or I misunderstood you.

Mohammed Azharuddin Shaikh Over a year ago

0 will be your index cursor.getString(0), not 1

|

Collectives™ on Stack Overflow

How to get column value from database using query?

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related