'Bad SQL grammer jdbcTemplate spring boot

I am getting a bad SQL grammer error when trying to run this.

    public List<UserTemp> findByID(Integer PatientNumber) {
    String sql = "SELECT PatientNumber,FirstName,Surname from paitents WHERE 'PatientNumber' = ?,PatientNumber";
    return jdbcTemplate.query(sql,
            (rs, rowNum) ->
                    new UserTemp(
                            rs.getInt("PatientNumber"),
                            rs.getString("FirstName"),
                            rs.getString("Surname")
                    ));
}

I am trying to select a patient based on the PatientNumber

javaspring-bootspring-jdbcjdbctemplate


Solution 1:[1]

Is your table called paitents or patients?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 oaPiet

Related Questions