1.批量删除正常写法,此方式在海量数据删除时可能有效率问题
private static final String DELETE_USER_NAME= "DELETE FROM User x WHERE x.name in (:usernames) and x.id = userId"; @Override public boolean deleteUserName(List<String> users, Integer userID) { if (username!= null && !username.isEmpty()) { Number result = em.createQuery(DELETE_USER_NAME) .setParameter("usernames",users) .setParameter("id", userID) .executeUpdate(); return ((result.intValue() == 1) ? true : false); } else return false; }
参考:https://forum.hibernate.org/viewtopic.php?f=1&t=1044044
原文:https://www.cnblogs.com/yln20170705/p/10592482.html