Update database (SQLiteDatabase issue)

Question

everyone. This is a piece of code from using sqlite in android tutorial:

return db.update(employeeTable, cv, colID+"=?", 
new String []{String.valueOf(emp.getID())});

I don't understand why in colID+"=?" after '=' stay '?'

Anyone can explain this, please?

Thanks for everyone!

en.wikipedia.org/wiki/Prepared_statement

CBredlow
– CBredlow

2012-06-18 13:26:02 +00:00
Commented Jun 18, 2012 at 13:26 — CBredlow
– CBredlow, Commented Jun 18, 2012 at 13:26

VanessaBR · Accepted Answer · 2012-06-18 13:36:02Z

1

This is a Prepared Satatement. In this case, you can define a query as a template and left some parameters to fill dynamically. You represent the parameter with an ?. In your case, you are indicating that String.valueOf(emp.getID()) will substitute the ?.

answered Jun 18, 2012 at 13:36

VanessaBR

1281 gold badge1 silver badge7 bronze badges

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

Comments

Simon Dorociak · Accepted Answer · 2012-06-18 13:26:09Z

1

This is parametrized statement, this mean that this String.valueOf(emp.getID()) will be added intead of ? character. ? represents one argument and String[] represents data which will be added to where clause.

answered Jun 18, 2012 at 13:26

Simon Dorociak

33.5k10 gold badges70 silver badges107 bronze badges

Comments

Graham Borland · Accepted Answer · 2012-06-18 13:26:39Z

1

The ? is where your argument is substituted into the query. Your argument in this case is String.valueOf(emp.getID().

answered Jun 18, 2012 at 13:26

Graham Borland

60.8k21 gold badges144 silver badges184 bronze badges

Collectives™ on Stack Overflow

Update database (SQLiteDatabase issue)

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related