ibatis 配置cdata

最新推荐文章于 2021-01-19 23:41:09 发布

最新推荐文章于 2021-01-19 23:41:09 发布 · 72 阅读

文章标签：

#iBATIS

本文提供了一个SQL查询示例，展示了如何从CONFIG.CCD_LINKS_INFO_VT和CONFIG.CCD_INTERFACE_T表中选择特定链接信息的方法。该查询包含了多个字段如LNKS_NAME、IF_CAPACITY等，并通过条件筛选和排序来获取所需数据。

<![CDATA[
 SELECT T.LNKS_NAME,
 I.LNK_NAME,
 I.LNK_ID,
 T.LEVEL_NAME,
 T.L1_VENDOR_CNAME,
 I.IF_CAPACITY,
 I.MEMO,
 T.L1_CITY_NAME,
 I.SLOT_NUM,
 I.IF_TYPE,
 I.IF_IP || ' ' || I.IF_NO as L1,
 I.IF_IP,
 I.IF_NO,
 T.L1_ID,
 T.L1_CITY_ID,
 T.L1_NE,
 T.L1_IF_IP_MASK,
 I.IF_STATUS,
 T.L2_CITY_NAME,
 T.L2_SLOT_NUM,
 T.L2_IF_IP || ' ' || T.L2_IF_NO as L2,
 T.L2_IF_IP,
 T.L2_IF_NO,
 T.L2_IF_IP_MASK,
 T.L2_NE,
 T.L2_CITY_ID
FROM CONFIG.CCD_LINKS_INFO_V T,
 CONFIG.CCD_INTERFACE_T I
WHERE T.LNK_NAME = I.LNK_NAME
 AND T.l1_NE = I.NE
AND T.L1_ID < T.L2_ID
AND #city_id# IN (L1_CITY_ID, T.L2_CITY_ID)
 and t.lnk_level=#link_level#
 order by I.LNK_NAME desc
]]>