一:配置文件如下:
<insert id="insertByList" parameterType="java.util.List" >
insert into ec_custom_question (ID, VERSION, PAPER_ID,
QUESTION_ID, STATUS, CREATED_BY,
creation_date, LAST_UPDATED_BY, LAST_UPDATED_DATE,
ENABLED_FALG, ques_order, model_id
)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.id,jdbcType=INTEGER}, #{item.version,jdbcType=INTEGER}, #{item.paperId,jdbcType=INTEGER},
#{item.questionId,jdbcType=INTEGER}, #{item.status,jdbcType=CHAR}, #{item.createdBy,jdbcType=INTEGER},
#{item.creationDate,jdbcType=TIMESTAMP}, #{item.lastUpdatedBy,jdbcType=INTEGER}, #{item.lastUpdatedDate,jdbcType=TIMESTAMP},
#{item.enabledFalg,jdbcType=CHAR}, #{item.quesOrder,jdbcType=INTEGER}, #{item.modelId,jdbcType