文档介绍:.
实用文档.
第十六章 回忆SQL99中的连接查询
1〕内连接
2〕外连接
3〕自连接
第十七章 回忆hibernate多表开发
1〕一对一
2〕一对多
3〕多对多
第十八章 mybatis一对一映射【学生与身份证】
1〕参见<<>>
2〕
drop table students;
drop table cards;
create table cards(
id int(5) primary key,
num varchar(20)
);
create table students(
id int(5) primary key,
name varchar(10),
cid int(5),
constraint cid_fk foreign key(cid) references cards(id)
);
insert into cards(id,num) values(1,'111');
.
实用文档.
insert into students(id,name,cid) values(1,'哈哈',1);
3〕
public class Card {
private Integer id;
private String num;
private Student student;
public Card(){}
public Integer getId() {
return id;
}
public void setId(Integer id) {
= id;
}
public String getNum() {
return num;
}
public void setNum(String num) {
= num;
}
public Student getStudent() {
return student;
}
public void setStudent(Student student) {
= student;
}
}
public class Student {
private Integer id;
private String name;
private Card card;
public Student(){}
public Integer getId() {
return id;
}
public void setId(Integer id) {
= id;
}
public String getName() {
return name;
}
public void setName(String name) {
= name;
}
.
实用文档.
public Card getCard() {
return card;
}
public void setCard(Card card) {
= card;
}
}
4〕
<?xml version="" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-////DTD Mapper //EN"
" ://-3-">
<mapper namespace="cardNamespace">
<resultMap type="" id="cardMap">
<id property="id" column="id" />
<result property="num" column="num" />
</resultMap>
</mapper>
<?xml version="" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-////DTD Mapper //EN"
" ://-3-