springCloud 使用sql更新数据库

最新推荐文章于 2024-12-04 18:24:41 发布

转载最新推荐文章于 2024-12-04 18:24:41 发布 · 297 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/qqzhulu/p/10241276.html

文章标签：

#java #数据库

本文详细介绍了如何在基于Spring框架的Java应用中实现用户取消帖子屏蔽的功能，包括Controller层、Service层和Repository层的具体代码实现。

1、controller 层：

@RequestMapping(value = "v2/member/blog/cancelBlogShield")//取消屏蔽别人的帖子
public Object cancelBlogShield(@RequestParam String blogId, HttpServletRequest httpServletRequest) {
Member member = memberService.checkIdAndToken(httpServletRequest);
if (member == null) {
return new APIResult(1000, "登录失效");
}
int rs = memberblogShieldService.updateActivesFalseByMemberIdAndBlogId(member.getId(), blogId);
System.out.println("updateBlogShieldNun=====" + rs);
return APIResult.createSuccess();
}

2、serviceImpl层：

@Autowired
MemberBlogShieldRepository memberBlogShieldRepository;

public int updateActivesFalseByMemberIdAndBlogId(String memberId, String blogId) {
return memberBlogShieldRepository.updateActivesFalseByMemberIdAndBlogId(memberId, blogId);
}

3、repository层：

@Modifying
@Transactional
@Query("update MemberBlogShield set actives = 0 where member_id = ?1 and blog_id = ?2")
int updateActivesFalseByMemberIdAndBlogId(String memberId, String blogId);

转载于:https://www.cnblogs.com/qqzhulu/p/10241276.html