1、一对一介绍
学生—学生证 用户---身份证 夫妻
案例:查询某个用户的基本信息,包括其身份证信息
sql: select p.*,c.cnumber,c.vlidatedate from person p,card c where p.cid=c.cid and p.personid=1
2、一对一案例
(1)创建数据库person表和card表
DROP TABLE IF EXISTS `card`;
CREATE TABLE `card` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`cnumber` varchar(255) DEFAULT NULL,
`vlidatedate` date DEFAULT NULL,
PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=10003 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of card
-- ----------------------------
INSERT INTO `card` VALUES ('10001', '140622199908326539', '2030-09-01');
INSERT INTO `card` VALUES ('10002', '1460887339w833333X', '2026-09-01');
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`personid` int(11) NOT NULL AUTO_INCREMENT,
`pname` varchar(255) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`cid` int(11) DEFAULT NULL,
PRIMARY KEY (`personid`),
KEY `cid` (`cid`),
CONSTRAINT `person_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `card` (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of person
-- ----------------------------
INSERT INTO `person` VALUES ('1', '小岳岳', '36', '10001');
INSERT INTO `person` VALUES ('2', '辣目洋子', '29', '10002');
(2)编写Person和Card实体类
(3) 编写sql语句
(4)编写接口方法
(5)测试