178-链接查询association

<resultMap id="BaseResultMap" type="com.bjpowernode.fastdfs.model.CreditorInfo">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="real_name" jdbcType="VARCHAR" property="realName" />
    <result column="id_card" jdbcType="VARCHAR" property="idCard" />
    <result column="address" jdbcType="VARCHAR" property="address" />
    <result column="sex" jdbcType="INTEGER" property="sex" />
    <result column="phone" jdbcType="VARCHAR" property="phone" />
    <result column="money" jdbcType="DECIMAL" property="money" />
    <!--给我们返回的实体类添加一个引用属性对象,而且将数据库表的字段值分别放到相对应属性的值,如将grpup_name的值放到groupName属性上->
    <association property="creditorFile" javaType="com.bjpowernode.fastdfs.model.CreditorFile">
      <id column="cfid" property="id"></id>
      <result column="group_name" property="groupName"></result>
      <result column="remote_file" property="remoteFile"></result>
      <result column="file_size" property="fileSize"></result>
      <result column="old_filename" property="oldFilename"></result>
      <result column="ci_id" property="ciId"></result>
    </association>
  </resultMap>

 

posted on 2020-05-17 07:43  十年磨三劍  阅读(120)  评论(0编辑  收藏  举报

导航