1. 出入参对应
int getIndexAllRedUnreadCount(@Param("list") List<Long> msgFirstTypeId,
@Param("userCode") String userCode);
<select id="getIndexAllRedUnreadCount" resultType="int">
void batchInsert(List<MsgDetail> list);
<insert id="batchInsert">
List<MsgList4AllFirstTypeResp> msgList4AllFirstType(@Param("userCode") String userCode);
<select id="msgList4AllFirstType" resultMap="MsgList4AllFirstTypeResp" parameterType="string">
2. 语法类
循环
<if test="list != null and list.size > 0">
AND msg_first_type_id IN
<foreach collection="list" item="item" separator="," open="(" close=")">
#{item}
</foreach>
</if>
判空
<if test="list != null and list.size > 0">
</if>
<if test="xwCode != null and xwCode != ''">
</if>
转义
<![CDATA[ 符号 ]]>
<if test="param.gmtCreateEnd != null and param.gmtCreateEnd != ''">
AND a.gmt_create <![CDATA[ <= ]]> #{param.gmtCreateEnd}
</if>