List<HoraireDb> horaires_reels = null;
try {
Dao<HoraireDb, Integer> dao = App.getHelper().getHoraireDao();
QueryBuilder<HoraireDb, Integer> builder = dao.queryBuilder();
Where where = builder.where();
where.eq("isprevis", false);
where.and();
where.eq("idactivite", Param.getIdActivite(App.getContext()));
where.and();
where.eq("jour",moment);
where.and();
where.isNotNull("debut");
where.and();
where.isNotNull("fin");
where.and();
where.ne("etat", "D");
where.and();
where.isNull("idabsence");
where.and();
where.lt("fin",moment);
horaires_reels = dao.query(builder.prepare());
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
i want to return an int just the number of rows, because returning a list take much time, i want to know there's any way to use countof() for my code ???
i found in stackoverflow this answer but didn't work for me :
int numRows = dao.queryBuilder().where().eq("name", "Joe Smith").countOf();
Aucun commentaire:
Enregistrer un commentaire