<mapper namespace="com.iotek.rbacapp.mapper.QuestionMapper">
<insert id="addQuestionFromExcel" parameterType="java.util.List" useGeneratedKeys="true" keyProperty="id">
insert into questions(typeQ,questionTittle,selectionA,selectionB,selectionC,selectionD,paperId,creator)
values
<foreach collection="list" item="items" index="index" separator=",">
(
#{items.typeQ},
#{items.questionTittle},
#{items.selectionA},#{items.selectionB},#{items.selectionC},#{items.selectionD},
#{items.paperId},
#{items.creator}
)
</foreach>
</insert>
</mapper>
mybatis添加对象数组到数据库
最新推荐文章于 2024-05-01 13:57:38 发布