package com.zr.test_mybatis.test;import java.util.List;import com.zr.test_mybatis.model.DeptInfo;import com.zr.test_mybatis.utils.ManagerSession;public class TestMybatis {public static void main(String[] args) {//根据 deptid 查询单条记录String str = "com.zr.test_mybatis.model.DeptInfo";// DeptInfo deptInfo = ManagerSession.getSession().selectOne(str +".selectById", 1);// System.out.println(deptInfo);// ManagerSession.commitAndCloseSession(ManagerSession.getSession());//// //查询所有的记录// List<DeptInfo> deptInfos = ManagerSession.getSession().selectList(str +".selectAll");// for (DeptInfo deptInfo2 : deptInfos) {// System.out.println(deptInfo2);// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());//执行添加操作// DeptInfo dept = new DeptInfo("006", "小红");// int count = ManagerSession.getSession().insert(str +".addDept", dept);// if(count > 0){// System.out.println("添加成功！");// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());// //执行删除操作// int count1 = ManagerSession.getSession().delete(str+".deleteDept",1);// if(count1 > 0){// System.out.println("删除成功！");// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());////执行更新操作// DeptInfo deptInfo = new DeptInfo("002","猫喵");// int count2 = ManagerSession.getSession().update(str +".updateDept", deptInfo);// if(count2 > 0){// System.out.println("更新成功！");// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());// //一对一关系查询// List<EmpInfo> empInfos = ManagerSession.getSession().selectList(str +".selectEmpAndDeptList");// for (EmpInfo empInfo : empInfos) {// System.out.println(empInfo);// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());//一对多关系查询List<DeptInfo> list = ManagerSession.getSession().selectList(str +".selectDeptAndEmpList");for (DeptInfo deptInfo : list) {System.out.println(deptInfo); }ManagerSession.commitAndCloseSession(ManagerSession.getSession());}}package com.zr.test_mybatis.test;import java.uti
阅读背景：
MyBatis一对一和一对多的关系映射(员工和部门)
来源：互联网
package com.zr.test_mybatis.test;import java.util.List;import com.zr.test_mybatis.model.DeptInfo;import com.zr.test_mybatis.utils.ManagerSession;public class TestMybatis {public static void main(String[] args) {//根据 deptid 查询单条记录String str = "com.zr.test_mybatis.model.DeptInfo";// DeptInfo deptInfo = ManagerSession.getSession().selectOne(str +".selectById", 1);// System.out.println(deptInfo);// ManagerSession.commitAndCloseSession(ManagerSession.getSession());//// //查询所有的记录// List<DeptInfo> deptInfos = ManagerSession.getSession().selectList(str +".selectAll");// for (DeptInfo deptInfo2 : deptInfos) {// System.out.println(deptInfo2);// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());//执行添加操作// DeptInfo dept = new DeptInfo("006", "小红");// int count = ManagerSession.getSession().insert(str +".addDept", dept);// if(count > 0){// System.out.println("添加成功！");// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());// //执行删除操作// int count1 = ManagerSession.getSession().delete(str+".deleteDept",1);// if(count1 > 0){// System.out.println("删除成功！");// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());////执行更新操作// DeptInfo deptInfo = new DeptInfo("002","猫喵");// int count2 = ManagerSession.getSession().update(str +".updateDept", deptInfo);// if(count2 > 0){// System.out.println("更新成功！");// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());// //一对一关系查询// List<EmpInfo> empInfos = ManagerSession.getSession().selectList(str +".selectEmpAndDeptList");// for (EmpInfo empInfo : empInfos) {// System.out.println(empInfo);// }// ManagerSession.commitAndCloseSession(ManagerSession.getSession());//一对多关系查询List<DeptInfo> list = ManagerSession.getSession().selectList(str +".selectDeptAndEmpList");for (DeptInfo deptInfo : list) {System.out.println(deptInfo); }ManagerSession.commitAndCloseSession(ManagerSession.getSession());}}package com.zr.test_mybatis.test;import java.uti
分享到：
