@Select("<script>" +
            "select avg( blood) " +
            "from " +
            "sensor_blood " +
            "<where> " +
            "sq_number in " +
            "<foreach item='item' inde='index' collection='imei' open='(' separator=',' close=')'> " +
            "#{item}  " +
            "</foreach>" +
            "<if test=\" startTime!=null\"> and upload_time <![CDATA[ >= ]]> #{startTime} </if> " +
            "<if test=\" stopTime!=null\"> and upload_time <![CDATA[ <= ]]>  #{stopTime} </if>" +
            "</where>" +
            "</script>")
    String selectBloodO2(@Param("imei") List<String> imei, @Param("startTime") Date startTime, @Param("stopTime") Date stopTime);

必须要写@param，否则找不到对应的集合，startTime>#{startTime}用的是转义字符