在mysql建表时可以设置联合主键,现在要建一个一个user表,user表中有三个字段username,usergroup,sex,将username与usergroup设置为联合主键,建表法如下:
CREATE TABLE `user` (
`usergroup` varchar(20) NOT NULL,
`username` varchar(20) NOT NULL,
`sex` varchar(20) DEFAULT NULL,
PRIMARY KEY (`usergroup`,`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
在Hibernate下设置联合主键的方式很多,具体参考:http://my.oschina.net/yotoo/blog/265571,本文采用比较常用的方式。
1)首先编写PrimaryKey的主类,在主类中包含联合主键的字段,涉及到的关键字是@Embeddable
@Embeddable
public class IdPk implements Serializable{
private static final long serialVersionUID = 1001961579189516481L;
@Column(length=20,name="username")
private String username;
@Column(length=20,name="usergroup")
private String usergroup;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUsergroup() {
return usergroup;
}
public void setUsergroup(String usergroup) {
this.usergroup = usergroup;
}
}
2)编写model
@Entity
@Table(name = "user")
public class User {
@EmbeddedId
private IdPk idPk;
@Column(length=20,name = "sex")
private String Sex;
public IdPk getIdPk() {
return idPk;
}
public void setIdPk(IdPk idPk) {
this.idPk = idPk;
}
public String getSex() {
return Sex;
}
public void setSex(String sex) {
Sex = sex;
}
}
如此配置就完成了联合主键的设置(文章简略做笔记之用)