关于mybatis查询上下篇数据的sql(mysql)

我爱海鲸 2020-05-09 23:47:29 暂无标签

简介mybatis查询上下篇数据的sql

原生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>



你好:我的2025