xml里面直接替换状态字段【如状态 1，直接查出来为司机】 -- case的小例

<select id="findByPage" parameterType="Map" resultType="com.e6yun.project.cqgy.vo.FeedbackInfoVO">
        SELECT
        case when user_type=1 then '司机' when user_type= 2 then '货主' end userTypeStr,
        <include refid="column"/>
        <include refid="findByPageFrom"/>
        <include refid="tms.util.page_footer"/>
    </select>