一些写法的记录

<delete id="deleteStBzrAppraByIds" parameterType="String">
        delete from ST_BZR_Appra where ID in
        <foreach item="iD" collection="array" open="(" separator="," close=")">
            #{iD}
        </foreach>
</delete>

<selectKey resultType="java.lang.Integer" keyProperty="id" order="AFTER">
      SELECT LAST_INSERT_ID()
</selectKey>

一些依赖

fastJson

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>fastjson</artifactId>
    <version>1.2.66</version>
</dependency>