wrapper中有条件时候会自动拼接sql
而当wrapper中么有条件,直接走xml的动态sql会导致
sql语句没有其他条件却依然拼接了And 条件相当于:select....from... And 条件
解决方案:如果wrapper中没值时,手动加个where,避免后续的查询没有where 导致报错
<select id="selectNewPage" resultType="vo.RepairpartIoappAndUserPageVO">
select * from( select a.*,b.nickname from cloud_repairpart_ioapp as a
left join system_users as b on a.creator=b.id ) as result ${ew.customSqlSegment}
<if test="ew.customSqlSegment == null or ew.customSqlSegment == '' ">where 1 = 1</if>
<if test="nickName != null and nickName != '' ">
AND nickName Like '%${nickName}%'
</if>
ORDER BY create_time;
</select>