ibatis -- 多参数

<sqlMap>
    <parameterMap class="包名" id="DOrder">
        <parameter javaType="string" jdbcType="VARCHAR" property="sOrderId"/>
        <parameter javaType="string" jdbcType="VARCHAR" property="orderType"/>
 </parameterMap>
    <resultMap class="包名" id="SOrderResult">
        <result column="ID" javaType="string" property="sOrderId"/>
        <result column="SHOP_ID" javaType="string" property="aShopId"/>
        <result column="QTY" javaType="long" property="qty"/>
    </resultMap>
   
    <select id="名称" parameterMap="DOrder" resultMap="SOrderResult">
     select sol.S_ORDERLINE_ID,
         sol.AD_SHOP_ID,
         nvl(sol.QTY, 0)  QTY

      from S_ORDER sol
      inner join MATERIAL ma
      on sol.MATERIAL_ID = ma.MATERIAL_ID
      where sol.S_ORDER_ID = $sOrderId$
   <isEqual property="orderType" compareValue="2">
         and -nvl(sol.QTY, 0) > nvl(sol.delivery_qty, 0)
   </isEqual>
   <isNotEqual property="orderType" compareValue="2">
          and nvl(sol.QTY, 0) > nvl(sol.delivery_qty, 0)
   </isNotEqual>
    </select>