Mybatis 多条件查询

<selectid="GetRecordCountByCondition1"parameterType="java.util.Map"resultType="int">

select count(*) from record where

<iftest="startime != null and startime != ''">

record_time>=#{startime} and

</if>

<iftest="stoptime != null and stoptime != ''">

record_time<![CDATA[ <= ]]>#{stoptime} and

</if>

<iftest="mintemp != null and mintemp != ''">

record_temp>=#{mintemp} and

</if>

<iftest="maxtemp != null and maxtemp != ''">

record_time<![CDATA[ <= ]]>#{maxtemp} and

</if>

record_p_pk=${id}

</select>