case mybatis 不同表_MyBatis 级联

最新推荐文章于 2021-02-06 15:07:43 发布

adamlam99

最新推荐文章于 2021-02-06 15:07:43 发布

阅读量112

点赞数

文章标签： case mybatis 不同表

本文链接：https://blog.csdn.net/weixin_32804237/article/details/112201433

版权

数据库关系模型中有一对一,一对多,关系,

首先建立如下表继续用最经典的学生管理系统

建表

模型图如图所示

学生表为中心

学生证表和其为一对一关系

学生表和课程表为一对多

一对一关系

因为上图中,学生和学生关系为一对一关系.

由于是数据库的一对一关系,那么对应的bean中,也应该是一对一关系

举栗子的表为学生表和学生证表

其中学生证表的中的学生编号的外键为学生表的主键

那么在学生表的POJO对象中,应该有学生证表的POJO的映射.即

package com.ming.MyBatis.POJO;/** * @author ming */public class Student { private int uid; private String studentName; private String gender; private String studentIdNumber; private String remarks; private StudentCard studentCard; public void setStudentCard(StudentCard studentCard) { this.studentCard = studentCard; } public StudentCard getStudentCard() { return studentCard; } public void setUid(int uid) { this.uid = uid; } public void setStudentName(String studentName) { this.studentName = studentName; } public void setGender(String gender) { this.gender = gender; } public void setStudentIdNumber(String studentIdNumber) { this.studentIdNumber = studentIdNumber; } public void setRemarks(String remarks) { this.remarks = remarks; } public int getUid() { return uid; } public String getStudentName() { return studentName; } public String getGender() { return gender; } public String getStudentIdNumber() { return studentIdNumber; } public String getRemarks() { return remarks; }}

对于card的POJO如下所示

package com.ming.MyBatis.POJO;import java.util.Date;/** * @author ming */public class StudentCard { private int uid; private String studentNumber; private String birthplace; private Date dateOfIssue; private Date endDate; private String remarks; public void setUid(int uid) { this.uid = uid; } public void setStudentNumber(String studentNumber) { this.studentNumber = studentNumber; } public void setBirthplace(String birthplace) { this.birthplace = birthplace; } public void setDateOfIssue(Date dateOfIssue) { this.dateOfIssue = dateOfIssue; } public void setEndDate(Date endDate) { this.endDate = endDate; } public void setRemarks(String remarks) { this.remarks = remarks; } public int getUid() { return uid; } public String getStudentNumber() { return studentNumber; } public String getBirthplace() { return birthplace; } public Date getDateOfIssue() { return dateOfIssue; } public Date getEndDate() { return endDate; } public String getRemarks() { return remarks; }}

先增加StudentCard的配置

SELECT student_card.uid, student_card.student_number, student_card.remarks,student_card.end_date, student_card.date_of_issue, student_card.birthplaceFROM student_card WHERE student_card.uid = #{studentId};

再增加Student的映射

SELECT student.uid, student.gender, student.remarks, student.student_id_number,student.student_nameFROM studentWHERE student.uid = 1;

可以看到当查询到studentCard的时候,将会调用com.ming.MyBatis.RoleMapper.findStudentSelfCardByStudentId sql语句的执行

对于数据展示层来说

`Hello World!`

 students = null; for(int i = 0; i < 10; i++) { try { sqlSession = SqlSessionFactoryUtil.openSqlSesion(); RoleMapper roleMapper = sqlSession.getMapper(RoleMapper.class); students = roleMapper.getStudent(1); sqlSession.commit(); } catch (Exception e) { e.printStackTrace(); sqlSession.rollback(); } finally { if (sqlSession != null) { sqlSession.close(); } } } long endTime = System.currentTimeMillis(); //获取结束时间%>