pom.xml<\/p>\n\n\n\n
<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n <modelVersion>4.0.0<\/modelVersion>\n\n <groupId>top.qaqaq.mybatis<\/groupId>\n <artifactId>MyBatis_demo3<\/artifactId>\n <version>1.0-SNAPSHOT<\/version>\n <packaging>jar<\/packaging>\n\n <name>MyBatis_demo3<\/name>\n <url>http:\/\/maven.apache.org<\/url>\n\n <properties>\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\n <\/properties>\n\n <dependencies>\n <dependency>\n <groupId>junit<\/groupId>\n <artifactId>junit<\/artifactId>\n <version>3.8.1<\/version>\n <scope>test<\/scope>\n <\/dependency>\n\n <!-- Mybatis\u6838\u5fc3 -->\n <dependency>\n <groupId>org.mybatis<\/groupId>\n <artifactId>mybatis<\/artifactId>\n <version>3.5.7<\/version>\n <\/dependency>\n <!-- junit\u6d4b\u8bd5 -->\n <dependency>\n <groupId>junit<\/groupId>\n <artifactId>junit<\/artifactId>\n <version>4.12<\/version>\n <scope>test<\/scope>\n <\/dependency>\n <!-- MySQL\u9a71\u52a8 -->\n <dependency>\n <groupId>mysql<\/groupId>\n <artifactId>mysql-connector-java<\/artifactId>\n <version>8.0.31<\/version>\n <\/dependency>\n <!-- log4j\u65e5\u5fd7 -->\n <dependency>\n <groupId>log4j<\/groupId>\n <artifactId>log4j<\/artifactId>\n <version>1.2.17<\/version>\n <\/dependency>\n\n <\/dependencies>\n<\/project>\n<\/code><\/pre>\n\n\n\nresources<\/p>\n\n\n\n
mybatis-config.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE configuration\n PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\"\n \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\n<configuration>\n\n <properties resource=\"jdbc.properties\"\/>\n\n <!--\u8bbe\u7f6eMyBatis\u7684\u5168\u5c40\u914d\u7f6e-->\n <settings>\n <!--\u5c06_\u81ea\u52a8\u6620\u5c04\u4e3a\u9a7c\u5cf0\uff0cemp_name:empName-->\n <setting name=\"mapUnderscoreToCamelCase\" value=\"true\"\/>\n <!--\u5f00\u542f\u5ef6\u8fdf\u52a0\u8f7d-->\n <setting name=\"lazyLoadingEnabled\" value=\"true\"\/>\n <\/settings>\n\n <typeAliases>\n <package name=\"top.qaqaq.mybatis.pojo\"\/>\n <\/typeAliases>\n\n <environments default=\"development\">\n <environment id=\"development\">\n <transactionManager type=\"JDBC\"\/>\n <dataSource type=\"POOLED\">\n <property name=\"driver\" value=\"${jdbc.driver}\"\/>\n <property name=\"url\" value=\"${jdbc.url}\"\/>\n <property name=\"username\" value=\"${jdbc.username}\"\/>\n <property name=\"password\" value=\"${jdbc.password}\"\/>\n <\/dataSource>\n <\/environment>\n <\/environments>\n\n <mappers>\n <package name=\"top.qaqaq.mybatis.mapper\"\/>\n <\/mappers>\n<\/configuration><\/code><\/pre>\n\n\n\njdbc.properties<\/p>\n\n\n\n
jdbc.driver=com.mysql.cj.jdbc.Driver\njdbc.url=jdbc:mysql:\/\/localhost:3306\/mybatis\njdbc.username=root\njdbc.password=123456\n<\/code><\/pre>\n\n\n\nlog4j.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE log4j:configuration SYSTEM \"log4j.dtd\">\n<log4j:configuration xmlns:log4j=\"http:\/\/jakarta.apache.org\/log4j\/\">\n <appender name=\"STDOUT\" class=\"org.apache.log4j.ConsoleAppender\">\n <param name=\"Encoding\" value=\"UTF-8\" \/>\n <layout class=\"org.apache.log4j.PatternLayout\">\n <param name=\"ConversionPattern\" value=\"%-5p %d{MM-dd HH:mm:ss,SSS}%m (%F:%L) \\n\" \/>\n <\/layout>\n <\/appender>\n <logger name=\"java.sql\">\n <level value=\"debug\" \/>\n <\/logger>\n <logger name=\"org.apache.ibatis\">\n <level value=\"info\" \/>\n <\/logger>\n <root>\n <level value=\"debug\" \/>\n <appender-ref ref=\"STDOUT\" \/>\n <\/root>\n<\/log4j:configuration><\/code><\/pre>\n\n\n\nresources\/mapper<\/p>\n\n\n\n
EmpMapper.xml<\/strong><\/h3>\n\n\n\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"top.qaqaq.mybatis.mapper.EmpMapper\">\n\n <!--\n resultMap\uff1a\u8bbe\u7f6e\u81ea\u5b9a\u4e49\u6620\u5c04\u5173\u7cfb\n id\uff1a\u552f\u4e00\u6807\u8bc6\uff0c\u4e0d\u80fd\u91cd\u590d\n type\uff1a\u8bbe\u7f6e\u6620\u5c04\u5173\u7cfb\u4e2d\u7684\u7c7b\u578b\n \u5b50\u6807\u7b7e\uff1a\n id\uff1a\u8bbe\u7f6e\u4e3b\u952e\u7684\u6620\u5c04\u5173\u7cfb\n result\uff1a\u8bbe\u7f6e\u666e\u901a\u5b57\u6bb5\u7684\u6620\u5c04\u5173\u7cfb\n \u5c5e\u6027\uff1a\n property\uff1a\u8bbe\u7f6e\u6620\u5c04\u5173\u7cfb\u4e2d\u7684\u5c5e\u6027\u540d\uff0c\u5fc5\u987b\u662ftype\u5c5e\u6027\u6240\u8bbe\u7f6e\u7684\u5b9e\u4f53\u7c7b\u7c7b\u578b\u4e2d\u7684\u5c5e\u6027\u540d\n column\uff1a\u8bbe\u7f6e\u6620\u5c04\u5173\u7cfb\u4e2d\u7684\u5b57\u6bb5\u540d\uff0c\u5fc5\u987b\u662fsql\u8bed\u53e5\u67e5\u8be2\u51fa\u7684\u5b57\u6bb5\u540d\n\n -->\n <resultMap id=\"empResultMap\" type=\"Emp\">\n <id property=\"eid\" column=\"eid\"><\/id>\n <result property=\"empName\" column=\"emp_name\"><\/result>\n <result property=\"age\" column=\"age\"><\/result>\n <result property=\"sex\" column=\"sex\"><\/result>\n <result property=\"email\" column=\"email\"><\/result>\n <\/resultMap>\n\n <!--List<Emp> getAllEmp();-->\n <select id=\"getAllEmp\" resultMap=\"empResultMap\">\n select * from t_emp\n <\/select>\n\n <!--\u5904\u7406\u591a\u5bf9\u4e00\u6620\u5c04\u5173\u7cfb\u65b9\u5f0f\u4e00\uff1a\u7ea7\u8054\u5c5e\u6027\u8d4b\u503c-->\n <resultMap id=\"empAndDeptResultMapOne\" type=\"Emp\">\n <id property=\"eid\" column=\"eid\"><\/id>\n <result property=\"empName\" column=\"emp_name\"><\/result>\n <result property=\"age\" column=\"age\"><\/result>\n <result property=\"sex\" column=\"sex\"><\/result>\n <result property=\"email\" column=\"email\"><\/result>\n <result property=\"dept.did\" column=\"did\"><\/result>\n <result property=\"dept.deptName\" column=\"dept_name\"><\/result>\n <\/resultMap>\n\n <!--\u5904\u7406\u591a\u5bf9\u4e00\u6620\u5c04\u5173\u7cfb\u65b9\u5f0f\u4e8c\uff1a\u7ea7\u8054\u5c5e\u6027\u8d4b\u503c-->\n <resultMap id=\"empAndDeptResultMapTwo\" type=\"Emp\">\n <id property=\"eid\" column=\"eid\"><\/id>\n <result property=\"empName\" column=\"emp_name\"><\/result>\n <result property=\"age\" column=\"age\"><\/result>\n <result property=\"sex\" column=\"sex\"><\/result>\n <result property=\"email\" column=\"email\"><\/result>\n <!--\n association:\u5904\u7406\u591a\u5bf9\u4e00\u7684\u6620\u5c04\u5173\u7cfb\n property:\u9700\u8981\u5904\u7406\u591a\u5bf9\u4e00\u6620\u5c04\u5173\u7cfb\u7684\u5c5e\u6027\u540d\n javaType:\u8be5\u5c5e\u6027\u7684\u7c7b\u578b\n -->\n <association property=\"dept\" javaType=\"Dept\">\n <id property=\"did\" column=\"did\"><\/id>\n <result property=\"deptName\" column=\"dept_name\"><\/result>\n <\/association>\n <\/resultMap>\n\n <!--Emp getEmpAndDept(@Param(\"eid\") Integer eid);-->\n <select id=\"getEmpAndDept\" resultMap=\"empAndDeptResultMapTwo\">\n select * from t_emp left join t_dept on t_emp.did = t_dept.did where t_emp.eid = #{eid}\n <\/select>\n\n <resultMap id=\"empAndDeptByStepResultMap\" type=\"Emp\">\n <id property=\"eid\" column=\"eid\"><\/id>\n <result property=\"empName\" column=\"emp_name\"><\/result>\n <result property=\"age\" column=\"age\"><\/result>\n <result property=\"sex\" column=\"sex\"><\/result>\n <result property=\"email\" column=\"email\"><\/result>\n <!--\n select:\u8bbe\u7f6e\u5206\u6b65\u67e5\u8be2\u7684sql\u7684\u552f\u4e00\u6807\u8bc6\uff08namespace.SQLId\u6216mapper\u63a5\u53e3\u7684\u5168\u7c7b\u540d\uff0c\u65b9\u6cd5\u540d\uff09\n column:\u8bbe\u7f6e\u5206\u6b65\u67e5\u8be2\u7684\u6761\u4ef6\n fetchType:\u5f53\u5f00\u542f\u4e86\u5168\u5c40\u7684\u5ef6\u8fdf\u52a0\u8f7d\u4ee5\u540e\uff0c\u53ef\u901a\u8fc7\u6b64\u5c5e\u6027\u624b\u52a8\u63a7\u5236\u5ef6\u8fdf\u52a0\u8f7d\u7684\u6548\u679c\n fetchType=\"lazy|eager\":lazy\u8868\u793a\u5ef6\u8fdf\u52a0\u8f7d\uff0ceager\u8868\u793a\u7acb\u5373\u52a0\u8f7d\n -->\n <association property=\"dept\"\n select=\"top.qaqaq.mybatis.mapper.DeptMapper.getEmpAndDeptByStepTwo\"\n column=\"did\"\n fetchType=\"eager\"><\/association>\n <\/resultMap>\n <!--Emp getEmpAndDeptByStepOne(@Param(\"eid\") Integer eid);-->\n <select id=\"getEmpAndDeptByStepOne\" resultMap=\"empAndDeptByStepResultMap\">\n select * from t_emp where eid = #{eid}\n <\/select>\n\n <select id=\"getAllEmpOld\" resultType=\"Emp\">\n <!--select eid, emp_name empName, age, sex, email from t_emp-->\n select * from t_emp\n <\/select>\n\n <!--List<Emp> getDeptAndEmpByStepTwo(@Param(\"did\") Integer did);-->\n <select id=\"getDeptAndEmpByStepTwo\" resultType=\"Emp\">\n select * from t_emp where did = #{did}\n <\/select>\n\n<\/mapper><\/code><\/pre>\n\n\n\nDeptMapper.xml<\/strong><\/h3>\n\n\n\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"top.qaqaq.mybatis.mapper.DeptMapper\">\n\n <!--Dept getEmpAndDeptByStepTwo(@Param(\"did\") Integer did);-->\n <select id=\"getEmpAndDeptByStepTwo\" resultType=\"Dept\">\n select * from t_dept where did = #{did}\n <\/select>\n\n <resultMap id=\"deptAndEmpResultMap\" type=\"Dept\">\n <id property=\"did\" column=\"did\"><\/id>\n <result property=\"deptName\" column=\"dept_name\"><\/result>\n <!--\n collection\uff1a\u5904\u7406\u4e00\u5bf9\u591a\u7684\u6620\u5c04\u5173\u7cfb\n ofType\uff1a\u8868\u793a\u8be5\u5c5e\u6027\u6240\u5bf9\u5e94\u7684\u96c6\u5408\u4e2d\u5b58\u50a8\u6570\u636e\u7684\u7c7b\u578b\n -->\n <collection property=\"emps\" ofType=\"Emp\">\n <id property=\"eid\" column=\"eid\"><\/id>\n <result property=\"empName\" column=\"emp_name\"><\/result>\n <result property=\"age\" column=\"age\"><\/result>\n <result property=\"sex\" column=\"sex\"><\/result>\n <result property=\"email\" column=\"email\"><\/result>\n <\/collection>\n <\/resultMap>\n <!--Dept getDeptAndEmp(@Param(\"did\") Integer did);-->\n <select id=\"getDeptAndEmp\" resultMap=\"deptAndEmpResultMap\">\n select * from t_dept left join t_emp on t_dept.did = t_emp.did where t_dept.did = #{did}\n <\/select>\n\n <resultMap id=\"deptAndEmpByStepResultMap\" type=\"Dept\">\n <id property=\"did\" column=\"did\"><\/id>\n <result property=\"deptName\" column=\"dept_name\"><\/result>\n <!--\n select:\u8bbe\u7f6e\u5206\u6b65\u67e5\u8be2\u7684sql\u7684\u552f\u4e00\u6807\u8bc6\uff08namespace.SQLId\u6216mapper\u63a5\u53e3\u7684\u5168\u7c7b\u540d\uff0c\u65b9\u6cd5\u540d\uff09\n column:\u8bbe\u7f6e\u5206\u6b65\u67e5\u8be2\u7684\u6761\u4ef6\n fetchType:\u5f53\u5f00\u542f\u4e86\u5168\u5c40\u7684\u5ef6\u8fdf\u52a0\u8f7d\u4ee5\u540e\uff0c\u53ef\u901a\u8fc7\u6b64\u5c5e\u6027\u624b\u52a8\u63a7\u5236\u5ef6\u8fdf\u52a0\u8f7d\u7684\u6548\u679c\n fetchType=\"lazy|eager\":lazy\u8868\u793a\u5ef6\u8fdf\u52a0\u8f7d\uff0ceager\u8868\u793a\u7acb\u5373\u52a0\u8f7d\n -->\n <collection property=\"emps\"\n select=\"top.qaqaq.mybatis.mapper.EmpMapper.getDeptAndEmpByStepTwo\"\n column=\"did\"\n fetchType=\"eager\"><\/collection>\n <\/resultMap>\n <!--Dept getDeptAndEmpByStepOne(@Param(\"did\") Integer did);-->\n <select id=\"getDeptAndEmpByStepOne\" resultMap=\"deptAndEmpByStepResultMap\">\n select * from t_dept where did = #{did}\n <\/select>\n\n<\/mapper><\/code><\/pre>\n\n\n\nmapper<\/p>\n\n\n\n
EmpMapper .java<\/strong><\/h3>\n\n\n\npackage top.qaqaq.mybatis.mapper;\n\nimport org.apache.ibatis.annotations.Param;\nimport top.qaqaq.mybatis.pojo.Emp;\n\nimport java.util.List;\n\npublic interface EmpMapper {\n\n \/**\n * \u67e5\u8be2\u6240\u6709\u7684\u5458\u5de5\u4fe1\u606f\n *\/\n List<Emp> getAllEmp();\n\n \/**\n * \u67e5\u8be2\u5458\u5de5\u4ee5\u53ca\u5458\u5de5\u6240\u5bf9\u5e94\u7684\u90e8\u95e8\u4fe1\u606f\n *\/\n Emp getEmpAndDept(@Param(\"eid\") Integer eid);\n\n \/**\n * \u901a\u8fc7\u5206\u6b65\u67e5\u8be2\u67e5\u8be2\u5458\u5de5\u4ee5\u53ca\u5458\u5de5\u6240\u5bf9\u5e94\u7684\u90e8\u95e8\u4fe1\u606f\n * \u5206\u6b65\u67e5\u8be2\u7b2c\u4e00\u6b65\uff1a\u67e5\u8be2\u5458\u5de5\u4fe1\u606f\n *\/\n Emp getEmpAndDeptByStepOne(@Param(\"eid\") Integer eid);\n\n \/**\n * \u901a\u8fc7\u5206\u6b65\u67e5\u8be2\u67e5\u8be2\u90e8\u95e8\u4ee5\u53ca\u90e8\u95e8\u4e2d\u6240\u6709\u7684\u5458\u5de5\u4fe1\u606f\n * \u5206\u6b65\u67e5\u8be2\u7b2c\u4e8c\u6b65\uff1a\u6839\u636edid\u67e5\u8be2\u5458\u5de5\u4fe1\u606f\n *\/\n List<Emp> getDeptAndEmpByStepTwo(@Param(\"did\") Integer did);\n}\n<\/code><\/pre>\n\n\n\nDeptMapper .java<\/strong><\/h3>\n\n\n\npackage top.qaqaq.mybatis.mapper;\n\nimport org.apache.ibatis.annotations.Param;\nimport top.qaqaq.mybatis.pojo.Dept;\n\npublic interface DeptMapper {\n\n \/**\n * \u901a\u8fc7\u5206\u6b65\u67e5\u8be2\u67e5\u8be2\u5458\u5de5\u4ee5\u53ca\u5458\u5de5\u6240\u5bf9\u5e94\u7684\u90e8\u95e8\u4fe1\u606f\n * \u5206\u6b65\u67e5\u8be2\u7b2c\u4e8c\u6b65\uff1a\u901a\u8fc7did\u67e5\u8be2\u5458\u5de5\u6240\u5bf9\u5e94\u7684\u90e8\u95e8\n *\/\n Dept getEmpAndDeptByStepTwo(@Param(\"did\") Integer did);\n\n \/**\n * \u83b7\u53d6\u90e8\u95e8\u4ee5\u53ca\u90e8\u95e8\u4e2d\u6240\u6709\u7684\u5458\u5de5\u4fe1\u606f\n *\/\n Dept getDeptAndEmp(@Param(\"did\") Integer did);\n\n \/**\n * \u901a\u8fc7\u5206\u6b65\u67e5\u8be2\u67e5\u8be2\u90e8\u95e8\u4ee5\u53ca\u90e8\u95e8\u4e2d\u6240\u6709\u7684\u5458\u5de5\u4fe1\u606f\n * \u5206\u6b65\u67e5\u8be2\u7b2c\u4e00\u6b65\uff1a\u67e5\u8be2\u90e8\u95e8\u4fe1\u606f\n *\/\n Dept getDeptAndEmpByStepOne(@Param(\"did\") Integer did);\n\n}\n<\/code><\/pre>\n\n\n\npojo<\/p>\n\n\n\n
Emp .java<\/p>\n\n\n\n
package top.qaqaq.mybatis.pojo;\n\npublic class Emp {\n\n private Integer eid;\n private String empName;\n private Integer age;\n private String sex;\n private String email;\n private Dept dept;\n\n public Emp() {\n }\n\n public Emp(Integer eid, String empName, Integer age, String sex, String email) {\n this.eid = eid;\n this.empName = empName;\n this.age = age;\n this.sex = sex;\n this.email = email;\n }\n\n public Integer getEid() {\n return eid;\n }\n\n public void setEid(Integer eid) {\n this.eid = eid;\n }\n\n public String getEmpName() {\n return empName;\n }\n\n public void setEmpName(String empName) {\n this.empName = empName;\n }\n\n public Integer getAge() {\n return age;\n }\n\n public void setAge(Integer age) {\n this.age = age;\n }\n\n public String getSex() {\n return sex;\n }\n\n public void setSex(String sex) {\n this.sex = sex;\n }\n\n public String getEmail() {\n return email;\n }\n\n public void setEmail(String email) {\n this.email = email;\n }\n\n public Dept getDept() {\n return dept;\n }\n\n public void setDept(Dept dept) {\n this.dept = dept;\n }\n\n @Override\n public String toString() {\n return \"Emp{\" +\n \"eid=\" + eid +\n \", empName='\" + empName + '\\'' +\n \", age=\" + age +\n \", sex='\" + sex + '\\'' +\n \", email='\" + email + '\\'' +\n \", dept=\" + dept +\n '}';\n }\n\n}\n<\/code><\/pre>\n\n\n\nDept .java<\/p>\n\n\n\n
package top.qaqaq.mybatis.pojo;\n\nimport java.util.List;\n\npublic class Dept {\n\n private Integer did;\n private String deptName;\n private List<Emp> emps;\n\n public Dept() {\n }\n\n public Dept(Integer did, String deptName) {\n this.did = did;\n this.deptName = deptName;\n }\n\n public Integer getDid() {\n return did;\n }\n\n public void setDid(Integer did) {\n this.did = did;\n }\n\n public String getDeptName() {\n return deptName;\n }\n\n public void setDeptName(String deptName) {\n this.deptName = deptName;\n }\n\n public List<Emp> getEmps() {\n return emps;\n }\n\n public void setEmps(List<Emp> emps) {\n this.emps = emps;\n }\n\n @Override\n public String toString() {\n return \"Dept{\" +\n \"did=\" + did +\n \", deptName='\" + deptName + '\\'' +\n \", emps=\" + emps +\n '}';\n }\n}\n<\/code><\/pre>\n\n\n\nutils<\/p>\n\n\n\n
SqlSessionUtils .java<\/p>\n\n\n\n
package top.qaqaq.mybatis.utils;\n\nimport org.apache.ibatis.io.Resources;\nimport org.apache.ibatis.session.SqlSession;\nimport org.apache.ibatis.session.SqlSessionFactory;\nimport org.apache.ibatis.session.SqlSessionFactoryBuilder;\n\nimport java.io.IOException;\nimport java.io.InputStream;\n\npublic class SqlSessionUtils {\n\n public static SqlSession getSqlSession() {\n SqlSession sqlSession = null;\n try {\n InputStream is = Resources.getResourceAsStream(\"mybatis-config.xml\");\n SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);\n sqlSession = sqlSessionFactory.openSession(true);\n } catch (IOException e) {\n throw new RuntimeException(e);\n }\n return sqlSession;\n }\n}\n<\/code><\/pre>\n\n\n\ntest<\/p>\n\n\n\n
ResultMapTest .java<\/strong><\/h3>\n\n\n\nimport org.apache.ibatis.session.SqlSession;\nimport org.junit.Test;\nimport top.qaqaq.mybatis.mapper.DeptMapper;\nimport top.qaqaq.mybatis.mapper.EmpMapper;\nimport top.qaqaq.mybatis.pojo.Dept;\nimport top.qaqaq.mybatis.pojo.Emp;\nimport top.qaqaq.mybatis.utils.SqlSessionUtils;\n\nimport java.util.List;\n\npublic class ResultMapTest {\n\n \/**\n * \u89e3\u51b3\u5b57\u6bb5\u540d\u548c\u5c5e\u6027\u540d\u4e0d\u4e00\u81f4\u7684\u60c5\u51b5\uff1a\n * a>\u4e3a\u5b57\u6bb5\u8d77\u522b\u540d\uff0c\u4fdd\u6301\u548c\u5c5e\u6027\u540d\u7684\u4e00\u81f4\n * b>\u8bbe\u7f6e\u5168\u5c40\u914d\u7f6e\uff0c\u5c06_\u81ea\u52a8\u6620\u5c04\u4e3a\u9a7c\u5cf0\n * <setting name=\"mapUnderscoreToCamelCase\" value=\"true\"\/>\n * c>\u901a\u8fc7resultMap\u8bbe\u7f6e\u81ea\u5b9a\u4e49\u7684\u6620\u5c04\u5173\u7cfb\n *<resultMap id=\"empResultMap\" type=\"Emp\">\n * <id property=\"eid\" column=\"eid\"><\/id>\n * <result property=\"empName\" column=\"emp_name\"><\/result>\n * <result property=\"age\" column=\"age\"><\/result>\n * <result property=\"sex\" column=\"sex\"><\/result>\n * <result property=\"email\" column=\"email\"><\/result>\n *<\/resultMap>\n *\n * \u5904\u7406\u591a\u5bf9\u4e00\u7684\u6620\u5c04\u5173\u7cfb\uff1a\n * a>\u7ea7\u8054\u5c5e\u6027\u8d4b\u503c\n * b>association\n * c>\u5206\u6b65\u67e5\u8be2\n *\n * \u5904\u7406\u4e00\u5bf9\u591a\u7684\u6620\u5c04\u5173\u7cfb\n * a>collection\n * b>\u5206\u6b65\u67e5\u8be2\n *\/\n\n @Test\n public void testGetEmpAndDeptByStep() {\n SqlSession sqlSession = SqlSessionUtils.getSqlSession();\n EmpMapper mapper = sqlSession.getMapper(EmpMapper.class);\n Emp emp = mapper.getEmpAndDeptByStepOne(3);\n System.out.println(emp.getEmpName());\n System.out.println(\"++++++++++++++++++++++++++++++++++\");\n System.out.println(emp.getDept());\n }\n\n @Test\n public void testGetEmpAndDept() {\n SqlSession sqlSession = SqlSessionUtils.getSqlSession();\n EmpMapper mapper = sqlSession.getMapper(EmpMapper.class);\n Emp emp = mapper.getEmpAndDept(3);\n System.out.println(emp);\n }\n\n @Test\n public void testGetAllEmp() {\n SqlSession sqlSession = SqlSessionUtils.getSqlSession();\n EmpMapper mapper = sqlSession.getMapper(EmpMapper.class);\n List<Emp> list = mapper.getAllEmp();\n list.forEach(emp -> System.out.println(emp));\n }\n\n @Test\n public void testGetDeptAndEmp() {\n SqlSession sqlSession = SqlSessionUtils.getSqlSession();\n DeptMapper mapper = sqlSession.getMapper(DeptMapper.class);\n Dept dept = mapper.getDeptAndEmp(1);\n System.out.println(dept);\n }\n\n @Test\n public void testGetDeptAndEmpByStep() {\n SqlSession sqlSession = SqlSessionUtils.getSqlSession();\n DeptMapper mapper = sqlSession.getMapper(DeptMapper.class);\n Dept dept = mapper.getDeptAndEmpByStepOne(1);\n System.out.println(dept.getDeptName());\n }\n}\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"pom.xml resources mybatis-config.xml jdbc.properties lo […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[108],"tags":[111],"class_list":["post-3109","post","type-post","status-publish","format-standard","hentry","category-mybatis-code","tag-mybatis"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3109"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3109"}],"version-history":[{"count":3,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3109\/revisions"}],"predecessor-version":[{"id":3118,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3109\/revisions\/3118"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}