mybatis动态插入リスト的实例代码如下所述:
<ID = "saveprpcitemkindlist" parametertype = "java.util.list"> prpcitemkind(riskcode、itemkindno、familyno、familyname、projectode、clausecode、clausename、dindcode、dindname、itemno、itemdetailname、modecode、modecode、modecode、項目図、項目、項目、項目、項目、項目、項目、項目、emosecode」 StartDate、StarThour、Enddate、Endhour、Model、BuyDate、AddressNo、CalculateFlag、Currency、Unitamount、数量、Unit、Value、額、Rateperiod、Rate、Rate、Rate、Premium、Calpremium、Basepremium、Benchmarkpremium、Discount、Unityustrate、Deductible、Flag、Premustrate、Premustrate、Dectremium、Premustrate、 INSERTTIMEFORHIS、OPERATETIMEFORHIS、TAXRATE、TAXFLAG、TAXFEE、NETPREMIUM、TAXFEE_GB、TAXFEE_LB、ALLTAXFEE、ALLNETPREMIUM、Prosposalno)<foreach Collection = "quite =" item "index =" index "separator =" aall " test = "item.riskCode!= null">#{item.riskCode}、</when> <thing> null、</rething> </choice> </choice> <test = "item.itemkindno!= null"> {item.itemkindno}、 null ">#{item.familyno}、</when> <thent> null、</sids> </choose> <choice> <test =" item.familyname!= null ">#{item.familyname}、</when when> <rets> null、</retsing> </choice> null ">#{item.ProjectCode}、</when> <issed null、</sidte> </choose> <choice> <test =" item.clausecode!= null ">#{item.clausecode}、</when> <> sot null ">#{item.clauseName}、</when> <sisthy> null、</sidte> </choose> <choice> <when test =" item.kindcode!= null ">#{item.kindcode}、</when> <sids> null、</rething> </chook> < null ">#{item.kindname}、</when> <thens> null、</sidte> </choose> <choice> <when test =" item.itemno!= null ">#{item.itemno}、</when </when> <> <> null、</sids </sids> </choice> <choed> <itemcode!= null ">#{item.itemcode}、</when> <issed null、</sids> </choose> <choice> <test =" item.itemdetailname!= null ">#{itemdetailname}、</when when> <diss> null、</rethin </> < null ">#{item.groupno}、</when> <sisthy> null、</sidte> </choice> <choice> <test =" item.modecode!= null ">#{item.modecode}、</when> <retsing> null、</sids </sids> </choice> <test =" modename!= null ">#{item.modename}、</when> <then> null、</sidte> </choose> <choice> <test =" item.startdate!= null ">#{item.startdate}、</when> <> <retsing> null、</rething> null ">#{item.starthour}、</when> <istar> null、</sids> </choose> <choice> <when test =" item.enddate!= null ">#{item.enddate}、</when> <> <> <> null、</ null ">#{item.endhour}、</when> <issed null、</retsion> </choose> <choice> <test =" item.model!= null ">#{item.model}、</when> <> null、</sids </sids> </choice> <chood> <" item.buydate!= null ">#{item.buydate}、</when> <thent> null、</sids> </choose> <choice> <test =" item.addressno!= null ">#{item.addressno}、</when when when> <rets> null、</rething> </choice> null ">#{item.calculateflag}、</when> <thent> null、</sids> </chood> <choice> <when test =" item.currency!= null ">#{currency}、</when </when> <> <siss> null、</sids> </seace> null ">#{item.unitamount}、</when> <thens> null、</sids> </choose> <choice> <when test =" item.quantity!= null ">#{item.quantity}、</when </when> null、</ null ">#{item.unit}、</when> <thens> null、</sids> </choose> <choice> <when test =" item.value!= null ">#{item.value}、</when> <> null、</sids> </choice> <choice> <test =" item.amount!= null ">#{item.Amount}、</when> <issed> null、</sidte> </choose> <shoice> <test =" item.rateperiod!= null ">#{item.rateperiod}、</when> <> <> null、</ null ">#{item.rate}、</when> <thent> null、</sids> </choose> <choice> <test =" item.shortrateflag!= null ">#{shortrateflag}、</when> <rets> null、</sids </rethin> </choice> null ">#{item.shortrate}、</when> <sisthy> null、</retsion> </choose> <choice> <test =" item.prepremium!= null ">#{item.prepremium}、</when> <sides> null、</retise> </choice> <test ="項目> < null ">#{item.calpremium}、</when> <thent> null、</sids> </choose> <choice> <test =" item.basepremium!= null ">#{item.basepremium}、</when> <rish> null、</rethin </shoice> < null ">#{item.benchmarkpremium}、</when> <thent> null、</sids> </choose> <choice> <when test =" item.discount!= null ">#{item.discount}、</when> <retsions> null、</rething> </chook> < null ">#{item.adjustrate}、</when> <sisthe> null、</retsion> </chuese> <choice> <test =" item.unitpremium!= null ">#{item.unitpremium}、</when> <sids> null、</sids> </choice> null ">#{item.premium}、</when> <sisthy> null、</sids> </choose> <choice> <test =" item.deductiblerate!= null ">#{item.deductiblerate}、</when> <rets> null、</sid> </chooke> null ">#{item.deductible}、</when> <sisthy> null、</retsion> </choice> <choice> <test =" item.flag!= null ">#{item.flag}、</when> <then> null、</sidte> </choice> <when test =" item.intimeforhis!= null ">#{item.inserttimeforhis}、</when> <then> <then> null、</sids> </chood> <choice> <test =" item.operateTimeforhis!= null ">#{item.operateTimeforhis}、</</when when> <otsing> null、</shoed </< null ">#{item.taxrate}、</when> <thens> null、</sidte> </choose> <choice> <test =" item.taxflag!= null ">#{item.taxflag}、</when> <> <> <> null、</sids </rething> </choice> <test =" etaxfee!= null ">#{item.taxfee}、</when> <thens> null、</sids> </choose> <choice> <test =" item.netpremium!= null ">#{item.netpremium}、</when> <ret> null、</sid </rething> < null ">#{item.taxfee_gb}、</when> <thent> null、</sidte> </chuese> <choice> <test =" ited.taxfee_lb!= null ">#{ited.taxfee_lb}、</when> </side </shoice> < null ">#{item.alltaxfee}、</when> <sistas> null、</sids> </choose> <choice> <test =" item.allnetpremium!= null ">#{item.allnetpremium}、</when> <diss> null、</side </> </shoice> {intecr.proposalnomybatis传入リスト参数的实例代码如下所述:
Java代码
// dao代码、也一样void insertdefaultmsg(@param( "idslist")arraylist <string> idslist); // xml open = "(" close = ")" index = "">#{item、jdbctype = varchar} </foreach> </update> //如果传入字符串// service文字列ids = map.get( "ids"); string [] idsarr = ids.split( "、"); string inid = ""; for(int i = 0; i <idsarr.length; i ++){if(i!= idsarr.length -1){inid += "'" +idsarr [i] +"'、"; } else {inid + = "'" + idsarr [i] + "'"; }} list <map <string、string >> list = purdeliveryplandao .getPlanlistmanual(inid); // dao // xml p.is_notice = '0' 'およびp.is_delete =' 1 'およびp.id in(<![$ {inid}]>)グループby p.supplier_code、p.pur_order_no by p.supplier_code </select>总结
MyBatis动态插入リスト传入リスト参数的实例代码、希望对大家有所帮助、如果大家有任何疑问欢迎给我留言、小编会及时回复大家的!