connecting to sqlite database

[vinal s.sen]

hi all!!!


i am doing a project,for which I am trying to select only certain rows,using the condition where.

how to write sql statement and retrieve certain rows only.

EditText eid=(EditText) findViewById(R.id.editText);
           EditText ename=(EditText)findViewById(R.id.editText2);
           ContentValues values=new ContentValues();
           values.put("id", eid.getText().toString());
           values.put("name", ename.getText().toString());
           if((db.insert("temp2", null, values))!=-1)
           {
           Toast.makeText(DatatestingActivity.this, "Record Successfully Inserted", 2000).show();
           }
           else
           {
           Toast.makeText(DatatestingActivity.this, "Insert Error", 2000).show();
           }
           eid.setText("");
           ename.setText("");

           //Cursor c=db.rawQuery("SELECT * FROM temp2",null);
   ------->        Cursor c=db.rawQuery("SELECT * FROM temp2 where name='mmm'",null);
           c.moveToFirst();
           while(!c.isAfterLast())
           {
               
           Toast.makeText(DatatestingActivity.this,c.getString(0)+ " "+c.getString(1),1000).show();
           c.moveToNext();
           }
           c.close();
           }

output is not right...... what is the method I should be using to select only certain rows.

thanks in advance

[Ulf Dittmer]

What is the output you are getting now, and which output would you like to get?

[vinal s.sen]

Sorry for me being vague. i try to input value to a textbox and based on that ,i want to get rows from the table..please help me..i am finding it difficult to use variable in a select statement...

EditText searchname=(EditText) findViewById(R.id.editText1);
        ------->	   String nn=searchname.getText().toString();
               
               //Toast.makeText(Selectdata2Activity.this,searchname.getText().toString(),2000).show();
               Toast.makeText(Selectdata2Activity.this,nn,2000).show();
        	  // Cursor c=db.rawQuery("SELECT * FROM temp2 where name like 'mmm'",null);
        ------->       Cursor c=db.rawQuery("SELECT * FROM temp2 where name like nn",null);
               c.moveToFirst();
               while(!c.isAfterLast())
               {
            	   
               Toast.makeText(Selectdata2Activity.this,c.getString(0)+ " "+c.getString(1),1000).show();
               c.moveToNext();
               }
               c.close();
               }
            });

cursor does not return any values...no output produced on the screen.how do I use a variable???

(however if i supply the value directly,it is working and fine and comes up with data)

thanks in advance

[Ulf Dittmer]

You're passing the literal value "nn" to the query, instead of the value of the variable "nn". Instead of this:

Cursor c = db.rawQuery("SELECT * FROM temp2 where name like nn",null)

try something like this:

Cursor c = db.rawQuery("SELECT * FROM temp2 where name like ?", new String[] { nn })

That's what the javadocs of that method mean when they talk about using "?". It's similar to using a PreparedStatement in JDBC. Since you're using "like", the value of "nn" should most likely have % characters at the beginning and end, as in

String nn = "%" + searchname.getText().toString() + "%"

[vinal s.sen]

thanks a lot,Ulf Dittmer....I have been struck with this 6 to 7 hours..was not able to solve it.

now it works

I went through net..could not find a solution.Is there any book that you will recommend?

once again,thanks