<InsertId="Insertgoodsdescription" Parameterclass="Goodsdescription"> <Selectkey ResultClass="int"Keyproperty="Servicedescriptionid"> SELECTGoods_description_seq.nextval asservice_description_id fromDual</Selectkey> Insert intoproduct_service_description (service_description_id, Label_name, Label_icon, Label_des Cription, Sort_num, product_id, Is_default, Is_delete, Add_time, add_user_id, Edit_time, edit_user_id)Values(#serviceDescriptionId #, #labelName #, #labelIcon #, #labelDescription #, NVL (#sortNu m#, (SELECT MAX(Sort_num)+ 1 fromproduct_service_description)),<!--#sortNum #,-->#productId #, #isDefault #,'N', #addTime #, #addUserId #, #editTime #, #editUserId #)</Insert>
<!--Add a group activity -- <InsertId="Save"ParameterType="Weixinactivity"> INSERT intoweixin_activity (Weixin_name, Banner_img_url, Start_time, End_time, Group_price, DISCO Unt_lab, Minimum_join_member_num, order_by, Is_status, Begin_wait_time, add_user_id, Edit_time, Is_delete, Add_time, edit_user_id)Values(#{weixinname}, #{bannerimgurl}, #{starttime}, #{endtime}, #{groupprice}, #{discountlab}, # {Minimumjoinmembernum}, Ifnull (#{sortby}, (SELECTID from ( SELECT MAX(order_by)+ 1 asID fromweixin_activity ) (t)),<!--(SELECT ID from--<!--(SELECT MAX (order_by) + 1 as ID from weixin_activity) t),#{isstatus}, #{beginwaittime}, #{adduserid}, #{edittime},'N', #{addtime}, #{edituserid})</Insert>
Oracle sort field self-growth