mybaitis 排序筛选

        <choose>
            <when test="sort != null and sort.trim() != ''">
                order by ${sort} ${order}
            </when>
            <otherwise>
                order by a.id desc
            </otherwise>
        </choose>

choose标签里是sort 是排序字段，order是 排序类型desc 或者 asc，此标签放在where标签后面