博客

mybatis复合型数据返回ListString写法

  • Post author:
  • Post category:其他


第一种写法

<resultMap id="roomResultMap" type="com.xs.ishp.afpt.dzdt.pojo.RoomDO">
    <result column="cell_name" jdbcType="VARCHAR" property="cellName"/>
    <result column="main_police_id" jdbcType="VARCHAR" property="mainPoliceId"/>
    <result column="main_police_name" jdbcType="VARCHAR" property="mainPoliceName"/>
    <result column="now_room_num" jdbcType="INTEGER" property="nowRoomNum"/>
    <result column="room_num" jdbcType="INTEGER" property="roomNum"/>
    <result column="risk_num" jdbcType="INTEGER" property="riskNum"/>
    <result column="room_percentage" jdbcType="FLOAT" property="roomPercentage"/>
    <collection property="auxiliaryPolice" ofType="com.xs.ishp.afpt.dzdt.pojo.AuxiliaryPoliceDO">
        <result property="auxiliaryPoliceId" jdbcType="VARCHAR" column="auxiliary_police_id"/>
        <result property="auxiliaryPoliceName" jdbcType="VARCHAR" column="aux


版权声明：本文为BBsatan原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。