67,513
社区成员
发帖
与我相关
我的任务
分享
<select id="getAddressPoolConfigCount" resultClass="Integer"
parameterClass="Map">
select count(*) from TMS_ADDRESS_POOL_CONFIG tapc, SYS_CITY
sc,SYS_PROVINCE sp where tapc.PROVINCE_ID = sp.PROVINCE_ID and
tapc.CITY_ID = sc.CITY_ID
<isNotEmpty prepend="AND" property="provinceId">
tapc.PROVINCE_ID like '%' || #provinceId#|| '%'
</isNotEmpty>
<isNotEmpty prepend="AND" property="cityId">
tapc.CITY_ID like '%' || #cityId#|| '%'
</isNotEmpty>
<isNotEmpty prepend="AND" property="configFlag">
tapc.CONFIG_FLAG like '%' || #configFlag#|| '%'
</isNotEmpty>
</select>