归档页面
归档是把所有新闻按照对应的年份划分起来,所以需要编写对应的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");
}
}