当前位置：Gxlcms > 数据库问题 > egg 连接mysql 在mysql 插入数据

egg 连接mysql 在mysql 插入数据

时间：2021-07-01 10:21:17 帮助过：4人阅读

use strict‘; module.exports = appInfo => { const config = exports = {}; // use for cookie sign key, should change to your own and keep security config.keys = appInfo.name + ‘_1551971762613_5533‘; // add your config here config.middleware = []; config.mysql = { client: { host: ‘localhost‘, port: ‘3306‘, user: ‘root‘, password: ‘root‘, database:‘cms-api‘ } }, config.security= { csrf: { enable: false, } } return config; };

2.services

user.js

<span style="color: #0000ff;">const</span> Service = require(<span style="color: #800000;">‘</span><span style="color: #800000;">egg</span><span style="color: #800000;">‘</span><span style="color: #000000;">).Service;
</span><span style="color: #0000ff;">class</span><span style="color: #000000;"> UserService extends Service {
    </span><span style="color: #0000ff;">async</span><span style="color: #000000;"> create(user)  {
        let {app}</span>=<span style="color: #0000ff;">this</span><span style="color: #000000;">;
        let  result </span>= <span style="color: #0000ff;">await</span> app.mysql.insert(<span style="color: #800000;">‘</span><span style="color: #800000;">user</span><span style="color: #800000;">‘</span><span style="color: #000000;">,
             user
           );
        </span><span style="color: #0000ff;">return</span><span style="color: #000000;">  result;
     }
}
module.exports </span>= UserService;

3.Controller

user.js

<span style="color: #0000ff;">const</span> Controller = require(<span style="color: #800000;">‘</span><span style="color: #800000;">egg</span><span style="color: #800000;">‘</span><span style="color: #000000;">).Controller;
</span><span style="color: #0000ff;">class</span><span style="color: #000000;"> UserController extends Controller {
  </span><span style="color: #0000ff;">async</span><span style="color: #000000;"> create() {
    </span><span style="color: #0000ff;">const</span> { ctx,service} = <span style="color: #0000ff;">this</span><span style="color: #000000;">;
    let  user  </span>=<span style="color: #000000;">ctx.request.body;
    let  result  </span>= <span style="color: #0000ff;">await</span><span style="color: #000000;">  service.user.create(user);
    console.log(result);
    </span><span style="color: #0000ff;">this</span>.ctx.body=<span style="color: #000000;">result;
    </span><span style="color: #0000ff;">if</span>(result.affectedRows === <span style="color: #800080;">1</span><span style="color: #000000;">)  {
        </span><span style="color: #0000ff;">this</span>.ctx.body =<span style="color: #000000;">{
            code:</span><span style="color: #800080;">0</span><span style="color: #000000;">,
            data:result.insertId
        }
    }</span><span style="color: #0000ff;">else</span><span style="color: #000000;"> {
      </span><span style="color: #0000ff;">this</span>.ctx.body =<span style="color: #000000;">{
        code:</span><span style="color: #800080;">1</span><span style="color: #000000;">,
        data:</span><span style="color: #800000;">‘</span><span style="color: #800000;">用户添加失败</span><span style="color: #800000;">‘</span><span style="color: #000000;">
    }
    }
  } 
}
module.exports </span>= UserController;

<span class="line"><span class="comment">/ 判断插入成功<br><span class="line"><span class="keyword">const insertSuccess = result.affectedRows === <span class="number">1;</span></span></span></span></span>

result的打印解果

<span style="color: #000000;">OkPacket {
  fieldCount: </span><span style="color: #800080;">0</span><span style="color: #000000;">,
  affectedRows: </span><span style="color: #800080;">1</span><span style="color: #000000;">,
  insertId: </span><span style="color: #800080;">0</span><span style="color: #000000;">,
  serverStatus: </span><span style="color: #800080;">2</span><span style="color: #000000;">,
  warningCount: </span><span style="color: #800080;">0</span><span style="color: #000000;">,
  message: </span><span style="color: #800000;">‘‘</span><span style="color: #000000;">,
  protocol41: </span><span style="color: #0000ff;">true</span><span style="color: #000000;">,
  changedRows: </span><span style="color: #800080;">0</span> }

数据库添加数据成功

技术图片

egg 连接mysql 在mysql 插入数据

标签：edr pac 插入 sql war password info app log

egg 连接mysql 在mysql 插入数据

人气教程排行