backend/src/main/java/com/rongyichuang/message/repository/MessageRepository.java
@@ -50,4 +50,9 @@ */ @Query("SELECT m FROM Message m WHERE m.playerId = :playerId AND m.state IN (0, 1)") List<Message> findUnpublishedMessagesByPlayerId(@Param("playerId") Integer playerId); /** * 根据用户ID查找消息,按创建时间倒序 */ List<Message> findByUserIdOrderByCreateTimeDesc(Long userId); }