mybatis動態插入清單::
<insert id="savePrpcitemkindList" parameterType="java.util.List">insert into prpcitemkind(RISKCODE, ITEMKINDNO, FAMILYNO, FAMILYNAME, PROJECTCODE, CLAUSECODE,CLAUSENAME,KINDCODE, KINDNAME, ITEMNO, ITEMCODE, ITEMDETAILNAME, GROUPNO, MODECODE,MODENAME, STARTDATE,STARTHOUR, ENDDATE, ENDHOUR, MODEL, BUYDATE, ADDRESSNO, CALCULATEFLAG, CURRENCY,UNITAMOUNT,QUANTITY, UNIT, VALUE, AMOUNT, RATEPERIOD, RATE, SHORTRATEFLAG, SHORTRATE,PREPREMIUM, CALPREMIUM,BASEPREMIUM, BENCHMARKPREMIUM, DISCOUNT, ADJUSTRATE, UNITPREMIUM, PREMIUM,DEDUCTIBLERATE, DEDUCTIBLE,FLAG, Inserttime Forhis,OperatiTemeTimeForhis,稅收貨物,稅收Flag,稅收Fee,NetPremium,netpremium,taxfee_gb,castfee_lb,alltaxfee,alltaxfee,allnetpremium,proposalno)<foreach collection =“ list” list'list'item =“ item” itex =“ intex =” index =“ index” index“ sipex” sipex =“ siperex”, test =“ item.riskcode!= null”>#{item.riskCode},</wher> <> <> <> null,</eye> </exect> </select> <選擇> <當test ='test =“ item.itemkindno!= null”>###{item.itemkindno} null“>#{item.familyno},</wher> <否則> null,</eye> </select> </select> <選擇> <wher test =“ test =” null“>#{item.projectCode},</wher> <否> null,</exect> </select> </select> <選擇> <wher test =“ test =” null“>#{item.clauseName},</wher> <否> null,</eye> </select> </select> <選擇> <wher test =“ test =” null“>#{item.kindname},</wher> <否則> null,</er> </exect> </select> <選擇> <當test ='test =“ item.itemno!= null”>##{item.itemno},</wher>> <eyfe> <eyfe> </wher> </wher> null,</eye> null,</feor>> </eflect>> </select> </select> </section> pestect> pestect> pest test =' null“>#{item.itemCode},</wher> <否> null,</eye> </select> </select> <選擇> <wher test =” null“>#{item.groupno},</wher> <否則> null,</eye> </select> </select> <選擇> <wher test =“ test =” null">#{item.modename},</when><otherwise>null,</otherwise></choose><choose><when test="item.startdate != null">#{item.startdate},</when><otherwise>null,</otherwise></choose><choose><when test="item.starthour != null">#{item.starthour},</when><otherwise>null,</otherwise></choose><choose><when test="item.enddate != null">#{item.enddate},</when><otherwise>null,</otherwise></choose><choose><when test="item.endhour != null“>#{item.EndHour},</wher> <否> null,</er> </exect> </select> <選擇> <何時test =“ test =” item.model! = null“>##{item.model},</wher> </wher> <> </wher> </eye> null,</eye> </exect> </select> </select> </select> pecose> pestect> pest test = <何時test =” item.buydate! null“>#{item.buydate},</wher> <否> null,</exect> </select> </select> <選擇> <當test =“ test =” null">#{item.calculateflag},</when><otherwise>null,</otherwise></choose><choose><when test="item.currency != null">#{item.currency},</when><otherwise>null,</otherwise></choose><choose><when test="item.unitamount != null“>#{item.unitamount},</wher> <否> null,</er> </exect> </select> <選擇> <何時test =” null“>#{item.Unit},</wher> <否> null,</eye> </select> </select> <> <何時test =“ test =” test =“ item.value!= null”>#{item.value},</wher> <eyfe> </wher> </wher> </eye> null,</eye> </efect> </select> </select> </select> <當test =“ null">#{item.amount},</when><otherwise>null,</otherwise></choose><choose><when test="item.rateperiod != null">#{item.rateperiod},</when><otherwise>null,</otherwise></choose><choose><when test="item.rate != null">#{item.rate},</when><otherwise>null,</otherwise></choose><choose><when test="item.shortrateflag != null">#{item.shortrateflag},</when><otherwise>null,</otherwise></choose><choose><when test="item.shortrate != null“>#{item.shortrate},</wher> <refe> null,</eye> </replect> </select> <選擇> <wher test =“ test =” null“>#{item.calpremium},</wher> <否> null,</eye> </exect> </select> <選擇> <當test =“ test =” null“>#{item.benchmarkPremium},</wher> <否則> null,</eye> </select> </select> <選擇> <wher test =“ test =” null“>#{item.adjustrate},</wher> <否> null,</eye> </replect> </select> <選擇> <wher test =' null">#{item.premium},</when><otherwise>null,</otherwise></choose><choose><when test="item.deductiblerate != null">#{item.deductiblerate},</when><otherwise>null,</otherwise></choose><choose><when test="item.deductible != null“>#{item.deDuctible},</wher> <否則> null,</eye> </select> </select> <選擇> <wher test =“ test =” item.flag! = null“>#{item.flag},</wher> </wher> <> </wher> null,</er> null,</exect> </select> </select> </select> </select> <當wher wher test ='itex =“ item.Interttime fore forhis! ”! null“>#{item.Inserttimeforhis},</wher> <否> null,</exect> </select> </select> <選擇> <當test =“ test =” item.operateTimeforhis! = null“>#{item.operatemptimeforhis} null">#{item.taxrate},</when><otherwise>null,</otherwise></choose><choose><when test="item.taxflag != null">#{item.taxflag},</when><otherwise>null,</otherwise></choose><choose><when test="item.taxfee != null">#{item.taxfee},</when><otherwise>null,</otherwise></choose><choose><when test="item.netpremium != null">#{item.netpremium},</when><otherwise>null,</otherwise></choose><choose><when test="item.taxfee_gb != null“>#{item.taxfee_gb},</wher> <否> null,</exect> </exect> <選擇> <選擇> <wher test =“ test =” null“>#{item.AllTaxFee},</wher> <否> null,</eye> </exect> <選擇> <選擇> <wher test =“ test =”mybatis傳入清單::
Java代碼
// dao代碼,也一樣void insertdefaultmsg(@param(“ idslist”)arraylist <string> idslist); // xml <<update id =“ insertDefaultMSG” parameteType =“ java.util.list”> fording plf_pur_delivery_plan p set p.promise_delivery_amount = p.quantity_req,p.promise_delivery_time_time = p.quantity_time = p.quantity_time = p.quantity_time = open =“(“ close =”)“ index =“”>#{item,jdbctype = varchar} </foreach> </update> </update> // service代碼map <string,string,string> map = bean.getDatas()。 get()。 get(0);字符串IDS = map.get(“ ids”); string [] idsarr = ids.split(“,”);字符串inid =“”; for(int i = 0; i <idsarr.length; i ++){if(i!= idsarr.length -1){inid +=“'” +idsarr [i] +“'',”; } else {inid + =“'” + idsarr [i] +“'”; }} list <map <字符串,字符串>> list = purdeliveryplandao .getPlanListManual(inid); // dao層代碼列表<map <string,字符串>> getPlanListManual(@param(“ inid”)字符串indid); // xml <<select id =“ getPlanListManual” parameteType =“ java.lang.string” resulttype =“ java.util.map”>選擇p.supplier_code,p.pur_order_code,p.pur_order_no,if(p.update_times> 0,p.update_times> 0,plan plan plan plan p plan plfan plfan plfan p p fut plfan p p fut plfan p pe y'修改訂單p.is_notice ='0'and p.is_delete ='1'和p.id in(<![cdata [$ {inid}]]>)組由p.supplier_code,p.pur_order_no訂單,p.supplier_code </select>總結
以上所述是小編給大家介紹的mybatis動態插入列表傳入列表參數的實例代碼,希望對大家有所幫助,如果大家有任何疑問歡迎給我留言,小編會及時回復大家的! ,小編會及時回復大家的!