var data={total:0,users:0,peruser:0,disks:[]} // 读取数据库数据 axios.get("../data/diskinfo.db",{responseType: 'arraybuffer'}, {headers:{'Access-Control-Allow-Origin': '*'}}) .then(function (response) { let db = new window.SQL.Database(new Uint8Array(response.data)); // 执行查询 let r = db.exec("SELECT * FROM sdiskusage where flag=1;"); // 解析数据 let col=r[0].columns; let val=r[0].values; //console.info(r[0]); for(i = 0,len_i=val.length; i < len_i; i++) { tmp={}; for(j=0,len_j=val[i].length;j<len_j;j++){ tmp[col[j]]=val[i][j]; } tmp['name']=tmp['device']; tmp['value']=tmp['percent']; data.total+=tmp['total']; data.users+=tmp['used']; if(tmp['total']>1){ tmp['total']=Math.round(tmp['total'])+"G"; } else{ tmp['total']=Math.round(tmp['total']*1024)+"M"; } data.disks[i]=tmp; } data.peruser=(data.users/data.total*100).toFixed(2)+"%"; if(data.total>1){ data.total=Math.round(data.total)+"G"; } else{ data.total=Math.round(data.total*1024)+"M"; } if(data.users>1){ data.users=Math.round(data.users)+"G"; } else{ data.users=Math.round(data.users*1024)+"M"; } console.info(data); }) .catch(function (error) { console.info(error); });