在线监测-实时监控-历史实时bug修复

whyclxw

2022-01-17 d643e8efd0a726050a28cdc4e908b9113e5ee00d

在线监测-实时监控-历史实时bug修复

 src/main/java/com/whyc/mapper/BattRealdataMapper.java

@@ -8,4 +8,6 @@
public interface BattRealdataMapper extends CustomMapper<BattRealdata>{
    //查询历史实时数据
    List<BattRealdata> serchByCondition(BattRealdata realdata);
    //判断表是否存在
    int judgeTable(@Param("table") String table);
}

 src/main/java/com/whyc/service/BattRealdataService.java

@@ -8,6 +8,7 @@
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;

@Service
@@ -17,9 +18,13 @@
    //查询历史实时数据
    public Response serchByCondition(BattRealdata realdata) {
        String table=realdata.getBattGroupId()+"_"+ActionUtil.sdfwithOutday.format(realdata.getRecrodTime());
        System.out.println(table);
        realdata.setNote(table);//表名时间格式部分
        List<BattRealdata> list=mapper.serchByCondition(realdata);
        //判断表是否存在
        int tableNum=mapper.judgeTable(table);
        List<BattRealdata> list=new ArrayList();
        if(tableNum>0){
            list=mapper.serchByCondition(realdata);
        }
        PageInfo pageInfo=new PageInfo(list);
        return new Response().set(1,pageInfo);
    }

 src/main/resources/mapper/BattRealdataMapper.xml

@@ -8,4 +8,7 @@
                where  recrod_time>=#{recrodTime} and recrod_time&lt;=#{recrodTime1}
                order by recrod_time asc
    </select>
    <select id="judgeTable" resultType="java.lang.Integer">
        select count(*) as tableNum from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='db_batt_history' and TABLE_NAME='tb_batt_realdata_${table}' ;
    </select>
</mapper>