nodejs

const express = require('express');

const app = express();

const moment = require('moment');

const cors = require('cors');

app.use(cors());

const bodyParser = require('body-parser');

app.use(bodyParser.urlencoded({

extended: true

}))

app.use(bodyParser.json());

 

const mysql = require('mysql');

const conn = mysql.createConnection({

host: '127.0.0.1',

user: 'root',

password: '2018',

database: 'android',

multipleStatements: true

})

app.get('/api/getlist', (req, res) => {

const sqlStr = 'select * from users'

conn.query(sqlStr, (err, results) => {

if (err) return res.json({

err_code: 1,

message: '数据不存在',

affextedRows: 0

})

res.json({

err_code: 200,

message: results,

affextedRows: results.affextedRows

})

})

})

 

function userHas(req) {

const sqlStr = 'select * from user where ?'

let user = {

imei: req.body.imei

};

conn.query(sqlStr, user, (err, results) => {

if (err) {

return true;

}

return false;

})

}

app.post('/api/addcard', (req, res) => {

let check = userHas(req);

console.log(check);

// const user = {};

// user.imei = req.body.imei

// user.lockopener = req.body.lockopener

// const sqlStr = 'insert into user set ?'

// conn.query(sqlStr, user, (err, results) => {

// if (err) return res.json({

// err_code: 1,

// message: err,

// affectedRows: 0

// })

// res.json({

// err_code: 0,

// message: '恭喜成功',

// affectedRows: results.affectedRows

// })

// })

})

 

app.listen(3000, () => {

console.log('正在监听端口3000,http://192.168.0.119:3000'); //192.168.1.114换成你的ip,本机ip查询用cmd=>ipconfig

})