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

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

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

Dao.query介绍

[英]Query for the items in the object table which match the prepared query. See #queryBuilder for more information.

NOTE: For medium sized or large tables, this may load a lot of objects into memory so you should consider using the #iterator(PreparedQuery) method instead.
[中]查询对象表中与准备的查询匹配的项。有关更多信息，请参阅#queryBuilder。
注意：对于中等大小或较大的表，这可能会将大量对象加载到内存中，因此您应该考虑使用γ迭代器（PravaReqQuy）方法。

代码示例

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

  1. public List<UserStats> getAllUsers() {
  2.   try {
  3.     QueryBuilder<UserStats, Object> qb = dao.queryBuilder();
  4.     return dao.query(qb.prepare());
  5.   } catch (SQLException ex) {
  6.     Logger.getLogger(UserStatsRepository.class).error("Error getting all users from DB - ", ex);
  7.   }
  8.   return null;
  9. }

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

  1. public List<ExpansionInfo> getAll() {
  2.   try {
  3.     QueryBuilder<ExpansionInfo, Object> qb = expansionDao.queryBuilder();
  4.     qb.orderBy("releaseDate", true);
  5.     return expansionDao.query(qb.prepare());
  6.   } catch (SQLException ex) {
  7.     logger.error(ex);
  8.   }
  9.   return Collections.emptyList();
  10. }

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

  1. public List<CardInfo> findCards(CardCriteria criteria) {
  2.   try {
  3.     QueryBuilder<CardInfo, Object> queryBuilder = cardDao.queryBuilder();
  4.     criteria.buildQuery(queryBuilder);
  5.     return cardDao.query(queryBuilder.prepare());
  6.   } catch (SQLException ex) {
  7.     Logger.getLogger(CardRepository.class).error("Error during execution of card repository query statement", ex);
  8.   }
  9.   return Collections.emptyList();
  10. }

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

  1. public List<String> getAllSetNames() {
  2.   try {
  3.     QueryBuilder<ExpansionInfo, Object> qb = expansionDao.queryBuilder();
  4.     qb.orderBy("releaseDate", true);
  5.     List<ExpansionInfo> expansions = expansionDao.query(qb.prepare());
  6.     List<String> setNames = new LinkedList<>();
  7.     for (ExpansionInfo expansionInfo : expansions) {
  8.       setNames.add(expansionInfo.getName());
  9.     }
  10.     return setNames;
  11.   } catch (SQLException ex) {
  12.     logger.error(ex);
  13.   }
  14.   return Collections.emptyList();
  15. }

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

  1. public UserStats getUser(String userName) {
  2.   try {
  3.     QueryBuilder<UserStats, Object> qb = dao.queryBuilder();
  4.     qb.limit(1L).where().eq("userName", userName);
  5.     List<UserStats> users = dao.query(qb.prepare());
  6.     if (!users.isEmpty()) {
  7.       return users.get(0);
  8.     }
  9.   } catch (SQLException ex) {
  10.     Logger.getLogger(UserStatsRepository.class).error("Error getting a user from DB - ", ex);
  11.   }
  12.   return null;
  13. }

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

  1. public List<CardInfo> getMissingCards(List<String> classNames) {
  2.   try {
  3.     QueryBuilder<CardInfo, Object> queryBuilder = cardDao.queryBuilder();
  4.     queryBuilder.where().not().in("className", classNames);
  5.     return cardDao.query(queryBuilder.prepare());
  6.   } catch (SQLException ex) {
  7.     Logger.getLogger(CardRepository.class).error("Error getting missing cards from DB : " + ex);
  8.   }
  9.   return Collections.emptyList();
  10. }

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

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

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

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

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

  1. public List<ExpansionInfo> getSetsFromBlock(String blockName) {
  2.   List<ExpansionInfo> sets = new LinkedList<>();
  3.   try {
  4.     QueryBuilder<ExpansionInfo, Object> qb = expansionDao.queryBuilder();
  5.     qb.where().eq("blockName", new SelectArg(blockName));
  6.     return expansionDao.query(qb.prepare());
  7.   } catch (SQLException ex) {
  8.     logger.error(ex);
  9.   }
  10.   return sets;
  11. }

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

  1. public AuthorizedUser getByName(String userName) {
  2.   try {
  3.     QueryBuilder<AuthorizedUser, Object> qb = dao.queryBuilder();
  4.     qb.where().eq("name", new SelectArg(userName));
  5.     List<AuthorizedUser> results = dao.query(qb.prepare());
  6.     if (results.size() == 1) {
  7.       return results.get(0);
  8.     }
  9.     return null;
  10.   } catch (SQLException ex) {
  11.     Logger.getLogger(AuthorizedUserRepository.class).error("Error getting a authorized_user - ", ex);
  12.   }
  13.   return null;
  14. }

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

  1. public AuthorizedUser getByEmail(String userName) {
  2.   try {
  3.     QueryBuilder<AuthorizedUser, Object> qb = dao.queryBuilder();
  4.     qb.where().eq("email", new SelectArg(userName));
  5.     List<AuthorizedUser> results = dao.query(qb.prepare());
  6.     if (results.size() == 1) {
  7.       return results.get(0);
  8.     }
  9.     return null;
  10.   } catch (SQLException ex) {
  11.     Logger.getLogger(AuthorizedUserRepository.class).error("Error getting a authorized_user - ", ex);
  12.   }
  13.   return null;
  14. }

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

  1. public List<CardInfo> findCards(String name) {
  2.   try {
  3.     QueryBuilder<CardInfo, Object> queryBuilder = cardDao.queryBuilder();
  4.     queryBuilder.where().eq("name", new SelectArg(name));
  5.     return cardDao.query(queryBuilder.prepare());
  6.   } catch (SQLException ex) {
  7.   }
  8.   return Collections.emptyList();
  9. }

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

  1. public List<ExpansionInfo> getSetsWithBasicLandsByReleaseDate() {
  2.   List<ExpansionInfo> sets = new LinkedList<>();
  3.   try {
  4.     QueryBuilder<ExpansionInfo, Object> qb = expansionDao.queryBuilder();
  5.     qb.orderBy("releaseDate", false);
  6.     qb.where().eq("basicLands", new SelectArg(true));
  7.     sets = expansionDao.query(qb.prepare());
  8.   } catch (SQLException ex) {
  9.     logger.error(ex);
  10.   }
  11.   return sets;
  12. }

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

  1. public ExpansionInfo getSetByCode(String setCode) {
  2.   ExpansionInfo set = null;
  3.   try {
  4.     QueryBuilder<ExpansionInfo, Object> qb = expansionDao.queryBuilder();
  5.     qb.limit(1L).where().eq("code", new SelectArg(setCode));
  6.     List<ExpansionInfo> expansions = expansionDao.query(qb.prepare());
  7.     if (!expansions.isEmpty()) {
  8.       set = expansions.get(0);
  9.     }
  10.   } catch (SQLException ex) {
  11.     logger.error(ex);
  12.   }
  13.   return set;
  14. }

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

  1. public ExpansionInfo getSetByName(String setName) {
  2.   ExpansionInfo set = null;
  3.   try {
  4.     QueryBuilder<ExpansionInfo, Object> qb = expansionDao.queryBuilder();
  5.     qb.limit(1L).where().eq("name", new SelectArg(setName));
  6.     List<ExpansionInfo> expansions = expansionDao.query(qb.prepare());
  7.     if (!expansions.isEmpty()) {
  8.       set = expansions.get(0);
  9.     }
  10.   } catch (SQLException ex) {
  11.     logger.error(ex);
  12.   }
  13.   return set;
  14. }

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

  1. public boolean cardExists(String className) {
  2.   try {
  3.     if (classNames == null) {
  4.       QueryBuilder<CardInfo, Object> qb = cardDao.queryBuilder();
  5.       qb.distinct().selectColumns("className").where().isNotNull("className");
  6.       List<CardInfo> results = cardDao.query(qb.prepare());
  7.       classNames = new TreeSet<>();
  8.       for (CardInfo card : results) {
  9.         classNames.add(card.getClassName());
  10.       }
  11.     }
  12.     return classNames.contains(className);
  13.   } catch (SQLException ex) {
  14.   }
  15.   return false;
  16. }

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

  1. public static long getDatabaseVersion(ConnectionSource connectionSource, String entityName) throws SQLException {
  2.   TableUtils.createTableIfNotExists(connectionSource, DatabaseVersion.class);
  3.   Dao<DatabaseVersion, Object> dbVersionDao = DaoManager.createDao(connectionSource, DatabaseVersion.class);
  4.   QueryBuilder<DatabaseVersion, Object> queryBuilder = dbVersionDao.queryBuilder();
  5.   queryBuilder.where().eq("entity", new SelectArg(entityName));
  6.   List<DatabaseVersion> dbVersions = dbVersionDao.query(queryBuilder.prepare());
  7.   if (dbVersions.isEmpty()) {
  8.     return 0;
  9.   } else {
  10.     return dbVersions.get(0).getVersion();
  11.   }
  12. }

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

  1. public CardInfo findCard(String setCode, String cardNumber) {
  2.   try {
  3.     QueryBuilder<CardInfo, Object> queryBuilder = cardDao.queryBuilder();
  4.     queryBuilder.limit(1L).where().eq("setCode", new SelectArg(setCode)).and().eq("cardNumber", cardNumber).and().eq("nightCard", false);
  5.     List<CardInfo> result = cardDao.query(queryBuilder.prepare());
  6.     if (!result.isEmpty()) {
  7.       return result.get(0);
  8.     }
  9.   } catch (SQLException ex) {
  10.     Logger.getLogger(CardRepository.class).error("Error finding card from DB : " + ex);
  11.   }
  12.   return null;
  13. }

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

  1. public static boolean isDatabaseObsolete(ConnectionSource connectionSource, String entityName, long version) throws SQLException {
  2.   TableUtils.createTableIfNotExists(connectionSource, DatabaseVersion.class);
  3.   Dao<DatabaseVersion, Object> dbVersionDao = DaoManager.createDao(connectionSource, DatabaseVersion.class);
  4.   QueryBuilder<DatabaseVersion, Object> queryBuilder = dbVersionDao.queryBuilder();
  5.   queryBuilder.where().eq("entity", new SelectArg(entityName)).and().eq("version", version);
  6.   List<DatabaseVersion> dbVersions = dbVersionDao.query(queryBuilder.prepare());
  7.   if (dbVersions.isEmpty()) {
  8.     DatabaseVersion dbVersion = new DatabaseVersion();
  9.     dbVersion.setEntity(entityName);
  10.     dbVersion.setVersion(version);
  11.     dbVersionDao.create(dbVersion);
  12.   }
  13.   return dbVersions.isEmpty();
  14. }

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

  1. public static void updateVersion(ConnectionSource connectionSource, String entityName, long version) throws SQLException {
  2.   TableUtils.createTableIfNotExists(connectionSource, DatabaseVersion.class);
  3.   Dao<DatabaseVersion, Object> dbVersionDao = DaoManager.createDao(connectionSource, DatabaseVersion.class);
  4.   QueryBuilder<DatabaseVersion, Object> queryBuilder = dbVersionDao.queryBuilder();
  5.   queryBuilder.where().eq("entity", new SelectArg(entityName));
  6.   List<DatabaseVersion> dbVersions = dbVersionDao.query(queryBuilder.prepare());
  7.   if (!dbVersions.isEmpty()) {
  8.     DeleteBuilder<DatabaseVersion, Object> deleteBuilder = dbVersionDao.deleteBuilder();
  9.     deleteBuilder.where().eq("entity", new SelectArg(entityName));
  10.     deleteBuilder.delete();
  11.   }
  12.   DatabaseVersion databaseVersion = new DatabaseVersion();
  13.   databaseVersion.setEntity(entityName);
  14.   databaseVersion.setVersion(version);
  15.   dbVersionDao.create(databaseVersion);
  16. }

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

Dao

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Dao类方法

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