假设应用场景如下:Node与PageServer是一对一的关系,其中,Node类对应node表如下:
PageServer类对应page_server表如下:
两个类分别如下:
- CREATE TABLE `node` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `node` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
PageServer类对应page_server表如下:
- CREATE TABLE `pageserver` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) DEFAULT NULL,
- `node_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- CONSTRAINT `fk_reference_67` FOREIGN KEY (`node_id`) REFERENCES `node` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `pageserver` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`node_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
CONSTRAINT `fk_reference_67` FOREIGN KEY (`node_id`) REFERENCES `node` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
两个类分别如下:
- public class Node {
- private PageServer pageServer;//PageServer实体
- @OneToOne(mappedBy = "node", fetch = FetchType.LAZY)
- public PageServer getPageServer() {
- return pageServer;
- }
- public void setPageServer(PageServer pageServer) {
- this.pageServer = pageServer;
- }
- }
public class Node {
private PageServer pageServer;//PageServer实体
@OneToOne(mappedBy = "node", fetch = FetchType.LAZY)
public PageServer getPageServer() {
return pageServer;
}
public void setPageServer(PageServer pageServer) {
this.pageServer = pageServer;
}
}