在egg.js中使用MySQL的步骤如下:
egg-mysql
,可以通过npm安装:$ npm install egg-mysql --save
config/plugin.js
配置文件中启用MySQL插件:exports.mysql = {
enable: true,
package: 'egg-mysql',
};
config/config.default.js
配置文件中配置MySQL连接信息:exports.mysql = {
client: {
host: 'localhost',
port: '3306',
user: 'root',
password: 'password',
database: 'test',
},
};
const Controller = require('egg').Controller;
class UserController extends Controller {
async index() {
const { ctx } = this;
const user = await this.app.mysql.get('user', { id: 1 });
ctx.body = user;
}
async create() {
const { ctx } = this;
const result = await this.app.mysql.insert('user', { name: 'Alice', age: 18 });
ctx.body = result;
}
async update() {
const { ctx } = this;
const result = await this.app.mysql.update('user', { id: 1, age: 20 });
ctx.body = result;
}
async destroy() {
const { ctx } = this;
const result = await this.app.mysql.delete('user', { id: 1 });
ctx.body = result;
}
}
module.exports = UserController;
这样就可以在Egg.js中使用MySQL进行数据库操作了。