sql返回一个jsonobject 案例

<select id="getInvSkuTotalForPay" resultType="com.alibaba.fastjson.JSONObject">
    SELECT SUM(payAmount) totalAmount,SUM( num ) totalQuantity
    FROM
    (
        SELECT
            SUM( DIFFERENCE_NUM ) * PRICE * - 1 payAmount,
            SUM(DIFFERENCE_NUM)    num
        FROM t_inventory_sku
            WHERE INVENTORY_ID = #{inventoryId}
        GROUP BY SPU
        HAVING SUM( DIFFERENCE_NUM ) &lt; 0
    )a
</select>

 service