From b06162b2966eea4f092b3edf3032de843059af4b Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期四, 12 六月 2025 18:16:10 +0800
Subject: [PATCH] add: 评论开发
---
src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java b/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java
index 700fe84..e259f11 100644
--- a/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java
@@ -26,4 +26,8 @@
List<FilmWorksVO> queryPage(@Param("dto") FilmWorksQueryDTO dto, Page page);
FilmWorksVO selectInfoById(@Param("id") Long id, @Param("userId") String userId);
+
+ //获取权重最高的数据
+ @Select("select * from film_works where sticky_weight = (select max(sticky_weight) from film_works) limit 1")
+ FilmWorks getTopStickyWeight();
}
--
Gitblit v1.9.3