mybatis批量添加

前几天做项目中遇到了使用批量添加操作，花了一点时间不是很难，就把删除和添加都贴出代码出来

INSERT INTO t_ques_answ
		(notes_code,question,answer)
		SELECT  A.*
		FROM(
		<foreach collection="list" item="item" index="index"
			separator="UNION ALL">
			SELECT
			#{item.notesCode,jdbcType=VARCHAR} notes_code,
			#{item.question,jdbcType=VARCHAR} question,
			#{item.answer,jdbcType=VARCHAR} answer
			FROM dual
		</foreach>
		)A

批量删除

delete t_ques_answ where QUES_ID in
		<foreach collection="list" item="quesId" index="index" open="("
			separator="," close=")">
			#{quesId}
		</foreach>

基于mybatis的框架