mybatis基础三

本文主要介绍mybatis一对一,一对多,多对多映射

 

mybatis一对一映射【学生与身份证】

1)创建students.sqlcards.sql 

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

注意:1. 先创建card表,因为它是副表。

2. Students表中要写外键

 

1)创建Students.javaCard.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) {
		this.name = name;
	}
	public Card getCard() {
		return card;
	}
	public void setCard(Card card) {
		this.card = card;
	}
}

1)创建StudentMapper.xmlCardMapper.xml

CardMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="cardNamespace">
	<resultMap type="cn.zc.mybatis.one2one.Card" id="cardMap">
		<id property="id" column="id" />
		<result property="num" column="num" />
	</resultMap>
</mapper>

StudentMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="studentNamespace">
	<resultMap type="cn.zc.mybatis.one2one.Student" id="studentMap">
		<id property="id" column="id" />
		<result property="name" column="name"/>
		<association property="card" resultMap="cardNamespace.cardMap"/>
	</resultMap>
	<select id="findById" parameterType="int" resultMap="studentMap">
		select s.id,s.name,c.id,c.num
		from students s inner join cards c
		on s.cid = c.id 
		and s.id = #{id}
	</select>
</mapper>

注意: select中返回s,c表的内容s.id,s.name,c.id,c.num,所以resultMap="studentMap"

因为,studentMap 中引入

<association property="card" resultMap="cardNamespace.cardMap"/>

所以包含了s.id,s.name,c.id,c.num

 

1)创建StudentCardDao.java 

public class StudentCardDao {
	/**
	 * 查询1号【学生】
	 */
	public Student findById(int id) throws Exception{
		SqlSession sqlSession = null;
		try{
			sqlSession = MybatisUtil.getSqlSession();
			return sqlSession.selectOne("studentNamespace.findById",id);
		}catch(Exception e){
			e.printStackTrace();
			throw e;
		}finally{
			MybatisUtil.closeSqlSession();
		}
	}
	public static void main(String[] args) throws Exception{
		StudentCardDao dao = new StudentCardDao();
		Student student = dao.findById(1);
		System.out.println(student.getId()+":"+student.getName());
		System.out.println(student.getCard().getId()+":"+student.getCard().getNum());
	}
}

mybatis一对多映射【班级与学生】

1)创建grades.sqlstudents.sql

drop table students;
drop table grades;
create table grades(
	gid	int(5)	primary key,
	gname varchar(10)
 );
create table students(
	sid	int(5)	primary key,
	sname varchar(10),
    sgid int(5),
    constraint sgid_fk foreign key(sgid) references grades(gid)
);

注意:一般是多引用单,这里是一个班级多个学生。

 

2)创建Grade.javaStudent.sql

public class Grade {
	private Integer id;
	private String name;
	private List<Student> studentList = new ArrayList<Student>();
	public Grade(){}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public List<Student> getStudentList() {
		return studentList;
	}
	public void setStudentList(List<Student> studentList) {
		this.studentList = studentList;
	}
}

public class Student {
	private Integer id;
	private String name;
	private Grade grade;
	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) {
		this.name = name;
	}
	public Grade getGrade() {
		return grade;
	}
	public void setGrade(Grade grade) {
		this.grade = grade;
	}
}

4)创建GradeMapper.xmlStudentMapper.xml

   GradeMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="gradeNamespace">
	<resultMap type="cn.zc.mybatis.one2many.Grade" id="gradeMap">
		<id property="id" column="gid" />
		<result property="name" column="gname"/>
		<collection property="studentList" resultMap="studentNamespace.studentMap"/>
	</resultMap>
	<select id="findGradeByName" parameterType="string" resultMap="gradeMap">
		select g.gid,g.gname,s.sid,s.sname
		from grades g,students s
		where g.gid = s.sgid
		and s.sname = #{name}
	</select>
</mapper>

StudentMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="studentNamespace">
	<resultMap type="cn.zc.mybatis.one2many.Student" id="studentMap">
		<id property="id" column="sid" />
		<result property="name" column="sname"/>
		<association property="grade" resultMap="gradeNamespace.gradeMap"/>
	</resultMap>
	<select id="findAllByName" parameterType="string" resultMap="studentMap">
		select s.sid,s.sname,g.gid,g.gname
		from grades g,students s
		where g.gid = s.sgid
		and g.gname = #{name}
	</select>
</mapper>

4)创建GradeStudentDao.java

public class GradeStudentDao {
	/**
	 * 查询java班级有哪些【学生】
	 */
	public List<Student> findAllByName(String name) throws Exception{
		SqlSession sqlSession = null;
		try{
			sqlSession = MybatisUtil.getSqlSession();
			return sqlSession.selectList("studentNamespace.findAllByName",name);
		}catch(Exception e){
			e.printStackTrace();
			throw e;
		}finally{
			MybatisUtil.closeSqlSession();
		}
	}
	/**
	 * 查询学生属于哪个【班级】
	 */
	public Grade findGradeByName(String name) throws Exception{
		SqlSession sqlSession = null;
		try{
			sqlSession = MybatisUtil.getSqlSession();
			return sqlSession.selectOne("gradeNamespace.findGradeByName",name);
		}catch(Exception e){
			e.printStackTrace();
			throw e;
		}finally{
			MybatisUtil.closeSqlSession();
		}
	}
	public static void main(String[] args) throws Exception{
		GradeStudentDao dao = new GradeStudentDao();
		List<Student> studentList = dao.findAllByName("java");
		for(Student s  : studentList){
	System.out.println(s.getId()+":"+s.getName()+":"+s.getGrade().getId()+":"+s.getGrade().getName());
		}
		Grade grade = dao.findGradeByName("小强");
		System.out.println(grade.getId()+":"+grade.getName());
	}
}

mybatis多对多映射【学生与课程】

1)创建students.sqlcourses.sqlmiddles.sql

drop table middles;
drop table students;
drop table courses;
create table students(
	sid int(5) primary key,
	sname varchar(10)
);
create table courses(
	cid int(5) primary key,
	cname varchar(10)
);
create table middles(
	sid int(5),
	cid int(5),
	primary key(sid,cid)	
);

注意:这里关键是建立了一个middles,将多对多转化成多对一,一对多。

 

2)创建Student.javaCourse.java

public class Student {
	private Integer id;
	private String name;
	private List<Course> courseList = new ArrayList<Course>();
	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) {
		this.name = name;
	}
	public List<Course> getCourseList() {
		return courseList;
	}
	public void setCourseList(List<Course> courseList) {
		this.courseList = courseList;
	}
}
/**
 * 课程(多方)
 */
public class Course {
	private Integer id;
	private String name;
	private List<Student> studentList = new ArrayList<Student>();
	public Course(){}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public List<Student> getStudentList() {
		return studentList;
	}
	public void setStudentList(List<Student> studentList) {
		this.studentList = studentList;
	}
}

4)创建StudentMapper.xmlCourseMapper.xml

   StudentMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="studentNamespace">
	<resultMap type="cn.zc.mybatis.many2many.Student" id="studentMap">
		<id property="id" column="sid" />
		<result property="name" column="sname"/>
	</resultMap>
	<select id="findStudentByName" parameterType="string" resultMap="studentMap">
		select s.sid,s.sname
		from students s,middles m,courses c
		where s.sid = m.sid 
		and m.cid = c.cid
		and c.cname = #{name}
	</select>
</mapper>

CourseMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="courseNamespace">
	<resultMap type="cn.zc.mybatis.many2many.Course" id="courseMap">
		<id property="id" column="cid" />
		<result property="name" column="cname"/>
	</resultMap>
	<select id="findCourseByName" parameterType="string" resultMap="courseMap">
		select c.cid,c.cname
		from students s,middles m,courses c
		where s.sid = m.sid 
		and m.cid = c.cid
		and s.sname = #{name}
	</select>
</mapper>

4)创建StudentCourseDao 

public class StudentCourseDao {
	/**
	 * 查询小强选学的【课程】
	 */
	public List<Course> findCourseByName(String name) throws Exception{
		SqlSession sqlSession = null;
		try{
			sqlSession = MybatisUtil.getSqlSession();
			return sqlSession.selectList("courseNamespace.findCourseByName",name);
		}catch(Exception e){
			e.printStackTrace();
			throw e;
		}finally{
			MybatisUtil.closeSqlSession();
		}
	}
	/**
	 * 查询java课程有哪些【学生】
	 */
	public List<Student> findStudentByName(String name) throws Exception{
		SqlSession sqlSession = null;
		try{
			sqlSession = MybatisUtil.getSqlSession();
			return sqlSession.selectList("studentNamespace.findStudentByName",name);
		}catch(Exception e){
			e.printStackTrace();
			throw e;
		}finally{
			MybatisUtil.closeSqlSession();
		}
	}
	public static void main(String[] args) throws Exception{
		StudentCourseDao dao = new StudentCourseDao();
		//List<Course> courseList = dao.findCourseByName("小强");
		//for(Course c : courseList){
		//	System.out.println(c.getId()+":"+c.getName());
		//}
		List<Student> studentList = dao.findStudentByName("java");
		for(Student s : studentList){
			System.out.println(s.getId()+":"+s.getName());
		}
	}	 
}
本文很多内容都是参考网友的资料,自己整理了一下,加入了一点自己的感想而已,设为原创主要想赚点C币,谅解








阅读更多
个人分类: mybatis
上一篇mybatis基础二
下一篇【转】夯实JAVA基本之二 —— 反射(1):基本类周边信息获取
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭