@Override
public 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 写法 如下
@Override
public Integer delete(List<Long> idList) {
String hql = "delete from " + clazz.getName() + " where id in (:idList)";
return getCurrentSession().createQuery(hql).setParameterList("idList", idList).executeUpdate();
}