mybatis xml分页报错!!


select * from(select a1.*,rownum rn from (select * from course)a1 where rownum<#{max})where rn>#{min}

左边有两个×;

The content of elements must consist of well-formed character data or markup.

1个回答


SELECT * FROM (
SELECT ed.*,ROWNUM rn FROM
(SELECT * FROM emp e INNER JOIN dept d ON e.deptno=d.deptno


e.ename LIKE #{eename}


and e.hiredate<![CDATA[>]]>to_date(#{ehiredate},'yyyy-MM-dd')


and d.dname LIKE CONCAT(CONCAT('%',#{edname}),'%')


) ed) de
WHERE de.rn<![CDATA[>]]>#{pageIndex1} AND de.rn<![CDATA[<]]>=#{pageIndex2}

</select>
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐