安装插件
$ npm i egg-mysql --save配置 配置书写方法见egg.js 2
//在 config/plugin.js mysql: { enable: true, package: 'egg-mysql', //在config/config-default.js config.mysql = { // database configuration client: { // host host: 'mysql.com', // port port: '3306', // username user: 'test_user',//账号 // password password: 'test_password', //密码 // database database: 'test', }, // load into app, default is open app: true, // load into agent, default is close agent: false, }; };首先重新启动后台项目 在controller/articels
const Controller = require('egg').Controller class ArticlesController extends Controller { async articles() { const { ctx } = this var result = await ctx.service.articles.article() console.log(result) ctx.body = { code: 1, msg: 'success', data: result } } } module.exports = ArticlesController然后在 文件夹 app 里 新建 serveice 文件夹 在里面写 跟接口相同名称的js文件
// app/service/articles const Service = require('egg').Service; class ArticleService extends Service { async article( ) { const { app } = this var result = app.mysqle.get('articles') return result }); module.exports = ArticeService