<insert id="addType" parameterClass="uploadFileTypeBean">
insert into upload_files_type
(id,
name,
pid,
type,
orderVal)
values
(SQ_UPLOAD_FILES_TYPE.nextval,
#name#,
#pId#,
#type#,
#orderVal#)
<selectKey resultClass="string" keyProperty="id">
select
SQ_UPLOAD_FILES_TYPE.currval as id from dual
</selectKey>
</insert>
insert into upload_files_type
(id,
name,
pid,
type,
orderVal)
values
(SQ_UPLOAD_FILES_TYPE.nextval,
#name#,
#pId#,
#type#,
#orderVal#)
<selectKey resultClass="string" keyProperty="id">
select
SQ_UPLOAD_FILES_TYPE.currval as id from dual
</selectKey>
</insert>