多条件查询时，用<where> <select id="findAllSelective" resultMap="BaseResultMap"> select <include refid="Base_Column_List" /> from sys_user <where> <if test="id != null"> and id = #{id,jdbcType=BIGINT} </if> <if test="username != null"> and username = #{username,jdbcType=VARCHAR} </if> </where> </select>
https://blog.csdn.net/thris/article/details/84810974
原文：https://www.cnblogs.com/isme-zjh/p/12615564.html