hibernate删除hql

来源:互联网 发布:java 打包maven工程 编辑:程序博客网 时间:2024/06/06 00:40
@Overridepublic void deleteUserRole(Long userId, Long roleId) {String sql = "DELETE FROM UserRole WHERE userId=:userId AND roleId=:roleId";getCurrentSession().createSQLQuery(sql).setLong("userId", userId).setLong("roleId", roleId).executeUpdate();}


以上sql 写法




hql 写法 如下


@Overridepublic Integer delete(List<Long> idList) {String hql = "delete from " + clazz.getName() + " where id in (:idList)";return getCurrentSession().createQuery(hql).setParameterList("idList", idList).executeUpdate();}




0 0