node + express + mysql 初识服务端
前期准备
npm install express --save
npm install mysql
npm install body-parser // POST请求获取body 用到
链接数据库
const connection = mysql.createConnection({
host: '127.0.0.1', // IP
port: '8888', // 端口
user: 'userName', // 用户名
password: 'password', // 密码
database: 'test_demo' // 想要连接的库
});
接口统一处理
app.all('*', function (req, res, next) {
res.header("Access-Control-Allow-Origin", "*");
res.header("Access-Control-Allow-Headers", "X-Requested-With");
res.header("Access-Control-Allow-Methods", "PUT,POST,GET,DELETE,OPTIONS");
res.header("X-Powered-By", ' 3.2.1');
res.header("Content-Type", "application/json;charset=utf-8");
next();
});
代码展示