点赞功能模块-获取文章列表

it2024-01-04  62

内容:直接查找数据库返回文章的列表即可。

PraiseController.java

//获取文章列表 @GetMapping("list") public BaseResponse articleList(){ BaseResponse response=new BaseResponse(StatusCode.Success); try { response.setData(praiseService.getAll()); }catch (Exception e){ response=new BaseResponse(StatusCode.Fail.getCode(),e.getMessage()); } return response; }

PraiseService.java

//获取文章的列表 public List<Article> getAll() throws Exception{ return articleMapper.selectAll(); }

ArticleMapper.xml

<select id="selectAll" resultType="com.redis.model.entity.Article"> select a.*, b.name as userName from article as a left join user as b on b.id = a.user_id where a.is_active = 1 order by a.create_time desc </select>

 

最新回复(0)