JPA的实体类的级联关系

**

## JPA的实体类的展示

**

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;

import javax.persistence.*;
import java.util.Date;

//Entity注解和数据表有映射关系
//如果数据库表和实体类不一致，需要table注解，指定表名
@Data
@Entity
@Table(name = "t_user",catalog = "zg5_1708d",schema = "zg5_1708d")
@ApiModel("用户的实体类")
public class UserEntity {
    /** 主键的生成策略： IDENTITY、AUTO **/
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    //没有被注解的属性，在建表也会生成对应的字段。
    @ApiModelProperty("用户登录名称")
    private String username;
    @Column(columnDefinition = "varchar(64) DEFAULT NULL COMMENT '密码'")
    private String password;
    //字段精度设置：precision长度，scale小数的位数
    @Column(precision = 10,scale = 2,columnDefinition = "double(10,2) DEFAULT NULL COMMENT '积分'")
    private double score;

    private Integer sex;

    private Integer classesId;
    //非数据的映射字段，加Transient注解
    @Transient
    private String classesName;

    @Transient
    private String orderNo;

    //枚举
    @Enumerated(EnumType.ORDINAL)
    private DeleteEnum isDelete;
    //大字段lob
    @Lob
    private String content;

    //按java命名规范，在表里生成create_time字段
    private Date createTime;
    //指定时间的精度,默认是datetime
    @Temporal(TemporalType.TIMESTAMP)
    private Date updateTime;

}

**

## 这个实体类中包含了多对多的关系连接

**

import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import lombok.Data;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;
import org.springframework.data.annotation.CreatedBy;
import org.springframework.data.annotation.CreatedDate;
import org.springframework.data.annotation.LastModifiedBy;
import org.springframework.data.annotation.LastModifiedDate;
import org.springframework.data.jpa.domain.support.AuditingEntityListener;

import javax.persistence.*;
import java.util.Date;
import java.util.List;

//Entity注解和数据表有映射关系
//如果数据库表和实体类不一致，需要table注解，指定表名
@Data
@Entity
@EntityListeners(AuditingEntityListener.class)
@Table(name = "t_role",catalog = "zg5_1708d",schema = "zg5_1708d")
public class RoleEntity {
    /** 主键的生成策略： IDENTITY、AUTO **/
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    //角色名称
    private String name;


    @CreatedDate
    @Temporal(TemporalType.TIMESTAMP)
    private Date createTime;

    @LastModifiedDate
    @Temporal(TemporalType.TIMESTAMP)
    private Date updateTime;

    @CreatedBy
    private Integer createBy;

    @LastModifiedBy
    private Integer updateBy;



    //多对多关系
    //JoinTable name是关系表的表名 joinColumns是主表在关系表对应的列，inverseJoinColumns从表对应的列
    @JsonIgnoreProperties("roleList")
    @ManyToMany
    @JoinTable(name = "t_user_role_relation",joinColumns = @JoinColumn(name = "role_id"),
            inverseJoinColumns = @JoinColumn(name = "user_id"))
    private List<UserEntity> userList;
}

**

## 这个实体类中有三级联动的关系和多对多

**


import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import lombok.Data;

import javax.persistence.*;
import java.util.Date;
import java.util.List;

@Entity
@Data
@Table(name = "t_shop")
public class Shop {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;

    private String name;

    private String pic;

    private double price;

    private int province;
    private int city;
    private int county;

    @Temporal(TemporalType.DATE)
    private Date created;

    @OneToOne
    @JoinColumn(name = "province",insertable = false,updatable = false,foreignKey = @ForeignKey(name = "none"))
    private Area provinceName;
    @OneToOne
    @JoinColumn(name = "city",insertable = false,updatable = false,foreignKey = @ForeignKey(name = "none"))
    private Area cityName;
    @OneToOne
    @JoinColumn(name = "county",insertable = false,updatable = false,foreignKey = @ForeignKey(name = "none"))
    private Area countyName;


    @ManyToMany
    @JoinTable(name = "t_shop_chuan",joinColumns = @JoinColumn(name = "shopid",foreignKey = @ForeignKey(name = "none")),
            inverseJoinColumns = @JoinColumn(name = "chuanid",foreignKey = @ForeignKey(name = "none")))
    private List<Chuan> chuanList;

    @Transient
    private Integer start;

    @Transient
    private Integer end;


```javascript

一对一以及多对一的实体类的关系

import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import lombok.Data;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;

import javax.persistence.*;
import java.util.Date;

//Entity注解和数据表有映射关系
//如果数据库表和实体类不一致，需要table注解，指定表名
@Data
@Entity
@Table(name = "t_order",catalog = "zg5_1708d",schema = "zg5_1708d")
public class OrderEntity {
    /** 主键的生成策略： IDENTITY、AUTO **/
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    //订单编号
    private String orderNo;
    //用户Id
    private Integer userId;
    //用户名称
    @Transient
    private String username;

    //创建时间
    @Temporal(TemporalType.TIMESTAMP)
    private Date createTime;
    //一对一关系，JoinColumn.name指定关联字段，referencedColumnName是当前实体主键，则可以省略。
    // insertable、updatable=false,新增或修改的时候，限制更新关联表，用到JoinColumn是都指定false
    @OneToOne(cascade = {CascadeType.REFRESH,CascadeType.MERGE})
    @JoinColumn(name = "userId"*//*,referencedColumnName = "id"*//*,insertable = false,updatable = false)
    private UserEntity user;

    //忽略UserEntity的orderList属性
    @JsonIgnoreProperties("orderList")
    @ManyToOne(cascade = {CascadeType.REFRESH,CascadeType.MERGE})
    @JoinColumn(name = "userId"/*,referencedColumnName = "id"*/,insertable = false,updatable = false)
    private UserEntity user;



}

}