如何配置mybatis的SQL语句

比如我要写入这条语句的话，如何配置XML
SELECT * FROM (SELECT * FROM WARNING_RECORD ORDER BY CREATE_TIME DESC )

WHERE ROWNUM <= 5

<!-- 将特殊的符号（标签开始和结束的尖括号）转换成 SQL的语句 -->
<![CDATA[
SELECT * FROM (SELECT * FROM WARNING_RECORD ORDER BY CREATE_TIME DESC )
WHERE ROWNUM <= 5

]]>

WARNINGRECORD 该表的对象实体
selectWARNINGRECORD调用这个mybatis查询的方法

 <select id="selectWARNINGRECORD"  resultMap="WARNINGRECORD">
       SELECT * FROM (SELECT * FROM WARNING_RECORD ORDER BY CREATE_TIME DESC )

WHERE ROWNUM <= 5
    </select>

mybatis是在xml文件中写入的，只需要按照标签写就可以了

SELECT * FROM (SELECT * FROM WARNING_RECORD ORDER BY CREATE_TIME DESC )
WHERE ROWNUM <= 5

id 是你的mapper方法名，resultType是你的返回值类型，返回的是实体类，直接将bean的引用路径写上就可以了

是mapping.xml么？要是那个你就直接配置呗

with a as ( SELECT * FROM WARNING_RECORD ORDER BY CREATE_TIME DESC)
select * from a WHERE ROWNUM <= 5

在你的mapper.xml 文件中配置
写在标签内，你应该知道。

 <mapper namespace="cn.edu.hpu.dao.EmployeeMapper">
    <select id="" resultType="" databaseId="">
        SELECT * FROM (SELECT * FROM WARNING_RECORD ORDER BY CREATE_TIME DESC )
    WHERE ROWNUM <= 5
    </select>
    </mapper>

cn.edu.hpu.dao.EmployeeMapper是我的mapper对应的全文件名即：包名+mapper名

语句是要使用这个便签括起来的，这样<符号才可以当做是语句中的一部分

<![CDATA[
sql语句
]]>