栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

MyBatis的关联映射

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

MyBatis的关联映射

一对一

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




	
		select s.*, c.balance from stu s, stu_card c where s.cardid
		= c.cid
		and s.sid = #{sid}
	
	
		
		
		
		
		
			
			
		
	

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




	
		select c.*,t.* from class_info c ,teach_info t, class_teach
		ct where
		c.cid=ct.class_id
		and ct.teach_id = t.tid and c.cid = #{cid}
	
	
		
		
		
		
			
			
			
			
		
	

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();
	}
}

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/937742.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号