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 put plfan, 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动态插入列表传入列表参数的实例代码,希望对大家有所帮助,如果大家有任何疑问欢迎给我留言,小编会及时回复大家的!,小编会及时回复大家的!