egg连接mysql配置
1.npm安装mysql
npm i --save egg-mysql
2.启用mysql
//根目录 /config/plugin.js
module.exports = {
mysql: {
enable: true,
package: 'egg-mysql',
}
};
3.配置 mysql 数据库连接
//根目录 /config/config.default.js
config.mysql = {
client: {
host: 'localhost', //链接地址
port: '3306', //端口
user: 'egg', //数据库用户名
password: '123456', //数据库密码
database: 'eggDemo' //数据库名称
},
//load into app,default is open //加载到应用程序，默认为打开
app: true,
//load into agent,default is close //加载到代理中，默认值为“关闭”
agent: false,
};
4.操作数据库
'use strict';
const Controller = require('egg').Controller;
class UserController extends Controller {
async userList() {
// 1.增加数据
let addData = { username: "userName", password: "password",sort:1 }
let addRes = await this.app.mysql.insert(
"user", addData
);
// 2.查询单条数据
let userData = await this.app.mysql.get(
'user', { id: 1 }
);
// 3.查询多条数据，正序
let userDataAll = await this.app.mysql.select(
'user', { orders: [['sort', 'asc']] }
);
// 4.修改
let updRes = await this.app.mysql.update('user',{ id:1, username:'test' });
// 5.删除
let delRes= await this.app.mysql.delete('user',{ id:1 });
}
module.exports = UserController;
\
