原生sql的书写方式:
(SELECT article_info_id,title FROM `article_info` WHERE `article_info_id`<113 ORDER BY `article_info_id` DESC LIMIT 1)
UNION
(SELECT article_info_id,title FROM `article_info` WHERE `article_info_id`>113 ORDER BY `article_info_id` ASC LIMIT 1)
在mybatis中的xml配置文件中如果直接写会导致错误,所以需要<![CDATA[ sql语句 ]] 对含有<的sql语句进行转义
<select id="getArticleDetailsUserUpDown" resultType="xyz.haijin.pojo.dto.ArticleDetailsUserUpDown" >
(SELECT article_info_id,title FROM `article_info` WHERE <![CDATA[`article_info_id`< #{article_info_id} ORDER BY `article_info_id` DESC LIMIT 1 ]]>)
UNION
(SELECT article_info_id,title FROM `article_info` WHERE `article_info_id`>#{article_info_id} ORDER BY `article_info_id` ASC LIMIT 1)
</select>