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

x33g5p2x  于2022-01-18 转载在 其他  
字(8.4k)|赞(0)|评价(0)|浏览(217)

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

Dao.queryForFirst介绍

[英]Query for and return the first item in the object table which matches the PreparedQuery. See #queryBuilder() for more information. This can be used to return the object that matches a single unique column. You should use #queryForId(Object) if you want to query for the id column.
[中]查询并返回对象表中与PreparedQuery匹配的第一项。有关详细信息，请参见#queryBuilder（）。这可用于返回与单个唯一列匹配的对象。如果要查询id列，应使用#queryForId（Object）。

代码示例

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

  1. /**
  2.  * A short cut to {@link Dao#queryForFirst(PreparedQuery)}.
  3.  */
  4. public T queryForFirst() throws SQLException {
  5.   return dao.queryForFirst(prepare());
  6. }

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

  1. /**
  2.  * @see Dao#queryForFirst(PreparedQuery)
  3.  */
  4. @Override
  5. public T queryForFirst(PreparedQuery<T> preparedQuery) {
  6.   try {
  7.     return dao.queryForFirst(preparedQuery);
  8.   } catch (SQLException e) {
  9.     logMessage(e, "queryForFirst threw exception on: " + preparedQuery);
  10.     throw new RuntimeException(e);
  11.   }
  12. }

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

  1. /**
  2.  * @see Dao#queryForFirst(PreparedQuery)
  3.  */
  4. @Override
  5. public T queryForFirst(PreparedQuery<T> preparedQuery) {
  6.   try {
  7.     return dao.queryForFirst(preparedQuery);
  8.   } catch (SQLException e) {
  9.     logMessage(e, "queryForFirst threw exception on: " + preparedQuery);
  10.     throw new RuntimeException(e);
  11.   }
  12. }

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

  1. /**
  2.  * A short cut to {@link Dao#queryForFirst(PreparedQuery)}.
  3.  */
  4. public T queryForFirst() throws SQLException {
  5.   return dao.queryForFirst(prepare());
  6. }

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

  1. @Test(expected = RuntimeException.class)
  2. public void testQueryForFirstPreparedThrow() throws Exception {
  3.   @SuppressWarnings("unchecked")
  4.   Dao<Foo, String> dao = (Dao<Foo, String>) createMock(Dao.class);
  5.   RuntimeExceptionDao<Foo, String> rtDao = new RuntimeExceptionDao<Foo, String>(dao);
  6.   expect(dao.queryForFirst(null)).andThrow(new SQLException("Testing catch"));
  7.   replay(dao);
  8.   rtDao.queryForFirst(null);
  9.   verify(dao);
  10. }

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

  1. public Dialog getByDialogId(String dialogId) {
  2.   Dialog dialog = null;
  3.   try {
  4.     QueryBuilder<Dialog, Long> queryBuilder = dao.queryBuilder();
  5.     queryBuilder.where().eq(Dialog.Column.ID, dialogId);
  6.     PreparedQuery<Dialog> preparedQuery = queryBuilder.prepare();
  7.     dialog = dao.queryForFirst(preparedQuery);
  8.   } catch (SQLException e) {
  9.     ErrorUtils.logError(e);
  10.   }
  11.   return dialog;
  12. }

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

  1. public Attachment getByAttachmentType(Attachment.Type type) {
  2.   Attachment attachment = null;
  3.   try {
  4.     QueryBuilder<Attachment, Long> queryBuilder = dao.queryBuilder();
  5.     queryBuilder.where().eq(Attachment.Column.ID, type);
  6.     PreparedQuery<Attachment> preparedQuery = queryBuilder.prepare();
  7.     attachment = dao.queryForFirst(preparedQuery);
  8.   } catch (SQLException e) {
  9.     ErrorUtils.logError(e);
  10.   }
  11.   return attachment;
  12. }

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

  1. public Social getBySocialId(String socialId) {
  2.   Social social = null;
  3.   try {
  4.     QueryBuilder<Social, Long> queryBuilder = dao.queryBuilder();
  5.     queryBuilder.where().eq(Social.Column.ID, socialId);
  6.     PreparedQuery<Social> preparedQuery = queryBuilder.prepare();
  7.     social = dao.queryForFirst(preparedQuery);
  8.   } catch (SQLException e) {
  9.     ErrorUtils.logError(e);
  10.   }
  11.   return social;
  12. }

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

  1. public Dialog getByRoomJid(String roomJid) {
  2.   Dialog dialog = null;
  3.   try {
  4.     QueryBuilder<Dialog, Long> queryBuilder = dao.queryBuilder();
  5.     queryBuilder.where().eq(Dialog.Column.ROOM_JID, roomJid);
  6.     PreparedQuery<Dialog> preparedQuery = queryBuilder.prepare();
  7.     dialog = dao.queryForFirst(preparedQuery);
  8.   } catch (SQLException e) {
  9.     ErrorUtils.logError(e);
  10.   }
  11.   return dialog;
  12. }

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

  1. public Message getByMessageId(String messageId) {
  2.   Message message = null;
  3.   try {
  4.     QueryBuilder<Message, Long> messageQueryBuilder = dao.queryBuilder();
  5.     messageQueryBuilder.where().eq(Message.Column.ID, messageId);
  6.     PreparedQuery<Message> preparedQuery = messageQueryBuilder.prepare();
  7.     message = dao.queryForFirst(preparedQuery);
  8.   } catch (SQLException e) {
  9.     ErrorUtils.logError(e);
  10.   }
  11.   return message;
  12. }

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

  1. public Friend getByUserId(int userId) {
  2.   Friend friend = null;
  3.   try {
  4.     QueryBuilder<Friend, Long> queryBuilder = dao.queryBuilder();
  5.     queryBuilder.where().eq(QMUserColumns.ID, userId);
  6.     PreparedQuery<Friend> preparedQuery = queryBuilder.prepare();
  7.     friend = dao.queryForFirst(preparedQuery);
  8.   } catch (SQLException e) {
  9.     ErrorUtils.logError(e);
  10.   }
  11.   return friend;
  12. }

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

  1. @Override
  2. public  QMUser getUserByColumn(String column, String value) {
  3.   QMUser user = null;
  4.   try {
  5.     QueryBuilder<QMUser, Long> queryBuilder = dao.queryBuilder();
  6.     queryBuilder.where().eq(column, value);
  7.     PreparedQuery<QMUser> preparedQuery = queryBuilder.prepare();
  8.     user = dao.queryForFirst(preparedQuery);
  9.   } catch (SQLException e) {
  10.     ErrorUtils.logError(e);
  11.   }
  12.   return user;
  13. }

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

  1. public QMUser getUserRequestById(int userId) {
  2.   UserRequest userRequest = null;
  3.   try {
  4.     QueryBuilder<UserRequest, Long> queryBuilder = dao.queryBuilder();
  5.     queryBuilder.where().eq(QMUserColumns.ID, userId);
  6.     PreparedQuery<UserRequest> preparedQuery = queryBuilder.prepare();
  7.     userRequest = dao.queryForFirst(preparedQuery);
  8.   } catch (SQLException e) {
  9.     ErrorUtils.logError(e);
  10.   }
  11.   return userRequest != null ? userRequest.getUser() : null;
  12. }

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

  1. public Message getLastMessageWithTempByDialogId(List<Long> dialogOccupantsList) {
  2.   Message message = null;
  3.   try {
  4.     QueryBuilder<Message, Long> queryBuilder = dao.queryBuilder();
  5.     queryBuilder.where().in(DialogOccupant.Column.ID, dialogOccupantsList);
  6.     queryBuilder.orderBy(Message.Column.CREATED_DATE, false);
  7.     PreparedQuery<Message> preparedQuery = queryBuilder.prepare();
  8.     message = dao.queryForFirst(preparedQuery);
  9.   } catch (SQLException e) {
  10.     ErrorUtils.logError(e);
  11.   }
  12.   return message;
  13. }

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

  1. public DialogOccupant getDialogOccupant(String dialogId, int userId) {
  2.   DialogOccupant dialogOccupant = null;
  3.   try {
  4.     QueryBuilder<DialogOccupant, Long> queryBuilder = dao.queryBuilder();
  5.     Where<DialogOccupant, Long> where = queryBuilder.where();
  6.     where.and(where.eq(Dialog.Column.ID, dialogId), where.eq(QMUserColumns.ID, userId));
  7.     PreparedQuery<DialogOccupant> preparedQuery = queryBuilder.prepare();
  8.     dialogOccupant = dao.queryForFirst(preparedQuery);
  9.   } catch (SQLException e) {
  10.     ErrorUtils.logError(e);
  11.   }
  12.   return dialogOccupant;
  13. }

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

  1. @Override
  2. public MetricsBinaryTypeDevice get(MetricsBinaryTypeDevice metric) {
  3.   try {
  4.     return this.getDao().queryForFirst(
  5.         this.getDao().queryBuilder()
  6.             .where()
  7.             .eq(MetricsBinaryTypeDevice.KEY_SENSOR_VARIABLE_ID, metric.getSensorVariable().getId())
  8.             .and().eq(MetricsBinaryTypeDevice.KEY_TIMESTAMP, metric.getTimestamp()).prepare());
  9.   } catch (SQLException ex) {
  10.     _logger.error("unable to get, metric:{}", metric, ex);
  11.   }
  12.   return null;
  13. }

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

  1. @Override
  2. public MetricsBinaryTypeDevice get(MetricsBinaryTypeDevice metric) {
  3.   try {
  4.     return this.getDao().queryForFirst(
  5.         this.getDao().queryBuilder()
  6.             .where()
  7.             .eq(MetricsBinaryTypeDevice.KEY_SENSOR_VARIABLE_ID, metric.getSensorVariable().getId())
  8.             .and().eq(MetricsBinaryTypeDevice.KEY_TIMESTAMP, metric.getTimestamp()).prepare());
  9.   } catch (SQLException ex) {
  10.     _logger.error("unable to get, metric:{}", metric, ex);
  11.     throw new McDatabaseException(ex);
  12.   }
  13. }

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

  1. @Test
  2. public void testQueryForFirstNoResults() throws Exception {
  3.   Dao<Foo, Integer> dao = createDao(Foo.class, true);
  4.   assertNull(dao.queryForFirst(dao.queryBuilder().prepare()));
  5. }

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

  1. @Override
  2. public MetricsBatteryUsage get(MetricsBatteryUsage metric) {
  3.   try {
  4.     return this.getDao().queryForFirst(
  5.         this.getDao().queryBuilder()
  6.             .where()
  7.             .eq(MetricsBatteryUsage.KEY_NODE_ID, metric.getNode().getId())
  8.             .and().eq(MetricsBatteryUsage.KEY_AGGREGATION_TYPE, metric.getAggregationType())
  9.             .and().eq(MetricsBatteryUsage.KEY_TIMESTAMP, metric.getTimestamp()).prepare());
  10.   } catch (SQLException ex) {
  11.     _logger.error("unable to get, metric:{}", metric, ex);
  12.     throw new McDatabaseException(ex);
  13.   }
  14. }

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

  1. @Test
  2. public void testQueryForFirst() throws Exception {
  3.   Dao<Foo, Integer> dao = createDao(Foo.class, true);
  4.   Foo foo1 = new Foo();
  5.   assertEquals(1, dao.create(foo1));
  6.   Foo foo2 = new Foo();
  7.   assertEquals(1, dao.create(foo2));
  8.   assertNotNull(dao.queryForId(foo1.id));
  9.   assertNotNull(dao.queryForId(foo2.id));
  10.   assertEquals(2, dao.queryForAll().size());
  11.   Foo foo3 = dao.queryForFirst(dao.queryBuilder().prepare());
  12.   assertNotNull(foo2);
  13.   assertEquals(foo1.id, foo3.id);
  14. }

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

Dao

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Dao类方法

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