在线博客系统——文章归档

接口说明

接口url：/articles/listArchives

请求方式：POST

请求参数：无

返回数据：

{
    "success": true,
    "code": 200,
    "msg": "success",
    "data": [
        {
            "year": "2021",
            "month": "6",
            "count": 2
        }
            
    ]
}

规划SQL语句

        select year(from_unixtime(create_date / 1000))  year,
               month(from_unixtime(create_date / 1000)) month,
               count(*)                                 count
        from ms_article
        group by year, month

编码实现 Dao持久层 do 对象

数据库 查询出来的对象但是不需要持久化，由于do是关键字所以加了个s成为dos

Archives:

package com.huing.blog.dao.dos;

import lombok.Data;


@Data
public class Archives {

    private Integer year;

    private Integer month;

    private Long count;
}

Mapper接口

ArticleMapper:

    
    List listArchives();

Mapper.xml

    
    
        select year(from_unixtime(create_date / 1000))  year,
               month(from_unixtime(create_date / 1000)) month,
               count(*)                                 count
        from ms_article
        group by year, month
    

Service业务逻辑层 ArticleService接口

    
    Result listarchives();

ArticleServiceImpl实现类

    @Override
    public Result listarchives() {
        List archivesList = articleMapper.listArchives();
        return Result.success(archivesList);
    }

Controller控制层

ArticleController:

    
    @PostMapping("listArchives")
    public Result listArchives(){
        return articleService.listarchives();
    }

前端测试