1創建連接池對象

2導出連接池對象

/** * 1.引入mysql模塊 * 2.創建連接池對象 * 3.導出連接池對象 */const mysql = require('mysql');var pool = mysql.createPool({  host:'localhost',  port:'3306',  user:'xxx',  password:'xxx',  database:'xxx',  connectionLimit:20});module.exports = pool;

1托管靜態資源到public

2使用body-parser中間件

3使用路由器掛在到指定的位置

//引入express模塊const express = require('express');//引入路由器const userRouter = require('./routes/user.js');const productRouter = require('./routes/product.js');const myproRouter = require('./routes/mypro.js');const demoRouter = require('./routes/demo.js');const bodyParser = require('body-parser');//創建web服務器var server = express();//監聽端口server.listen(8080);//托管靜態資源server.use(express.static('public'));server.use(express.static('ajaxdemo'));server.use(express.static('mypro'));server.use(express.static('js'));server.use(express.static('css'));server.use(express.static('bootstrap'));server.use(express.static('img'));//使用body-parser中間件server.use(bodyParser.urlencoded({  extended:false}));//掛載路由器server.use('/user',userRouter);server.use('/demo',demoRouter);

1引入連接池模塊

2創建路由器對象

3往路由器中添加路由

4在路由中使用連接池

5導出路由器

/*  1.引入express  2.創建路由器對象  3.添加路由  4.導出路由器  5.引入連接池對象  6.將數據插入到數據庫中*/const express = require('express');const pool = require('../pool.js');var router = express.Router();//查看所有數據router.get('/sele', (req, res) => {  //驗證數據是否為空  var obj = req.query;  //console.log('query',obj);  for(var key in obj) {    if(!obj[key]) {      res.send('數據不能為空');      return;    }  }  var sqlselect = 'select * from xxx';  pool.query(sqlselect,(err, result) => {    if(err) throw err;    if(result.length > 0) {      res.send(result);    }  });});//查看用戶名router.get('/seleUname', (req, res) => {  //驗證數據是否為空  var obj = req.query;  //console.log('query',obj);  for(var key in obj) {    if(!obj[key]) {      res.send('數據不能為空');      return;    }  }  var sqlselect = 'select uname from xxx where uname = ?';  pool.query(sqlselect,[obj.uname],(err,result) => {    if(err) throw err;    if(result.length > 0) {      console.log(result.tength);      res.send('1');    }else{      res.send('0');    }  });});router.post('/reg', (req, res) => {  var obj = req.body;  console.log('body',obj);  for(var key in obj){    if(!obj[key]){      res.send('內容不能為空');      return;    }  }  var selectInsert = 'insert into xxx set ?';  pool.query(selectInsert, [obj], (err, result) => {    if(err) throw err;    if(result.affectedRows > 0) {      console.log(result.affectedRows)      res.send('1');    } else {      res.send('0');      console.log(result.affectedRows)    }  });});//導出路由器module.exports = router;