记录mybatis动态sql ，查询指定时间段的数据。

1.直接接收参数startTime,endTime

        <if test="startTime != null and endTime != null ">
            and `create_time` BETWEEN #{startTime} and #{endTime}
        </if>

2.通过类来接收参数startTime,endTime

        <if test="deviceCollectQuery.startTime != null and deviceCollectQuery.endTime != null ">
            and host.`host_activate_time` BETWEEN #{deviceCollectQuery.startTime} and #{deviceCollectQuery.endTime}
        </if>