At the moment I have a table that look like this:
ID VAR1 VAR2
SN453 1 blablabla
SN453 2 blablabla
AK221 1 blablabla
AK221 2 blablabla
What I want to do is to select VAR1 and VAR2 for a given ID. ID is in a String variable, I would use this:
ps = connect.prepareStatement("SELECT VAR1, VAR2 FROM TABLE1 WHERE ID = ?");
How can I tell SQLite to pick the ID value from my string variable?
Aucun commentaire:
Enregistrer un commentaire