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

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

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

Dao.queryRaw介绍

[英]Similar to the #queryRaw(String,RawRowMapper,String...) but this iterator returns rows that you can map yourself using DatabaseResultsMapper.
[中]类似于#queryRaw（String、RawRowMapper、String…）但是这个迭代器返回可以使用DatabaseResultsMapper自己映射的行。

代码示例

代码示例来源：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#queryRaw(String, DatabaseResultsMapper, String...)
  3.  */
  4. @Override
  5. public <UO> GenericRawResults<UO> queryRaw(String query, DatabaseResultsMapper<UO> mapper, String... arguments) {
  6.   try {
  7.     return dao.queryRaw(query, mapper, arguments);
  8.   } catch (SQLException e) {
  9.     logMessage(e, "queryRaw threw exception on: " + query);
  10.     throw new RuntimeException(e);
  11.   }
  12. }

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

  1. /**
  2.  * A short cut to {@link Dao#queryRaw(String, String...)}.
  3.  */
  4. public GenericRawResults<String[]> queryRaw() throws SQLException {
  5.   return dao.queryRaw(prepareStatementString());
  6. }

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

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

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

  1. /**
  2.  * @see Dao#queryRaw(String, RawRowMapper, String...)
  3.  */
  4. @Override
  5. public <UO> GenericRawResults<UO> queryRaw(String query, RawRowMapper<UO> mapper, String... arguments) {
  6.   try {
  7.     return dao.queryRaw(query, mapper, arguments);
  8.   } catch (SQLException e) {
  9.     logMessage(e, "queryRaw threw exception on: " + query);
  10.     throw new RuntimeException(e);
  11.   }
  12. }

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

  1. /**
  2.  * @see Dao#queryRaw(String, DataType[], String...)
  3.  */
  4. @Override
  5. public GenericRawResults<Object[]> queryRaw(String query, DataType[] columnTypes, String... arguments) {
  6.   try {
  7.     return dao.queryRaw(query, columnTypes, arguments);
  8.   } catch (SQLException e) {
  9.     logMessage(e, "queryRaw threw exception on: " + query);
  10.     throw new RuntimeException(e);
  11.   }
  12. }

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

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

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

  1. /**
  2.  * @see Dao#queryRaw(String, DatabaseResultsMapper, String...)
  3.  */
  4. @Override
  5. public <UO> GenericRawResults<UO> queryRaw(String query, DatabaseResultsMapper<UO> mapper, String... arguments) {
  6.   try {
  7.     return dao.queryRaw(query, mapper, arguments);
  8.   } catch (SQLException e) {
  9.     logMessage(e, "queryRaw threw exception on: " + query);
  10.     throw new RuntimeException(e);
  11.   }
  12. }

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

  1. /**
  2.  * @see Dao#queryRaw(String, RawRowMapper, String...)
  3.  */
  4. @Override
  5. public <UO> GenericRawResults<UO> queryRaw(String query, RawRowMapper<UO> mapper, String... arguments) {
  6.   try {
  7.     return dao.queryRaw(query, mapper, arguments);
  8.   } catch (SQLException e) {
  9.     logMessage(e, "queryRaw threw exception on: " + query);
  10.     throw new RuntimeException(e);
  11.   }
  12. }

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

  1. /**
  2.  * @see Dao#queryRaw(String, DataType[], String...)
  3.  */
  4. @Override
  5. public GenericRawResults<Object[]> queryRaw(String query, DataType[] columnTypes, String... arguments) {
  6.   try {
  7.     return dao.queryRaw(query, columnTypes, arguments);
  8.   } catch (SQLException e) {
  9.     logMessage(e, "queryRaw threw exception on: " + query);
  10.     throw new RuntimeException(e);
  11.   }
  12. }

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

  1. /**
  2.  * @see Dao#queryRaw(String, DataType[], RawRowObjectMapper, String...)
  3.  */
  4. @Override
  5. public <UO> GenericRawResults<UO> queryRaw(String query, DataType[] columnTypes, RawRowObjectMapper<UO> mapper,
  6.     String... arguments) {
  7.   try {
  8.     return dao.queryRaw(query, columnTypes, mapper, arguments);
  9.   } catch (SQLException e) {
  10.     logMessage(e, "queryRaw threw exception on: " + query);
  11.     throw new RuntimeException(e);
  12.   }
  13. }

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

  1. /**
  2.  * @see Dao#queryRaw(String, DataType[], RawRowObjectMapper, String...)
  3.  */
  4. @Override
  5. public <UO> GenericRawResults<UO> queryRaw(String query, DataType[] columnTypes, RawRowObjectMapper<UO> mapper,
  6.     String... arguments) {
  7.   try {
  8.     return dao.queryRaw(query, columnTypes, mapper, arguments);
  9.   } catch (SQLException e) {
  10.     logMessage(e, "queryRaw threw exception on: " + query);
  11.     throw new RuntimeException(e);
  12.   }
  13. }

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

  1. /**
  2.  * A short cut to {@link Dao#queryRaw(String, String...)} and {@link GenericRawResults#getFirstResult()}.
  3.  */
  4. public String[] queryRawFirst() throws SQLException {
  5.   return dao.queryRaw(prepareStatementString()).getFirstResult();
  6. }

代码示例来源：origin: annmuor/jnode

  1. public GenericRawResults<Object[]> getRaw(String query, DataType[] types) {
  2.   try {
  3.     return getDao().queryRaw(query, types);
  4.   } catch (SQLException e) {
  5.     logger.l1("SQL Exception in getRaw", e);
  6.     logger.l1(MessageFormat.format("we worked with {0} {1}", query,
  7.         Arrays.toString(types)));
  8.   }
  9.   return null;
  10. }

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

  1. public boolean hasTable(String tableName) {
  2.   try {
  3.     // test if the table already exists
  4.     DaoUtils.getUserDao().getDao().queryRaw("SELECT count(*) FROM " + getTableName(tableName));
  5.     return true;
  6.   } catch (SQLException ex) {
  7.     return false;
  8.   }
  9. }

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

  1. @Test(expected = RuntimeException.class)
  2. public void testQueryRawDateTypesThrow() 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.queryRaw(null, (DataType[]) null)).andThrow(new SQLException("Testing catch"));
  7.   replay(dao);
  8.   rtDao.queryRaw(null, (DataType[]) null);
  9.   verify(dao);
  10. }

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

  1. @Test(expected = RuntimeException.class)
  2. public void testQueryRawThrow() 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.queryRaw(null)).andThrow(new SQLException("Testing catch"));
  7.   replay(dao);
  8.   rtDao.queryRaw(null);
  9.   verify(dao);
  10. }

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

  1. @Test(expected = RuntimeException.class)
  2. public void testQueryRawRowMapperThrow() 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.queryRaw(null, (RawRowMapper<String>) null)).andThrow(new SQLException("Testing catch"));
  7.   replay(dao);
  8.   rtDao.queryRaw(null, (RawRowMapper<String>) null);
  9.   verify(dao);
  10. }

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

  1. @Test(expected = SQLException.class)
  2. public void testQueryRawObjectsThrow() throws Exception {
  3.   Dao<Foo, Integer> dao = createDao(Foo.class, true);
  4.   Foo foo = new Foo();
  5.   assertEquals(1, dao.create(foo));
  6.   DatabaseConnection conn = connectionSource.getReadWriteConnection(FOO_TABLE_NAME);
  7.   try {
  8.     conn.close();
  9.     dao.queryRaw("SELECT * FROM FOO", new DataType[0]);
  10.   } finally {
  11.     connectionSource.releaseConnection(conn);
  12.   }
  13. }

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

Dao

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Dao类方法

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