Node.js实现http请求服务与Mysql数据库操作方法详解

const http = require('http');

http.createServer(function(request,response){})

response.end("<strong>hello server!!</strong>");

response.writeHead(200,{'Content-type':'text/html'});

http.createServer(function(request,response) {
    response.writeHead(200,{'Content-type':'text/html'})
    response.end("<strong>hello server!!</strong>");
}).listen(8888);

const http = require('http');
http.createServer(function(request,response) {
    response.writeHead(200,{'Content-type':'text/html'})
    response.end("<strong>hello server!!</strong>");
}).listen(8888);
console.log("您启动的服务是: http://localhost:8888已启动成功");

var mysql = require("mysql");

mysql.createConnection({
    host:"127.0.0.1",
    post:3306,
    user:"root",
    passWord:'111',
    database:"testdb"
});

var connection = mysql.createConnection({
    host:"127.0.0.1",
    post:3306,
    user:"root",
    password:'111',
    database:"testdb"
});

connection.connect();

connection.query("select * from user",function(error,results,fields) {
    //如果查询出错，直接抛出
    if(error)throw error;
    //查询成功
    console.log("results = ",results);
})

connection.end();

var mysql = require("mysql");
var connection = mysql.createConnection({
    host:"127.0.0.1",
    post:3306,
    user:"root",
    password:'111',
    database:"testdb"
});
connection.connect();
connection.query("select * from user",function(error,results,fields) {
    if(error)throw error;
    console.log("results = ",results);
})
connection.end();