ibats iterate的使用

xml配置:

 

   <select id="getorddeleritem"   parameterClass="map" resultClass="dto">
    select salesorderid,salesorderitem,upsalesorderitem,orderitemtype,storeid,materialnumber,batchnumber,
    salesquantity,storagelocation,netprice,goodsprocessingfee,goldprice,totalamount,
    tagprice,goldweight,customersdiscount,storediscount,unit,changefee,otherfee,exchangepint,
    lowerlevelsnumber,productpictureurl,statementid,settlementrate,settlementamount,
    originalsettlementrate,originalsettlementamount,materialclassificationcode,materialdesc from orderitem
    where   salesorderid=#salesorderid#   and salesorderitem in
    <iterate property="delist" open="("
          close=")" conjunction=",">
                #delist[]# 
        </iterate>
 </select>
 

 

程序: DTO 相当于hashMap

      String delrecords = orderHead.getAsString("delrecords");
       Dto delorderitem = new BaseDto();
       delorderitem.put("salesorderid", orderHead.get("salesorderid"));
       String[] delsalesorderitem = delrecords.split(";");
       List delist=new ArrayList();
       for(int i=0;i<delsalesorderitem.length;i++){
        Dto delOrderitem = new BaseDto();
        delOrderitem.put("salesorderitem", delsalesorderitem[i]);
        delist.add(delsalesorderitem[i]);
       }
       delorderitem.put("delist", delist);
      
       List<Dto> listorderitem = ireaderOrder.queryForList("ordersystem.getorddeleritem",delorderitem)