Ibatis insert语句中包含子查询问题

Ibatis中的Insert语句，将values采用select代替

[sql] view plaincopy

1. <insert id="insertFaqContinue">  
2.         INSERT INTO FAQ (   
3.         <dynamic prepend="">  
4.             <isNotNull prepend="," property="topicID"> topicID </isNotNull>  
5.             <isNotNull prepend="," property="listID"> listID </isNotNull>  
6.             <isNotNull prepend="," property="topicID"> faqfloor </isNotNull>  
7.         </dynamic>  
8.         )  
9.         SELECT   
10.         <dynamic prepend="">  
11.             <isNotNull prepend="," property="topicID"> #topicID# </isNotNull>  
12.             <isNotNull prepend="," property="listID"> #listID# </isNotNull>  
13.             <isNotNull prepend="," property="title"> #title# </isNotNull>  
14.             <isNotNull prepend="," property="topicID"> (SELECT count(faqID)+1 FROM FAQ WHERE topicID = #topicID#) </isNotNull>  
15.         </dynamic>  
16.           
17.         <selectKey resultClass="int" keyProperty="faqID" >  
18.             SELECT @@IDENTITY AS faqID  
19.         </selectKey>  
20.     </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>