lundi 25 janvier 2016

How can I count specific item in sqlite database?

How can I count spesific item in sqlite database? I try this but don't work. Thanks for helping. (Sorry my English)

 String Query = "SELECT COUNT(*) FROM mytable WHERE date = '" + 2015 + "'";
 ResultSet rs = stmt.executeQuery(Query);
 jtextfield.setText(String.valueOf(rs));

Aucun commentaire:

Enregistrer un commentaire