超详细超实用！！！零基础java开发之云风笔记接口开发之笔记分类列表以及笔记数量统计（十三）

云风网
云风笔记
云风知识库

一、service/NoteApi新增getNodeDetail接口定义

public interface NoteApi {
    ...
    List<NoteManage> getNoteTypeList();
}

二、service/impl/NoteServiceImpl接口实现逻辑

public class NoteServiceImpl implements NoteApi {
    @Autowired
    NoteMapper noteMapper;
    ...

    public List<NoteManage> getNoteTypeList() {
        return noteMapper.getNoteTypeList();
    }
}

三、mapper/NoteMapper新增接口

...
public interface NoteMapper {
    ...
    List<NoteManage> getNoteTypeList();
}

四、新增sql语句

<select id="getNoteTypeList" resultType="java.util.Map">
    SELECT type typeName, COUNT(1) noteNum FROM note GROUP BY type
</select>

五、控制类NoteController新增更新逻辑

@RequestMapping(value = "/getNoteTypeList",method = RequestMethod.GET)
public Response getNoteTypeList(){
    Response response = new Response();
    List<NoteManage> typeList = service.getNoteTypeList();
    response.setResponse(true,"查询成功",200, typeList);
    return response;
}

六、接口请求测试