休眠-约束名称 [英] Hibernate - Constraint Name
问题描述
有人知道如何为主键(PK_ [name])设置约束名称,选中(CK_ [Name]),默认[DF_ [Name]],外键(Fk_ [Name]),唯一. 例如,通过使用注释或xml配置,我希望该表::::
Does anybody knows how to set the constraint name for primary key (PK_[name]) ,check (CK_[Name]),Default [DF_[Name]], Foreign Key (Fk_[Name]) ,Unique .. by using Annotations or xml config for example i want that Table ::::
CREATE TABLE ACCOUNT (
[ID] INT NOT NULL IDENTITY(1,1),
[USERNAME] VARCHAR(50) NOT NULL,
[PASSWORD] VARCHAR(50) NOT NULL,
[EMAIL] VARCHAR(100) NOT NULL,
[GENDER] INT NOT NULL ,
[ADDRESS] INT,
[AGE] INT CONSTRAINT DF_tblAccount_Age DEFAULT 0,
CONSTRAINT PK_tblAccount_ID PRIMARY KEY([ID]),
CONSTRAINT UQ_tblAccount_Address UNIQUE(ADDRESS),
CONSTRAINT FK_tblAccount_Gender FOREIGN KEY([GENDER]) REFERENCES GENDER([ID]),
CONSTRAINT FK_tblAccount_Address FOREIGN KEY([ADDRESS]) REFERENCES ADDRESS([ID]) ON DELETE SET NULL,
CONSTRAINT CK_tblAccount_Age CHECK ([AGE] > 0 AND [AGE] <100)
)
将其翻译为注释类或[name] .hbm.xml, Hibernate是否支持使用约束名称,否则我必须更改表 每次我创建一个新班级时... 我进行搜索,发现有0条关于约束名称的结果!
Translate it into annotation class or [name].hbm.xml , does Hibernate support to use constraint name or i must alter the tables every time i create a new class ... I searched and i find 0 results about constraint names !!
注释类示例:::
@Id @GeneratedValue(strategy=GenerationType.AUTO)
@Column(name="ID")
// -->>Add Primary Key constraint Name Here !! ???
private int id;
@Column(name="Name")
private String name;
@Column(name="Surname")
private String surname;
@Column(name="age")
// -->>Add Check constraint Name Here !! ???
private String age;
@OneToOne(cascade={CascadeType.ALL},fetch=FetchType.LAZY)
@OnDelete(action=OnDeleteAction.CASCADE)
@JoinColumn(name="Address" , referencedColumnName="id",nullable=false)
// -->>Add Foreign Key constraint Name Here !! ???
private Address address;
推荐答案
在JPA中,您可以使用@Table
批注属性在类级别上执行此操作,并在其中指定约束名称.对于映射到列id
的主键id
:
In JPA, you can do this at class level, using @Table
annotation properties, where you specify constraints names. For primary key id
mapped to column id
:
@Table(uniqueConstraints = @UniqueConstraint(columnNames = "ID", name = "PERSONS_PK_CONSTRAINT"))
这篇关于休眠-约束名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!