<select id="getExportWarnList" resultType="java.util.LinkedHashMap">
SELECT
w.ID AS "ID",
( CASE
w.DELIVER_STATE
WHEN '1' THEN
'已交付'
WHEN '0' THEN
'未交付'
WHEN '2' THEN
'审核中'
WHEN '3' THEN
'未通过' ELSE '未交付' END
) AS "交付状态"
FROM
warn_config w
WHERE
1 = 1
<if test="configIds != null">
AND w.ID in
<foreach collection="configIds" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</if>
</select>
mybatis中sql查询 码值转为中文
最新推荐文章于 2024-03-06 10:44:00 发布