mybatis 动态插入 list 的实例代码如下所述 : :
<insert id = "saveprpcitemkindlist"parametertype = "java.util.list"> prpcitemKind (riskCode, itemkindno, familyno, familyName, ProjectCode, ClaUsecode, Clausename, KindCode, Kindname, ItemCode, itemdetailname, Groupdetailname, modeno, modeno, inittailname에 삽입합니다. StartDate, Starthour, EndDate, Endhour, Model, BuyDate, 주소, 계산 플래그, 통화, 유니 타임, 수량, 단위, 가치, 금액, 요율, 속도, 해안 플래그, 쇼어 플로어, 미세한 프리미엄, Calpremium, 기초, 기초, 기초, 공제, 공제, 공제, 공제, 공제. insertTimeForHis, OperateTimeforHis, Taxrate, Taxflag, Taxfee, Netpremium, Taxfee_GB, Taxfee_LB, AllTaxfee, AllnetPremium, ProposalNo) <foreach Collection = "List"항목 = "item"index = "index" "<at all"> test = "item.riskCode! = null">##{item.riskCode}, </when> </</elege> </ever> </선택> <test = "item.itemkindno! = null">#{item.itemkindno}, </when> null, </eloge> </chance> < "" null ">##{item.familyno}, </when> <syg> null, </elure> </선택> <test ="item.familyname! = null ">#{item.familyName}, </when> </elist> </선택> <선택> <eirest ="item.projectCode! = NULL ">##{item.projectCode}, </when> <syg> null, </ever> </선택> <test ="item.clausecode! = null ">#{item.clausecode}, </when> null, </elist> </select> <select> <test ="item.clausename! = null ">##{item.clausename}, </when> <syg> null, </exter> </chelect> <test ="item.kindcode! = null ">##{item.kindcode}, </when> null, </elise> </선택> <선택> aitt ="Kindname! = null ">##{item.kindname}, </when> <othe> null, </exter> </chelect> <test ="item.itemno! = null ">#{item.itemno}, </when> <syg> null, </elure> </chelect> <read ="item.itemcode! = NULL ">##{item.ItemCode}, </when> <othe> null, </ever> </선택> <test ="item.ItemDetailName! = null ">#{item.ItemDetailName}, </when> </ooth> </옵션> <선택> <test ="airet.groupno! = null ">##{item.groupno}, </when> <othe> null, </elure> </선택> <test ="item.modecode! = null ">#{item.modecode}, </when> </elure> </선택> <initem.modename! = null ">##{item.modename}, </when </when> <othe> null, </elure> </선택> <test ="item.startDate! = null ">#{item.startDate}, </when> null, </ely> </선택> <exect> <initem.starthour! = NULL ">##{item.starthour}, </when> <syg> null, </ever> </chelect> <test ="item.enddate! = null ">#{item.enddate}, </when> <syt> null, </elure> </선택> <test ="item.endhour! = null ">##{item.endhour}, </when> <othe> null, </exter> </chelect> <test ="item.model! = null ">#{item.model}, </when> <syt> null, </elure> </chelace> <"airet = buydate! = null ">##{item.buydate}, </when> <syg> null, </elure> </선택> <test ="item.addressno! = null ">##{item.addressno}, </when> </elist> </select> <선택> <ited ="item.calculationfflag! = null ">##{item.calculateflag}, </when> <syult> null, </elure> </선택> <test ="item.currency! = null ">#{item.currency}, </when> </elose> </select> <선택> initem.unitamount! = null ">##{item.unitamount}, </when> <othe> null, </ever> </chelect> <test ="item.quantity! = null ">#{item.quantity}, </when> <syt> null, </ely> </chelect> <test ="item.unit! = null ">##{item.unit}, </when </when> <othe> null, </elure> </선택> <선택> <test ="item.value! = null ">#{item.value}, </when> <syg> null, </elure> </selection> <test ="item.amount! = NULL ">##{item.amount}, </when </when> <othe> null, </elure> </선택> <test ="item.rateperiod! = null ">#{item.rateperiod}, </when> </elure> </선택> <aited.rate! = NULL ">##{item.rate}, </shen </when> <syt> null, </elure> </선택> <선택> <test ="item.shortrateflag! = null ">#{item.shortrateflag}, </when> null, </elist> </선택> <select> <aitre ="ited.shortrate! null ">##{item.shortrate}, </when> <othe> null, </elure> </선택> <test ="item.prepremium! = null ">#{item.prepremium}, </when> null, </elist> </select> <selection> <aitre ="airet = "calpremium! NULL ">##{item.calpremium}, </when> <othe> null, </ever> </선택> <test ="item.basepremium! = null ">#{item.basepremium}, </when> null, </elist> <선택> <aitre ="item.benchmark prpremium! null ">##{item.benchmarkpremium}, </when> <syull, null, </elure> </select> <test ="item.discount! = null! = null ">#{item.discount}, </when> </ely> </선택> <선택> aitem.adjustrate! = null ">##{item.adjustrate}, </when> <othe> null, </exter> </선택> <test ="item.unitpremium! = null ">#{item.unitpremium}, </</when> </elist> </선택> <selection> <extem.premium! = NULL ">##{item.premium}, </when> <othe> null, </elure> </선택> <test ="item.deductiblerate! = null ">#{item.deductiblerate}, </when> null, </elure> </선택> <선택> <initem.ductible! = null ">##{item.deductible}, </when </when> <othe> null, </elure> </선택> <test ="item.flag! = null ">#{item.flag}, </when> <syg> null, </eleach> </onection> <test ="item.inserttimeforhis! = null ">##{item.inserttimeforhis}, </when> <other> null, </ever> </select> <test ="item.operateTimeforHis! = null ">#{experateTimeforHis}, </when> <syg> null, </옵션> <exect> <ehple =" null ">##{item.taxrate}, </when> <syg> null, </elure> </선택> <test ="item.taxflag! = null ">#{item.taxflag}, </when> </ely> </선택> <선택> recide.taxfee! = null ">##{item.taxfee}, </when> <othe> null, </elure> </선택> <test ="item.netpremium! = null ">#{item.netpremium}, </when> </elype> </chelect> <recive.taxfee_gb! = null ">##{item.taxfee_gb}, </when> <sygr> null, </elure> </선택> <test ="item.taxfee_lb! = null ">#{item.taxfee_lb}, </when> <syg> null, </secel> <선택> <aitt =" null ">##{item.alltaxfee}, </when> <othe> null, </exter> </선택> <test ="item.allnetpremium! = null ">#{item.allnetpremium}, </when> null, </elist> </select>#</inforposalno}mybatis 传入 list 参数的实例代码如下所述 : :
Java 代码
// dao 代码 o o, 也一样 void insertDefaultMsg (@param ( "idslist") arraylist <string> idslist); // xml l <update id = "insertDefaultMsg"ParameterType = "java.util.list"> 업데이트 plf_delivery_plan p set p.promise_delivery_amount = p.quantity_req, p.promise_delivery_time = p.quantity_req, p.ideach in in item = "idslist" "idslist" Open = "("close = ")"index = ""> # #{item, jdbctype = varchar} </foreach> </update> // 如果传入字符串 // service 代码 map <string, string> map = bean.getDatas (). get (0); 문자열 ids = map.get ( "ids"); 문자열 [] 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 <string, string >> list = purdeliveryPlandao .getPlanListmanual (inid); // dao 层代码 list <map <string, string >> getPlanListmanual (@param ( "inid") String inid); // xml l <select id = "getplanlistmanual"parametertype = "java.lang.string"resulttype = "java.util.map"> select p.supplier_code, p.pur_order_no, if (p.update_timess> 0, '修改订单 新订单'). p.is_notice = '0'및 p.is_delete = '1'및 p.id in (<!总结
以上所述是小编给大家介绍的 mybatis b 목록 传入 목록 参数的实例代码 参数的实例代码, 希望对大家有所帮助, 如果大家有任何疑问欢迎给我留言, 小编会及时回复大家的! 小编会及时回复大家的!