mybatis使用if else 的方法

单个if else

<select id="selectUserByState" resultType="com.bz.model.entity.User">
    SELECT
      *
    FROM
      user
    WHERE
      1=1
    
      "state == 1">
        AND name = #{name1}
      
      
        AND name = #{name2}
      
    
  select>

多个if elseif else

<select id="selectUserByState" resultType="com.bz.model.entity.User">
    SELECT
      *
    FROM
      user
    WHERE
      1=1
    
      "state == 1">
        AND name = #{name1}
      
     "state == 2">
        AND name = #{name2}
      
      
        AND name = #{name3}
      
    
  select>