sqlite

[ { ID: 1,
    Time: '2019-04-13 18:36:44',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '升级版本',
    Mark:
     '版本升级成功!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4T2-JSDX,V2.0.0.0) ' },
  { ID: 2,
    Time: '2019-04-13 18:37:49',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '升级配置',
    Mark:
     '配置升级成功!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 3,
    Time: '2019-04-13 18:37:49',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '',
    Mark:
     'Over1  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 4,
    Time: '2019-04-13 18:40:45',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '升级配置',
    Mark:
     '配置升级成功!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 5,
    Time: '2019-04-13 18:40:45',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '',
    Mark:
     'Over1  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 6,
    Time: '2019-04-13 18:43:04',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '文件下载失败!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 7,
    Time: '2019-04-13 18:43:46',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '文件下载失败!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 8,
    Time: '2019-04-13 18:44:21',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '文件下载失败!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 9,
    Time: '2019-04-13 18:45:10',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '文件下载失败!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 10,
    Time: '2019-04-13 18:45:43',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '文件下载失败!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 11,
    Time: '2019-04-13 18:46:23',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '未知错误!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 12,
    Time: '2019-04-13 18:47:31',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '升级配置',
    Mark:
     '配置升级成功!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 13,
    Time: '2019-04-13 18:47:31',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '',
    Mark:
     'Over1  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 14,
    Time: '2019-04-13 18:49:35',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '升级版本',
    Mark:
     '版本升级成功!  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4_T2-default,V2.0.0.0) ' },
  { ID: 15,
    Time: '2019-04-13 18:50:45',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '未知错误!  (V2.0.3T1,HN5RN78J2800001,V2.0.1,V2.0.4T2-JSDX,V2.0.0.0) ' },
  { ID: 16,
    Time: '2019-04-13 18:54:34',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '未知错误!  (V2.0.3T1,HN5RN78J2800001,V2.0.1,V2.0.4T2-JSDX,V2.0.0.0) ' },
  { ID: 17,
    Time: '2019-04-13 18:55:26',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '文件下载失败!  (V2.0.3T1,HN5RN78J2800001,V2.0.1,V2.0.4T2-JSDX,V2.0.0.0) ' },
  { ID: 18,
    Time: '2019-04-13 18:55:45',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '文件下载失败!  (V2.0.3T1,HN5RN78J2800001,V2.0.1,V2.0.4T2-JSDX,V2.0.0.0) ' },
  { ID: 19,
    Time: '2019-04-13 18:56:07',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级配置',
    Mark:
     '文件下载失败!  (V2.0.3T1,HN5RN78J2800001,V2.0.1,V2.0.4T2-JSDX,V2.0.0.0) ' },
  { ID: 20,
    Time: '2019-04-13 18:57:46',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '失败',
    Item: '升级版本',
    Mark:
     '文件下载失败!  (V2.0.3T1,HN5RN78J2800001,V2.0.1,V2.0.4T2-JSDX,V2.0.0.0) ' },
  { ID: 21,
    Time: '2019-04-13 19:00:51',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '升级版本',
    Mark:
     '版本升级成功!  (V2.0.3T1,HN5RN78J2800001,V2.0.1,V2.0.4T2-JSDX,V2.0.0.0) ' },
  { ID: 22,
    Time: '2019-04-13 19:01:51',
    DevModel: 'E8820C',
    DevSN: '7c:39:53:a8:c7:e8',
    Result: '成功',
    Item: '升级版本',
    Mark:
     'Over1  (V2.0.4_JSDXT1,HN5RN78J2800001,V2.0.1,V2.0.4T2-JSDX,V2.0.0.0) ' } ]


var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('record.db3');

db.all("select * from detail",  function (err, row) {
    console.log(row)
    var Time = row.Time;

});
var os=require("os");
var networkInterfaces=os.networkInterfaces();
if(networkInterfaces.length!=0)
    console.log(networkInterfaces["本地连接"][0].mac);
//console.log(networkInterfaces);



{
  "name": "sqlite",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "author": "",
  "license": "ISC",
  "dependencies": {
    "sqlite3": "^4.0.6"
  }
}

  

posted @ 2019-04-13 19:58  cnchengv  阅读(116)  评论(0编辑  收藏  举报