CRM项目后端解决全局异常处理和权限不足Handler冲突的问题并为所有操作设置权限------CRM项目

已于 2024-03-17 12:25:20 修改
阅读量1k 收藏 18
点赞数 26
分类专栏： CRM项目 # Spring-Boot框架 # Mybatis框架 文章标签： java spring boot spring mybatis mysql 后端 架构
于 2024-03-05 18:04:16 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2201_75960169/article/details/136481080
版权 
package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TUser;
import com.alatus.query.UserQuery;
import com.alatus.result.Result;
import com.alatus.service.UserService;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.security.core.Authentication;
import org.springframework.web.bind.annotation.*;
import java.util.Arrays;
import java.util.List;

@RestController
public class UserController {
    @Resource
    private UserService userService;

//    获取登录信息
    @GetMapping(value = "/api/login/info")
    public Result loginInfo(Authentication authentication){
        TUser tUser = (TUser) authentication.getPrincipal();
        return Result.OK(tUser);
    }


    //免登录验证
    //因为发送的请求过来首先会过filter那一关,能到这说明token验证都通过了,我们直接返回200即可
    @GetMapping(value = "/api/login/free")
    public Result freeLogin(){
        return Result.OK();
    }
//    查询用户列表,用户分页查询

    @PreAuthorize(value = "hasAuthority('user:list')")
    @GetMapping(value = "/api/users")
//    传递参数current,可传可不传,
    public Result userPage(@RequestParam(value = Constants.CURRENT,required = false) Integer current){
        if(current == null){
            current = 1;
        }
//        返回结果为PageInfo
        PageInfo<TUser> userByPage = userService.getUserByPage(current);
        return Result.OK(userByPage);
    }

    @PreAuthorize(value = "hasAuthority('user:view')")
    @GetMapping(value = "/api/user/{id}")
    public Result userDetail(@PathVariable(value = Constants.ID)Integer id){
        TUser tUser = userService.getUserById(id);
        return Result.OK(tUser);
    }


//    添加用户
    @PreAuthorize(value = "hasAuthority('user:add')")
    @PostMapping(value = "/api/user/add")
    public Result addUser(UserQuery userQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        userQuery.setToken(token);
        int result = userService.saveUser(userQuery);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }


//    编辑用户
    @PreAuthorize(value = "hasAuthority('user:edit')")
    @PutMapping(value = "/api/user/edit")
    public Result editUser(UserQuery userQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        userQuery.setToken(token);
        int result = userService.updateUser(userQuery);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('user:delete')")
    @DeleteMapping(value = "/api/user/del/{id}")
    public Result delUser(@PathVariable(value = Constants.ID) Integer id, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        int result = userService.delUserById(id);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('user:delete')")
    @DeleteMapping(value = "/api/user/batchDel")
    public Result batchDelUsers(@RequestParam(value = Constants.IDS) String ids, @RequestHeader(value = Constants.TOKEN_NAME)String token){
//        将我们的字符串拆分并放到list中作为元素
        List<String> idList = Arrays.asList(ids.split(","));
        int result = userService.delUsersByIds(idList);
        return result >= idList.size() ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:view')")
    @GetMapping(value = "/api/user/activityOwner")
    public Result loadActivityOwner(){
        return Result.OK(userService.getOwnerList());
    }
}
package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TUser;
import com.alatus.query.UserQuery;
import com.alatus.result.Result;
import com.alatus.service.UserService;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.security.core.Authentication;
import org.springframework.web.bind.annotation.*;
import java.util.Arrays;
import java.util.List;

@RestController
public class UserController {
    @Resource
    private UserService userService;

//    获取登录信息
    @GetMapping(value = "/api/login/info")
    public Result loginInfo(Authentication authentication){
        TUser tUser = (TUser) authentication.getPrincipal();
        return Result.OK(tUser);
    }


    //免登录验证
    //因为发送的请求过来首先会过filter那一关,能到这说明token验证都通过了,我们直接返回200即可
    @GetMapping(value = "/api/login/free")
    public Result freeLogin(){
        return Result.OK();
    }
//    查询用户列表,用户分页查询

    @PreAuthorize(value = "hasAuthority('user:list')")
    @GetMapping(value = "/api/users")
//    传递参数current,可传可不传,
    public Result userPage(@RequestParam(value = Constants.CURRENT,required = false) Integer current){
        if(current == null){
            current = 1;
        }
//        返回结果为PageInfo
        PageInfo<TUser> userByPage = userService.getUserByPage(current);
        return Result.OK(userByPage);
    }

    @PreAuthorize(value = "hasAuthority('user:view')")
    @GetMapping(value = "/api/user/{id}")
    public Result userDetail(@PathVariable(value = Constants.ID)Integer id){
        TUser tUser = userService.getUserById(id);
        return Result.OK(tUser);
    }


//    添加用户
    @PreAuthorize(value = "hasAuthority('user:add')")
    @PostMapping(value = "/api/user/add")
    public Result addUser(UserQuery userQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        userQuery.setToken(token);
        int result = userService.saveUser(userQuery);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }


//    编辑用户
    @PreAuthorize(value = "hasAuthority('user:edit')")
    @PutMapping(value = "/api/user/edit")
    public Result editUser(UserQuery userQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        userQuery.setToken(token);
        int result = userService.updateUser(userQuery);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('user:delete')")
    @DeleteMapping(value = "/api/user/del/{id}")
    public Result delUser(@PathVariable(value = Constants.ID) Integer id, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        int result = userService.delUserById(id);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('user:delete')")
    @DeleteMapping(value = "/api/user/batchDel")
    public Result batchDelUsers(@RequestParam(value = Constants.IDS) String ids, @RequestHeader(value = Constants.TOKEN_NAME)String token){
//        将我们的字符串拆分并放到list中作为元素
        List<String> idList = Arrays.asList(ids.split(","));
        int result = userService.delUsersByIds(idList);
        return result >= idList.size() ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:view')")
    @GetMapping(value = "/api/user/activityOwner")
    public Result loadActivityOwner(){
        return Result.OK(userService.getOwnerList());
    }
}
package com.alatus.config.handler;

import com.alatus.result.CodeEnum;
import com.alatus.result.Result;
import org.springframework.dao.DataAccessException;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.RestControllerAdvice;

/**
 * 全局异常处理
 */
//拦截标注了@RestController的所有controller的方法
@RestControllerAdvice
public class GlobalExceptionHandler {

    @ExceptionHandler(value = Exception.class)
    public Result handlerException(Exception e) {
        //打出异常信息
        e.printStackTrace();
//    权限不足的异常
        if(e.getMessage().equals("Access Denied")){
            return Result.FAIL(CodeEnum.ACCESS_DENIED);
        }
        else{
            return Result.FAIL(e.getMessage());
        }
    }

//    数据库的异常
    @ExceptionHandler(value = DataAccessException.class)
    public Result handlerSQLException(DataAccessException e) {
        e.printStackTrace();
        return Result.FAIL(CodeEnum.DATA_ACCESS_EXCEPTION);
    }
}

package com.alatus.config.handler;

import com.alatus.result.CodeEnum;
import com.alatus.result.Result;
import org.springframework.dao.DataAccessException;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.RestControllerAdvice;

/**
 * 全局异常处理
 */
//拦截标注了@RestController的所有controller的方法
@RestControllerAdvice
public class GlobalExceptionHandler {

    @ExceptionHandler(value = Exception.class)
    public Result handlerException(Exception e) {
        //打出异常信息
        e.printStackTrace();
//    权限不足的异常
        if(e.getMessage().equals("Access Denied")){
            return Result.FAIL(CodeEnum.ACCESS_DENIED);
        }
        else{
            return Result.FAIL(e.getMessage());
        }
    }

//    数据库的异常
    @ExceptionHandler(value = DataAccessException.class)
    public Result handlerSQLException(DataAccessException e) {
        e.printStackTrace();
        return Result.FAIL(CodeEnum.DATA_ACCESS_EXCEPTION);
    }
}

package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TClue;
import com.alatus.query.ClueQuery;
import com.alatus.result.Result;
import com.alatus.service.ClueService;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.util.Arrays;
import java.util.List;

@RestController
public class ClueController {
    @Resource
    private ClueService clueService;

    @PreAuthorize(value = "hasAuthority('clue:list')")
    @GetMapping(value = "/api/clues")
    public Result cluePage(@RequestParam(value = Constants.CURRENT,required = false)Integer current){
        if(current == null){
            current = 1;
        }
        PageInfo<TClue> pageInfo = clueService.getClueByPage(current);
        return Result.OK(pageInfo);
    }

    @PreAuthorize(value = "hasAuthority('clue:import')")
    @PostMapping(value = "/api/clue/importExcel")
    public Result importExcel(MultipartFile file, @RequestHeader(value = Constants.TOKEN_NAME)String token) throws IOException {
//        接收到的文件名字需要和前端提交的名字相同,否则无法接收
        clueService.importExcel(file.getInputStream(),token);
        return Result.OK();
    }

    @PreAuthorize(value = "hasAuthority('clue:delete')")
    @DeleteMapping(value = "/api/clue/delete/{id}")
    public Result clueDel(@PathVariable(value = Constants.ID)Integer id){
        Integer result = clueService.deleteClue(id);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:delete')")
    @DeleteMapping(value = "/api/clue/batchDel")
    public Result batchDelClue(@RequestParam(value = Constants.IDS)String ids,@RequestHeader(value = Constants.TOKEN_NAME)String token){
        List<String> idsList = Arrays.asList(ids.split(","));
        int result = clueService.delClueByIds(idsList);
        return result >= idsList.size() ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:view')")
    @GetMapping(value = "/api/clue/phone/{phone}")
    public Result checkPhone(@PathVariable(value = Constants.PHONE)String phone){
        Boolean check = clueService.checkPhone(phone);
        return check ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:add')")
    @PostMapping(value = "/api/clue/add")
    public Result addClue(@RequestHeader(value = Constants.TOKEN_NAME)String token, ClueQuery clueQuery){
        clueQuery.setToken(token);
        int save = clueService.saveClue(clueQuery);
        return save >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:view')")
    @GetMapping(value = "/api/clue/{id}")
    public Result getClue(@PathVariable(value = Constants.ID)Integer id){
        TClue tClue = clueService.getClueById(id);
        return Result.OK(tClue);
    }

    @PreAuthorize(value = "hasAuthority('clue:edit')")
    @PutMapping(value = "/api/clue/edit")
    public Result editClue(@RequestHeader(value = Constants.TOKEN_NAME)String token, ClueQuery clueQuery){
        clueQuery.setToken(token);
        int update = clueService.editClue(clueQuery);
        return update >= 1 ? Result.OK() : Result.FAIL();
    }
}

package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TClue;
import com.alatus.query.ClueQuery;
import com.alatus.result.Result;
import com.alatus.service.ClueService;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.util.Arrays;
import java.util.List;

@RestController
public class ClueController {
    @Resource
    private ClueService clueService;

    @PreAuthorize(value = "hasAuthority('clue:list')")
    @GetMapping(value = "/api/clues")
    public Result cluePage(@RequestParam(value = Constants.CURRENT,required = false)Integer current){
        if(current == null){
            current = 1;
        }
        PageInfo<TClue> pageInfo = clueService.getClueByPage(current);
        return Result.OK(pageInfo);
    }

    @PreAuthorize(value = "hasAuthority('clue:import')")
    @PostMapping(value = "/api/clue/importExcel")
    public Result importExcel(MultipartFile file, @RequestHeader(value = Constants.TOKEN_NAME)String token) throws IOException {
//        接收到的文件名字需要和前端提交的名字相同,否则无法接收
        clueService.importExcel(file.getInputStream(),token);
        return Result.OK();
    }

    @PreAuthorize(value = "hasAuthority('clue:delete')")
    @DeleteMapping(value = "/api/clue/delete/{id}")
    public Result clueDel(@PathVariable(value = Constants.ID)Integer id){
        Integer result = clueService.deleteClue(id);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:delete')")
    @DeleteMapping(value = "/api/clue/batchDel")
    public Result batchDelClue(@RequestParam(value = Constants.IDS)String ids,@RequestHeader(value = Constants.TOKEN_NAME)String token){
        List<String> idsList = Arrays.asList(ids.split(","));
        int result = clueService.delClueByIds(idsList);
        return result >= idsList.size() ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:view')")
    @GetMapping(value = "/api/clue/phone/{phone}")
    public Result checkPhone(@PathVariable(value = Constants.PHONE)String phone){
        Boolean check = clueService.checkPhone(phone);
        return check ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:add')")
    @PostMapping(value = "/api/clue/add")
    public Result addClue(@RequestHeader(value = Constants.TOKEN_NAME)String token, ClueQuery clueQuery){
        clueQuery.setToken(token);
        int save = clueService.saveClue(clueQuery);
        return save >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('clue:view')")
    @GetMapping(value = "/api/clue/{id}")
    public Result getClue(@PathVariable(value = Constants.ID)Integer id){
        TClue tClue = clueService.getClueById(id);
        return Result.OK(tClue);
    }

    @PreAuthorize(value = "hasAuthority('clue:edit')")
    @PutMapping(value = "/api/clue/edit")
    public Result editClue(@RequestHeader(value = Constants.TOKEN_NAME)String token, ClueQuery clueQuery){
        clueQuery.setToken(token);
        int update = clueService.editClue(clueQuery);
        return update >= 1 ? Result.OK() : Result.FAIL();
    }
}


package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TActivity;
import com.alatus.query.ActivityQuery;
import com.alatus.result.Result;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
import com.alatus.service.ActivityService;

import java.util.Arrays;
import java.util.List;

@RestController
public class ActivityController {
    @Resource
    private ActivityService activityService;

    @PreAuthorize(value = "hasAuthority('activity:list')")
    @GetMapping(value = "/api/activities")
    public Result activityPage(@RequestParam(value = Constants.CURRENT,required = false)Integer current,
                               ActivityQuery activityQuery){
        if(current == null){
            current = 1;
        }
//        返回结果为PageInfo
        PageInfo<TActivity> activityByPage = activityService.getActivityByPage(current,activityQuery);
        return Result.OK(activityByPage);
    }

    @PreAuthorize(value = "hasAuthority('activity:add')")
    @PostMapping(value = "/api/activity/add")
    public Result addActivity(ActivityQuery activityQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        activityQuery.setToken(token);
        int result = activityService.saveActivity(activityQuery);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('activity:delete')")
    @DeleteMapping(value = "/api/activity/delete/{id}")
    public Result deleteActivty(@PathVariable(value = Constants.ID)Integer id){
        int result = activityService.deleteActivtyById(id);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('activity:view')")
    @GetMapping(value = "/api/activity/{id}")
    public Result activityDetail(@PathVariable(value = Constants.ID)Integer id){
        TActivity tActivity = activityService.getActivityById(id);
        return Result.OK(tActivity);
    }

    @PreAuthorize(value = "hasAuthority('activity:delete')")
    @DeleteMapping(value = "/api/activity/batchDel")
    public Result activityBatchDel(@RequestParam(value = Constants.IDS)String ids, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        List<String> idList = Arrays.asList(ids.split(","));
        int result = activityService.delActivityByIds(idList);
        return result >= idList.size() ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('activity:edit')")
    @PutMapping(value = "/api/activity/edit")
    public Result editActivity(ActivityQuery activityQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        activityQuery.setToken(token);
        int result = activityService.updateActivity(activityQuery);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }
}

package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TActivity;
import com.alatus.query.ActivityQuery;
import com.alatus.result.Result;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
import com.alatus.service.ActivityService;

import java.util.Arrays;
import java.util.List;

@RestController
public class ActivityController {
    @Resource
    private ActivityService activityService;

    @PreAuthorize(value = "hasAuthority('activity:list')")
    @GetMapping(value = "/api/activities")
    public Result activityPage(@RequestParam(value = Constants.CURRENT,required = false)Integer current,
                               ActivityQuery activityQuery){
        if(current == null){
            current = 1;
        }
//        返回结果为PageInfo
        PageInfo<TActivity> activityByPage = activityService.getActivityByPage(current,activityQuery);
        return Result.OK(activityByPage);
    }

    @PreAuthorize(value = "hasAuthority('activity:add')")
    @PostMapping(value = "/api/activity/add")
    public Result addActivity(ActivityQuery activityQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        activityQuery.setToken(token);
        int result = activityService.saveActivity(activityQuery);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('activity:delete')")
    @DeleteMapping(value = "/api/activity/delete/{id}")
    public Result deleteActivty(@PathVariable(value = Constants.ID)Integer id){
        int result = activityService.deleteActivtyById(id);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('activity:view')")
    @GetMapping(value = "/api/activity/{id}")
    public Result activityDetail(@PathVariable(value = Constants.ID)Integer id){
        TActivity tActivity = activityService.getActivityById(id);
        return Result.OK(tActivity);
    }

    @PreAuthorize(value = "hasAuthority('activity:delete')")
    @DeleteMapping(value = "/api/activity/batchDel")
    public Result activityBatchDel(@RequestParam(value = Constants.IDS)String ids, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        List<String> idList = Arrays.asList(ids.split(","));
        int result = activityService.delActivityByIds(idList);
        return result >= idList.size() ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('activity:edit')")
    @PutMapping(value = "/api/activity/edit")
    public Result editActivity(ActivityQuery activityQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        activityQuery.setToken(token);
        int result = activityService.updateActivity(activityQuery);
        return result >= 1 ? Result.OK() : Result.FAIL();
    }
}

package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TCustomer;
import com.alatus.query.CustomerQuery;
import com.alatus.result.CustomerExcel;
import com.alatus.result.Result;
import com.alatus.service.CustomerService;
import com.alibaba.excel.EasyExcel;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.util.ObjectUtils;
import org.springframework.web.bind.annotation.*;

import java.io.IOException;
import java.net.URLEncoder;
import java.util.Arrays;
import java.util.List;

@RestController
public class CustomerController {
    @Resource
    private CustomerService customerService;

    @PostMapping(value = "/api/clue/customer")
    public Result transferCustomer(@RequestBody CustomerQuery customerQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        customerQuery.setToken(token);
        Boolean convert = customerService.convertCustomer(customerQuery);
        return convert ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('customer:list')")
    @GetMapping(value = "/api/customers")
    public Result CustomersByPages(@RequestParam(value = Constants.CURRENT,required = false)Integer current){
        if(current == null){
            current = 1;
        }
        PageInfo<TCustomer> pageInfo = customerService.getCustomerByPage(current);
        return Result.OK(pageInfo);
    }

    @PreAuthorize(value = "hasAuthority('customer:export')")
    @GetMapping(value = "/api/exportExcel")
    public void exportExcel(@RequestParam(value = Constants.IDS,required = false)String ids, HttpServletResponse response) throws IOException {
        List<String> idList = null;
        if(!ObjectUtils.isEmpty(ids)){
            idList = Arrays.asList(ids.split(","));
        }
        //要想让浏览器弹出下载框，后端要设置一下响应头信息
        response.setContentType("application/octet-stream");
        response.setCharacterEncoding(Constants.UTF_8);
        response.setHeader("X-Frame-Options", "allow-from uri");// 解决IFrame拒绝的问题
        response.setHeader("Content-disposition", "attachment;filename="+ URLEncoder.encode(Constants.CUSTOMER_FILE_NAME,Constants.UTF_8)+System.currentTimeMillis() +".xlsx");
        List<CustomerExcel> dataList = customerService.getCustomerByExcel(idList);
        EasyExcel.write(response.getOutputStream(), CustomerExcel.class)
                .sheet()
                .doWrite(dataList);
    }
}

package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TCustomer;
import com.alatus.query.CustomerQuery;
import com.alatus.result.CustomerExcel;
import com.alatus.result.Result;
import com.alatus.service.CustomerService;
import com.alibaba.excel.EasyExcel;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.util.ObjectUtils;
import org.springframework.web.bind.annotation.*;

import java.io.IOException;
import java.net.URLEncoder;
import java.util.Arrays;
import java.util.List;

@RestController
public class CustomerController {
    @Resource
    private CustomerService customerService;

    @PostMapping(value = "/api/clue/customer")
    public Result transferCustomer(@RequestBody CustomerQuery customerQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        customerQuery.setToken(token);
        Boolean convert = customerService.convertCustomer(customerQuery);
        return convert ? Result.OK() : Result.FAIL();
    }

    @PreAuthorize(value = "hasAuthority('customer:list')")
    @GetMapping(value = "/api/customers")
    public Result CustomersByPages(@RequestParam(value = Constants.CURRENT,required = false)Integer current){
        if(current == null){
            current = 1;
        }
        PageInfo<TCustomer> pageInfo = customerService.getCustomerByPage(current);
        return Result.OK(pageInfo);
    }

    @PreAuthorize(value = "hasAuthority('customer:export')")
    @GetMapping(value = "/api/exportExcel")
    public void exportExcel(@RequestParam(value = Constants.IDS,required = false)String ids, HttpServletResponse response) throws IOException {
        List<String> idList = null;
        if(!ObjectUtils.isEmpty(ids)){
            idList = Arrays.asList(ids.split(","));
        }
        //要想让浏览器弹出下载框，后端要设置一下响应头信息
        response.setContentType("application/octet-stream");
        response.setCharacterEncoding(Constants.UTF_8);
        response.setHeader("X-Frame-Options", "allow-from uri");// 解决IFrame拒绝的问题
        response.setHeader("Content-disposition", "attachment;filename="+ URLEncoder.encode(Constants.CUSTOMER_FILE_NAME,Constants.UTF_8)+System.currentTimeMillis() +".xlsx");
        List<CustomerExcel> dataList = customerService.getCustomerByExcel(idList);
        EasyExcel.write(response.getOutputStream(), CustomerExcel.class)
                .sheet()
                .doWrite(dataList);
    }
}

package com.alatus.config.handler;

import com.alatus.result.CodeEnum;
import com.alatus.result.Result;
import com.alatus.util.JSONUtils;
import com.alatus.util.ResponseUtils;
import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.security.access.AccessDeniedException;
import org.springframework.security.web.access.AccessDeniedHandler;
import org.springframework.stereotype.Component;

import java.io.IOException;

@Component
public class MyAccessDeniedHandler implements AccessDeniedHandler {

    @Override
    public void handle(HttpServletRequest request, HttpServletResponse response, AccessDeniedException accessDeniedException) throws IOException, ServletException {
        //执行到这里，说明登录成功，那我们向前端返回json就行了
        //R result = R.FAIL(accessDeniedException.getLocalizedMessage());
        Result result = Result.FAIL(CodeEnum.ACCESS_DENIED);

        //把R对象转成json
        String resultJSON = JSONUtils.toJSON(result);

        //把json写出去，写到浏览器
        ResponseUtils.write(response, resultJSON);
    }
}

package com.alatus.config.handler;

import com.alatus.result.CodeEnum;
import com.alatus.result.Result;
import com.alatus.util.JSONUtils;
import com.alatus.util.ResponseUtils;
import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.security.access.AccessDeniedException;
import org.springframework.security.web.access.AccessDeniedHandler;
import org.springframework.stereotype.Component;

import java.io.IOException;

@Component
public class MyAccessDeniedHandler implements AccessDeniedHandler {

    @Override
    public void handle(HttpServletRequest request, HttpServletResponse response, AccessDeniedException accessDeniedException) throws IOException, ServletException {
        //执行到这里，说明登录成功，那我们向前端返回json就行了
        //R result = R.FAIL(accessDeniedException.getLocalizedMessage());
        Result result = Result.FAIL(CodeEnum.ACCESS_DENIED);

        //把R对象转成json
        String resultJSON = JSONUtils.toJSON(result);

        //把json写出去，写到浏览器
        ResponseUtils.write(response, resultJSON);
    }
}
旧约Alatus
关注
专栏目录
Spring security 自定义的AccessDeniedHandler无效，抛出AccessDeniedException 不允许访问
m0_37257009的博客
08-16 1137
security异常
引发了未经处理的异常:读取访问权限冲突_操作系统CPU处理器原理
weixin_39754411的博客
11-21 1308
“看书犯困，那是梦开始的地方。”处理器逻辑结构实模式、保护模式处理器主要有两种运行模式，实模式和保护模式处理器在上电或重启后自动进入到实模式，控制寄存器 CR0 中的 PE 标志控制着处理器是在实模式下还是在保护模式下操作系统一启动，就通过修改PE标志，将处理器从实模式切换到保护模式下面的知识都是保护模式下的知识全局和局部描述符表(GDT和LDT)在保护模式下操作时，所有的内存访问要么...
vue框架搭建（移动端-crm7slyun项目）
一生为追梦的博客
08-20 3259
一.开发环境 安装nodejs、webpack，按网上教程即可 二.vue-cli初始化项目 拉取git已建好的项目名，在本地使用vue-cli初始化项目，按网上教程即可 三.css处理方式（scss） 使用scss方式处理css，首先安装scss：执行 npm install node-sass sass-loader --save-dev 在vue的style标签中加入lang="...
前后端分离微服务管理系统项目实战SaaS-HRM项目(一)——系统概述与环境搭建
weixin_44240370的博客
07-17 5084
文章目录
CRM项目使用全局异常捕获实现拦截数据库出现的异常情况并提交回前端------CRM项目
春风若有怜花意，可否许我再少年
02-11 445
CRM项目使用全局异常捕获实现拦截数据库出现的异常情况并提交回前端------CRM项目
你这代码写得真丑，满屏的try-catch，全局异常处理不会吗？
欢迎关注公众号：【码农突围】，公号后台回复9999，可以获取一份500页的LeetCode刷题笔记。
03-25 351
背景 软件开发过程中，不可避免的是需要处理各种异常，就我自己来说，至少有一半以上的时间都是在处理各种异常情况，所以代码中就会出现大量的try {…} catch {…} finally {…} 代码块，不仅有大量的冗余代码，而且还影响代码的可读性。比较下面两张图，看看您现在编写的代码属于哪一种风格？然后哪种编码风格您更喜欢？ 丑陋的 try catch 代码块 优雅的Controller 上面的示例，还只是在Controller层，如果是在Service层，可能会有更多的try catch代码块。这将会
经过半个月的深入发现CRM-SSM项目如此简单
weixin_55292171的博客
08-19 1268
​ ​学习的最大理由是想摆脱平庸，早一天就多一份人生的精彩；迟一天就多一天平庸的困扰。各位小伙伴，如果您： 想系统/深入学习某技术知识点… 一个人摸索学习很难坚持，想组团高效学习… 想写博客但无从下手，急需写作干货注入能量… 热爱写作，愿意让自己成为更好的人…视图层(view)：展示数据，跟用户交互。控制层(Controller)：控制业务处理流程(接收请求,接收参数,封装参数;根据不同的请求调用业务层处理业务;根据处理结果，返回响应信息)业务层(Service)：处理业务逻辑(处理业务的步骤以及操作的原子
尚硅谷-MyBatis3笔记
ctflq的博客
01-08 1194
MyBatis3详细文档，案例完整，可作为工具说时长翻阅
ruoyi-admin和ruoyi-vue3笔记-gl-wms物流管理项目
TY121810的博客
07-24 647
gl-wms物流管理项目。
day03-搭建项目
wuhua_0829的博客
12-25 471
- 了解vue-router使用 - 了解webpack使用 - 会使用vue-cli搭建项目 - 独立搭建后台管理系统 - 了解系统基本结构
实施Microsoft Dynamics 365 CE-7.扩展Dynamics 365 CE，包括为Dynamics 365 CE应用程序编写代码。
Martin-Mei的博客
08-28 214
扩展Dynamics 365 CE，包括为Dynamics 365 CE应用程序编写代码。
九，DRF JWT-RBAC
奔波儿屁的朋友圈
05-04 372
一 JWT认证 在用户注册或登录后，我们想记录用户的登录状态，或者为用户创建身份认证的凭证。我们不再使用Session认证机制，而使用Json Web Token（本质就是token）认证机制。 Json web token (JWT), 是为了在网络应用环境间传递声明而执行的一种基于JSON的开放标准（(RFC 7519).该token被设计为紧凑且安全的，特别适用于分布式站点的单点登录（SSO）场景。JWT的声明一般被用来在身份提供者和服务提供者间传递被认证的用户身份信息，以便于从资源服务器获取资源，也
红队系列-网络安全知识锦囊(持续更新)
aming小老弟
11-09 1251
AJP13是定向包协议。因为性能原因，使用二进制格式来传输可读性文本。AJP协议：WEB服务器通过TCP连接和SERVLET容器连接。为了减少进程生成socket的花费，WEB服务器和SERVLET容器之间尝试保持持久性的TCP连接，对多个请求/回复循环重用一个连接。一旦连接分配给一个特定的请求，在请求处理循环结束之前不会在分配。换句话说，在连接上，请求不是多元的。这个是连接两端的编码变得容易，虽然这导致在一时刻会有很多连接。
GPIO中断- 6U中断向量表编写
我思故我在！
09-24 412
linux系统中，按键一般当作中断使用。本节介绍通过key中断 一上电，第一步就要执行复位中断函数。 IRQ中断服务函数。 按照手册定义，从上到下定义。 ldr pc, =Reset_Handler /* 复位中断服务函数 */， 只要复位，就自动跳到偏移地址为0的地方开始执行。 ldr pc, =Undefined_Handler /* 未定义指令中断函数 */ 。。。 写...
JDK1.0主要特性
FoolRabbit的专栏
10-06 295
JDK1.0主要特性。
JavaScript ArrayBuffer的读写与类型转换
白瑕 的博客
10-01 495
所有视图的基本单位是ArrayBuffer, ArrayBuffer中只存储二进制格式的数据.ArrayBuffer不可直接读写, 必须通过视图(比如DataView)暴露的API.
Puppeteer自动化：使用JavaScript定制PDF下载
最新发布
ip16yun的博客
10-08 499
Puppeteer 是一个强大的Node.js库，提供了对无头Chrome或Chromium的控制，可以用于生成网页快照、抓取数据、自动化测试等任务。其中，生成PDF文件是一个常见的需求，本文将通过使用Puppeteer展示如何自动化生成定制的PDF，并使用代理IP、设置user-agent、cookie等技术来增强自动化过程的灵活性与稳定性。为了更好地理解如何定制Puppeteer生成的PDF文件，我们提供一个生成A4纸张格式的网页PDF的实例。用户可以根据需求自定义输出的PDF格式或内容。
Java内存布局
阿呆的专栏
10-01 830
64位 JVM 不启用指针压缩时：Object Header 大小是16字节。64位 JVM 启用指针压缩时（默认）：Object Header 大小是12字节。32位 JVM：Object Header 大小是8字节。JVM在默认情况下启用指针压缩，但如果堆内存超过32GB，就会禁用指针压缩。32GB是压缩指针的最大寻址范围。超过32GB的堆内存中，压缩指针带来的性能提升并不显著，而且需要解压指针反而可能增加开销。
Cortex-M3异常处理：Fault类异常解析
Cortex-M3有多种操作模式，其中handler模式用于处理异常和中断，始终工作在特权级，而线程模式可以在用户级和特权级之间切换。在复位后，处理器默认进入线程模式的特权级。 寄存器组是Cortex-M3的重要组成部分，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值