1 回答

TA貢獻1811條經驗 獲得超5個贊
我發現問題是不再支持帶有 ?1 和 ?2 參數的 @Query 它改變了
** 請求存儲庫**
現在我的班級是:
package com.spring.course.repository;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import com.spring.course.domain.Request;
import com.spring.course.enums.RequestState;
@Repository
public interface RequestRepository extends JpaRepository<Request, Long>{
public List<Request> findAllByOwnerId(Long id);
@Query("UPDATE request SET state = :state WHERE id = :id")
public Request updateStatus(Long id, RequestState state);
}
** 請求StageRepository**
package com.spring.course.repository;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import com.spring.course.domain.Request;
import com.spring.course.domain.RequestStage;
import com.spring.course.enums.RequestState;
@Repository
public interface RequestSatageRepository extends JpaRepository<RequestStage, Long>{
public List<RequestStage> findAllByRequest(Long id);
@Query("UPDATE request SET state = :state WHERE id = :id")
public Request updateStatus(Long id, RequestState state);
}
** 用戶存儲庫**
package com.spring.course.repository;
import java.util.Optional;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import com.spring.course.domain.User;
@Repository
public interface UserRepository extends JpaRepository<User, Long> {
@Query("SELECT u FROM user u WHERE email = :email AND password = :password")
public Optional<User> login(String email, String password);
}
添加回答
舉報