MyBatis动态 SQL语法条件 WHERE 子句代码示例

<select id="findUser" parameterType="map" resultType="User">
  select * from users
  <where> 
    <if test="id != null">
      and id = #{id}   
    </if>   
  </where>
</select>