SpringBoot后端开发归档页面+异常处理+拦截

归档页面

归档是把所有新闻按照对应的年份划分起来，所以需要编写对应的sql查询语句，将结果按照年份分组进行返回。
在NewRepository.java中编写对应的方法和SQL语句:

	@Query("select function('date_format',n.updateTime,'%Y') as year from News n group by year order by year desc ")
    List<String> findGroupYear();

    @Query("select n from News n where function('date_format',n.updateTime,'%Y') = ?1 ")
    List<News> findByYear(String year);

在NewService.java中添加新闻归档方法：

//年份对应的新闻
    Map<String,List<News>> archiveNews();

    Long newCount();

在NewServiceImpl.java中实现该方法：

	@Override
    public Map<String, List<News>> archiveNews() {
        List<String> years = newRepository.findGroupYear();
        //LinkedHashMap是有序集合，会按照添加的顺序保存
        Map<String,List<News>> map = new LinkedHashMap<>();
        for(String year:years){
            map.put(year,newRepository.findByYear(year));
        }
        return map;

    }

    @Override
    public Long newCount() {
        return newRepository.count();
    }

添加控制器ArchiveShowController.java:

@Controller
public class ArchiveShowController {
    @Autowired
    NewService newService;

    @GetMapping("/archives")
    public String archives(Model model){
        model.addAttribute("archiveMap",newService.archiveNews());
        model.addAttribute("newsCount",newService.newCount());
        return "archives";
    }
}

异常处理

在web包下新建一个NotFoundException.java:

@ResponseStatus(HttpStatus.NOT_FOUND)
public class NotFoundException extends RuntimeException{

    public NotFoundException(){
    }

    public NotFoundException(String message) {
        super(message);
    }

    public NotFoundException(String message, Throwable cause) {
        super(message, cause);
    }
}

然后在项目下新建一个handler包，新建一个ControllerExceptionHandler.java 显示出现错误后具体导向的页面：

@ControllerAdvice
public class ControllerExceptionHandler {

    private final Logger logger = LoggerFactory.getLogger(this.getClass());

    @ExceptionHandler(Exception.class)
    public ModelAndView exceptionHandler(HttpServletRequest request,Exception e) throws Exception{
        logger.error("Request: URL: {},Exception: {}",request.getRequestURI(),e);
        if (AnnotationUtils.findAnnotation(e.getClass(), ResponseStatus.class)!=null){
            throw e;
        }
        ModelAndView mv = new ModelAndView();
        mv.addObject("url",request.getRequestURI());
        mv.addObject("exception",e);
        mv.setViewName("error/error");
        return mv;
    }
}

登录拦截

在项目下新建一个interceptor包，新建LoginInterceptor.java 如果发现到达新闻管理界面没有用户信息的话就返回登录界面:

public class LoginInterceptor extends HandlerInterceptorAdapter {

    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        if (request.getSession().getAttribute("user")==null){
            response.sendRedirect("/admin");
            return false;
        }
        return super.preHandle(request, response, handler);
    }
}

新建WebConfig.java：

@Configuration
public class WebConfig implements WebMvcConfigurer {

    @Override
    public void addInterceptors(InterceptorRegistry registry) {
        registry.addInterceptor(new LoginInterceptor())
                .addPathPatterns("/admin/**")
                .excludePathPatterns("/admin")
                .excludePathPatterns("/admin/login");
    }
}

界面显示

归档页面

错误显示页面