Spring Data JPA - ManyToMany - JPQL -@仓库中的查询格式

// 实体类定义
@Entity
public class User {
    @Id
    private Long id;
    private String name;
    
    @ManyToMany
    private List<Role> roles;
    
    // 省略getter和setter
}

@Entity
public class Role {
    @Id
    private Long id;
    private String name;
    
    @ManyToMany(mappedBy = "roles")
    private List<User> users;
    
    // 省略getter和setter
}

// 仓库接口定义
public interface UserRepository extends JpaRepository<User, Long> {
    List<User> findByName(String name);
    
    @Query("SELECT u FROM User u JOIN u.roles r WHERE r.name = :roleName")
    List<User> findByRoleName(@Param("roleName") String roleName);
}

// 使用示例
@Service
public class UserService {
    @Autowired
    private UserRepository userRepository;
    
    public List<User> getUsersByName(String name) {
        return userRepository.findByName(name);
    }
    
    public List<User> getUsersByRoleName(String roleName) {
        return userRepository.findByRoleName(roleName);
    }
}