Mybatis 动态列排序

   <choose>
      <when test="params.orderBy == 'ascending'">
         ORDER BY ${params.column} ASC
      </when>
      <when test="params.orderBy == 'descending'">
         ORDER BY ${params.column} DESC
      </when>
      <otherwise>
         order by xxx desc
      </otherwise>
    </choose>
posted @ 2023-11-16 10:23  启航黑珍珠号  阅读(37)  评论(0)    收藏  举报