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

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

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

QueryBuilder.queryForFirst介绍

[英]A short cut to Dao#queryForFirst(PreparedQuery).
[中]到Dao#queryForFirst（PreparedQuery）的捷径。

代码示例

代码示例来源：origin: BaronZ88/MinimalistWeather

/**
 * 根据城市查询城市信息
 *
 * @param cityId 城市ID
 * @return city
 * @throws SQLException
 */
public City queryCityById(String cityId) throws SQLException {
  QueryBuilder<City, Integer> queryBuilder = cityDaoOperation.queryBuilder();
  queryBuilder.where().eq(City.CITY_ID_FIELD_NAME, cityId);
  return queryBuilder.queryForFirst();
}

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

/**
 * A short-cut for calling {@link QueryBuilder#queryForFirst()}.
 */
public T queryForFirst() throws SQLException {
  return checkQueryBuilderMethod("queryForFirst()").queryForFirst();
}

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

/**
 * A short-cut for calling {@link QueryBuilder#queryForFirst()}.
 */
public T queryForFirst() throws SQLException {
  return checkQueryBuilderMethod("queryForFirst()").queryForFirst();
}

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

@Override
public Firmware get(Integer typeId, Integer versionId) {
  QueryBuilder<Firmware, Integer> queryBuilder = getDao().queryBuilder();
  try {
    queryBuilder.where().eq(Firmware.KEY_TYPE_ID, typeId).and().eq(Firmware.KEY_VERSION_ID, versionId);
    return queryBuilder.queryForFirst();
  } catch (SQLException ex) {
    _logger.error("unable to fetch Firmware:[typeId:{},versionId:{}]", typeId, versionId, ex);
    return null;
  }
}

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

@Override
public Node get(Integer gatewayId, String nodeEui) {
  try {
    QueryBuilder<Node, Integer> queryBuilder = this.getDao().queryBuilder();
    queryBuilder.where().eq(Node.KEY_GATEWAY_ID, gatewayId).and().eq(Node.KEY_EUI, nodeEui);
    return queryBuilder.queryForFirst();
  } catch (SQLException ex) {
    _logger.error("unable to get Node", ex);
    return null;
  }
}

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

@Override
public Node get(Integer gatewayId, String nodeEui) {
  QueryBuilder<Node, Integer> queryBuilder = null;
  try {
    queryBuilder = this.getDao().queryBuilder();
    queryBuilder.where().eq(Node.KEY_GATEWAY_ID, gatewayId).and().eq(Node.KEY_EUI, nodeEui);
    return queryBuilder.queryForFirst();
  } catch (SQLException ex) {
    _logger.error("unable to get Node. gatewayId:{}, nodeEui:{}", gatewayId, nodeEui, ex);
    try {
      _logger.error("PrepareStatement:[{}]", queryBuilder.prepareStatementString());
    } catch (SQLException qEx) {
      _logger.error("Exception on prepareStatement,", qEx);
    }
    throw new McDatabaseException(ex);
  }
}

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

@Override
public Firmware get(Integer typeId, Integer versionId) {
  QueryBuilder<Firmware, Integer> queryBuilder = getDao().queryBuilder();
  try {
    queryBuilder.where().eq(Firmware.KEY_TYPE_ID, typeId).and().eq(Firmware.KEY_VERSION_ID, versionId);
    return queryBuilder.queryForFirst();
  } catch (SQLException ex) {
    _logger.error("unable to fetch Firmware:[typeId:{},versionId:{}]", typeId, versionId, ex);
    throw new McDatabaseException(ex);
  }
}

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

@Override
public ResourcesGroup get(ResourcesGroup resourcesGroup) {
  try {
    if (resourcesGroup.getId() != null) {
      return this.getDao().queryForId(resourcesGroup.getId());
    } else if (resourcesGroup.getName() != null) {
      QueryBuilder<ResourcesGroup, Integer> queryBuilder = this.getDao().queryBuilder();
      queryBuilder.where().eq("name", resourcesGroup.getName());
      return queryBuilder.queryForFirst();
    }
  } catch (SQLException ex) {
    _logger.error("unable to get ResourcesGroup", ex);
    throw new McDatabaseException(ex);
  }
  return null;
}

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

@Override
public ResourcesGroup get(ResourcesGroup resourcesGroup) {
  try {
    if (resourcesGroup.getId() != null) {
      return this.getDao().queryForId(resourcesGroup.getId());
    } else if (resourcesGroup.getName() != null) {
      QueryBuilder<ResourcesGroup, Integer> queryBuilder = this.getDao().queryBuilder();
      queryBuilder.where().eq("name", resourcesGroup.getName());
      return queryBuilder.queryForFirst();
    }
  } catch (SQLException ex) {
    _logger.error("unable to get ResourcesGroup", ex);
    return null;
  }
  return null;
}

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

@Override
public Settings get(Integer userId, String key, String subKey) {
  try {
    Where<Settings, Integer> where = this.getDao().queryBuilder().where();
    int andCount = 0;
    if (userId == null) {
      where.isNull(Settings.KEY_USER_ID);
      andCount++;
    } else {
      where.eq(Settings.KEY_USER_ID, userId);
      andCount++;
    }
    where.eq(Settings.KEY_KEY, key);
    andCount++;
    where.eq(Settings.KEY_SUB_KEY, subKey);
    andCount++;
    where.and(andCount);
    QueryBuilder<Settings, Integer> queryBuilder = this.getDao().queryBuilder();
    queryBuilder.setWhere(where);
    return queryBuilder.queryForFirst();
  } catch (SQLException ex) {
    _logger.error("unable to get item for userId:{}, key:{}, subKey:{}", userId, key, subKey, ex);
    return null;
  }
}

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

@Override
public Settings get(Integer userId, String key, String subKey) {
  try {
    Where<Settings, Integer> where = this.getDao().queryBuilder().where();
    int andCount = 0;
    if (userId == null) {
      where.isNull(Settings.KEY_USER_ID);
      andCount++;
    } else {
      where.eq(Settings.KEY_USER_ID, userId);
      andCount++;
    }
    where.eq(Settings.KEY_KEY, key);
    andCount++;
    where.eq(Settings.KEY_SUB_KEY, subKey);
    andCount++;
    where.and(andCount);
    QueryBuilder<Settings, Integer> queryBuilder = this.getDao().queryBuilder();
    queryBuilder.setWhere(where);
    return queryBuilder.queryForFirst();
  } catch (SQLException ex) {
    _logger.error("unable to get item for userId:{}, key:{}, subKey:{}", userId, key, subKey, ex);
    throw new McDatabaseException(ex);
  }
}

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

@Test
public void testCacheWithSelectColumns() throws Exception {
  Dao<CacheWithSelectColumns, Object> dao = createDao(CacheWithSelectColumns.class, true);
  // Add object to database
  CacheWithSelectColumns foo = new CacheWithSelectColumns();
  foo.text = "some text";
  dao.create(foo);
  // enable object cache
  dao.setObjectCache(true);
  // fetch the object, but only with its id field
  QueryBuilder<CacheWithSelectColumns, Object> qb =
      dao.queryBuilder().selectColumns(CacheWithSelectColumns.COLUMN_NAME_ID);
  CacheWithSelectColumns result = qb.queryForFirst();
  assertNotNull(result);
  assertNull(result.text);
  // fetch the same object again, this time asking for the text column as well
  qb = dao.queryBuilder().selectColumns(CacheWithSelectColumns.COLUMN_NAME_ID,
      CacheWithSelectColumns.COLUMN_NAME_TEXT);
  result = qb.queryForFirst();
  assertNotNull(result);
  assertEquals(foo.text, result.text);
  // fetch the same object again, this time asking for everything
  qb = dao.queryBuilder();
  result = qb.queryForFirst();
  assertNotNull(result);
  assertEquals(foo.text, result.text);
}

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

private void selectPointer() {
  if (filter != null) {
    Where<Message, Object> filteredWhere;
    try {
      filteredWhere = filter.modWhere(app.getDao(Message.class)
          .queryBuilder().where());
      filteredWhere.and().le(Message.ID_FIELD, app.getPointer());
      QueryBuilder<Message, Object> closestQuery = app.getDao(
          Message.class).queryBuilder();
      closestQuery.orderBy(Message.TIMESTAMP_FIELD, false).setWhere(
          filteredWhere);
      Message closestMessage = closestQuery.queryForFirst();
      // use anchor message id if message was narrowed
      if (anchorId != -1) {
        selectMessage(getMessageById(anchorId));
      } else {
        recyclerView.scrollToPosition(adapter.getItemIndex(closestMessage));
      }
    } catch (SQLException e) {
      throw new RuntimeException(e);
    }
  } else {
    int anc = app.getPointer();
    selectMessage(getMessageById(anc));
  }
}

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

.orderBy(Message.ID_FIELD, false)
.offset((long) olderThan).limit((long) 1)
.queryForFirst().getID();

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

public void testMessageTrim() throws SQLException {
  prepTests();
  TransactionManager.callInTransaction(app.getDatabaseHelper()
      .getConnectionSource(), new Callable<Void>() {
    public Void call() throws Exception {
      for (int i = 1; i <= 300; i++) {
        sampleMessage(app, i);
      }
      for (int i = 501; i <= 800; i++) {
        sampleMessage(app, i);
      }
      app.getDao(MessageRange.class).create(new MessageRange(1, 300));
      app.getDao(MessageRange.class).create(
          new MessageRange(501, 800));
      return null;
    }
  });
  RuntimeExceptionDao<MessageRange, Integer> messageRangeDao = app
      .getDao(MessageRange.class);
  assertEquals(600, messageDao.countOf());
  Message.trim(100, app);
  this.messageDao.queryForAll();
  assertEquals(100, messageDao.countOf());
  assertEquals(1, messageRangeDao.countOf());
  MessageRange r = messageRangeDao.queryBuilder().queryForFirst();
  // We have messages 701 through 800, which is 100 messages.
  assertEquals(800, r.high);
  assertEquals(800 - 99, r.low);
}

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

QueryBuilder

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

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