JPA生成: @GeneratedValue(strategy=GenerationType.IDENTITY)
JPA提供的四种标准用法为TABLE,SEQUENCE,IDENTITY,AUTO.
TABLE:使用一个特定的数据库表格来保存主键。SEQUENCE:根据底层数据库的序列来生成主键,条件是数据库支持序列。
IDENTITY:主键由数据库自动生成(主要是自动增长型)
AUTO:主键由程序控制。
hibernate:
@GeneratedValue(generator = "1")
@GenericGenerator(name = "1", strategy = "native")
native: 对于 oracle 采用 Sequence 方式,对于MySQL 和 SQL Server 采用identity
uuid: 采用128位的uuid算法生成主键,uuid被编码为一个32位16进制数字的字符串。
assigned: 在插入数据的时候主键由程序处理(很常用),这是 <generator>元素没有指定时的默认生成策略。等同于JPA中的AUTO。
increment: 插入数据的时候hibernate会给主键添加一个自增的主键,但是一个hibernate实例就维护一个计数器,所以在多个实例运行的时候不能使用这个方法。
注意mysql数据库的自动生成与oracle的不同
项目注解摘录:
@Entity
@Table(name = "t_product_margin_common", catalog = "exadmin", uniqueConstraints = @UniqueConstraint(columnNames = {"PRODUCT_ID", "MODE_TYPE", "TRADE_TYPE", "SERIES_GROUP_ID", "PERIOD_ID" }))
public class TProductMarginCommon.....
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name = "ARITH_ID", unique = true, nullable = false, precision = 65, scale = 30)
@Column(name = "PRODUCT_ID", nullable = false, length = 30)
@Entity
@Table(name = "t_arith_params_details", catalog = "exadmin")
联合主键
@EmbeddedId
@AttributeOverrides({
@AttributeOverride(name = "arithId", column = @Column(name = "ARITH_ID", nullable = false, precision = 65, scale = 30)),
@AttributeOverride(name = "arithCode", column = @Column(name = "ARITH_CODE", nullable = false, length = 4)),
@AttributeOverride(name = "paramId", column = @Column(name = "PARAM_ID", nullable = false, length = 50)) })
public TArithParamsDetailsId getId() {}
@Embeddable
public class TArithParamsDetailsId