mybatis模糊查询

  <!--

    
     配置查询：根据姓名模糊查询员工信息
    
     -->
    
     <select id="findByName" resultType="employee">
    
     SELECT id,NAME,gender,idcard,nationid
    
     FROM employee
    
     WHERE 1=1
    
       <if test="name != null">
    
           <bind name="p_name" value="'%' + name + '%'"/>
    
       and NAME LIKE #{p_name}
    
       </if>
    
     </select>
    
  
    
  <!--
    
     配置查询：多条件模糊查询员工信息
    
     -->
    
     <select id="findByCondition" resultT