ibatis 中case使用

<!-- 猜你喜欢 -->
<select id="getGoodsFromCookie" resultClass="java.util.HashMap" parameterClass="java.util.Map">
SELECT A.CONTRACT_GOODS_ID,
       A.GOODS_ID,
       A.CONTRACT_GOODS_NAME,
       A.CATGORY_ID,
       A.CONTRACTED,
       B.GOODS_NAME,
       B.PRICE_B,
       CASE A.CONTRACTED
          WHEN 1
          THEN
             CASE 
                WHEN A.SPECIAL_PRICE='0.000000' THEN A.CONTRACT_PRICE
                WHEN A.SPECIAL_PRICE IS NULL THEN A.CONTRACT_PRICE
                ELSE A.SPECIAL_PRICE
             END
          ELSE
             B.PRICE_B
       END
          AS PRICE,
       B.GOODS_PIC
  FROM (SELECT CONTRACT_GOODS_ID,
               GOODS_ID,
               CONTRACT_GOODS_NAME,
               CATGORY_ID,
               CONTRACT_PRICE,
               CONTRACTED,
               SPECIAL_PRICE              
          FROM EM_CM_CONTRACT_GOODS
         WHERE IS_INACTIVE = 0  AND UP_ACT = 1 AND CONTRACT_GOODS_ID IN ($contract_goods_ids$)) A,
       EM_GD_GOODS B
WHERE A.GOODS_ID = B.GOODS_ID
AND EXISTS (
SELECT
1
FROM
EM_CM_VICATEGORY Q
WHERE
Q.CUSTOMER_ID = #CUSTOMER_ID#
AND Q.CATGORY_ID = A.CATGORY_ID
AND LENGTH(Q.CATEGORY_TREE_CODE)=9
)
</select>