1.创建数据库表stu,stu_card
stu表:
stu_card表
学生表与学生卡是一对一的关系
2.创建项目chapter03,并导入相关jar包
总项目结构如下:
StuCard.java
package com.qfedu.pojo;
public class StuCard {
private int cid;
private double balance;
public StuCard() {
super();
// TODO Auto-generated constructor stub
}
public StuCard(int cid, double balance) {
super();
this.cid = cid;
this.balance = balance;
}
public int getCid() {
return cid;
}
public void setCid(int cid) {
this.cid = cid;
}
public double getBalance() {
return balance;
}
public void setBalance(double balance) {
this.balance = balance;
}
@Override
public String toString() {
return "StuCard [cid=" + cid + ", balance=" + balance + "]";
}
}
Stu.java
package com.qfedu.pojo;
public class Stu {
private int sid;
private String sname;
private String age;
private String course;
private StuCard sc;
public int getSid() {
return sid;
}
public void setSid(int sid) {
this.sid = sid;
}
public String getSname() {
return sname;
}
public void setSname(String sname) {
this.sname = sname;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getCourse() {
return course;
}
public void setCourse(String course) {
this.course = course;
}
public StuCard getSc() {
return sc;
}
public void setSc(StuCard sc) {
this.sc = sc;
}
@Override
public String toString() {
return "Stu [sid=" + sid + ", sname=" + sname + ", age=" + age + ", course=" + course + ", sc=" + sc + "]";
}
}
StuCardMapper.xml
select * from stu_card where cid = #{cid}
StuMapper.xml
StuMapper.xml
mybatis-config.xml
TestOneToOne.java
package com.qfedu.test;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.*;
import com.qfedu.pojo.*;
public class TestOneToMany {
public static void main(String[] args) throws Exception {
InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);
SqlSession session = sessionFactory.openSession();
// 使用MyBatis查询cid为1的班级信息(包括该班级的学生信息)
StuClass stuClass = session.selectOne("stuClass.findStuClassByCid", 1);
System.out.println("班级ID:" + stuClass.getCid() + "n班级名称:" + stuClass.getCname() + "n班级人数:" + stuClass.getSum()
+ "n学生信息:");
List stuInfoList = stuClass.getStuInfoList();
for (StuInfo stuInfo : stuInfoList) {
System.out.println(stuInfo);
}
session.close();
}
}
一对多
1.创建数据库表stu_class,stu_info表
stu_class表
stu_info表
班级与学生是一对多的关系
StuInfo.java
package com.qfedu.pojo;
public class StuInfo {
private int sid;
private String sname;
private String age;
private String course;
public int getSid() {
return sid;
}
public void setSid(int sid) {
this.sid = sid;
}
public String getSname() {
return sname;
}
public void setSname(String sname) {
this.sname = sname;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getCourse() {
return course;
}
public void setCourse(String course) {
this.course = course;
}
@Override
public String toString() {
return "Stu [sid=" + sid + ", sname=" + sname + ", age=" + age + ", " + " course=" + course + "]";
}
}
StuClass.java
package com.qfedu.pojo;
import java.util.List;
public class StuClass {
private Integer cid;
private String cname;
private Integer sum;
private List stuInfoList;
public Integer getCid() {
return cid;
}
public void setCid(Integer cid) {
this.cid = cid;
}
public String getCname() {
return cname;
}
public void setCname(String cname) {
this.cname = cname;
}
public Integer getSum() {
return sum;
}
public void setSum(Integer sum) {
this.sum = sum;
}
public List getStuInfoList() {
return stuInfoList;
}
public void setStuInfoList(List stuInfoList) {
this.stuInfoList = stuInfoList;
}
}
StuClassMapper.xml
TestOneToMany.java
package com.qfedu.test;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.*;
import com.qfedu.pojo.*;
public class TestOneToMany {
public static void main(String[] args) throws Exception {
InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);
SqlSession session = sessionFactory.openSession();
// 使用MyBatis查询cid为1的班级信息(包括该班级的学生信息)
StuClass stuClass = session.selectOne("stuClass.findStuClassByCid", 1);
System.out.println("班级ID:" + stuClass.getCid() + "n班级名称:" + stuClass.getCname() + "n班级人数:" + stuClass.getSum()
+ "n学生信息:");
List stuInfoList = stuClass.getStuInfoList();
for (StuInfo stuInfo : stuInfoList) {
System.out.println(stuInfo);
}
session.close();
}
}
多对多
1.创建数据库表class_info,class_teach表
class_info表:
class_teach表:
班级与老师是多对多的关系
TeachInfo.java
package com.qfedu.pojo;
import java.util.List;
public class TeachInfo {
private Integer tid;
private String tname;
private String age;
private String course;
private List classInfoList;
public Integer getTid() {
return tid;
}
public void setTid(Integer tid) {
this.tid = tid;
}
public String getTname() {
return tname;
}
public void setTname(String tname) {
this.tname = tname;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getCourse() {
return course;
}
public void setCourse(String course) {
this.course = course;
}
public List getClassInfoList() {
return classInfoList;
}
public void setClassInfoList(List classInfoList) {
this.classInfoList = classInfoList;
}
@Override
public String toString() {
return "TeachInfo [tid=" + tid + ", tname=" + tname + ", age=" + age + ", course=" + course + ", classInfoList="
+ classInfoList + "]";
}
}
ClassInfo.java
package com.qfedu.pojo;
import java.util.List;
public class ClassInfo {
private Integer cid;
private String cname;
private Integer sum;
private List teachInfoList;
public Integer getCid() {
return cid;
}
public void setCid(Integer cid) {
this.cid = cid;
}
public String getCname() {
return cname;
}
public void setCname(String cname) {
this.cname = cname;
}
public Integer getSum() {
return sum;
}
public void setSum(Integer sum) {
this.sum = sum;
}
public List getTeachInfoList() {
return teachInfoList;
}
public void setTeachInfoList(List teachInfoList) {
this.teachInfoList = teachInfoList;
}
@Override
public String toString() {
return "ClassInfo [cid=" + cid + ", cname=" + cname + ", sum=" + sum + ", teachInfoList=" + teachInfoList + "]";
}
}
ClassInfoMapper.xml
TestManyToMany.java
package com.qfedu.test;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.*;
import com.qfedu.pojo.*;
public class TestManyToMany {
public static void main(String[] args) throws Exception {
InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);
SqlSession session = sessionFactory.openSession();
// 使用MyBatis查询cid为1的班级信息(包括该班级的教师信息)
ClassInfo classInfo = session.selectOne("classInfo.findClassInfoByCid", 1);
System.out.println("班级ID:" + classInfo.getCid() + "n班级名称:" + classInfo.getCname() + "n班级人数:"
+ classInfo.getSum() + "n教师信息:");
List teachInfoList = classInfo.getTeachInfoList();
for (TeachInfo teachInfo : teachInfoList) {
System.out.println(teachInfo.toString());
}
session.close();
}
}
主键映射
TestAddStuClass.java
package com.qfedu.test;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.*;
import com.qfedu.pojo.StuClass;
public class TestAddStuClass {
public static void main(String[] args) throws Exception {
InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);
SqlSession session = sessionFactory.openSession();
StuClass stuClass = new StuClass();
stuClass.setCname("Javaweb");
stuClass.setSum(50);
// 使用MyBatis插入一条班级信息
//int result = session.insert("stuClass.addStuClass01", stuClass);
int result = session.insert("stuClass.addStuClass02",stuClass );
if (result > 0) {
System.out.println("成功插入" + result + "条数据");
System.out.println("插入数据的主键cid为:" + stuClass.getCid());
} else {
System.out.println("插入操作失败");
}
// 提交事务
session.commit();
// 关闭SqlSession
session.close();
}
}



