Nodejsの簡単な構築

var app = express();//web  
var mysql=require('mysql')//mysql   
var url=require('url')//post   url    
var body=require('body-parser')//     body    
app.use('/public',express.static('public'))//         
/public      public    ，    img      /public/img
const con=mysql.createConnection({//mysql     
   host:"localhost",
   user:"root",
   password:"123456",
   database:"book"
})
con.connect();
let book="";
//       "Hello World"
app.get('/index',function(req,res){
   res.sendFile(__dirname+'/'+'index.html');//      
})
app.get('/view',function(req,res){
   res.sendFile(__dirname+'/view/'+'index.html');
})
app.get('/model',function(req,res){
   res.sendFile(__dirname+'/model/'+'index.html');
})
app.get('/controller',function(req,res){
   res.sendFile(__dirname+'/controller/'+'index.html');//_filename
})
app.get('/', function (req, res) {//get post                     
   console.log("   GET   ");
   res.set("Access-Control-Allow-Origin","http://localhost:8080")
   // var admin={
   //    user:req.query.user,
   //    pass:req.query.pass
   // }
   res.json(req.query)
   // con.query("SELECT * FROM books  WHERE name='    '",function(err,result,field){
   //    if(err) throw err;
   //   console.log(result)

   //  res.json(result)
   // })
   // const user={
   //    age:18,
   //    sex:" "
   // }
  
})
 
const u=body.urlencoded({extended:false})//  body.parse  body      url  
//  POST   
app.post('/',u,function (req, res) {
   res.set("Access-Control-Allow-Origin","http://localhost:8080")
   console.log("   POST   ");
   var admin={
      user:req.body.user,
      pass:req.body.pass
   }
   res.json(admin)
  
})
 
//  /del_user     
app.get('/del_user', function (req, res) {
   console.log("/del_user    DELETE   ");
   res.send('    ');
})
 
//  /list_user    GET   
app.get('/list_user', function (req, res) {
   console.log("/list_user GET   ");
   res.send('      ');
})
 
//     abcd, abxcd, ab123cd,     GET   
app.get('/ab*cd', function(req, res) {   
   console.log("/ab*cd GET   ");
   res.send('    ');
})
 
 
var server = app.listen(8081, function () {//           
 
  var host = server.address().address
  var port = server.address().port
 
  console.log("    ，      http://%s:%s", host, port)
 
})