var express = require(‘express‘);var bodyParser = require("body-parser");var cors = require(‘cors‘);var app = express();var mysql = require(‘mysql‘);var connection = mysql.createPool({    connectionLimit : 10,    host   : ‘localhost‘,    user   : ‘root‘,　　//数据库登陆就名    password : ‘123321‘, //数据库登陆密码    database : ‘test1‘ //数据库名});app.use(cors()); //跨域处理app.use(bodyParser.json());app.use(bodyParser.urlencoded({ extended: true }));//查询userapp.get(‘/listUsers‘, function (req, res) {    connection.query(‘select * from `userone`‘, function(err, rows, fields) {        if (err) throw err;        var data = http://www.mamicode.com/{code:‘200‘,code_decoration:‘查询成功‘};        data.order = rows;        res.send(data);    })});//增加userapp.post(‘/adduser‘, function(req, res){    console.log(req.body);    var param = req.body || req.params;    connection.query(‘insert into userone(id, name, password, email) values(0,?,?,?)‘, [param.name,param.password,param.email], function(err, result) {        if (err){            throw err;        }else{            var data = http://www.mamicode.com/{code:‘200‘,code_decoration:‘添加成功‘};            res.send(data);        }    });});//删出userapp.post(‘/delUser‘, function (req, res) {    var name = req.body.name || req.params.name;    console.log(name);    connection.query("delete from userone where name=" + name, function (err, rows) {        if (err) {            res.send(‘删除失败：‘ + err);                    } else {            var data = http://www.mamicode.com/{code:‘200‘,code_decoration:‘删除成功‘};            res.send(data);        }    });});//update userapp.post(‘/updateUser‘, function (req, res) {    var param = req.body || req.params;    console.log(param.name + ‘--‘ +param.password);    connection.query("update userone set password=" + param.password + ‘where name=‘ + param.name, function (err, rows) {        if (err) {            res.send(‘更新失败：‘ + err);        } else {            var data = http://www.mamicode.com/{code:‘200‘,code_decoration:‘更新成功‘};            res.send(data);        }    });});var server = app.listen(8081, function () {  console.log("服务启动成功！");})