mybatis 根据条件查询

<select id="GetRecordCountByCondition1" parameterType="java.util.Map" resultType="int">
select count(*) from record where
<if test="startime != null and startime != ''">
  record_time>=#{startime} and  
  </if>
  <if test="stoptime != null and stoptime != ''">
  record_time<![CDATA[ <= ]]>#{stoptime} and 
  </if>
  <if test="mintemp != null and mintemp != ''">
  record_temp>=#{mintemp} and 
  </if>
  <if test="maxtemp != null and maxtemp != ''">
  record_time<![CDATA[ <= ]]>#{maxtemp} and 
  </if>
  record_p_pk=${id}
</select>