<select id="queryFbiFinanceChannelByFinanceWhere" resultType="string" parameterType="fbiFinanceChannel" >
<![CDATA[
SELECT FINANCE_CHANNEL as financeChannel FROM FBI_FINANCE_CHANNEL where ENABLE_STATUS = '1'
AND FINANCE_CHANNEL like CONCAT('${financeChannel}','%') AND BUSINESS_CATEGORY_CODE = #{businessCategoryCode} AND BUSINESS_CODE = #{businessCode} AND SUB_BUSINESS_CODE = #{subBusinessCode} AND TRANSACTION_TYPE = #{transactionType}
]]>
</select>
myBatis Like 的使用
最新推荐文章于 2024-03-19 09:23:20 发布