コード例 #1
0
ファイル: TipSegServiceImpl.java プロジェクト: Mcodeco/SisApp
 public List<SliderTipSeg> getSliderTipSegById(int idTipSeg) {
   try {
     Dao<SliderTipSeg, Integer> dao = getHelper().getSliderTipSegDao();
     QueryBuilder<SliderTipSeg, Integer> builder = dao.queryBuilder();
     builder.setWhere(builder.where().eq("id_tipseg", idTipSeg));
     builder.orderBy("order", true);
     List<SliderTipSeg> items = dao.query(builder.prepare());
     return items;
   } catch (SQLException e) {
     e.printStackTrace();
   }
   return null;
 }
コード例 #2
0
  public CloseableIterator<PlayerWarnData> findWarnings(long fromTime) throws SQLException {
    if (fromTime == 0) {
      return iterator();
    }

    long checkTime = fromTime + DateUtils.getTimeDiff();

    QueryBuilder<PlayerWarnData, Integer> query = queryBuilder();
    Where<PlayerWarnData, Integer> where = query.where();
    where.ge("created", checkTime);

    query.setWhere(where);

    return query.iterator();
  }