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

QueryBuilder.orderByRaw介绍

[英]Add raw SQL "ORDER BY" clause to the SQL query statement.
[中]将原始SQL“ORDER BY”子句添加到SQL查询语句中。

代码示例

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

public List<Friend> getAllSorted() {
    List<Friend> friendsList = Collections.emptyList();

    try {
      QueryBuilder<Friend, Long> friendQueryBuilder = dao.queryBuilder();

      QueryBuilder<QMUser, Long> userQueryBuilder = userDao.queryBuilder();
      userQueryBuilder.orderByRaw(QMUserColumns.FULL_NAME + " COLLATE NOCASE");

      friendQueryBuilder.join(userQueryBuilder);

      PreparedQuery<Friend> preparedQuery = friendQueryBuilder.prepare();

      friendsList = dao.query(preparedQuery);
    } catch (SQLException e) {
      ErrorUtils.logError(e);
    }

    return friendsList;
  }
}

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

@Test
public void testOrderByRawArg() throws Exception {
  Dao<Foo, Integer> dao = createDao(Foo.class, true);
  Foo foo1 = new Foo();
  foo1.val = 1;
  assertEquals(1, dao.create(foo1));
  Foo foo2 = new Foo();
  foo2.val = 2;
  assertEquals(1, dao.create(foo2));
  List<Foo> results = dao.queryBuilder()
      .orderByRaw("(" + Foo.VAL_COLUMN_NAME + " = ? ) DESC", new SelectArg(SqlType.INTEGER, 2))
      .query();
  assertEquals(2, results.size());
  assertEquals(foo2.id, results.get(0).id);
  assertEquals(foo1.id, results.get(1).id);
  results = dao.queryBuilder()
      .orderByRaw("(" + Foo.VAL_COLUMN_NAME + " = ? )", new SelectArg(SqlType.INTEGER, 2))
      .query();
  assertEquals(2, results.size());
  assertEquals(foo1.id, results.get(0).id);
  assertEquals(foo2.id, results.get(1).id);
}

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

@Test
public void testSpecificJoinLoggingBug() throws Exception {
  /*
   * Test trying to specifically reproduce a reported bug. The query built in the logs was enough to show that
   * either the bug has already been fixed or the test is not reproducing the problem adequately.
   */
  Dao<Category, Integer> categoryDao = createDao(Category.class, true);
  Dao<Criterion, Integer> criterionDao = createDao(Criterion.class, true);
  QueryBuilder<Criterion, Integer> criteriaQb = criterionDao.queryBuilder();
  criteriaQb.where().eq("active", Boolean.valueOf(true));
  QueryBuilder<Category, Integer> categoryQb = categoryDao.queryBuilder();
  categoryQb.orderByRaw("id").join(criteriaQb).query();
}

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

assertEquals(1, dao.create(foo3));
List<Foo> results = dao.queryBuilder()
    .orderByRaw("(" + Foo.VAL_COLUMN_NAME + "+" + Foo.EQUAL_COLUMN_NAME + ") DESC")
    .query();
assertEquals(3, results.size());
    .orderByRaw("(" + Foo.VAL_COLUMN_NAME + "+" + Foo.EQUAL_COLUMN_NAME + ") DESC")
    .orderBy(Foo.VAL_COLUMN_NAME, false)
    .query();
    .orderByRaw("(" + Foo.VAL_COLUMN_NAME + "+" + Foo.EQUAL_COLUMN_NAME + ") DESC")
    .query();
assertEquals(3, results.size());

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

@Test
public void testOrderByRaw() throws Exception {
  Dao<Foo, Integer> dao = createDao(Foo.class, true);
  Foo foo1 = new Foo();
  foo1.val = 1;
  foo1.equal = 10;
  assertEquals(1, dao.create(foo1));
  Foo foo2 = new Foo();
  foo2.val = 5;
  foo2.equal = 7;
  assertEquals(1, dao.create(foo2));
  List<Foo> results = dao.queryBuilder()
      .orderByRaw("(" + Foo.VAL_COLUMN_NAME + "+" + Foo.EQUAL_COLUMN_NAME + ") DESC")
      .query();
  assertEquals(2, results.size());
  assertEquals(foo2.id, results.get(0).id);
  assertEquals(foo1.id, results.get(1).id);
}

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

queryBuilder.orderByRaw(query.getOrderBy() + query.getOrder());
} else {
  queryBuilder.orderBy(query.getOrderBy(), query.getOrder().equalsIgnoreCase(Query.ORDER_ASC));

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

queryBuilder.orderByRaw(query.getOrderBy() + query.getOrder());
} else {
  queryBuilder.orderBy(query.getOrderBy(), query.getOrder().equalsIgnoreCase(Query.ORDER_ASC));