Const HTTP = require ("http");
Const EXPRESS = require ("Express");
Const MySQL = require ("MySQL");
var pool = Mysql.createpool ({
Host: ' 127.0.0.1 ',
User: ' Root ',
Password: ",
Database: ' JD ',
Connectionlimit:5
});
var app = Express ();
var server = Http.createserver (APP);
Server.listen (80);
App.get ("/", (req,res) =>{
Res.sendfile (__dirname+ "/public/users.html");
});
App.get ("/jquery", (req,res) =>{
Res.sendfile (__dirname+ "/public/jquery-1.11.3.js");
});
App.get ("/list.do", (req,res) =>{
Pool.getconnection ((err,conn) =>{
Conn.query ("SELECT * from Jd_user", (Err,result) =>{
Res.json (result);
});
});
});
App.get ("/add", (req,res) =>{
Res.sendfile (__dirname+ "/public/user_add.html");
});
App.get ("/add.do", (req,res) =>{
var u = req.query.uname;
var p = req.query.upwd;
Pool.getconnection ((err,conn) =>{
Conn.query ("INSERT into jd_user values (null,?,?)", [U,p], (Err,result) =>{
Res.json (result);
});
});
});
Node http and Express and MySQL