# youn-node-basic

**Repository Path**: base_yang/youn-node-basic

## Basic Information

- **Project Name**: youn-node-basic
- **Description**: node 服务端的建立
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-01-15
- **Last Updated**: 2024-01-15

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# node 项目测试

## 热部署
nodemon

## 路由监听
```js
function queryParam (req) {
  const query = req.query;
  return query;
}
// 监听客户端的 GET 和 POST 请求，并响应请求
app.get("/user", (req, res) => {
  res.send(Result.SuccessResult("GET 请求成功", queryParam(req)));
})
app.post("/user", (req, res) => {
  res.send(Result.SuccessResult("POST 请求成功！"));
})
// 动态参数的测试使用 "/user/:id/:name"
app.get("/user/:id", (req, res) => {
  res.send(Result.SuccessResult(`请求成功！查询参数`, req.params));
})
```

## mysql 的使用
> 普通的put 请求的例子
```js
  const db = require("../tools/mysql");
  const { Router } = require("express");
  const { SuccessResult, ErrorResult } = require("../utils");

  const router = Router();

  router.put("/user", (req, res) => {
    const user = req.query;
    // const sqlStr = 'INSERT INTO sys_user (name, phone) VALUES (?, ?)'
    const sqlStr = 'INSERT INTO sys_user SET ?'
    db.query(sqlStr, user, (err, results) => {
      if(err) return console.log(err.message);
      if(results.affectedRows === 1) {
        res.send(SuccessResult("用户保存成功！"));
      } else {
        res.send(ErrorResult("用户保存失败！"));
      }
    })
  });
```