中间件的应用

1.上传访问日志

 文件目录:

                 

 代码:

 

const express = require('express')
const app = express()
const fs = require('fs')
const path = require('path')
const url = path.join(__dirname,'./rizhi.txt')
function getClientIp(req) {
  return req.headers['x-forwarded-for'] ||
      req.connection.remoteAddress ||
      req.socket.remoteAddress ||
      req.connection.socket.remoteAddress;
}
  
  app.use((req,res,next) => {
    const dt = new Date() 
    let str =  `访问的地址: ${req.url}, 访问时间: ${dt.toLocaleTimeString()}, 来自: ${getClientIp(req)} `
    fs.appendFile(url, str,'utf8', (err) => {
      if (err) {
        console.log('err',err);
      } else {
        console.log('纪录成功');
      }
    })
    next();
  })
  app.use(express.static('public'))
 
  app.listen(8563)

 

---

 2.路由中间件

文件目录:

              

代码:

1.加载数据库

// 1. 加载mysql
const mysql = require('mysql');
// 2. 创建连接对象
const connection = mysql.createConnection({
    // 对象的属性名字不能改变
    host: 'localhost',
    port: 3306,
    user: 'root',
    password: 'root',
    database: 'student'
});
// 3. 连接到MySQL服务器
connection.connect((err) => {
  // 如果有错误对象，表示连接失败
  if (err) return console.log('数据库连接失败')
  // 没有错误对象提示连接成功
  console.log('mysql数据库连接成功')
});

module.exports = connection

2.POST接口

const express = require('express');
const connection = require('../tool/sgl')
const router = express.Router();
router.post('/add', (req, res) => {
  const {name, age} = req.body
    let sql = `insert into user(name, age) values("${name}",${age})`
    connection.query(sql, (err, data) => {
        if(err) {
            console.log(err)
            res.json({msg:'添加失败', code: 0})
        } else {
            console.log(data)
            // 返回
            res.json({msg:'添加成功', code: 1})
        }
});  
});
module.exports = router;  // 模块导出

 3.GET接口

const express = require('express');
const connection = require('../tool/sgl')
const router = express.Router();
router.get('/userinfo', (req, res) => {
        const sql = `select * from user`
        connection.query(sql,(err, data)=> {
            if(err) {
                res.json({msg:'查询失败', code: 0})
            } else {
                res.json({msg:'查询成功', code: 1,result: data})
            }
        })
});
module.exports = router;  // 模块导出

 4.DELETE接口

const express = require('express');
const connection = require('./tool/sgl')
const router = express.Router();
router.delete('/user', (req, res) => {
  const {name} = req.body
    let sql = `delete from user where ${name}`
    connection.query(sql, (err, data) => {
        if(err) {
            console.log(err)
            res.json({msg:'删除失败', code: 0})
        } else {
            console.log(data)
            // 返回
            res.json({msg:'删除成功', code: 1})
        }
});  
});
module.exports = router;  // 模块导出

 5.合并

const express = require('express');
const app = express();
app.use(express.urlencoded())
const apiRouter = require('./router/delete')
const categoryRouter = require('./router/my/category');
const userRouter = require('./router/my/user');

// 路由中间件 
app.use('/delete', apiRouter)
app.use('/my/category', categoryRouter);
app.use('/my/user', userRouter);


app.listen(7777,()=>{
    console.log('express应用在7777端口启动了'); 
})

 

---