1.在对象类中将该属性定义为String类型
private String id;
private String name;
private String age;
private String describe;//该属性为CLOB类型
2.在对应的xml中写下相应的SQL语句
<insert id="insert" parameterType="java.util.ArrayList">
<foreach collection="list" item="item" index="index" open="begin" close="end;">
MERGE INTO TABLE_NAME A USING (
SELECT
#{item.id , jdbcType=VARCHAR} ID ,
#{item.name , jdbcType=VARCHAR} NAME ,
#{item.age , jdbcType=VARCHAR} AGE ,
#{item.describe , jdbcType=CLOB} DESCRIBE
FROM DUAL
) B ON (
A.ID= B.ID
)
WHEN NOT MATCHED THEN
INSERT (
ID ,
NAME ,
AGE ,
DESCRIBE
)
VALUES (
B.ID ,
B.NAME ,
B.AGE ,
B.DESCRIBE
);
</foreach>
</insert>