mybatis关联查询

1. 关联部分列：

<resultMap id="BaseResultMap" type="com.test.entity.ContractBase">
  <id column="id" jdbcType="BIGINT" property="id" />
  <result column="contract_name" jdbcType="VARCHAR" property="contractName" />

<!-- 关联查询-->
<result column="project_name" jdbcType="VARCHAR" property="projectName" />
<result column="project_code" jdbcType="VARCHAR" property="projectCode" />

<select id="selectById" resultMap="BaseResultMap">
  select c.*, p.project_name,p.project_code
  from contract_base c
  left join opm.project_info p on c.project_id = p.id
  where c.id = #{id}
</select>

2. 关联整个表：

<resultMap id="ResultMap" type="com.test.Order" >

  <association property="goResource" column="go_resource_id" select="com.test.mapper.OrderResourceMapper.selectByPrimaryKey"/>
  <association property="backResource" column="back_resource_id" select="com.test.mapper.OrderResourceMapper.selectByPrimaryKey"/>

<select id="selectByCondition" resultMap="ResultMap">
  select *
  from flight_order o
  left join flight_order_resource g on o.go_resource_id=g.id
  left join flight_order_resource b on o.back_resource_id=b.id