CASE type
WHEN 0 THEN
'审核中'
WHEN 1 THEN
'审核通过'
WHEN 2 THEN
'审核失败'
END AS typeDesc,
举个栗子:
<select id="selectTransferStatisticsList" resultType="com.tansen.test.AuditVo">
SELECT w.withdrawNo,w.transactionNo, w.amount, w.transferType,
CASE type
WHEN 0 THEN
'审核中'
WHEN 1 THEN
'审核通过'
WHEN 2 THEN
'审核失败'
END AS typeDesc
FROM gp_agent_withdraw w where actualRrivalStatus=1
<if test="transferType != null">
and w.transferType = #{transferType}
</if>
ORDER BY w.tranTime desc
</select>