node服务端实现mysql连接

1. 自己安装mysql
2. 直接上代码

   var express=require('./node_modules/express');
   var app =express();
   var mysql=require('./node_modules/mysql');
   
   //设置跨域访问
   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 server = app.listen(3000, function () {
       var host = server.address().address;
        var port = server.address().port;
           console.log('Example app listening at http://%s:%s', host, port);
       })
   	//创建连接
   	var db=mysql.createConnection({
   		host:"localhost",
   		user:"root",
   		password:"123456",
   		database:"test"
   	})
   	db.connect((err)=>{
   		if(err) throw err;
   		console.log("连接成功");
   	})
   	//查询内容
   	app.get("/getselect",(req,res)=>{
   		let sql="select * from kalmanresult where id>19883153";
   		db.query(sql,(err,result)=>{
   			if(err){
   				console.log(err);
   			}else{
   				console.log(result);
   				//将查询结果以json的类型返回
   				res.json(result);	
   			}
   		})
   	})
   	

   注意：将sql改为自己的查询语句发送“/getselect”请求即可