新闻管理系统的归档模块设计，异常处理和登录拦截

一.归档模块

1.dao层

在NewsRepository中新增两个方法
分别查询按年分类的时间和按年分类的新闻

    @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);

2.service层

在service层中的NewsService中新增两个方法

    //归档模块新闻分类查询
    Map<String,List<News>> archiveNew();

    //新闻总数
    Long countNew();

NewsServiceImpl类中实现NewsService新增的两个方法

    @Override
    public Map<String, List<News>> archiveNew() {

        List<String> years = newsRepository.findGroupYear();
        Map<String,List<News>> map = new LinkedHashMap<>();
        for(String year :years){
            map.put(year,newsRepository.findByYear(year));
            System.out.println(year);
        }

        return map;
    }

    @Override
    public Long countNew() {
        return newsRepository.count();
    }

3.web层

创建ArchiveShowController实现归档的功能

package com.guang.demo.web;

import com.guang.demo.service.NewsService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;

@Controller
public class ArchiveShowController {

    @Autowired
    private NewsService newsService;

    @GetMapping("/archives")
    public String archives(Model model){
        model.addAttribute("archiveMap",newsService.archiveNew());
        model.addAttribute("newsCount",newsService.countNew());
        return "archives";

    }
}

4.功能实现

点击主页的归档标签，跳转到归档页面

二.异常处理

1.在web层中创建NotFoundException类，继承RuntimeException

package com.guang.demo;

import org.springframework.http.HttpStatus;
import org.springframework.web.bind.annotation.ResponseStatus;

@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);
    }

}

2.创建handler包,在handler包下创建ControllerExceptionHandler类，实现对所有页面跳转进行异常处理

package com.guang.demo.handler;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.core.annotation.AnnotationUtils;
import org.springframework.web.bind.annotation.ControllerAdvice;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.ResponseStatus;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;

@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("Requset: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;

    }
}

三.登录拦截

1.创建interceptor包，在interceptor下创建LoginInterceptor类继承HandlerInterceptorAdapter,重写preHandle方法，判断session中的user是否存在，不存在就重定向到/admin界面

package com.guang.demo.interceptor;
import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

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 true;
    }
}

2.在interceptor包下创建WebConfig，定义拦截路径和个别不拦截的路径

package com.guang.demo.interceptor;

import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;

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