摘要：實(shí)體關(guān)系映射建了四個實(shí)體，啟動程序。打開數(shù)據(jù)庫，發(fā)現(xiàn)只生成了三張表。與都創(chuàng)建成功，只有表創(chuàng)建失敗。同時，控制臺也報(bào)出了如下錯誤大致意思就是你的表中有一個語法錯誤，導(dǎo)致了創(chuàng)建表失敗。原因猜測應(yīng)該是屬于中的關(guān)鍵字，所以會報(bào)語法錯誤。

建了四個實(shí)體，啟動程序。

打開數(shù)據(jù)庫，發(fā)現(xiàn)只生成了三張表。

OrderDetail、ProductCategory與ProductInfo都創(chuàng)建成功，只有Order表創(chuàng)建失敗。

同時，控制臺也報(bào)出了如下錯誤：

org.hibernate.tool.hbm2ddl.SchemaExport  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "order" at line 1
org.hibernate.tool.hbm2ddl.SchemaExport  : HHH000389: Unsuccessful: create table order (id varchar(255) not null, amount decimal(19,2), buyer_address varchar(255), buyer_name varchar(255), buyer_openid varchar(255), buyer_phone varchar(255), create_time datetime, pay_status integer, status integer, update_time datetime, primary key (id))
org.hibernate.tool.hbm2ddl.SchemaExport  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "order (id varchar(255) not null, amount decimal(19,2), buyer_address varchar(255" at line 1
org.hibernate.tool.hbm2ddl.SchemaExport  : HHH000389: Unsuccessful: alter table order_detail add constraint FKplam7wxc4tjbgex0xyk8f0qxo foreign key (order_id) references order (id)
org.hibernate.tool.hbm2ddl.SchemaExport  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "order (id)" at line 1

大致意思就是你的Order表中有一個SQL語法錯誤，導(dǎo)致了創(chuàng)建order表失敗。

語法錯誤，第一反應(yīng)就是去看看Order實(shí)體，應(yīng)該是哪里寫錯了。

package com.imooc.spring.entity;

import org.hibernate.annotations.CreationTimestamp;
import org.hibernate.annotations.UpdateTimestamp;

import javax.persistence.Entity;
import javax.persistence.Id;
import java.math.BigDecimal;
import java.util.Calendar;

/**
 * @author zhangxishuo on 2018/4/25
 * 訂單主表
 */

@Entity
public class Order {

    public static final Integer NEW = 0;         // 新下單

    public static final Integer FINISH = 1;      // 已完結(jié)

    public static final Integer CANCEL = 2;      // 已取消

    public static final Integer WAIT =  0;       // 未支付

    public static final Integer SUCCESS = 1;     // 支付成功

    @Id
    private String id;                    // 訂單id

    private String buyerName;             // 買家姓名

    private String buyerPhone;            // 買家電話

    private String buyerAddress;          // 買家地址

    private String buyerOpenid;           // 買家Openid

    private BigDecimal amount;            // 總金額

    private Integer status = NEW;         // 訂單狀態(tài)

    private Integer payStatus = WAIT;     // 支付狀態(tài)

    @CreationTimestamp
    private Calendar createTime;          // 創(chuàng)建時間

    @UpdateTimestamp
    private Calendar updateTime;          // 更新時間

    public Order() {
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getBuyerName() {
        return buyerName;
    }

    public void setBuyerName(String buyerName) {
        this.buyerName = buyerName;
    }

    public String getBuyerPhone() {
        return buyerPhone;
    }

    public void setBuyerPhone(String buyerPhone) {
        this.buyerPhone = buyerPhone;
    }

    public String getBuyerAddress() {
        return buyerAddress;
    }

    public void setBuyerAddress(String buyerAddress) {
        this.buyerAddress = buyerAddress;
    }

    public String getBuyerOpenid() {
        return buyerOpenid;
    }

    public void setBuyerOpenid(String buyerOpenid) {
        this.buyerOpenid = buyerOpenid;
    }

    public BigDecimal getAmount() {
        return amount;
    }

    public void setAmount(BigDecimal amount) {
        this.amount = amount;
    }

    public Integer getStatus() {
        return status;
    }

    public void setStatus(Integer status) {
        this.status = status;
    }

    public Integer getPayStatus() {
        return payStatus;
    }

    public void setPayStatus(Integer payStatus) {
        this.payStatus = payStatus;
    }

    public Calendar getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Calendar createTime) {
        this.createTime = createTime;
    }

    public Calendar getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Calendar updateTime) {
        this.updateTime = updateTime;
    }
}

看看這個實(shí)體，并沒有找到有什么錯誤。

然后就去對比慕課網(wǎng)的代碼，發(fā)現(xiàn)講師建的訂單實(shí)體名為OrderMaster，我這里的代碼與講師的代碼除了實(shí)體名不同其他完全一樣。

試著將實(shí)體名從Order修改為OrderMaster。

改完名，妥妥地成功。

猜測應(yīng)該是Order屬于SQL中的關(guān)鍵字，所以會報(bào)語法錯誤。

把語法錯誤的報(bào)錯信息加上order去Google一下。

Unsuccessful: create table order You have an error in your SQL syntax; order

果然，StackOverflow給出了一個非常完美的解釋。

Order實(shí)體會默認(rèn)映射到order表，但是order是sql中的一個服務(wù)關(guān)鍵字。所以生成order表的時候異常就發(fā)生了。