mybatis学习笔记2.docxVIP

第十六章 回顾SQL99中的连接查询 1）内连接 2）外连接 3）自连接 第十七章 回顾hibernate多表开发1）一对一2）一对多3）多对多第十八章 mybatis一对一映射【学生与身份证】1）参见一对一图示.JPG2）创建students.sql和cards.sql drop table students;drop table cards;create table cards(idint(5)primary key,num varchar(20));create table students(idint(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）创建Students.java和Card.java public class Card {private Integer id;private String num;private Student student;public Card(){}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getNum() {return num;}public void setNum(String num) {this.num = num;}public Student getStudent() {return student;}public void setStudent(Student student) {this.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) {this.id = id;}public String getName() {return name;}public void setName(String name) { = name;}public Card getCard() {return card;}public void setCard(Card card) {this.card = card;}}4）创建StudentMapper.xml和CardMapper.xml CardMapper.xml?xml version=1.0 encoding=UTF-8 ?!DOCTYPE mapper PUBLIC -////DTD Mapper 3.0//EN/dtd/mybatis-3-mapper.dtdmapper namespace=cardNamespaceresultMap type=cn.itcast.javaee.mybatis.one2one.Card id=cardMapid property=id column=id /result property=num column=num //resultMap/mapper StudentMapper.xml?xml version=1.0 encoding=UTF-8 ?!DOCTYPE mapper PUBLIC -////DTD Mapper 3.0//EN/dtd/mybatis-3-mapper.dtdmapper namespace=studentNamespaceresultMap type=cn.itcast.javaee.mybatis.one2one.Student id=studentMapid property=id column=id /result property=name column=name/association property=card resultMap=cardNamespace.cardMap//resultMapselect id=findById parameterType=int resultMap=studentMapselect s.id,,c.id,c.numfrom students s inner join cards con s.cid = c.id and s