3.轮播图接口

1.在resources下的mapper下的VideoMapper.xml添加

    <select id="listVideoBanner" resultType="VideoBanner">

        select  * from video_banner order by weight asc

    </select>

2.在java下的mapper下的VideoMapper添加

    /**
     * 首页轮播图列表
     * @return
     */
    List<VideoBanner> listVideoBanner();

3.在service下的VideoService添加

   List<VideoBanner> listBanner();

4.在service.Impl下的VideoServiceImpl下添加

    @Override
    public List<VideoBanner> listBanner() {
        return videoMapper.listVideoBanner();
    }

5.在controller下的VideoController下添加

    /*
    * 轮播图列表
    * @return
    * */
    @GetMapping("list_banner")
    public JsonData indexBanner(){
        List<VideoBanner> bannerList = videoService.listBanner();
        return JsonData.buildSuccess(bannerList);
    }

n JsonData.buildSuccess(bannerList);
}

![在这里插入图片描述](https://img-blog.csdnimg.cn/20210313174809785.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNjI2MjE1,size_16,color_FFFFFF,t_70#pic_center)