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

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

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

Dao.updateRaw介绍

[英]Run a raw update SQL statement to the database. The statement must be an SQL INSERT, UPDATE or DELETE statement.The arguments are optional but can be set with strings to expand ? type of SQL.
[中]对数据库运行原始更新SQL语句。该语句必须是SQL INSERT、UPDATE或DELETE语句。参数是可选的,但可以使用字符串进行设置以展开?SQL的类型。

代码示例

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

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

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

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

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

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

代码示例来源: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
  2. public void testUpdateRaw() 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.updateRaw("DELETE FROM FOO WHERE " + Foo.ID_COLUMN_NAME + " = ?", Integer.toString(foo1.id));
  10. assertEquals(1, dao.queryForAll().size());
  11. }

代码示例来源: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(expected = SQLException.class)
  2. public void testUpdateRawThrow() 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.updateRaw("DELETE FROM FOO");
  10. } finally {
  11. connectionSource.releaseConnection(conn);
  12. }
  13. }

相关文章