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

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

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

Dao.queryForAll介绍

[英]Query for all of the items in the object table. For medium sized or large tables, this may load a lot of objects into memory so you should consider using the #iterator() method instead.
[中]查询对象表中的所有项。对于中等大小或较大的表，这可能会将大量对象加载到内存中，因此应该考虑使用“γ迭代器”（）方法。

代码示例

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

  1. /**
  2.  * 查询表中的所有城市
  3.  *
  4.  * @return 城市列表数据
  5.  */
  6. public List<City> queryCityList() {
  7.   try {
  8.     return cityDaoOperation.queryForAll();
  9.   } catch (SQLException e) {
  10.     e.printStackTrace();
  11.   }
  12.   return null;
  13. }

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

  1. /**
  2.    * 查询所有热门城市
  3.    *
  4.    * @return 热门城市列表
  5.    */
  6.   public List<HotCity> queryAllHotCity() {
  7.     try {
  8.       return hotCityDaoOperation.queryForAll();
  9.     } catch (SQLException e) {
  10.       e.printStackTrace();
  11.     }
  12.     return null;
  13.   }
  14. }

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

  1. public List<Log> getAllLogs() {
  2.   List<Log> logs = new ArrayList<>();
  3.   try {
  4.     logs = logDao.queryForAll();
  5.   } catch (SQLException ex) {
  6.   }
  7.   return logs;
  8. }

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

  1. public List<Feedback> getAllFeedbacks() {
  2.     List<Feedback> feedbacks = new ArrayList<>();
  3.     try {
  4.       feedbacks = feedbackDao.queryForAll();
  5.     } catch (SQLException ex) {
  6.     }
  7.     return feedbacks;
  8.   }
  9. }

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

  1. /**
  2.  * 查询数据库中的所有已添加的城市
  3.  *
  4.  * @return 结果集中只包括城市信息，天气数据不在其中
  5.  * @throws SQLException
  6.  */
  7. public List<Weather> queryAllSaveCity() throws SQLException {
  8.   return TransactionManager.callInTransaction(WeatherDatabaseHelper.getInstance(context).getConnectionSource(), () -> {
  9.     List<Weather> weatherList = weatherDaoOperation.queryForAll();
  10.     for (Weather weather : weatherList) {
  11.       String cityId = weather.getCityId();
  12.       weather.setAirQualityLive(apiDaoOperation.queryForId(cityId));
  13.       weather.setWeatherForecasts(forecastDaoOperation.queryForEq(WeatherForecast.CITY_ID_FIELD_NAME, cityId));
  14.       weather.setLifeIndexes(lifeIndexesDaoOperation.queryForEq(WeatherForecast.CITY_ID_FIELD_NAME, cityId));
  15.       weather.setWeatherLive(realTimeDaoOperation.queryForId(cityId));
  16.     }
  17.     return weatherList;
  18.   });
  19. }

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

  1. public List<String> getClassNames() {
  2.   List<String> names = new ArrayList<>();
  3.   try {
  4.     List<CardInfo> results = cardDao.queryForAll();
  5.     for (CardInfo card : results) {
  6.       names.add(card.getClassName());
  7.     }
  8.   } catch (SQLException ex) {
  9.     Logger.getLogger(CardRepository.class).error("Error getting classnames from DB : " + ex);
  10.   }
  11.   return names;
  12. }

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

  1. public List<String> getSetCodes() {
  2.   List<String> setCodes = new ArrayList<>();
  3.   try {
  4.     List<ExpansionInfo> expansions = expansionDao.queryForAll();
  5.     for (ExpansionInfo expansion : expansions) {
  6.       setCodes.add(expansion.getCode());
  7.     }
  8.   } catch (SQLException ex) {
  9.     logger.error("Can't get the expansion set codes from database.", ex);
  10.     return setCodes;
  11.   }
  12.   return setCodes;
  13. }

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

  1. @Test
  2. public void testDateStringFormatNotDayAlign() throws Exception {
  3.   Dao<DateStringFormat, Object> dao = createDao(DateStringFormat.class, true);
  4.   DateStringFormat dateStringFormat = new DateStringFormat();
  5.   dateStringFormat.date = new SimpleDateFormat("yyyy-MM-dd HH").parse("2012-09-01 12");
  6.   assertEquals(1, dao.create(dateStringFormat));
  7.   List<DateStringFormat> results = dao.queryForAll();
  8.   assertEquals(1, results.size());
  9.   assertFalse(dateStringFormat.date.equals(results.get(0).date));
  10. }

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

  1. @Test(expected = Exception.class)
  2. public void testCallBatchThrow() throws Exception {
  3.   final Dao<Foo, Integer> dao = createDao(Foo.class, true);
  4.   assertEquals(0, dao.queryForAll().size());
  5.   // this should be none
  6.   dao.callBatchTasks(new Callable<Void>() {
  7.     @Override
  8.     public Void call() throws Exception {
  9.       throw new Exception("for the hell of it");
  10.     }
  11.   });
  12. }

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

  1. @Test
  2. public void testExecuteRaw() 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.   assertEquals(2, dao.queryForAll().size());
  9.   dao.executeRaw("TRUNCATE TABLE FOO");
  10.   assertEquals(0, dao.queryForAll().size());
  11. }

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

  1. @Test
  2. public void testDefaultValue() throws Exception {
  3.   Dao<EnumDefault, Object> dao = createDao(EnumDefault.class, true);
  4.   EnumDefault enumDefault = new EnumDefault();
  5.   assertEquals(1, dao.create(enumDefault));
  6.   List<EnumDefault> unknowns = dao.queryForAll();
  7.   assertEquals(1, unknowns.size());
  8.   assertEquals(OurEnum.SECOND, unknowns.get(0).ourEnum);
  9. }

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

  1. @Test
  2. public void testBigDecimalNull() throws Exception {
  3.   Dao<LocalBigDecimal, Object> dao = createDao(LocalBigDecimal.class, true);
  4.   LocalBigDecimal foo = new LocalBigDecimal();
  5.   assertEquals(1, dao.create(foo));
  6.   List<LocalBigDecimal> results = dao.queryForAll();
  7.   assertEquals(1, results.size());
  8.   assertNull(results.get(0).bigDecimal);
  9. }

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

  1. @Test
  2. public void testLongPrimitiveNull() throws Exception {
  3.   Dao<LocalLongObj, Object> objDao = createDao(LocalLongObj.class, true);
  4.   LocalLongObj foo = new LocalLongObj();
  5.   foo.longField = null;
  6.   assertEquals(1, objDao.create(foo));
  7.   Dao<LocalLong, Object> dao = createDao(LocalLong.class, false);
  8.   List<LocalLong> all = dao.queryForAll();
  9.   assertEquals(1, all.size());
  10.   assertEquals(0, all.get(0).longField);
  11. }

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

  1. @Test
  2. public void testDoublePrimitiveNull() throws Exception {
  3.   Dao<LocalDoubleObj, Object> objDao = createDao(LocalDoubleObj.class, true);
  4.   LocalDoubleObj foo = new LocalDoubleObj();
  5.   foo.doubleField = null;
  6.   assertEquals(1, objDao.create(foo));
  7.   Dao<LocalDouble, Object> dao = createDao(LocalDouble.class, false);
  8.   List<LocalDouble> all = dao.queryForAll();
  9.   assertEquals(1, all.size());
  10.   assertEquals(0.0F, all.get(0).doubleField, 0.0F);
  11. }

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

  1. @Test
  2. public void testUnknownValueAnnotation() throws Exception {
  3.   Dao<LocalUnknownEnum, Object> dao = createDao(LocalUnknownEnum.class, true);
  4.   LocalUnknownEnum localUnknownEnum = new LocalUnknownEnum();
  5.   localUnknownEnum.ourEnum = OurEnum.SECOND;
  6.   assertEquals(1, dao.create(localUnknownEnum));
  7.   assertEquals(1, dao.updateRaw("UPDATE Foo set ourEnum = 'THIRD'"));
  8.   List<LocalUnknownEnum> unknowns = dao.queryForAll();
  9.   assertEquals(1, unknowns.size());
  10.   assertEquals(OurEnum.FIRST, unknowns.get(0).ourEnum);
  11. }

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

  1. @Test(expected = SQLException.class)
  2. public void testBigIntegerInvalidDbValue() throws Exception {
  3.   Dao<LocalBigInteger, Object> dao = createDao(LocalBigInteger.class, true);
  4.   Dao<NotBigInteger, Object> notDao = createDao(NotBigInteger.class, false);
  5.   NotBigInteger notFoo = new NotBigInteger();
  6.   notFoo.bigInteger = "not valid form";
  7.   assertEquals(1, notDao.create(notFoo));
  8.   dao.queryForAll();
  9. }

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

  1. @Test(expected = SQLException.class)
  2. public void testBigDecimalInvalidDbValue() throws Exception {
  3.   Dao<LocalBigDecimal, Object> dao = createDao(LocalBigDecimal.class, true);
  4.   Dao<NotBigDecimal, Object> notDao = createDao(NotBigDecimal.class, false);
  5.   NotBigDecimal notFoo = new NotBigDecimal();
  6.   notFoo.bigDecimal = "not valid form";
  7.   assertEquals(1, notDao.create(notFoo));
  8.   dao.queryForAll();
  9. }

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

  1. @Test(expected = SQLException.class)
  2. public void testUnknownEnumValue() throws Exception {
  3.   Dao<LocalEnumString, Object> dao = createDao(LocalEnumString.class, true);
  4.   LocalEnumString localEnumString = new LocalEnumString();
  5.   localEnumString.ourEnum = OurEnum.FIRST;
  6.   assertEquals(1, dao.create(localEnumString));
  7.   assertEquals(1, dao.updateRaw("UPDATE Foo set ourEnum = 'THIRD'"));
  8.   dao.queryForAll();
  9. }

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

  1. @Test
  2. public void testDeleteById() throws Exception {
  3.   Dao<Foo, Integer> dao = createDao(Foo.class, true);
  4.   Foo foo = new Foo();
  5.   assertEquals(1, dao.create(foo));
  6.   assertNotNull(dao.queryForId(foo.id));
  7.   assertEquals(1, dao.deleteById(foo.id));
  8.   assertNull(dao.queryForId(foo.id));
  9.   assertEquals(0, dao.queryForAll().size());
  10. }

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

  1. @Test
  2. public void testDelete() throws Exception {
  3.   Dao<Foo, Integer> dao = createDao(Foo.class, true);
  4.   Foo foo = new Foo();
  5.   assertEquals(1, dao.create(foo));
  6.   assertNotNull(dao.queryForId(foo.id));
  7.   assertEquals(1, dao.delete(foo));
  8.   assertNull(dao.queryForId(foo.id));
  9.   assertEquals(0, dao.queryForAll().size());
  10. }

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

Dao

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Dao类方法

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