MyBatis笔记

2019-07-18

记录一下MyBatis配置的笔记。

in条件拼接

<select id="getVoteTemplateKeys" resultMap="VoteTemplateKey" parameterType="java.util.List">
      SELECT *
      FROM TEM T
      WHERE T.ID IN
      <foreach collection="array" item="item" index="index" open="(" separator="," close=")">
          #{item}
      </foreach>
  </select>

多表查询xml

注解的方式：https://blog.csdn.net/qq_40348465/article/details/84718602
1 association：组合的方式
2 collection：集合的方式

<resultMap id="VoCustomer" type="com.entity.VoCustomer" extends="BaseResultMap">
    <association property="voteRecord" javaType="com.entity.Vo">
        <id column="C_RECORD_ID" property="cRecordId"/>
        <result column="N_SCORE" property="nScore"/>
    </association>
    <collection property="keysList" ofType="com.entity.VoGeneral">
        <result column="C_DESC" property="cDesc"/>
        <result column="C_SCORETYPE" property="cScoretype"/>
        <result column="N_ORDER" property="nOrder"/>
    </collection>
</resultMap>

<resultMap id="BaseResultMap" type="cn.com.yusys.tkbb.entity.AddressCompanyCustomer">
    <id column="acid" property="id" />
    <result column="acname" property="name" />
    <collection property="list" ofType="cn.com.yusys.tkbb.entity.AddressDepartmentCustomer">
        <id column="adid" property="id" />
        <result column="adname" property="name" />
        <result column="acid" property="parent" />
        <collection property="list" ofType="cn.com.yusys.tkbb.entity.AddressTeamCustomer">
                <result column="batid" property="id" />
                <result column="batname" property="name" />
                <collection property="list" ofType="cn.com.yusys.tkbb.entity.AddressUserCustomer">
                    <id column="auid" property="id" />
                    <result column="auname" property="name" />
                    <result column="autel" property="tel" />
                    <result column="auemail" property="email" />
                    <result column="aufax" property="fax" />
                    <result column="aumemo" property="memo" />
            </collection>
        </collection>
    </collection>
</resultMap>

java中在mybatis的配置文件中使用两个foreach问题

没有验证，不应该写的：https://blog.csdn.net/qq_20565303/article/details/79762351
“id” />