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

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

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

Dao.deleteBuilder介绍

[英]Like #queryBuilder() but allows you to build an DELETE statement. You can then call call DeleteBuilder#prepare() and pass the returned PreparedDelete to #delete(PreparedDelete).
[中]类似于#queryBuilder（），但允许您生成DELETE语句。然后可以调用call DeleteBuilder#prepare（），并将返回的PreparedDelete传递给#delete（PreparedDelete）。

代码示例

代码示例来源：origin: stackoverflow.com

  1. //Get helper
  2. DatabaseHelper helper = OpenHelperManager.getHelper(App.getContext(), DatabaseHelper.class);
  4. //get dao
  5. Dao dao = helper.getDao(YOUR_CLASS.class);
  7. //delete elements from table in field by arg
  8. DeleteBuilder<CanteenLog, Integer> deleteBuilder = dao.deleteBuilder();
  9. deleteBuilder.where().eq("FIELD_NAME", arg);
  10. deleteBuilder.delete();

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

  1. private void updateWeather(Weather weather) throws SQLException {
  3.     weatherDaoOperation.update(weather);
  4.     apiDaoOperation.update(weather.getAirQualityLive());
  6.     //先删除旧数据
  7.     DeleteBuilder<WeatherForecast, Long> forecastDeleteBuilder = forecastDaoOperation.deleteBuilder();
  8.     forecastDeleteBuilder.where().eq(WeatherForecast.CITY_ID_FIELD_NAME, weather.getCityId());
  9.     PreparedDelete<WeatherForecast> forecastPrepared = forecastDeleteBuilder.prepare();
  10.     forecastDaoOperation.delete(forecastPrepared);
  11.     //再插入新数据
  12.     for (WeatherForecast weatherForecast : weather.getWeatherForecasts()) {
  13.       forecastDaoOperation.create(weatherForecast);
  14.     }
  16.     //先删除旧数据
  17.     DeleteBuilder<LifeIndex, Long> lifeIndexDeleteBuilder = lifeIndexesDaoOperation.deleteBuilder();
  18.     lifeIndexDeleteBuilder.where().eq(LifeIndex.CITY_ID_FIELD_NAME, weather.getCityId());
  19.     PreparedDelete<LifeIndex> lifeIndexPrepared = lifeIndexDeleteBuilder.prepare();
  20.     lifeIndexesDaoOperation.delete(lifeIndexPrepared);
  21.     //再插入新数据
  22.     for (LifeIndex index : weather.getLifeIndexes()) {
  23.       lifeIndexesDaoOperation.create(index);
  24.     }
  25.     realTimeDaoOperation.update(weather.getWeatherLive());
  26.   }
  27. }

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

  1. public void remove(final String userName) {
  2.   try {
  3.     DeleteBuilder<AuthorizedUser, Object> db = dao.deleteBuilder();
  4.     db.where().eq("name", new SelectArg(userName));
  5.     db.delete();
  6.   } catch (SQLException ex) {
  7.     Logger.getLogger(AuthorizedUserRepository.class).error("Error removing a user from DB - ", ex);
  8.   }
  9. }

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

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

代码示例来源：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. }

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

  1. @Override
  2. public void deleteBySensorVariableRefId(int sensorValueRefId) {
  3.   try {
  4.     DeleteBuilder<MetricsCounterTypeDevice, Object> deleteBuilder = this.getDao().deleteBuilder();
  5.     deleteBuilder.where().eq(MetricsCounterTypeDevice.KEY_SENSOR_VARIABLE_ID, sensorValueRefId);
  6.     int count = deleteBuilder.delete();
  7.     _logger.debug("Metric-sensorValueRefId:[{}] deleted, Delete count:{}", sensorValueRefId, count);
  8.   } catch (SQLException ex) {
  9.     _logger.error("unable to delete metric-sensorValueRefId:[{}]", sensorValueRefId, ex);
  10.   }
  11. }

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

  1. public void delete(String key, Object value) {
  2.   try {
  3.     DeleteBuilder<Tdao, Tid> deleteBuilder = this.getDao().deleteBuilder();
  4.     deleteBuilder.where().eq(key, value);
  5.     int deleteCount = deleteBuilder.delete();
  6.     _logger.debug("Deleted count:{}, for key:{}, value:{}", deleteCount, key, value);
  7.   } catch (SQLException ex) {
  8.     _logger.error("unable to delete item, key:{}, value:{}", key, value, ex);
  9.   }
  10. }

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

  1. @Override
  2. public void deleteBySensorVariableRefId(int sensorValueRefId) {
  3.   try {
  4.     DeleteBuilder<MetricsDoubleTypeDevice, Object> deleteBuilder = this.getDao().deleteBuilder();
  5.     deleteBuilder.where().eq(MetricsDoubleTypeDevice.KEY_SENSOR_VARIABLE_ID, sensorValueRefId);
  6.     int count = deleteBuilder.delete();
  7.     _logger.debug("Metric-sensorValueRefId:[{}] deleted, Delete count:{}", sensorValueRefId, count);
  8.   } catch (SQLException ex) {
  9.     _logger.error("unable to delete metric-sensorValueRefId:[{}]", sensorValueRefId, ex);
  10.   }
  11. }

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

  1. @Override
  2. public void deleteByNodeId(int nodeId) {
  3.   try {
  4.     DeleteBuilder<MetricsBatteryUsage, Object> deleteBuilder = this.getDao().deleteBuilder();
  5.     deleteBuilder.where().eq(MetricsBatteryUsage.KEY_NODE_ID, nodeId);
  6.     int count = deleteBuilder.delete();
  7.     _logger.debug("Metric-nodeId:[{}] deleted, Delete count:{}", nodeId, count);
  8.   } catch (SQLException ex) {
  9.     _logger.error("unable to delete metric-nodeId:[{}]", nodeId, ex);
  10.     throw new McDatabaseException(ex);
  11.   }
  12. }

代码示例来源：origin: PaNaVTEC/Clean-Contacts

  1. private void internalDeleteContacts(List<String> deleteMd5s) throws SQLException {
  2.   DeleteBuilder<BddContact, Integer> deleteBuilder = daoContacts.deleteBuilder();
  3.   deleteBuilder.where().in(BddContact.FIELD_MD5, deleteMd5s);
  4.   deleteBuilder.delete();
  5.  }
  6. }

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

  1. public void delete(String key, Object value) {
  2.   try {
  3.     DeleteBuilder<Tdao, Tid> deleteBuilder = this.getDao().deleteBuilder();
  4.     deleteBuilder.where().eq(key, value);
  5.     int deleteCount = deleteBuilder.delete();
  6.     _logger.debug("Deleted count:{}, for key:{}, value:{}", deleteCount, key, value);
  7.   } catch (SQLException ex) {
  8.     _logger.error("unable to delete item, key:{}, value:{}", key, value, ex);
  9.     throw new McDatabaseException(ex);
  10.   }
  11. }

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

  1. public void delete(String key, List<?> values) {
  2.   try {
  3.     DeleteBuilder<Tdao, Tid> deleteBuilder = this.getDao().deleteBuilder();
  4.     deleteBuilder.where().in(key, values);
  5.     int deleteCount = deleteBuilder.delete();
  6.     _logger.debug("Deleted count:{}, for key:{}, values:{}", deleteCount, key, values);
  7.   } catch (SQLException ex) {
  8.     _logger.error("unable to delete item, key:{}, values:{}", key, values, ex);
  9.     throw new McDatabaseException(ex);
  10.   }
  11. }

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

  1. @Override
  2. public void deleteBySensorVariableRefId(int sensorValueRefId) {
  3.   try {
  4.     DeleteBuilder<MetricsGPSTypeDevice, Object> deleteBuilder = this.getDao().deleteBuilder();
  5.     deleteBuilder.where().eq(MetricsGPSTypeDevice.KEY_SENSOR_VARIABLE_ID, sensorValueRefId);
  6.     int count = deleteBuilder.delete();
  7.     _logger.debug("Metric-sensorValueRefId:[{}] deleted, Delete count:{}", sensorValueRefId, count);
  8.   } catch (SQLException ex) {
  9.     _logger.error("unable to delete metric-sensorValueRefId:[{}]", sensorValueRefId, ex);
  10.     throw new McDatabaseException(ex);
  11.   }
  12. }

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

  1. @Override
  2. public void delete(Integer typeId, Integer versionId) {
  3.   DeleteBuilder<Firmware, Integer> deleteBuilder = getDao().deleteBuilder();
  4.   try {
  5.     deleteBuilder.where().eq(Firmware.KEY_TYPE_ID, typeId).and().eq(Firmware.KEY_VERSION_ID, versionId);
  6.     int count = deleteBuilder.delete();
  7.     _logger.error("Deleted Firmware(s) count:[{}]", count);
  8.   } catch (SQLException ex) {
  9.     _logger.error("unable to delete Firmware:[typeId:{},versionId:{}]", typeId, versionId, ex);
  10.   }
  11. }

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

  1. @Override
  2. public void deleteAll(RESOURCE_TYPE resourceType, Integer resourceId) {
  3.   try {
  4.     DeleteBuilder<ResourcesLogs, Integer> deleteBuilder = this.getDao().deleteBuilder();
  5.     this.updateWhereQuery(deleteBuilder.where(), resourceType, resourceId);
  6.     int deleteCount = deleteBuilder.delete();
  7.     _logger.debug("Deleted Resource:[Type:{}, KEY_ID:{}], delete count:{}", resourceType.getText(),
  8.         resourceId,
  9.         deleteCount);
  10.   } catch (SQLException ex) {
  11.     _logger.error("unable to delete Resource:[Type:{}, KEY_ID:{}]", resourceType.getText(), resourceId, ex);
  12.   }
  13. }

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

  1. @Override
  2. public void delete(Integer typeId, Integer versionId) {
  3.   DeleteBuilder<Firmware, Integer> deleteBuilder = getDao().deleteBuilder();
  4.   try {
  5.     deleteBuilder.where().eq(Firmware.KEY_TYPE_ID, typeId).and().eq(Firmware.KEY_VERSION_ID, versionId);
  6.     int count = deleteBuilder.delete();
  7.     _logger.error("Deleted Firmware(s) count:[{}]", count);
  8.   } catch (SQLException ex) {
  9.     _logger.error("unable to delete Firmware:[typeId:{},versionId:{}]", typeId, versionId, ex);
  10.     throw new McDatabaseException(ex);
  11.   }
  12. }

代码示例来源：origin: QuickBlox/q-municate-android

  1. public void deleteByUserId(int userId) {
  2.   try {
  3.     DeleteBuilder<UserRequest, Long> deleteBuilder = dao.deleteBuilder();
  4.     deleteBuilder.where().eq(QMUserColumns.ID, userId);
  5.     if (deleteBuilder.delete() > 0) {
  6.       //TODO VT need to think how to send ID to observers
  7.       notifyObserversDeletedById(userId);
  8.     }
  9.   } catch (SQLException e) {
  10.     ErrorUtils.logError(e);
  11.   }
  12. }

代码示例来源：origin: QuickBlox/q-municate-android

  1. public void deleteById(String dialogId) {
  2.   try {
  3.     DeleteBuilder<Dialog, Long> deleteBuilder = dao.deleteBuilder();
  4.     deleteBuilder.where().eq(Dialog.Column.ID, dialogId);
  5.     if (deleteBuilder.delete() > 0){
  6.       //TODO VT need to think how to send ID to observers
  7.       notifyObserversDeletedById(dialogId);
  8.     }
  9.   } catch (SQLException e) {
  10.     ErrorUtils.logError(e);
  11.   }
  12. }

代码示例来源：origin: QuickBlox/q-municate-android

  1. @Override
  2. public void deleteUserByExternalId(String externalId) {
  3.   try {
  4.     DeleteBuilder<QMUser, Long> deleteBuilder = dao.deleteBuilder();
  5.     deleteBuilder.where().eq(EXTERNAL_ID,externalId);
  6.     PreparedDelete<QMUser> preparedQuery = deleteBuilder.prepare();
  7.     dao.delete(preparedQuery);
  8.     notifyObservers(OBSERVE_KEY);
  9.   } catch (SQLException e) {
  10.     ErrorUtils.logError(e);
  11.   }
  12. }

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

  1. @Test(expected = SQLException.class)
  2. public void testDeletePreparedThrow() 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.delete(dao.deleteBuilder().prepare());
  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