mysql知识点

 - 循环map插入key和value

int insert(Map<String,Object> params);

实际是循环Map<String，Map<String,String>>
phyMap,userid是params的key

<insert id="insertPhy"  parameterType="java.util.HashMap">
    INSERT INTO table (id,userid,key,value) VALUES
    <foreach collection="phyMap" index="key" item="value" separator="," >
       ((SELECT CONCAT(DATE_FORMAT(NOW(),'%Y%m%d%H%i%s'),REPLACE(UUID(),'-','')) AS ID), 
       #{userid, jdbcType=VARCHAR},
       #{key, jdbcType=VARCHAR},
       #{value, jdbcType=VARCHAR}) 
    </foreach>
</insert>

大于号、小于号转译
<![CDATA[ < ]]>、<![CDATA[ > ]]>

循环List

<foreach collection="roleUserList" item="roleUser" separator="," >
	      ((SELECT CONCAT(DATE_FORMAT(NOW(),'%Y%m%d%H%i%s'),REPLACE(UUID(),'-','')) AS ID),
	      #{roleUser.roleid, jdbcType=VARCHAR},
	      #{roleUser.userid, jdbcType=VARCHAR})
</foreach>

循环数组[]

<foreach collection="uuid" item="id"  open="(" close=")" separator=",">
    		#{id,jdbcType=VARCHAR}
</foreach>