动态设置

<update id="LockOrders" parameterClass="java.util.HashMap">
   UPDATE orders$routeTableNameSuffix$ 
   SET UPDATEDATE=now(),
       Executor=#executor#,
       state = (case when state >= 100 then state else state + 100 end) 
   WHERE  id in
   <iterate property="orderIdList" open="(" close=")"
conjunction=",">
      #orderIdList[]#
   </iterate>
   <![CDATA[ and splittype != -1]]>
   and yn=1 
   and   (
   (state=0 or state=100)
   or ((state=5) or (state=105))
   or
   ((state=6 and state2=9) or (state=106 and state2=9))
   or ((state=6 and
   state2=0) or (state=106 and state2=0))
   or (state=8 or state=108)
   or
   ((state=7 and state2=9 and printx=1) or (state=107 and state2=9 and
   printx=1))
   or ((state=7 and state2=9 and printx=4) or (state=107 and
   state2=9 and
   printx=4))
   or ((state=7 and state2=9 and printx=3) or
   (state=107 and state2=9 and
   printx=3))
   )
</update>