[{"pid":"000000000015","type":"0","addr":"ZYG15","addrv":"3434.540039","ctime":"1970/01/27 16:15:54"},{"pid":"000000000015","type":"0","addr":"ZWG15","addrv":"906.599976","ctime":"1970/01/27 16:15:54"},{"pid":"000000000017","type":"0","addr":"ZYG17","addrv":"4430.660156","ctime":"1970/01/27 16:15:54"},{"pid":"000000000017","type":"0","addr":"ZWG17","addrv":"1260.770020","ctime":"1970/01/27 16:15:54"},{"pid":"000000000007","type":"0","addr":"ZYG07","addrv":"10429.730469","ctime":"1970/01/27 16:15:54"},{"pid":"000000000007","type":"0","addr":"ZWG07","addrv":"2233.939941","ctime":"1970/01/27 16:15:54"},{"pid":"000000000008","type":"0","addr":"ZYG08","addrv":"3346.370117","ctime":"1970/01/27 16:15:54"},{"pid":"000000000008","type":"0","addr":"ZWG08","addrv":"965.059998","ctime":"1970/01/27 16:15:54"},{"pid":"000000000095","type":"0","addr":"ZYG95","addrv":"24052.509766","ctime":"1970/01/27 16:15:54"},{"pid":"000000000095","type":"0","addr":"ZWG95","addrv":"329.790009","ctime":"1970/01/27 16:15:54"}]
万能的格友
上面的字符串,是MQTT设备的订阅消息存储到数据库里的文本数据,PID代表的是设备ID, addr 代表的是数据ID,ADDRV代表的是数据,我根据设备ID,数据ID,用函数提取出后面的数据,求函数和写法。
|