mybatis文件映射之利用association进行关联查询之分步查询（三）

发布时间：2020-12-14 18:02:52 所属栏目：大数据来源：网络整理

导读：上一节我们有Employee.java和Department.java 有EmployeeMapper.java和EmployeeMapper.xml 现在新增：DepartmentMapper.java和DepartmentMapper.xml EmployeeMapper接口中有这么一个方法： public Employee getEmpByIdStep(Integer id); DepartmentMapper接

上一节我们

有Employee.java和Department.java

有EmployeeMapper.java和EmployeeMapper.xml

现在新增：DepartmentMapper.java和DepartmentMapper.xml

EmployeeMapper接口中有这么一个方法：

public Employee getEmpByIdStep(Integer id);

DepartmentMapper接口中有这么一个方法：

public Department getDeptById(Integer id);

DepartmentMapper.xml中：

<mapper namespace="com.gong.mybatis.dao.DepartmentMapper">
    select id="getDeptById" resultType="com.gong.mybatis.bean.Department">
        select * from tbl_department where id=#{id}
    </select>
mapper>

EmployeeMapper.xml中

="com.gong.mybatis.dao.EmployeeMapperPlus">
    
    resultMap type="com.gong.mybatis.bean.Employee" id="MySimpleByStep">
        id column="id" property="id"/>
        result ="last_name"="lastName"association property="dept" select="com.gong.mybatis.dao.DepartmentMapper.getDeptById"
        column="d_id">            
        associationresultMap="getEmpByIdStep" resultMap
        select * from tbl_employee where id=#{id}
    >
    
>

说明：我们直接对association中的属性进行操作。property属性还是指定所需要关联的Employee类中的成员属性的名称。select属性对应着DepartmentMapper.xml中的getDeptById方法。column属性对应着传入到该方法中的参数，由于tbl_employee中的d_id字段是和tbl_department中的Id字段相关联，我们可以传入d_id。

最后进行测试：

package com.gong.mybatis.test;

import java.io.IOException;
 java.io.InputStream;
 java.util.Map;

 org.apache.ibatis.io.Resources;
 org.apache.ibatis.session.SqlSession;
 org.apache.ibatis.session.SqlSessionFactory;
 org.apache.ibatis.session.SqlSessionFactoryBuilder;
 org.junit.Test;

 com.gong.mybatis.bean.Department;
 com.gong.mybatis.bean.Employee;
 com.gong.mybatis.dao.DepartmentMapper;
 com.gong.mybatis.dao.EmployeeMapperPlus;

public class TestMybatis2 {
    
    public SqlSessionFactory getSqlSessionFactory() throws IOException {
        String resource = "mybatis-config.xml";
        InputStream is = Resources.getResourceAsStream(resource);
        return new SqlSessionFactoryBuilder().build(is);
    }

    @Test
    void test()  IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        try {
            EmployeeMapperPlus mapper = openSession.getMapper(EmployeeMapperPlus.);
            Employee employee = mapper.getEmpByIdStep(3);
            System.out.println(employee);
            System.out.println(employee.getDept());
            openSession.commit();
        } finally {
            openSession.close();
        }
        
    }
}

输出：

DEBUG 01-20 14:36:37,371 ==> Parameters: 3(Integer) (BaseJdbcLogger.java:145)
DEBUG 01-20 14:36:37,413 ====> Preparing: select * from tbl_department where id=? (BaseJdbcLogger.java:145)
DEBUG 01-20 14:36:37,414 ====> Parameters: 1(Integer) (BaseJdbcLogger.java:145)
DEBUG 01-20 14:36:37,418 <==== Total: 1 (BaseJdbcLogger.java:145)
DEBUG 01-20 14:36:37,419 <== Total: 1 (BaseJdbcLogger.java:145)
Employee [id=3,lastName=小红,gender=0,email=xiaohong@qq.com,dept=Department [id=1,deptName=开发部]]
Department [id=1,deptName=开发部]

说明通过这种方式也是可以成功的。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!