如何根据传的参数选择where条件，网上百度了半天也不合适，求大神解答疑惑

Question

<select id="payMode" parameterType="java.lang.String" resultMap="getpay">
    SELECT * from pay_mode
    where
      <if test="pay=='1'">
        pay=#{pay}
      </if>
      <if test="pay=='2'">
        pay=#{pay}
      </if>
      <if test="pay=='3'">
        pay=#{pay}
      </if>
      <if test="pay=='4'">
        pay=#{pay}
      </if>
  </select>
一直报的错是 There is no getter for property named 'payType' in 'class java.lang.String'，求解

Answer 1

改为
<select id="payMode" parameterType="java.lang.String" resultMap="getpay">
    SELECT * from pay_mode
    where
      <if test="_parameter=='1'">
        pay=#{pay}
      </if>
      <if test="_parameter=='2'">
        pay=#{pay}
      </if>
      <if test="_parameter=='3'">
        pay=#{pay}
      </if>
      <if test="_parameter=='4'">
        pay=#{pay}
      </if>
  </select>
试一下