“Field List”中得列“UserEntity0_.last_name”未知

Question

我在一个使用Spring Framework的Java web项目中工作，但在使用数据库时遇到了一个问题（铭文、连接）。

下面是我的数据库SQL代码：

CREATE TABLE USER (
  Login             VARCHAR(20) NOT NULL,
  Password          VARCHAR(32) NOT NULL,
  LastName          VARCHAR(20) NOT NULL,
  Address           VARCHAR(60) NOT NULL,
  Email             VARCHAR(50) NOT NULL,
  MobilePhoneNumber INT(10)     NOT NULL,
  LoyaltyPoints     INT(4)      NOT NULL,
  PhoneNumber       INT(9),
  PRIMARY KEY (Login)
)

package com.spring.henallux.model;

public class User {

    private String login;

    private String password;

    private String lastName;

    private String address;

    private String email;

    private int mobilePhoneNumber;

    private int loyaltyPoints;

    private int phoneNumber;

    public String getLogin() {
        return login;
    }

    public void setLogin(String login) {
        this.login = login;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public int getMobilePhoneNumber() {
        return mobilePhoneNumber;
    }

    public void setMobilePhoneNumber(int mobilePhoneNumber) {
        this.mobilePhoneNumber = mobilePhoneNumber;
    }

    public int getLoyaltyPoints() {
        return loyaltyPoints;
    }

    public void setLoyaltyPoints(int loyaltyPoints) {
        this.loyaltyPoints = loyaltyPoints;
    }

    public int getPhoneNumber() {
        return phoneNumber;
    }

    public void setPhoneNumber(int phoneNumber) {
        this.phoneNumber = phoneNumber;
    }

    public User() {
        this.login = new String();
        this.password = new String();
        this.lastName = new String();
        this.address = new String();
        this.email = new String();
        this.mobilePhoneNumber = 0;
        this.loyaltyPoints = 0;
    }
}

package com.spring.henallux.dataAccess.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "user")
public class UserEntity {

    @Id
    @Column(name = "Login")
    private String login;

    @Column(name = "Password", nullable = false)
    private String password;

    @Column(name = "LastName", nullable = false)
    private String lastName;

    @Column(name = "Address", nullable = false)
    private String address;

    @Column(name = "Email", nullable = false)
    private String email;

    @Column(name = "MobilePhoneNumber", nullable = false)
    private int mobilePhoneNumber;

    @Column(name = "LoyaltyPoints", nullable = false)
    private int loyaltyPoints;

    @Column(name = "PhoneNumber", nullable = true)
    private int phoneNumber;

    public String getLogin() {
        return login;
    }

    public void setLogin(String login) {
        this.login = login;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public int getMobilePhoneNumber() {
        return mobilePhoneNumber;
    }

    public void setMobilePhoneNumber(int mobilePhoneNumber) {
        this.mobilePhoneNumber = mobilePhoneNumber;
    }

    public int getLoyaltyPoints() {
        return loyaltyPoints;
    }

    public void setLoyaltyPoints(int loyaltyPoints) {
        this.loyaltyPoints = loyaltyPoints;
    }

    public int getPhoneNumber() {
        return phoneNumber;
    }

    public void setPhoneNumber(int phoneNumber) {
        this.phoneNumber = phoneNumber;
    }

    /*@OneToOne(mappedBy="user", fetch=FetchType.LAZY)
    private CommandEntity command;*/
}

下面是错误消息：

2016-12-19 11:40:35.223错误7952---[nio-8080-exec-2]O.H.Engine.jdbc.spi.sqlexceptionHelper：“Field List”2016-12-19 11:40:35.225信息7952---[nio-8080-exec-2]O.H.E.Internal.DefaultLoadEventListener:hhh000327:执行加载命令时出错：org.hibernate.exception.sqlgrammarexception：无法提取ResultSet 2016-12-19 11:40:35.249错误7952---

当我这样做时，我会得到这样的信息：

public User save(User user){
    UserEntity userEntity = converter.userModelToUserEntity(user);
    userEntity = userRepository.save(userEntity);
    return converter.userEntityToUserModel(userEntity);
}

Answer 1

只需使用实体类而不使用模型类，将实体名改为user，不要忘记在DB中添加id列