backend/src/main/java/com/rongyichuang/activity/repository/ActivityRepository.java
@@ -33,9 +33,9 @@ // 统计比赛数量 @Query("SELECT COUNT(a) FROM Activity a WHERE a.pid = 0 AND a.state = 1") long countActiveCompetitions(); long countActiveActivities(); // 查询进行中的比赛 @Query("SELECT a FROM Activity a WHERE a.pid = 0 AND a.state = 1 AND a.matchTime <= CURRENT_TIMESTAMP AND a.signupDeadline >= CURRENT_TIMESTAMP") List<Activity> findOngoingCompetitions(); List<Activity> findOngoingActivities(); }