1.在对应的对象类中定义属性为Date类型
private Timestamp start_time;
private Timestamp end_time;
2.对应xml的写法
<insert id="insert" parameterType="java.util.ArrayList">
MERGE INTO TABLE_NAME A USING (
<foreach collection="list" item="item" index="index" separator="UNION">
SELECT
#{item.id , jdbcType=VARCHAR} ID ,
#{item.start_time , jdbcType=TIMESTAMP} START_TIME ,
#{item.end_time , jdbcType=TIMESTAMP} END_TIME
FROM DUAL
</foreach>
) B ON (
A.ID= B.ID
)
WHEN NOT MATCHED THEN
INSERT (
ID ,
START_TIME ,
END_TIME
)
VALUES (
B.ID ,
B.START_TIME ,
B.END_TIME
)
</insert>