运行springboot项目时获取SQLSyntaxErrorException

Question

package com.rahul.flightreservation.repos;

import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import com.rahul.flightreservation.entities.Flight;

public interface FlightRepository extends JpaRepository<Flight, Long > {

    
    @Query(value="from Flight where departureCity= :departureCity and arrivalCity= :arrivalCity and dateOfDeparture= :dateOfDeparture", nativeQuery = true)
    List<Flight> findFlights(@Param("departureCity") String from, @Param("arrivalCity") String to, @Param("dateOfDeparture")  Date departureDate);

}

航班类别：package com.rahul.flightreservation.entities；

import java.sql.Timestamp;
import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;

@Entity
public class Flight extends AbstractEntity {
    
    private String flightNumber;
    private String operatingAirlines;
    @Column(name="Departure_City")
    private String departureCity;
    @Column(name="Arrival_City")
    private String arrivalCity;
    @Column(name="Date_of_Departure")
    private Date dateOfDeparture;
    private Timestamp estimatedDepartureTime;

    public String getFlightNumber() {
        return flightNumber;
    }

    public void setFlightNumber(String flightNumber) {
        this.flightNumber = flightNumber;
    }

    public String getOperatingAirlines() {
        return operatingAirlines;
    }

    public void setOperatingAirlines(String operatingAirlines) {
        this.operatingAirlines = operatingAirlines;
    }

    public String getDepartureCity() {
        return departureCity;
    }

    public void setDepartureCity(String departureCity) {
        this.departureCity = departureCity;
    }

    public String getArrivalCity() {
        return arrivalCity;
    }

    public void setArrivalCity(String arrivalCity) {
        this.arrivalCity = arrivalCity;
    }

    public Date getDateOfDeparture() {
        return dateOfDeparture;
    }

    public void setDateOfDeparture(Date dateOfDeparture) {
        this.dateOfDeparture = dateOfDeparture;
    }

    public Timestamp getEstimatedDepartureTime() {
        return estimatedDepartureTime;
    }

    public void setEstimatedDepartureTime(Timestamp estimatedDepartureTime) {
        this.estimatedDepartureTime = estimatedDepartureTime;
    }
    
    
    

}

表说明：ID航班号运营航空公司出发城市到达城市日期出发估计日期出发时间

错误：Hibernate：from Fligher where departurecity=？和到达=？和DateofDeparture=？2020-06-28 20:32:13.138警告5744---[nio-8083-exec-8]O.H.Engine.jdbc.spi.sqlexceptionHelper：SQL错误：1064,SQLState：42000 2020-06-28 20:32:13.138错误5744---[nio-8083-exec-8]O.H.Engine.jdbc.spi.sqlexceptionHelper：您的SQL语法有错误；查看与您的MySQL server版本相对应的手册中的正确语法，以使用“from Flight where departurecity='AUS'和arrivalcity='NYC'和dateofdepartur”在第1行202-06-28 20:32:13.194错误5744---[nio-8083-exec-8]o.a.c.c.c.[.[.[.[.[.[.[.[.[.[.[dispatcherServlet]:在路径为[/FlightReservation]的上下文中servlet[dispatcherServlet]的servlet.Service（）引发异常[请求处理失败；嵌套异常为

null

Answer 1

首先，这里不是缺少select*吗？

其次，您将其称为本机查询，但在查询中使用flight实体。

如果您选择使用JPQL，那么查询应该是

select f from Flight f where f.departureCity= :departureCity and f.arrivalCity= :arrivalCity and f.dateOfDeparture= :dateOfDeparture

但是，如果您将该方法重命名为

findallbydeparturecityandarrivalcityanddateofdeparty(...)