以下的这些就是一个简单的增删查
技术栈
前台: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,
}