Ibatis中的Insert语句,将values采用select代替
- <insert id="insertFaqContinue">
- INSERT INTO FAQ (
- <dynamic prepend="">
- <isNotNull prepend="," property="topicID"> topicID </isNotNull>
- <isNotNull prepend="," property="listID"> listID </isNotNull>
- <isNotNull prepend="," property="topicID"> faqfloor </isNotNull>
- </dynamic>
- )
- SELECT
- <dynamic prepend="">
- <isNotNull prepend="," property="topicID"> #topicID# </isNotNull>
- <isNotNull prepend="," property="listID"> #listID# </isNotNull>
- <isNotNull prepend="," property="title"> #title# </isNotNull>
- <isNotNull prepend="," property="topicID"> (SELECT count(faqID)+1 FROM FAQ WHERE topicID = #topicID#) </isNotNull>
- </dynamic>
- <selectKey resultClass="int" keyProperty="faqID" >
- SELECT @@IDENTITY AS faqID
- </selectKey>
- </insert>
分析:整体结构为Insert into select 语句,select 语句中包含子查询
<insert id="insertSubjectRelDemand" parameterClass="subjectreldemand">
insert into dsp_subject_reldemand (no,subject_no,demand_no,version)
select dsp_subject_reldemand_seq.nextval,#subject_no#,#demand_no#,(select version from dsp_subject where no = #subject_no#) from dual
</insert>
<!-- 插入一条历史编辑内容 -->
<insert id="insertSubjectHistory" parameterClass="subjectHistory">
insert into dsp_hstry (sub_no,editer_no,edit_date,descr,sqls,caliber,clasy,version,edit_des)
(select no,cre_no,edit_date,descr,sqls,caliber,clasy,version,cre_des as edit_des from dsp_subject where no = #no#)
</insert>