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

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

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

Dao.getRawRowMapper介绍

[英]Return a row mapper that is suitable for use with #queryRaw(String,RawRowMapper,String...). This is a bit experimental at this time. It most likely will not work with all databases since the string output for each data type is hard to forecast. Please provide feedback.
[中]返回适合与#queryRaw一起使用的行映射器(String,RawRowMapper,String…)。这是一个有点实验在这个时候。它很可能不会适用于所有数据库,因为很难预测每种数据类型的字符串输出。请提供反馈。

代码示例

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

  1. public List<CardInfo> findCardsCaseInsensitive(String name) {
  2. try {
  3. String sqlName = name.toLowerCase(Locale.ENGLISH).replaceAll("\'", "\'\'");
  4. GenericRawResults<CardInfo> rawResults = cardDao.queryRaw(
  5. "select * from " + CardRepository.VERSION_ENTITY_NAME + " where lower(name) = '" + sqlName + '\'',
  6. cardDao.getRawRowMapper());
  7. List<CardInfo> result = new ArrayList<>();
  8. for (CardInfo cardinfo : rawResults) {
  9. result.add(cardinfo);
  10. }
  11. return result;
  12. } catch (SQLException ex) {
  13. Logger.getLogger(CardRepository.class).error("Error during execution of raw sql statement", ex);
  14. }
  15. return Collections.emptyList();
  16. }

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

  1. public ExpansionInfo[] getWithBoostersSortedByReleaseDate() {
  2. try {
  3. // only with boosters and cards
  4. GenericRawResults<ExpansionInfo> setsList = expansionDao.queryRaw(
  5. "select * from expansion e "
  6. + " where e.boosters = 1 "
  7. + " and exists(select (1) from card c where c.setcode = e.code) "
  8. + " order by e.releasedate desc",
  9. expansionDao.getRawRowMapper());
  10. List<ExpansionInfo> resList = new ArrayList<>();
  11. for (ExpansionInfo info : setsList) {
  12. resList.add(info);
  13. }
  14. return resList.toArray(new ExpansionInfo[0]);
  15. } catch (SQLException ex) {
  16. logger.error(ex);
  17. return new ExpansionInfo[0];
  18. }
  19. }

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

  1. /**
  2. * @see Dao#getRawRowMapper()
  3. */
  4. @Override
  5. public RawRowMapper<T> getRawRowMapper() {
  6. return dao.getRawRowMapper();
  7. }

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

  1. /**
  2. * @see Dao#getRawRowMapper()
  3. */
  4. @Override
  5. public RawRowMapper<T> getRawRowMapper() {
  6. return dao.getRawRowMapper();
  7. }

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

  1. GenericRawResults<MetricsCounterTypeDevice> rawResult = DaoUtils
  2. .getMetricsCounterTypeDeviceDao().getDao().queryRaw(sqlSelectQuery,
  3. DaoUtils.getMetricsCounterTypeDeviceDao().getDao().getRawRowMapper());
  4. metric = rawResult.getFirstResult();
  5. _logger.debug("Metric:[{}]", metric);

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

  1. GenericRawResults<MetricsCounterTypeDevice> rawResult = DaoUtils
  2. .getMetricsCounterTypeDeviceDao().getDao().queryRaw(sqlSelectQuery,
  3. DaoUtils.getMetricsCounterTypeDeviceDao().getDao().getRawRowMapper());
  4. metric = rawResult.getFirstResult();
  5. _logger.debug("Metric:[{}]", metric);

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

  1. GenericRawResults<MetricsDoubleTypeDevice> rawResult = DaoUtils
  2. .getMetricsDoubleTypeDeviceDao().getDao().queryRaw(sqlSelectQuery,
  3. DaoUtils.getMetricsDoubleTypeDeviceDao().getDao().getRawRowMapper());
  4. metric = rawResult.getFirstResult();
  5. _logger.debug("Metric:[{}]", metric);

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

  1. GenericRawResults<MetricsBatteryUsage> rawResult = DaoUtils
  2. .getMetricsBatteryUsageDao().getDao().queryRaw(sqlSelectQuery,
  3. DaoUtils.getMetricsBatteryUsageDao().getDao().getRawRowMapper());
  4. metric = rawResult.getFirstResult();
  5. _logger.debug("Metric:[{}]", metric);

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

  1. GenericRawResults<MetricsBatteryUsage> rawResult = DaoUtils
  2. .getMetricsBatteryUsageDao().getDao().queryRaw(sqlSelectQuery,
  3. DaoUtils.getMetricsBatteryUsageDao().getDao().getRawRowMapper());
  4. metric = rawResult.getFirstResult();
  5. _logger.debug("Metric:[{}]", metric);

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

  1. GenericRawResults<MetricsDoubleTypeDevice> rawResult = DaoUtils
  2. .getMetricsDoubleTypeDeviceDao().getDao().queryRaw(sqlSelectQuery,
  3. DaoUtils.getMetricsDoubleTypeDeviceDao().getDao().getRawRowMapper());
  4. metric = rawResult.getFirstResult();
  5. _logger.debug("Metric:[{}]", metric);

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

  1. @Test
  2. public void testQueryRawUsingRawRowMapper() throws Exception {
  3. Dao<Foo, Integer> dao = createDao(Foo.class, true);
  4. Foo foo1 = new Foo();
  5. int equal1 = 1231231232;
  6. foo1.equal = equal1;
  7. assertEquals(1, dao.create(foo1));
  8. Foo foo2 = new Foo();
  9. int equal2 = 1231232;
  10. foo2.equal = equal2;
  11. assertEquals(1, dao.create(foo2));
  12. QueryBuilder<Foo, Integer> queryBuilder = dao.queryBuilder();
  13. queryBuilder.where().eq(Foo.ID_COLUMN_NAME, foo1.id);
  14. GenericRawResults<Foo> results =
  15. dao.queryRaw("SELECT " + Foo.ID_COLUMN_NAME + " FROM FOO", dao.getRawRowMapper());
  16. List<Foo> resultList = results.getResults();
  17. assertEquals(2, resultList.size());
  18. assertEquals(foo1.id, resultList.get(0).id);
  19. assertEquals(0, resultList.get(0).equal);
  20. assertEquals(foo2.id, resultList.get(1).id);
  21. assertEquals(0, resultList.get(0).equal);
  22. }

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

  1. @Test
  2. public void testCountInReadOnlyField() throws Exception {
  3. Dao<AsField, Integer> dao = createDao(AsField.class, true);
  4. AsField foo1 = new AsField();
  5. int val1 = 123213;
  6. foo1.val = val1;
  7. assertEquals(1, dao.create(foo1));
  8. AsField foo2 = new AsField();
  9. int val2 = 122433213;
  10. foo2.val = val2;
  11. assertEquals(1, dao.create(foo2));
  12. QueryBuilder<AsField, Integer> qb = dao.queryBuilder();
  13. qb.selectRaw("*");
  14. int val3 = 12;
  15. qb.selectRaw(val3 + " AS " + AsField.SUM_FIELD);
  16. List<AsField> results = dao.queryRaw(qb.prepareStatementString(), dao.getRawRowMapper()).getResults();
  17. assertEquals(2, results.size());
  18. assertEquals(val1, (int) results.get(0).val);
  19. assertEquals(val3, (int) results.get(0).sum);
  20. assertEquals(val2, (int) results.get(1).val);
  21. assertEquals(val3, (int) results.get(1).sum);
  22. }

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

  1. qb.selectRaw("string, max(val) as val");
  2. qb.groupBy(Foo.STRING_COLUMN_NAME);
  3. GenericRawResults<Foo> results = dao.queryRaw(qb.prepareStatementString(), dao.getRawRowMapper());
  4. assertNotNull(results);
  5. CloseableIterator<Foo> iterator = results.closeableIterator();

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

  1. qb.selectRaw("MAX(val) AS val");
  2. qb.groupBy(Foo.STRING_COLUMN_NAME);
  3. GenericRawResults<Foo> results = dao.queryRaw(qb.prepareStatementString(), dao.getRawRowMapper());
  4. assertNotNull(results);
  5. CloseableIterator<Foo> iterator = results.closeableIterator();

相关文章