主页 / 问题 / 1480678
Accepted
invzbl3
Asked:2022-12-24 10:07:28 +0000 UTC2022-12-24 10:07:28 +0000 UTC

如何解决问题：如果在脚本中正确指定了某些字段，则“无法解析列”？

  • 772

我有以下脚本：

/*==============================================================*/
/* Table: Employees                                             */
/*==============================================================*/
insert into Employees (firstName, lastName, phoneNumber, email, salary, role, password, username)
values ('Christiano', 'Ronaldo', '+421905123456', 'test@gmail.com', 50000.00, 'TEAM_LEADER', 'testPassword', 'C7'),
       ('John', 'Smith', '+421905123480', 'test2@gmail.com', 40000.00, 'PM', 'testPassword2', 'Jo'),
       ('Michael', 'Jackson', '+421905123400', 'test3@gmail.com', 30000.00, 'DEVELOPER', 'testPassword3', 'Mike'),
       ('Leonardo', 'DiCaprio', '+421905123450', 'test4@gmail.com', 20000.00, 'SCIENTIST', 'testPassword4', 'Leo'),
       ('Brad', 'Pitt', '+421905123455', 'test5@gmail.com', 10000.00, 'ENGINEER', 'testPassword5', 'Brad');

有一个实体：

import com.test.application.data.enums.Role;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.ToString;
import org.springframework.security.core.GrantedAuthority;
import org.springframework.security.core.userdetails.UserDetails;
import javax.persistence.*;
import java.util.Collection;
import java.util.List;

/**
 * @author invzbl3 on 12/16/2022
 * @project RestApiApplication
 */
@Data
@ToString
@EqualsAndHashCode
@Entity(name = "employee_entity")
@Table(name = "employees")
public class Employee implements UserDetails {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Integer id;
    private String firstName;
    private String lastName;
    private String phoneNumber;
    private String email;
    private double salary;
    @Enumerated(EnumType.STRING)
    private Role role;
    private String password;
    private String username;

    @Override
    public Collection<? extends GrantedAuthority> getAuthorities() {
        return List.of(() -> "USER");
    }

    @Override
    public String getPassword() {
        return password;
    }

    @Override
    public String getUsername() {
        return username;
    }

    @Override
    public boolean isAccountNonExpired() {
        return true;
    }

    @Override
    public boolean isAccountNonLocked() {
        return true;
    }

    @Override
    public boolean isCredentialsNonExpired() {
        return true;
    }

    @Override
    public boolean isEnabled() {
        return true;
    }
}

我检查了一个类似的问题，但对我来说它看起来不一样，因为我在那里正确检查了一些字段。

考虑到这一点，我有一个问题：

我该如何解决这个问题？

如果您需要随时提供任何其他信息。

在此先感谢您对此事的任何想法。

java

1 个回答

  1. Best Answer

    该问题与默认的Spring Data 约定有关。

    在实体上添加注释@JsonProperty，以便脚本没有匹配问题：

    @Data
@ToString
@EqualsAndHashCode
@Entity(name = "employee_entity")
@Table(name = "employees")
public class Employee implements UserDetails {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Integer id;

    @JsonProperty("first_name")
    private String firstName;

    @JsonProperty("last_name")
    private String lastName;

    @JsonProperty("phone_number")
    private String phoneNumber;
    private String email;
    private double salary;
    @Enumerated(EnumType.STRING)
    private Role role;
    private String password;
    private String username;

    @Override
    public Collection<? extends GrantedAuthority> getAuthorities() {
        return List.of(() -> "USER");
    }

    @Override
    public String getPassword() {
        return password;
    }

    @Override
    public String getUsername() {
        return username;
    }

    @Override
    public boolean isAccountNonExpired() {
        return true;
    }

    @Override
    public boolean isAccountNonLocked() {
        return true;
    }

    @Override
    public boolean isCredentialsNonExpired() {
        return true;
    }

    @Override
    public boolean isEnabled() {
        return true;
    }
}
    • 1

相关问题