1.npm init 生成package.json文件
2. 安装依赖
npm install express –save
npm install body-parser –save
3.新建app.js
4.新建index.html
app.js
const http = require(‘http’);
var express=require(‘express’);
var app =express();
var bodyParser = require(‘body-parser’);
//引用bodyParser 这个不要忘了写
app.use(bodyParser.json()); // for parsing application/json
app.use(bodyParser.urlencoded({ extended: true })); // for parsing application/x-www-form-urlencoded
//设置跨域访问
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 questions=[
{
data:213,
num:444,
age:12
},
{
data:456,
num:678,
age:13
}];
//接口123
app.get(’/123’,function(req,res){
res.status(200),
res.json(questions)
});
//开启服务器
var server = app.listen(3000, function () {
var host = server.address().address;
var port = server.address().port;
console.log('服务器开启成功', host, port);
})
在终端执行node app.js,成功会看到‘服务器开启成功’::3000
index.html 接接口
$.ajax({
type:‘get’,
url:‘http://localhost:3000/123’,
success:function(data){
console.log(data);
},
error:function(){
console.log(‘error’);
}
})
nodejs连接数据库
test.js
var mysql = require(‘mysql’);
var connection = mysql.createConnection({
host : ‘localhost’,
user : ‘root’,
password : ‘123456’,
database : ‘mis15’
});
connection.connect();
var sql = ‘SELECT * FROM user’;
//查询
connection.query(sql,function (err, result) {
if(err){
console.log(’[SELECT ERROR] - ',err.message);
return;
}
console.log('--------------------------SELECT----------------------------');
console.log(result);
console.log('------------------------------------------------------------\n\n');
});
connection.end();
在终端执行node test.js