case when

最新推荐文章于 2023-10-12 15:45:18 发布

weixin_30709061

最新推荐文章于 2023-10-12 15:45:18 发布

阅读量80

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/wangchuanfu/p/6882749.html

   <select id="getLimitPage" resultMap="limitFieldBeanSubMap" parameterClass="LimitField"  >
          <include refid="be_fy"/>
          select T_LIMIT_FIELD.*,
             (
                  case state
                     when 'N' then '下线'
                     when 'Y' then '上线'                    
                      end               
             ) as stateStr          
           from T_LIMIT_FIELD  where IS_DELETE='N'
                <include refid="whereLimitList" />
          order by ADD_TIME desc
          <include refid="ed_fy"/>
    </select>

转载于:https://www.cnblogs.com/wangchuanfu/p/6882749.html