l链接数据库
var mysql = require('mysql');
console.log(1)
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '123456',
database : 'test'
});
// connection.connect();
connection.connect(function(err){
if(err)
return console.log('连接失败!'+err.message);
console.log('连接成功')
})
module.exports = connection;
post api 实现
// 引入express
const express = require('express')
// 调用express()
const app = express()
var connection = require('./test.js')
var sql = 'SELECT * FROM websites';
var data;
connection.query(sql,function (err, result) {
if(err){
console.log('[SELECT ERROR] - ',err.message);
return;
}
data = result;
});
// // 使用中间件--请求的格式为普通键值对格式
// app.use(express.urlencoded())
// // 接口2--post普通键值对格式a=1&b=2
app.post('/addbooks', (request, response) => {
//request.body发送的请求的参数
console.log('请求返回', request.body)
//response.send响应回来的参数
console.log(1)
response.send({data:data})
})
app.listen(8000, function () {
})
console.log('Server running at http://127.0.0.1:8000/');
