mybatis那些事

1.字符串相等

or

不能直接等

2，直接跑sql


${sql}


3.result嵌入 list

<resultMap id="FencePointInfo" type="com.xgit.iot.dao.entity.alarmManage.GeoFencePointDO">
    <id column="fence_point_id" property="fencePointId" />
    <result column="fp_fence_id" property="fenceId" />
</resultMap>

4.result返回嵌对象

<resultMap id="GeoFenceDO" type="com.xgit.iot.dao.entity.alarmManage.GeoFenceDO">
    <id column="fence_id" property="fenceId" />
    <result column="detail_address" property="detailAddress"/>
</resultMap>