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>