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