归档功能、异常处理、登录拦截功能

归档功能、异常处理、登录拦截功能

1.归档：

在idea的database中打开console（default），编写sql语句：

select date_format(n.update_time,'%Y') from t_news n group by date_format(n.update_time,'%Y') order by date_format(n.update_time,'%Y') desc
select * from t_news n where date_format(n.update_time,'%Y')=2020

在NewRepository中：

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

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

在NewService中增加方法接口：

 Map<String,List<News>> archiveNew();

 Long countNew();

在NewServiceImpl中实现：

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

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

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

在ArchiveController中：

package com.zr0726.news.web;


import com.zr0726.news.service.NewService;
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 NewService newService;

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

运行项目：

2.异常处理

在news包下新建NotFoundException类：

package com.zr0726.news;

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


}

在news包下新建handler包，在该包下新建ControllerExceptionHandler类：

package com.zr0726.news.handler;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.core.annotation.AnnotationUtils;
import org.springframework.stereotype.Controller;
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("Request:URL:{},exception:{}",request.getRequestURL(),e);
        if(AnnotationUtils.findAnnotation(e.getClass(), ResponseStatus.class)!=null){
            throw e;
        }
        ModelAndView mv=new ModelAndView();
        mv.addObject("url",request.getRequestURL());
        mv.addObject("exception",e);
        mv.setViewName("error/error");
        return mv;
    }

}

3.登录拦截功能

在news下新建intercepter包，在该包下新建LoginInterceptor类

package com.zr0726.news.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;
    }
}

以及WebConfig类：

package com.zr0726.news.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");
    }
}

运行结果，未登录状态直接转到管理界面时被拦截，重定向为登录页面：