中间表更新：先删除后添加。

事物注解：
@Transactional(rollbackFor = Exception.class)
代码：

 @Override
    public BhResponse addOrUpdateUserManageDept(HttpServletRequest request,
        AddOrUpdateUserManageDeptRequestDto addOrUpdateUserManageDeptRequestDto) {
        BhResponse bhResponse = new BhResponse();

        userManageDeptMapper.delete(new QueryWrapper<UserManageDept>()
            .eq(UserManageDept.COL_WORK_NO, addOrUpdateUserManageDeptRequestDto.getWorkNo()));
        int insertCount = 0;
        for (String deptCode : addOrUpdateUserManageDeptRequestDto.getDeptCodes()) {
            UserManageDept userManageDept = new UserManageDept();
            userManageDept.setWorkNo(addOrUpdateUserManageDeptRequestDto.getWorkNo());
            userManageDept.setDeptCode(deptCode);

            int insertSingleCount = userManageDeptMapper.insert(userManageDept);
            insertCount = insertCount + insertSingleCount;
        }

        //新增失败
        if (insertCount != addOrUpdateUserManageDeptRequestDto.getDeptCodes().size()) {

            //手动回滚
            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();

            return BhResponseUtil.getInsertFailBhResponse(bhResponse);
        }

        return bhResponse;
    }