<!--创建/删除临时表-->
<update id="createAREASHIP_SOURCE">
    drop TABLE IF EXISTS AREASHIP_SOURCE;
    CREATE TEMPORARY TABLE AREASHIP_SOURCE (
        YEA_ID Integer,
        PERIOD_NAME CHAR(10),
        THIS_FLAG Integer,
        LAST_FLAG Integer,
        QTY Integer
    )
</update>
<!--插入-->
<insert id="addSAL_AREASHIP_SOURCE" parameterType="java.util.HashMap">
    INSERT INTO SAL_AREASHIP_SOURCE
    VALUES
    <foreach collection="p.values" item="value" open="(" close=")" separator=",">
        #{value}
    </foreach>
</insert>