##一下是部分稍完整代码 ---》可以不看
--------
tatement id="NewsClass.queryNewsClassListByCondition" parameterClass="newsclass" resultClass="newsclass">
select * from (
select newsID, newsTitle, createDate, pubDate, issuanceSign, orderID, deployPath, rownum rn
from othNewsClass
<dynamic prepend=" WHERE ">
<isNotNull property="newsID" prepend=" AND ">newsID = #newsID#</isNotNull>
<isNotNull property="newsTitle" prepend=" AND ">newsTitle = #newsTitle#</isNotNull>
<isNotNull property="pubDate" prepend=" AND ">pubDate = to_date('$pubDate$', 'yyyy-mm-dd')</isNotNull>
<isNotNull property="issuanceSign" prepend=" AND ">issuanceSign in ($issuanceSign$)</isNotNull>
<isNotNull property="orderID" prepend=" AND ">orderID = #orderID#</isNotNull>
<isNotNull property="deployPath" prepend=" AND ">deployPath = #deployPath#</isNotNull>
</dynamic>
order by orderID asc, decode(issuanceSign, 'U', '1', 'Y', '2', 'N', '3'), pubDate desc
) where rn <= #currentPage# * #pageSize# and rn > (#currentPage# - 1) * #pageSize#
order by orderID asc, decode(issuanceSign, 'U', '1', 'Y', '2', 'N', '3'), pubDate desc
</statement>
======================
??请问这里 order by orderID asc, decode(issuanceSign, 'U', '1', 'Y', '2', 'N', '3'), pubDate desc 是什么意思啊
--------
tatement id="NewsClass.queryNewsClassListByCondition" parameterClass="newsclass" resultClass="newsclass">
select * from (
select newsID, newsTitle, createDate, pubDate, issuanceSign, orderID, deployPath, rownum rn
from othNewsClass
<dynamic prepend=" WHERE ">
<isNotNull property="newsID" prepend=" AND ">newsID = #newsID#</isNotNull>
<isNotNull property="newsTitle" prepend=" AND ">newsTitle = #newsTitle#</isNotNull>
<isNotNull property="pubDate" prepend=" AND ">pubDate = to_date('$pubDate$', 'yyyy-mm-dd')</isNotNull>
<isNotNull property="issuanceSign" prepend=" AND ">issuanceSign in ($issuanceSign$)</isNotNull>
<isNotNull property="orderID" prepend=" AND ">orderID = #orderID#</isNotNull>
<isNotNull property="deployPath" prepend=" AND ">deployPath = #deployPath#</isNotNull>
</dynamic>
order by orderID asc, decode(issuanceSign, 'U', '1', 'Y', '2', 'N', '3'), pubDate desc
) where rn <= #currentPage# * #pageSize# and rn > (#currentPage# - 1) * #pageSize#
order by orderID asc, decode(issuanceSign, 'U', '1', 'Y', '2', 'N', '3'), pubDate desc
</statement>
======================
??请问这里 order by orderID asc, decode(issuanceSign, 'U', '1', 'Y', '2', 'N', '3'), pubDate desc 是什么意思啊
比如 order by a1,a2,a3 asc, a4,a4 desc
decode(issuanceSign, 'U', '1', 'Y', '2', 'N', '3'),
的意思就是 issuanceSign的值如果是U就输入1,是Y输出2,是N输出3,,依次类推