Question

在mybatis中xml中不等于怎么写？

Answer 1

<if test="startTime != null and startTime !=''">

</if>

例子：

①select * from 表 where username = 'Tom' and id != 45

②mybatis :

select * from 表 where

<if test='username != "%null%"'>

username = #{username} and id != #{id}

</if>