mybatis中的where语句的使用

    <select id="findUserInfoByTrim" parameterType="Map"  
        resultMap="UserInfoResult">  
        select * from userinfo  
        <trim prefix="where" prefixOverrides="and|or">  
            <if test="department!=null">  
                AND department like #{department}  
            </if>  
            <if test="gender!=null">  
                AND gender=#{gender}  
            </if>  
            <if test="position!=null">  
                AND position like #{position}  
            </if>  
        </trim>  
    </select>  

转载地址：https://blog.csdn.net/qq_35192741/article/details/78923840