pfw里的配置
错误原因:
orderType是pfw里的关键字,而我们的sql语句中还是用到了orderType这个变量,一般情况下是由于Class的路径不正确
<map-sql id="/order/getOrderList" type="query"
param-map="/order/getOrderListParams"
result-map="/order/getOrderListResults">
<![CDATA[
SELECT *
FROM TBL_SS_ORDER
WHERE 1=1
<isNotEmpty property="domainId">
AND DOMAIN_ID = ##domainId##
</isNotEmpty>
<isNotEmpty property="orderType">
AND ORDER_TYPE = ##orderType##
</isNotEmpty>
<isNotEmpty property="orderStatus">
AND ORDER_STATUS = ##orderStatus##
</isNotEmpty>
<dynamic prepend="ORDER BY">
<isNotEmpty property="sortOrder">
#sortOrder# #orderType#
</isNotEmpty>
</dynamic>
]]>
</map-sql>
错误原因:
orderType是pfw里的关键字,而我们的sql语句中还是用到了orderType这个变量,一般情况下是由于Class的路径不正确