com.j256.ormlite.stmt.QueryBuilder.orderBy()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(8.2k)|赞(0)|评价(0)|浏览(139)

本文整理了Java中com.j256.ormlite.stmt.QueryBuilder.orderBy方法的一些代码示例，展示了QueryBuilder.orderBy的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。QueryBuilder.orderBy方法的具体详情如下：
包路径：com.j256.ormlite.stmt.QueryBuilder
类名称：QueryBuilder
方法名：orderBy

QueryBuilder.orderBy介绍

[英]Add "ORDER BY" clause to the SQL query statement. This can be called multiple times to add additional "ORDER BY" clauses. Ones earlier are applied first.
[中]在SQL查询语句中添加“ORDER BY”子句。这可以多次调用以添加额外的“ORDER BY”子句。先用前面的。

代码示例

代码示例来源：origin: magefree/mage

public List<ExpansionInfo> getAll() {
  try {
    QueryBuilder<ExpansionInfo, Object> qb = expansionDao.queryBuilder();
    qb.orderBy("releaseDate", true);
    return expansionDao.query(qb.prepare());
  } catch (SQLException ex) {
    logger.error(ex);
  }
  return Collections.emptyList();
}

代码示例来源：origin: magefree/mage

public List<String> getAllSetNames() {
  try {
    QueryBuilder<ExpansionInfo, Object> qb = expansionDao.queryBuilder();
    qb.orderBy("releaseDate", true);
    List<ExpansionInfo> expansions = expansionDao.query(qb.prepare());
    List<String> setNames = new LinkedList<>();
    for (ExpansionInfo expansionInfo : expansions) {
      setNames.add(expansionInfo.getName());
    }
    return setNames;
  } catch (SQLException ex) {
    logger.error(ex);
  }
  return Collections.emptyList();
}

代码示例来源：origin: magefree/mage

public long getLatestEndTimeMs() {
  try {
   QueryBuilder<UserStats, Object> qb = dao.queryBuilder();
    qb.orderBy("endTimeMs", false).limit(1L);
   List<UserStats> users = dao.query(qb.prepare());
    if (!users.isEmpty()) {
     return users.get(0).getEndTimeMs();
   }
  } catch (SQLException ex) {
    Logger.getLogger(UserStatsRepository.class).error("Error getting the latest end time from DB - ", ex);
  }
  return 0;
}

代码示例来源：origin: magefree/mage

public List<TableRecord> getAfter(long endTimeMs) {
  try {
    QueryBuilder<TableRecord, Object> qb = dao.queryBuilder();
    qb.where().gt("endTimeMs", endTimeMs);
    qb.orderBy("endTimeMs", true);
    return dao.query(qb.prepare());
  } catch (SQLException ex) {
    Logger.getLogger(TableRecordRepository.class).error("Error getting table_records from DB - ", ex);
  }
  return null;
}

代码示例来源：origin: magefree/mage

public List<ExpansionInfo> getSetsWithBasicLandsByReleaseDate() {
  List<ExpansionInfo> sets = new LinkedList<>();
  try {
    QueryBuilder<ExpansionInfo, Object> qb = expansionDao.queryBuilder();
    qb.orderBy("releaseDate", false);
    qb.where().eq("basicLands", new SelectArg(true));
    sets = expansionDao.query(qb.prepare());
  } catch (SQLException ex) {
    logger.error(ex);
  }
  return sets;
}

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

@Override
public List<UserSettings> getAll() {
  try {
    return this.getDao().queryBuilder().orderBy("key", true).orderBy("id", true).query();
  } catch (SQLException ex) {
    _logger.error("unable to get all list", ex);
    return null;
  }
}

代码示例来源：origin: magefree/mage

qb.orderBy(sortBy, true);

代码示例来源：origin: mycontroller-org/mycontroller

@Override
public List<UserSettings> getAll() {
  try {
    return this.getDao().queryBuilder().orderBy("key", true).orderBy("id", true).query();
  } catch (SQLException ex) {
    _logger.error("unable to get all list", ex);
    throw new McDatabaseException(ex);
  }
}

代码示例来源：origin: annmuor/jnode

public List<T> getOrderAnd(String order, boolean asc, Object... args) {
  try {
    QueryBuilder<T, ?> qb = getDao().queryBuilder();
    qb.orderBy(order, asc);
    buildWhere(qb, true, args);
    return qb.query();
  } catch (SQLException e) {
    logger.l1("SQL Exception in getOrderAnd", e);
    logger.l1(MessageFormat.format("we worked with {0} {1} {2}", order,
        asc, Arrays.toString(args)));
  }
  return new ArrayList<>();
}

代码示例来源：origin: QuickBlox/q-municate-android

@Override
public List<T> getAllSorted(String sortedColumn, boolean ascending) {
  List<T> objectsList = Collections.emptyList();
  try {
    QueryBuilder<T, ID> queryBuilder = dao.queryBuilder();
    queryBuilder.orderBy(sortedColumn, ascending);
    PreparedQuery<T> preparedQuery = queryBuilder.prepare();
    objectsList = dao.query(preparedQuery);
  } catch (SQLException e) {
    ErrorUtils.logError(e);
  }
  return objectsList;
}

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

@Override
public List<UserSettings> getLike(User user, String key) {
  try {
    QueryBuilder<UserSettings, Integer> queryBuilder = getDao().queryBuilder();
    queryBuilder.where().like("key", key);
    return queryBuilder.orderBy("id", true).query();
  } catch (SQLException ex) {
    _logger.error("unable to get like:[{}]", key, ex);
    return null;
  }
}

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

@Override
public List<UserSettings> get(User user, List<String> keys) {
  try {
    QueryBuilder<UserSettings, Integer> queryBuilder = getDao().queryBuilder();
    queryBuilder.where().in("key", keys);
    return queryBuilder.orderBy("id", true).query();
  } catch (SQLException ex) {
    _logger.error("unable to get list:[{}]", keys, ex);
    return null;
  }
}

代码示例来源：origin: mycontroller-org/mycontroller

@Override
public List<UserSettings> get(User user, List<String> keys) {
  try {
    QueryBuilder<UserSettings, Integer> queryBuilder = getDao().queryBuilder();
    queryBuilder.where().in("key", keys);
    return queryBuilder.orderBy("id", true).query();
  } catch (SQLException ex) {
    _logger.error("unable to get list:[{}]", keys, ex);
    throw new McDatabaseException(ex);
  }
}

代码示例来源：origin: mycontroller-org/mycontroller

@Override
public List<UserSettings> getLike(User user, String key) {
  try {
    QueryBuilder<UserSettings, Integer> queryBuilder = getDao().queryBuilder();
    queryBuilder.where().like("key", key);
    return queryBuilder.orderBy("id", true).query();
  } catch (SQLException ex) {
    _logger.error("unable to get like:[{}]", key, ex);
    throw new McDatabaseException(ex);
  }
}

代码示例来源：origin: geeksonsecurity/android-overlay-protection

private void refreshItems() {
  List<DetectedOverlay> listData = new ArrayList<>();
  try {
    listData = DatabaseHelper.getHelper(getActivity()).getDetectedOverlayDao().queryBuilder().orderBy("timestamp", false).query();
  } catch (SQLException e) {
    Log.e(getTag(), "Failed to obtain detected overlays objects", e);
  }
  mAdapter.clear();
  mAdapter.addAll(listData);
}

代码示例来源：origin: geeksonsecurity/android-overlay-protection

private void refreshList() {
  Dao<SuspectedApp, Integer> suspectedAppDao = null;
  try {
    suspectedAppDao = DatabaseHelper.getHelper(getActivity()).getSuspectedAppDao();
    List<SuspectedApp> suspectedApps = suspectedAppDao.queryBuilder().orderBy("appName", true).query();
    mAdapter.clear();
    mAdapter.addAll(suspectedApps);
  } catch (SQLException e) {
    e.printStackTrace();
  }
}

代码示例来源：origin: j256/ormlite-core

@Test
public void testOrderByDesc() throws Exception {
  QueryBuilder<Foo, Integer> qb = new QueryBuilder<Foo, Integer>(databaseType, baseFooTableInfo, null);
  String field = Foo.VAL_COLUMN_NAME;
  qb.orderBy(field, false);
  StringBuilder sb = new StringBuilder();
  sb.append("SELECT * FROM ");
  databaseType.appendEscapedEntityName(sb, baseFooTableInfo.getTableName());
  sb.append(" ORDER BY ");
  databaseType.appendEscapedEntityName(sb, field);
  sb.append(" DESC ");
  assertEquals(sb.toString(), qb.prepareStatementString());
}

代码示例来源：origin: QuickBlox/q-municate-android

public Message getLastMessageByDialogId(List<Long> dialogOccupantsList) {
  Message message = null;
  try {
    QueryBuilder<Message, Long> queryBuilder = dao.queryBuilder();
    Where<Message, Long> where = queryBuilder.where();
    where.in(DialogOccupant.Column.ID, dialogOccupantsList);
    queryBuilder.orderBy(Message.Column.CREATED_DATE, false);
    PreparedQuery<Message> preparedQuery = queryBuilder.prepare();
    message = dao.queryForFirst(preparedQuery);
  } catch (SQLException e) {
    ErrorUtils.logError(e);
  }
  return message;
}

代码示例来源：origin: j256/ormlite-core

@Test(expected = IllegalArgumentException.class)
public void testOrderByForeignCollection() throws Exception {
  Dao<Project, Integer> dao = createDao(Project.class, false);
  QueryBuilder<Project, Integer> qb = dao.queryBuilder();
  qb.orderBy("categories", false);
}

代码示例来源：origin: zulip/zulip-android

private void checkRanges(String rangestr) throws SQLException {
  List<MessageRange> ranges = app.getDao(MessageRange.class)
      .queryBuilder().orderBy("low", true).query();
  String s = "";
  for (MessageRange rng : ranges) {
    s += "(" + rng.low + "," + rng.high + ")";
  }
  assertEquals(rangestr, s);
}

内容来源于网络，如有侵权，请联系作者删除！

QueryBuilder

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com