egg.js的基本使用和調(diào)用數(shù)據(jù)庫的方法示例

npm i egg-init -g //安裝egg
egg-init egg-example --type=simple //初始化一個egg模板例子 后面的type跟的是模板類型這里是簡單的
cd egg-example//進入例子
npm i //安裝依賴

'use strict';

/**
 * @param {Egg.Application} app - egg application
 */
module.exports = app => {
 const { router, controller } = app;
 router.get('/', controller.home.index);
 router.get('/custom',controller.customController.custonIndex); //自定義controller的路由
};

'use strict';

const Controller = require('egg').Controller;

class CustomController extends Controller {
  async custonIndex() { //注意這里要定義成異步方法防止請求被阻塞
    //let {id} = this.ctx.params; // 獲取路由參數(shù)
    //let {name} = this.ctx.query; // 獲取用戶入?yún)?    let options = {id:'5', name:2}
    
    let info = await this.ctx.service.customService.getInfo(options);//調(diào)用Service層傳參
    處理，返回結(jié)果賦值
    
    this.ctx.body = {
      code: 200,
      data: info
    };//返回體
    this.ctx.status = 200;
  }
}

module.exports = CustomController;

const Service = require('egg').Service;

class CustimService extends Service {
  async getInfo(options) {
    const results = await this.app.MySQL.select('test',{id:5});
    return results[0].name;
  }
}

module.exports = CustimService;

'use strict';

module.exports = appInfo => {
 const config = exports = {
   mysql:{
     // 單數(shù)據(jù)庫信息配置
     client: {
       // host
       host: '44.44.44.44',
       // 端口號
       port: '3306',
       // 用戶名
       user: 'mysq',
       // 密碼
       password: '359359',
       // 數(shù)據(jù)庫名
       database: 'mysql_db',
     },
     // 是否加載到 app 上，默認(rèn)開啟
     app: true,
     // 是否加載到 agent 上，默認(rèn)關(guān)閉
     agent: false,
   }
 };

 // use for cookie sign key, should change to your own and keep security
 config.keys = appInfo.name + '_17792_5967';

 // add your config here
 config.middleware = [];

 return config;
};