mybatis级联插入
两张表:
selftesttitle
id name de pic_url
selftestquestion
id title_id question view_order
<insert id="insertSTT" useGeneratedKeys="true" keyProperty="id"
parameterType="SelfTestTitle">
INSERT INTO selftesttitle(`id`, `name`, `de`,`pic_url`)
VALUES(#{id},
#{name}, #{de},#{picUrl})
<selectKey resultType="java.lang.Integer" keyColumn="id" keyProperty="id" order="AFTER" >
SELECT LAST_INSERT_ID() AS id
</selectKey>
INSERT INTO selftestquestion(`id`,`titile_id`,`question`,`view_order`)
<foreach collection="questionList" item="item" index="index"
separator=" UNION ALL ">
(SELECT #{item.id} , #{id},
#{item.question},
#{item.viewOrder})
</foreach>
</insert>
一直不能成功能,请问如何修改