5-10 影片列表查询实现

开始影片的查询
定义接口方法




返回的数据类型

对照着这个返回类，把数据一个个的返回回来。

现在sql的编辑器里面把sql写好

复制到xml内，然后再调整下格式

 

select
        film.`UUID` AS filmId,
        film.`film_status` AS filmStatus,
        info.`film_en_name` AS filmEnName,
        film.`film_score` AS filmScore,
        film.`film_preSaleNum` AS preSaleNum,
        film.`film_box_office` AS boxOffice,
        film.`film_time` AS filmTime,
        info.`film_length` AS filmLength,
        film.`img_address` AS mainImg
    from mooc_film_t film
    left join mooc_film_info_t info on film.`UUID`=info.`film_id`

 

加上注释

结束