【C017114】在MyBatis中，假设User已经定义，以下可以实现模糊查询姓名的选项是（ ）。

• A.<select id="queryUserByName" resultType="User" parameterType="User">
  
      SELECT * FROM tb_users t
  
      <where>
  
          <if test="userName != null and userName !=''" >
  
              AND t.user_name LIKE #{userName}
  
          </if>
  
      </where> 
  
  </select>

• B.<select id="queryUserByName" resultType="User" parameterType="User">
  
      SELECT * FROM tb_users t
  
      <where>
  
          <if test="userName != null and userName !=''" >
  
              t.user_name LIKE ${userName}%
  
          </if>
  
      </where> 
  
  </select>

• C.<select id="queryUserByName" resultType="User" parameterType="User">
  
      SELECT * FROM tb_users t
  
      <where>
  
          <if test="userName != null and userName !=''" >
  
              t.user_name LIKE '%${userName}%'
  
          </if>
  
      </where> 
  
  </select>

• D.<select id="queryUserByName" resultType="User" parameterType="User">
  
      SELECT * FROM tb_users t
  
      <where>
  
          <if test="userName != null and userName !=''" >
  
              t.user_name LIKE '%#{userName}%'
  
          </if>
  
      </where> 
  
  </select>