使用express框架简单写一写数据库的增删查改接口,技术栈为 express + mysql + nodejs
const httpManager = require('http');
const mysql = require('mysql');
// const urlManager = require('url');
var express = require('express');
var app = express();
var bodyParser = require('body-parser')
//设置跨域访问
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();
});
//实现本地链接
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '123456'