<select id="selectEmpList" resultType="emp" >
select * from (select e.*,ROWNUM rn from (select * from emp
<where>
<if test="empCondition.empno !=null">
and empno = #{empCondition.empno}
</if>
<if test="empCondition.ename !=null">
and ename = #{empCondition.ename}
</if>
<if test="empCondition.deptno !=null">
and deptno = #{empCondition.deptno}
</if>
</where>
order by sal ) e
)
where rn>=#{rowStart} and rn <![CDATA[<]]>= #{rowEnd}
select * from (select e.*,ROWNUM rn from (select * from emp
<where>
<if test="empCondition.empno !=null">
and empno = #{empCondition.empno}
</if>
<if test="empCondition.ename !=null">
and ename = #{empCondition.ename}
</if>
<if test="empCondition.deptno !=null">
and deptno = #{empCondition.deptno}
</if>
</where>
order by sal ) e
)
where rn>=#{rowStart} and rn <![CDATA[<]]>= #{rowEnd}
</select>
错误原因:由于中文的标点符号“。”在mybatis配置文件中和英文“.”是一样的,所以容易看不出错误,这里将中文"empConditon.empname"改成英文半角"empConditon.empname"