myBatis 多条件查询

    <select id="queryByName" parameterType="com.example.entity.Approval" resultType="com.example.entity.Approval">
        select * from approval
        <where>
            <if test="stuName != null and stuName != ''">
                and stu_name like concat('%',#{stuName},'%')
            </if>
            <if test="tutorName != null and tutorName != ''">
                and tutor_name like concat('%',#{tutorName},'%')
            </if>
        </where>
    </select>

id表示对应Mapper中的查询的方法名 

List<Approval> queryByName(Approval approval);

 parameterType  传入的参数类型

resultType返回结果