# manage

**Repository Path**: guoyer/manage

## Basic Information

- **Project Name**: manage
- **Description**: nodejs+express + [mongodb / mysql]
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-10-29
- **Last Updated**: 2021-10-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## mongodb 和 mysql 数据库切换实现 登录 注册, token验证
## 切换数据库修改config/db_config.js use属性

## 接口
```js
[
    {
        "url": "http://127.0.0.1:3000/reg",
        "method": "post",
        "params": {
            "username": "String",
            "password": "String"
        }
    },
    {
        "url": "http://127.0.0.1:3000/login",
        "method": "post",
        "params": {
            "username": "String",
            "password": "String"
        }
    },
    {
        "url": "http://127.0.0.1:3000/verify",
        "method": "get",
        "params": {
            "username": "String"
        },
        "headers": {
            "authorization": "String"
        }
    },
    {
        "url": "http://127.0.0.1:3000/check",
        "method": "get",
        "params": {
            "username": "String"
        }
    }
]
```
## mysql
```js
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `username` varchar(64) DEFAULT NULL COMMENT '用户名',
  `password` varchar(32) DEFAULT NULL COMMENT '用户密码',
  PRIMARY KEY (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户表';
INSERT INTO `users` VALUES ('1', 'admin', 'admin');
```

## mongodb
```js
use manage;
db.users.insertOne({username:"admin",password:"admin"});
```