ajax mysql 接口_用原生node实现服务器上的MySQL数据库传送给前端ajax接口接收

node代码实现

```node var http = require("http"); var fs = require("fs"); var url = require("url"); var mysql = require("mysql");

http.createServer(function(request, response) {

var connection = mysql.createConnection({ host : "localhost", post : 3000, user : "", password : "", database : "123" });

var pathname = url.parse(request.url).pathname; var ext = pathname.match(/(.[^.]+|)$/)[0]; //取得后缀名 switch (ext) { case ".css": case ".js": case ".png": case ".jpg": fs.readFile("." + request.url, function(err, data) { response.writeHead(200, { "Content-Type": { ".css": "text/css", ".js": "application/javascript", ".jpg": "image/jpeg", ".png": "image/png", }[ext] }); response.end(data); }); break; default: if(request.url == "/login"){ connection.query("SELECT * FROM login", function(error, results) { if(error) { console.log("login error"); } else { var loginobj = { success : true, information : results }; response.end(JSON.stringify(loginobj)); } }); } else if(request.url == "/lotteryPeople") { connection.query("SELECT * FROM lotteryPeople", function(error, results) { if(error) { console.log("lottey error"); } else { var lotteryPeopleobj = { success : true, lotteryP : results }; response.end(JSON.stringify(lotteryPeopleobj)); } });

} else { fs.readFile("./index.html", "utf-8", function(err,data) { if (err) throw err; //response.write();

response.writeHead(200, { "Content-Type": "text/html", }); response.end(data); }); } } //connection.end(); }) .listen(3000); console.log("server start...");

注释：创建用户给权限从服务器的123数据库上取得login和lotteryPeople两张表上的数据返回给前端，这里我只实现了从服务器取数据给前端ajax接口接收，在前端ajax接口接收url分别写"http://xxx:3000/login"和"http://xxx:3000/lotteryPeople"即可。