sql:{
        host:'127.0.0.1',
        port:'3306',
        user:'root',
        password:'root',
        database:'test',
        showSql:true // 是否显示sql
    },

 redis: {
        isOpen: false,
        ip: '127.0.0.1',
        port: 6379,
        username: '',
        password: ''
    }

const express = require('express');
const router = express.Router();
const apiUtils = require('../../utils/apiUtils')

router.get('/test',async (req, res) => {
  try {
      apiUtils.sendSuccessMsg(res,"HelloWorld")
  } catch (error) {
      apiUtils.sendErrorMsg(res)
  }
})

module.exports = router;

app.use('/test', require(__dirname + '/src/api/helloWorldApi'));

const dbUtils = require('../../utils/dbUtils')

  var sql = "SELECT * FROM SYS_USER WHERE USER_NAME = '" + username + "' AND PASS_WORD = '" + password + "'";
  dbUtils.query(sql)
   .then(res=>{
       resolve(res)
   }).then(err=>{
       reject(err)
   })

var sql = " DELETE FROM SYS_USER WHERE ID = '" + id + "' ";
  dbUtils.update(sql)
    .then(res => {
        resolve(res)
    }).then(err => {
        reject(err)
    })

const redisUtils = require('../../utils/redisUtils')

redisUtils.set(key , 数据)

redisUtils.set(bizConst.userConst.REDIS_KEY, JSON.stringify(res))

redisUtils.get(值的key).then(res=>{
   // .. res为存入的数据
})

redisUtils.get(bizConst.userConst.REDIS_KEY).then(redisResult => {
  // 业务代码
})

redisUtils.del(值的key)

redisUtils.del(bizConst.userConst.REDIS_KEY)