数据库操作

select * from acscon_realnode where addr='100-30#1-2'

--获取保持数据总数
select count(id) from acscon_downCardToDoorRef where realnodeid='22382915-C8C5-E611-8D5B-00155D00FD00'


--获取未更新状态数量
 select count(id) from acscon_downCardToDoorRef where realnodeid='22382915-C8C5-E611-8D5B-00155D00FD00' and updatetime is null

--获取未更新状态列表
select * from acscon_downCardToDoorRef where realnodeid='22382915-C8C5-E611-8D5B-00155D00FD00' and updatetime is null

--清空数据库
delete from acscon_downCardToDoorRef where realnodeid='22382915-C8C5-E611-8D5B-00155D00FD00'