Spring JPA學習之delete方法示例詳解
一、deleteById 和 delete
為什么要把這兩個方法放在一起呢?我們先看源碼再說
deleteById(Id id)(通過id進行刪除)
@Transactional
@Override
public void deleteById(ID id) {
Assert.notNull(id, ID_MUST_NOT_BE_NULL);
delete(findById(id).orElseThrow(() -> new EmptyResultDataAccessException(
String.format("No %s entity with id %s exists!", entityInformation.getJavaType(), id), 1)));
}
delete(T entity)(通過實體對象進行刪除)
@Override
@Transactional
@SuppressWarnings("unchecked")
public void delete(T entity) {
Assert.notNull(entity, "Entity must not be null!");
if (entityInformation.isNew(entity)) {
return;
}
Class<?> type = ProxyUtils.getUserClass(entity);
T existing = (T) em.find(type, entityInformation.getId(entity));
// if the entity to be deleted doesn't exist, delete is a NOOP
if (existing == null) {
return;
}
em.remove(em.contains(entity) ? entity : em.merge(entity));
}
一目了然了吧!deleteById 先在方法體內(nèi)通過 id 求出 entity 對象,然后調(diào)用了 delete 的方法。也就是說,這兩個方法同根同源,使用起來差距不大,結(jié)果呢?也是一樣的,就是單條刪除。實際使用中呢,也是使用 deleteById 的情況比較多,廢話少說,try it。
實例
service 層
添加deleteById方法(deleteById 是 JPA 自帶接口不需要在dao層中添加)
@Transactional
public void deleteById(Integer id){
userDao.deleteById(id);
}
control層
/**
* 通過id進行刪除數(shù)據(jù)
* @param id
*/
@GetMapping("/deleteById")
public void deleteById(Integer id){
userService.deleteById(id);
}
執(zhí)行請求 /deleteById?id=2,控制臺打印如下:
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=? Hibernate: delete from user where id=?
結(jié)論
先通過 select 查詢實體對象是否存在,然后再通過 id 進行刪除。
二、deleteAllById 和 deleteAll
1、deleteAllById(Iterable<? extends ID> ids)(通過id進行批量刪除)
@Override
@Transactional
public void deleteAllById(Iterable<? extends ID> ids) {
Assert.notNull(ids, "Ids must not be null!");
for (ID id : ids) {
deleteById(id);
}
}
結(jié)論
通過源碼可以看出,就是遍歷 ids 然后循環(huán)調(diào)用上面的 deleteById(Id id) 方法。
2、deleteAll(Iterable<? extends T> entities)(通過實體對象進行批量刪除)
@Override
@Transactional
public void deleteAll(Iterable<? extends T> entities) {
Assert.notNull(entities, "Entities must not be null!");
for (T entity : entities) {
delete(entity);
}
}
結(jié)論
這個呢?也就是遍歷 entities 然后循環(huán)調(diào)用上面的 delete(T entity) 方法
還有一個不傳參數(shù)的deleteAll()方法來刪除所有數(shù)據(jù)(慎用)
@Override
@Transactional
public void deleteAll() {
for (T element : findAll()) {
delete(element);
}
}
就是通過findAll求出所有實體對象然后循環(huán)調(diào)用delete方法
綜上所述,我們發(fā)現(xiàn)以上所有的刪除事件都是調(diào)用了delete(T entity)方法,也就是差距不是很大,就是單條 和多條刪除的區(qū)別。
實例
service 層
添加 deleteAllById 方法(deleteAllById 是三方件自帶接口不需要在dao層中添加)
@Transactional
public void deleteAllById(Iterable ids){
userDao.deleteAllById(ids);
}
control層
/**
* 通過id進行批量刪除
* @param ids
*/
@GetMapping("/deleteAllById")
public void deleteAllById(Integer[] ids){
userService.deleteAllById(Arrays.asList(ids));
}
瀏覽器測試成功 /deleteAllById?id=3,4刪除前:
刪除后:
控制臺打印如下:
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
Hibernate: delete from user where id=?
Hibernate: delete from user where id=?
由此可以看出,數(shù)據(jù)是一條一條的進行了刪除。
三、deleteAllInBatch 和 deleteAllByIdInBatch
1、deleteAllInBatch(Iterable<T> entities)(通過實體對象進行批量刪除)
public static final String DELETE_ALL_QUERY_STRING = "delete from %s x";
@Override
@Transactional
public void deleteAllInBatch(Iterable<T> entities) {
Assert.notNull(entities, "Entities must not be null!");
if (!entities.iterator().hasNext()) {
return;
}
applyAndBind(getQueryString(DELETE_ALL_QUERY_STRING, entityInformation.getEntityName()), entities, em)
.executeUpdate();
}
/**
* Creates a where-clause referencing the given entities and appends it to the given query string. Binds the given
* entities to the query.
*
* @param <T> type of the entities.
* @param queryString must not be {@literal null}.
* @param entities must not be {@literal null}.
* @param entityManager must not be {@literal null}.
* @return Guaranteed to be not {@literal null}.
*/
public static <T> Query applyAndBind(String queryString, Iterable<T> entities, EntityManager entityManager) {
Assert.notNull(queryString, "Querystring must not be null!");
Assert.notNull(entities, "Iterable of entities must not be null!");
Assert.notNull(entityManager, "EntityManager must not be null!");
Iterator<T> iterator = entities.iterator();
if (!iterator.hasNext()) {
return entityManager.createQuery(queryString);
}
String alias = detectAlias(queryString);
StringBuilder builder = new StringBuilder(queryString);
builder.append(" where");
int i = 0;
while (iterator.hasNext()) {
iterator.next();
builder.append(String.format(" %s = ?%d", alias, ++i));
if (iterator.hasNext()) {
builder.append(" or");
}
}
Query query = entityManager.createQuery(builder.toString());
iterator = entities.iterator();
i = 0;
while (iterator.hasNext()) {
query.setParameter(++i, iterator.next());
}
return query;
}
通過上面的源碼,我們大體能猜測出deleteAllInBatch(Iterable<T> entities)的實現(xiàn)原理:delete from %s where x=? or x=?實際測試一下:http://localhost:7777/deleteAllInBatch?ids=14,15,16&names=a,b,c&ages=0,0,0控制臺打印如下:
Hibernate: delete from user where id=? or id=? or id=?
2、deleteAllByIdInBatch(Iterable<ID> ids)源碼(通過ids批量刪除)
public static final String DELETE_ALL_QUERY_BY_ID_STRING = "delete from %s x where %s in :ids";
@Override
@Transactional
public void deleteAllByIdInBatch(Iterable<ID> ids) {
Assert.notNull(ids, "Ids must not be null!");
if (!ids.iterator().hasNext()) {
return;
}
if (entityInformation.hasCompositeId()) {
List<T> entities = new ArrayList<>();
// generate entity (proxies) without accessing the database.
ids.forEach(id -> entities.add(getReferenceById(id)));
deleteAllInBatch(entities);
} else {
String queryString = String.format(DELETE_ALL_QUERY_BY_ID_STRING, entityInformation.getEntityName(),
entityInformation.getIdAttribute().getName());
Query query = em.createQuery(queryString);
/**
* Some JPA providers require {@code ids} to be a {@link Collection} so we must convert if it's not already.
*/
if (Collection.class.isInstance(ids)) {
query.setParameter("ids", ids);
} else {
Collection<ID> idsCollection = StreamSupport.stream(ids.spliterator(), false)
.collect(Collectors.toCollection(ArrayList::new));
query.setParameter("ids", idsCollection);
}
query.executeUpdate();
}
}
通過上面源碼我們大體可以猜出deleteAllByIdInBatch(Iterable ids)的實現(xiàn)原理:delete from %s where id in (?,?,?)實際測試一下:http://localhost:7777/deleteAllByIdInBatch?ids=17,18,19 控制臺打印如下:
Hibernate: delete from user where id in (? , ? , ?)
這里同樣有個不帶參數(shù)的deleteAllInBatch()的方法,源碼如下:
@Override
@Transactional
public void deleteAllInBatch() {
em.createQuery(getDeleteAllQueryString()).executeUpdate();
}
public static final String DELETE_ALL_QUERY_STRING = "delete from %s x";
private String getDeleteAllQueryString() {
return getQueryString(DELETE_ALL_QUERY_STRING, entityInformation.getEntityName());
}
通過源碼不難猜到實現(xiàn)原理吧,多的不說,直接給測試的控制臺數(shù)據(jù):Hibernate: delete from user
結(jié)論:
從上面兩種刪除接口來看,第二種實現(xiàn)比起第一種更加的快捷;
第一種就是一條一條的進行刪除操作,如果有萬級的數(shù)據(jù),執(zhí)行起來肯定非常耗時,所以如果數(shù)據(jù)量比較大的話,還是建議大家使用第二種。
以上就是Spring JPA學習之delete方法示例詳解的詳細內(nèi)容,更多關于Spring JPA delete方法的資料請關注腳本之家其它相關文章!
相關文章
Spring?boot?運用策略模式實現(xiàn)避免多次使用if
這篇文章主要介紹了Spring?boot?運用策略模式實現(xiàn)避免多次使用if,文章圍繞主題展開詳細的內(nèi)容介紹,具有一定的參考價值,需要的小伙伴可以參考一下2022-09-09
SpringBoot環(huán)境搭建及第一個程序運行(小白教程)
這篇文章主要介紹了SpringBoot環(huán)境搭建及第一個程序運行,文中通過示例代碼介紹的非常詳細,對大家的學習或者工作具有一定的參考學習價值,需要的朋友們下面隨著小編來一起學習學習吧2020-06-06
mybatis學習之路mysql批量新增數(shù)據(jù)的方法
這篇文章主要介紹了mybatis學習之路mysql批量新增數(shù)據(jù)的方法,文中通過示例代碼介紹的非常詳細,對大家的學習或者工作具有一定的參考學習價值,需要的朋友們下面隨著小編來一起學習學習吧2019-02-02
Java中l(wèi)ogback?自動刷新不生效的問題解決
本文主要介紹了Java中l(wèi)ogback?自動刷新不生效的問題解決,文中通過示例代碼介紹的非常詳細,對大家的學習或者工作具有一定的參考學習價值,需要的朋友們下面隨著小編來一起學習學習吧2023-05-05

