mybatis动态SQL if的test写法及规则详解

<select id="findActiveBlogWithTitleLike"
     resultType="Blog">
  SELECT * FROM BLOG
  WHERE state = ‘ACTIVE'
  <if test="title != null">
    AND title like #{title}
  </if>
</select>

<select id="getStudentId" parameterType="java.lang.String" resultType="java.lang.String">
        SELECT MAX(Student_ID) FROM Student
        <where>
            <if test="classid !=null and classid !=''">  
                AND CLASS_ID = {student.classID} 
            </if>
            <if test="age ==null or age ==''">  
                AND AGE = {student.age}
            </if>
        </where>
</select>