Android SQLite SELECT Query

Question

I have taken String value from a EditText and set it inside SELECT QUERY after WHERE condition

As

TextView tv = (TextView) findViewById(R.id.textView3); EditTextet2 et = (EditText) findViewById(R.id.editText1);  String name = et.getText().toString();  Cursor c = db.rawQuery("SELECT * FROM tbl1 WHERE name = '"+name+"'", null);   c.moveToNext();  tv.setText(c.getString(c.getColumnIndex("email"))); 

But it doesn't work. Any suggestions?

Answer 1

Try trimming the string to make sure there is no extra white space:

Cursor c = db.rawQuery("SELECT * FROM tbl1 WHERE TRIM(name) = '"+name.trim()+"'", null); 

Also use c.moveToFirst() like @thinksteep mentioned.

Answer 2

This is a complete code for select statements.

SQLiteDatabase db = this.getReadableDatabase(); Cursor c = db.rawQuery("SELECT column1,column2,column3 FROM table ", null); if (c.moveToFirst()){     do {         // Passing values          String column1 = c.getString(0);         String column2 = c.getString(1);         String column3 = c.getString(2);          // Do something Here with values     } while(c.moveToNext()); } c.close(); db.close();