錯(cuò)誤示例:
select
id,
channel,
if(txntime='', createtime, STR_TO_DATE(txntime, '%Y%m%d%H%i%s')) onDate,
feeType,
amount bizAmount,
ROUND((case platform when '8' then if(amount*0.002<1,1,amount*0.002) when '6' then amount*0.003 else amount*0.003 end),2) fee,
't_union_order' refType,
id refValue,
'' memo,
isDeprecated,
createTime,
lastUpdateTime
from t_order
錯(cuò)誤原因:mybatis查詢的時(shí)候,需要用到運(yùn)算符 小于號(hào):< 和 大于號(hào): >赦颇,在mybatis配置文件里面芥玉,這種會(huì)被認(rèn)為是標(biāo)簽,所以解析錯(cuò)誤.
解決方法,用<![CDATA[ ]]>將有<,>的代碼包起來(lái)硬耍。
如下:
select
id,
channel,
if(txntime='', createtime, STR_TO_DATE(txntime, '%Y%m%d%H%i%s')) onDate,
'用戶還款' feeType,
amount bizAmount,
<![CDATA[ROUND((case platform when '8' then if(amount*0.002<1,1,amount*0.002) when '6' then amount*0.003 else amount*0.003 end),2)]]> fee,
't_union_order' refType,
id refValue,
'' memo,
isDeprecated,
createTime,
lastUpdateTime
from t_order