mybatis动态插入list传入List参数的实例代码

2023-09-13 21:31:07 57

insertintoprpcitemkind (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,INSERTTIMEFORHIS,OPERATETIMEFORHIS,TAXRATE,TAXFLAG,TAXFEE, NETPREMIUM,TAXFEE_GB,TAXFEE_LB,ALLTAXFEE,ALLNETPREMIUM,PROPOSALNO) #{item.riskcode}, null, #{item.itemkindno}, null, #{item.familyno}, null, #{item.familyname}, null, #{item.projectcode}, null, #{item.clausecode}, null, #{item.clausename}, null, #{item.kindcode}, null, #{item.kindname}, null, #{item.itemno}, null, #{item.itemcode}, null, #{item.itemdetailname}, null, #{item.groupno}, null, #{item.modecode}, null, #{item.modename}, null, #{item.startdate}, null, #{item.starthour}, null, #{item.enddate}, null, #{item.endhour}, null, #{item.model}, null, #{item.buydate}, null, #{item.addressno}, null, #{item.calculateflag}, null, #{item.currency}, null, #{item.unitamount}, null, #{item.quantity}, null, #{item.unit}, null, #{item.value}, null, #{item.amount}, null, #{item.rateperiod}, null, #{item.rate}, null, #{item.shortrateflag}, null, #{item.shortrate}, null, #{item.prepremium}, null, #{item.calpremium}, null, #{item.basepremium}, null, #{item.benchmarkpremium}, null, #{item.discount}, null, #{item.adjustrate}, null, #{item.unitpremium}, null, #{item.premium}, null, #{item.deductiblerate}, null, #{item.deductible}, null, #{item.flag}, null, #{item.inserttimeforhis}, null, #{item.operatetimeforhis}, null, #{item.taxrate}, null, #{item.taxflag}, null, #{item.taxfee}, null, #{item.netpremium}, null, #{item.taxfee_gb}, null, #{item.taxfee_lb}, null, #{item.alltaxfee}, null, #{item.allnetpremium}, null, #{item.proposalno}

//dao代码如果传入的参数是数组，也一样 voidinsertDefaultMsg(@Param("idsList")ArrayListidsList); //xml文件 UPDATE plf_pur_delivery_planp SET p.promise_delivery_amount=p.quantity_req, p.promise_delivery_time=p.quantity_time WHEREp.idIN #{item,jdbcType=VARCHAR} //如果传入字符串 //service代码 Mapmap=bean.getDatas().get(0); Stringids=map.get("ids"); String[]idsArr=ids.split(","); StringinId=""; for(inti=0;i>list=purDeliveryPlanDao .getPlanListManual(inId); //dao层代码 List>getPlanListManual(@Param("inId")StringinId); //xml文件 SELECT p.supplier_code, p.pur_order_no, IF( p.update_times>0, '修改订单', '新订单' )ASorder_type FROM plf_pur_delivery_planp WHEREp.is_notice='0' ANDp.is_delete='1' ANDp.idin() GROUPBYp.supplier_code, p.pur_order_no ORDERBYp.supplier_code

mybatis动态插入list传入List参数的实例代码

热门推荐

随机推荐