mybatis plus 查询排序_MyBatis基本查询、条件查询、查询排序

/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}