/p>
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
resultMap="linkType">
SELECT * FROM OD_LINK_TYPE
WHERE LINK_URI = #{linkUri}
resultType="int">
SELECT EXISTS(SELECT LINK_URI FROM OD_LINK_TYPE
WHERE LINK_URI=BASE_TYPE_URI AND LINK_URI=#{linkUri})
DELETE FROM OD_LINK_TYPE WHERE BASE_TYPE_URI=#{baseTypeUri}
SELECT * FROM OD_LINK_TYPE
WHERE LINK_URI = BASE_TYPE_URI
resultMap="linkType">
SELECT * FROM OD_LINK_TYPE
LINK_URI != BASE_TYPE_URI
AND BASE_TYPE_URI=#{baseTypeUri}
ORDER BY
LINK_URI ${orderdir}
LINK_LABEL ${orderdir}
BASE_TYPE_URI ${orderdir}
SELECT * FROM OD_LINK_TYPE
LINK_URI != BASE_TYPE_URI
AND LINK_URI LIKE '%${linkUri}%'
AND LINK_LABEL LIKE '%${linkLabel}%'
AND BASE_TYPE_URI=#{baseTypeUri}
ORDER BY
LINK_URI ${orderdir}
LINK_LABEL ${orderdir}
BASE_TYPE_URI ${orderdir}