egg+react 增加 删除 详情

以下的这些就是一个简单的增删查

技术栈

前台：react
后台： egg+mysql

后台

• app/controller.user

'use strict';

const Controller = require('egg').Controller;
class userController extends Controller {
   
   //获取数据库数据
  async userlist() {
   
    const {
    ctx ,service} = this;
    let result=await service.user.userlist()
     ctx.body={
   
        ...{
   result},
         code:1,
     }
   
  }

   //详情
  async getdetail() {
   
    const {
    ctx ,service} = this;
     let uid=ctx.query.uid;
     console.log(uid,"11")
     let result= await service.user.getdetail(uid);
      ctx.body={
   
        ...{
   result},
        code:1,
    }
  }
  
    //删除
    async getdel(){
   
      const {
   ctx,service}=this;
      let uid=ctx.query.uid;
      let result=await service.user.getdel(uid)
        ctx.body=result;
    }
    
    //添加
    async addlist(){
   
      const {
   ctx,service}=this;
      let username=ctx.request.body.username;
      let name=ctx.request.body.name;
      let password=ctx.request.body.password;
      let tel=ctx.request.body.tel;
      let address=ctx.request.body.address;
     
      let result=await service.user.addlist(username,name,password,tel,address)
      ctx.body=result;
       
    }    
}

module.exports = userController;

• app/service/user.js

const Service=require("egg").Service;
class UserService extends Service{
   
    async userlist(){
   
        let result=await this.app.mysql.select("users")
        // console.log(result)
        return result;
    }   
     //详情
     async getdetail(uid){
   
         return await this.app.mysql.get("users",{
   uid})
     } 
     //删除
     async getdel(uid){
   
         console.log(uid,'1')
         return await this.app.mysql.delete("users",{
   uid:uid})
     }

      //添加
      async addlist(username,name,password,tel,address){
   
          console.log(username,"111")
         return await this.app.mysql.insert("users",{
   
             username:username,
             name:name,
             tel:tel,
             address:address,
         }