示例1:in
(1)、xml文件配置:
<select id="getSearchIpForWeb" resultClass="com.poson.dacs.util.IgnoreCaseMap">
select f.frame_id as frame_id, f.frame_code as c_name, o.org_id
as org_id, o.org_name as org_name, f.frame_code as frame_code,
'' as port_name ,'' as pool_id from tb_rm_frame f, tb_sm_organ o
where 1 = 1 and f.org_id = o.org_id
<isPropertyAvailable prepend=" AND " property="frameAddr">
f.frame_addr
<iterate prepend=" in " property="frameAddr" open="("
close=")&