mybatis association查询怎么使用？

按网上的实验了好多一个都没成功的

<resultMap id="ShopifyProduct" type="xxxx.model.ShopifyProduct" >
  <id column="id" property="id" jdbcType="BIGINT" />
  <result column="title" property="title" jdbcType="VARCHAR" />
  <result column="vendor" property="vendor" jdbcType="VARCHAR" />
  <result column="productType" property="productType" jdbcType="VARCHAR" />
  <result column="createTime" property="createTime" jdbcType="TIMESTAMP" />
  <result column="handle" property="handle" jdbcType="VARCHAR" />
  <result column="updateTime" property="updateTime" jdbcType="TIMESTAMP" />
  <result column="publishTime" property="publishTime" jdbcType="TIMESTAMP" />
  <result column="templateSuffix" property="templateSuffix" jdbcType="VARCHAR" />
  <result column="publishedScope" property="publishedScope" jdbcType="VARCHAR" />
  <result column="tags" property="tags" jdbcType="VARCHAR" />

  <association property="image" column="imageId" select="getImgById">
  </association>

</resultMap>

<resultMap id="img" type="coxxxxapi.model.ShopifyProductImage" >
  <id column="id" property="id" jdbcType="BIGINT" />
  <result column="src" property="src" jdbcType="VARCHAR" />
</resultMap>

0个评论

1个牛币 mybatis association查询 mybatis查询语法

所有回答列表(1)

mq7410p123 LV3 2016年7月12日

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.batis.classes.bean">   
   <select id="getClass" parameterType="int" resultMap="getMap"> 
       select * from classes c,teacher t where c.teacher_id = #{teacherId} and c.teacher_id=t.id;
   </select>
   <resultMap type="Classes" id="getMap">                
       <id property="id" column="id"/>                   
       <result property="name" column="name"/>

</resultMap>
</mapper>

最热评论
最新问答