NestJS 管理员增删改查功能实现

NestJS 管理员增删改查功能实现 | 极客日志

@Get('add') @Render('admin/manager/add')
async add() {
  let result = await this.roleService.find({});
  return { roleResult: result };
}

@Post('doAdd')
async doAdd(@Body() body, @Response() res) {
  console.log('body: ', body);
  if (body.username == '' || body.password.length < 2) {
    this.toolsService.error(res, '用户名或密码长度不合法', `/${Config.adminPath}/manager/add`);
  } else {
    // 从数据库查询当前用户名是否存在
    let adminResult = await this.adminService.find({'username': body.username});
    if (adminResult.length > 0) {
      this.toolsService.error(res, '此管理员已存在', `/${Config.adminPath}/manager/add`);
    } else {
      body.password = this.toolsService.getMd5(body.password);
      let result = await this.adminService.add(body);
      console.log('result: ', result);
      if (result) {
        this.toolsService.success(res, `/${Config.adminPath}/manager`);
      } else {
        this.toolsService.error(res, '增加失败', `/${Config.adminPath}/manager/add`);
      }
    }
  }
}

<form action="/<%=config.adminPath%>/manager/doAdd" method="post">
  <ul>
    <li>管理员名称：<input type="text" name="username"/></li>
    <li>管理员密码：<input type="text" name="password"/></li>
    <li>管理员电话：<input type="text" name="mobile"/></li>
    <li>管理员邮箱：<input type="text" name="email"/></li>
    <li>管理员角色：
      <select name="role_id" id="role_id">
        <%for(var i=0; i<roleResult.length; i++){%>
          <option value="<%=roleResult[i]._id%>"><%=roleResult[i].title%></option>
        <%}%>
      </select>
    </li>
    <li><button type='submit' class="btn btn-default">提交</button></li>
  </ul>
</form>

@Get()
@Render('admin/manager/index')
async index() {
  // 获取 admin 表以及 role 表关联数据
  var result = await this.adminService.getModel().aggregate([
    {
      $lookup: {
        from: "role",
        localField: "role_id",
        foreignField: "_id",
        as: "role"
      }
    }
  ]);
  console.log('result: ', JSON.stringify(result));
  return { adminResult: result };
}

<table class="table table-bordered">
  <thead>
    <tr class="th">
      <th>管理员名称</th>
      <th>管理员电话</th>
      <th>管理员邮箱</th>
      <th>管理员角色</th>
      <th class="text-center">操作</th>
    </tr>
  </thead>
  <tbody>
    <%for(var i=0;i<adminResult.length;i++){%>
    <tr>
      <td><%=adminResult[i].username%></td>
      <td><%=adminResult[i].mobile%></td>
      <td><%=adminResult[i].email%></td>
      <!-- adminResult[i].role[0].title -->
      <td><%=adminResult[i].role[0]%></td>
      <td class="text-center">
        <a href="/<%=config.adminPath%>/manager/edit?id=<%=adminResult[i]._id%>">修改</a>
        <a class="" href="/<%=config.adminPath%>/manager/delete?id=<%=adminResult[i]._id%>">删除</a>
      </td>
    </tr>
    <%}%>
  </tbody>
</table>

role_id: { type: mongoose.Types.ObjectId },

@Get('edit')
@Render('admin/manager/edit')
async edit(@Query() query) {
  let roleResult = await this.roleService.find();
  let adminResult = await this.adminService.find({_id: query.id});
  return { roleResult: roleResult, adminResult: adminResult[0] };
}

@Post('doEdit')
async doEdit(@Body() body, @Response() res) {
  let id = body._id;
  let password = body.password;
  let mobile = body.mobile;
  let email = body.email;
  let role_id = body.role_id;
  let params:any = { mobile, email, role_id };

  // 密码不为空时更新密码
  if (password != "") {
    if (password.length <= 2) {
      this.toolsService.error(res, '密码长度不合法', `/${Config.adminPath}/manager/edit?id=${body._id}`);
    }
    params.password = this.toolsService.getMd5(password);
  }

  let result = await this.adminService.update({'_id': id}, params);
  if (result) {
    this.toolsService.success(res, `/${Config.adminPath}/manager`);
  }
}

<form action="/<%=config.adminPath%>/manager/doEdit" method="post">
  <ul>
    <input type="hidden" name="_id" value="<%=adminResult._id%>"/>
    <li>管理员名称：<input readonly type="text" name="username" value="<%=adminResult.username%>"/></li>
    <li>管理员密码：<input type="text" name="password"/></li>
    <li>管理员电话：<input type="text" name="mobile" value="<%=adminResult.mobile%>"/></li>
    <li>管理员邮箱：<input type="text" name="email" value="<%=adminResult.email%>"/></li>
    <li>管理员角色：
      <select name="role_id" id="role_id">
        <%for(var i=0; i<roleResult.length; i++){%>
          <%if(roleResult[i]._id.toString() == adminResult.role_id){%>
            <option selected value="<%=roleResult[i]._id%>"><%=roleResult[i].title%></option>
          <%}else {%>
            <option value="<%=roleResult[i]._id%>"><%=roleResult[i].title%></option>
          <%}%>
        <%}%>
      </select>
    </li>
    <li><button type='submit' class="btn btn-default">提交</button></li>
  </ul>
</form>

@Get('delete')
async delete(@Query() query, @Response() res ) {
  let result = await this.adminService.delete({"_id": query.id});
  this.toolsService.success(res, `/${Config.adminPath}/manager`);
}

<a class='delete' href="/<%=config.adminPath%>/manager/delete?id=<%=adminResult[i]._id%>">删除</a>

import { Module } from '@nestjs/common';
import { MainController } from './main/main.controller';
import { LoginController } from './login/login.controller';
import { ManagerController } from './manager/manager.controller';
import { ToolsService } from '../../service/tools/tools.service';
// 配置 schema1
import { MongooseModule } from '@nestjs/mongoose';
import { AdminSchema } from '../../schema/admin.schema';
import { RoleSchema } from '../../schema/role.schema';
// 引入服务
import { AdminService } from '../../service/admin/admin.service';
import { RoleService } from '../../service/role/role.service';
import { RoleController } from './role/role.controller';

@Module({
  imports: [
    MongooseModule.forFeature([
      { name: "Admin", schema: AdminSchema, collection: 'admin' },
      { name: "Role", schema: RoleSchema, collection: 'role' }
    ])
  ],
  controllers: [MainController, LoginController, ManagerController, RoleController],
  providers: [ToolsService, AdminService, RoleService]
})
export class AdminModule {}

@filename(admin.schema)
import * as mongoose from 'mongoose';
const Schema = mongoose.Schema;
const d = new Date();

export const AdminSchema = new mongoose.Schema({
  username: { type: String },
  password: { type: String },
  mobile: { type: String },
  email: { type: String },
  status: { type: String },
  role_id: { type: mongoose.Types.ObjectId },
  add_time: { type: Number, default: d.getTime() },
  is_super: { type: Number },
});

import { Injectable } from '@nestjs/common';
import { InjectModel } from '@nestjs/mongoose';
import { AdminInterface } from '../../interface/admin.interface';

@Injectable()
export class AdminService {
  constructor(@InjectModel('Admin') private adminModel) {}

  async find(json: AdminInterface = {}) {
    let result = await this.adminModel.find(json);
    return result;
  }

  async add(json: AdminInterface) {
    let role = new this.adminModel(json);
    let result = await role.save();
    return result;
  }

  async update(json1: AdminInterface, json2: AdminInterface) {
    let result = await this.adminModel.updateOne(json1, json2);
    return result;
  }

  async delete(json: AdminInterface) {
    let result = await this.adminModel.deleteOne(json);
    return result;
  }

  getModel() {
    return this.adminModel;
  }
}

@filename(admin.interface)
export interface AdminInterface {
  _id?: String;
  username?: String;
  password?: String;
  mobile?: String;
  email?: String;
  status?: String;
  role_id?: String;
  add_time?: Number;
  is_super?: Number;
}

import { Controller, Get, Render, Post, Body, Response } from '@nestjs/common';
import { Config } from '../../../config/config';
import { AdminService } from '../../../service/admin/admin.service';
import { RoleService } from '../../../service/role/role.service';
import { ToolsService } from '../../../service/tools/tools.service';

@Controller(`${Config.adminPath}/manager`)
export class ManagerController {
  constructor(
    private adminService: AdminService,
    private roleService: RoleService,
    private toolsService: ToolsService
  ) {}

  @Get()
  @Render('admin/manager/index')
  async index() {
    return {};
  }

  @Get('add')
  @Render('admin/manager/add')
  async add() {
    let result = await this.roleService.find({});
    return { roleResult: result };
  }

  @Post('doAdd')
  async doAdd(@Body() body, @Response() res) {
    console.log('body: ', body);
    if (body.username == '' || body.password.length < 2) {
      this.toolsService.error(res, '用户名或密码长度不合法', `/${Config.adminPath}/manager/add`);
    } else {
      // 从数据库查询当前用户名是否存在
      let adminResult = await this.adminService.find({'username': body.username});
      if (adminResult.length > 0) {
        this.toolsService.error(res, '此管理员已存在', `/${Config.adminPath}/manager/add`);
      } else {
        body.password = this.toolsService.getMd5(body.password);
        let result = await this.adminService.add(body);
        console.log('result: ', result);
        if (result) {
          this.toolsService.success(res, `/${Config.adminPath}/manager`);
        } else {
          this.toolsService.error(res, '增加失败', `/${Config.adminPath}/manager/add`);
        }
      }
    }
  }

  @Get('edit')
  @Render('admin/manager/edit')
  edit() {
    return {};
  }
}

NestJS 管理员增删改查功能实现

一、重点

二、前后台联调，管理员表的增删改查

1、增加管理员

1.1 admin.controller

1.2 前端页面

2、展示管理员列表 (表关联)

2.1 controller

2.2 前端页面

2.3 重点注意事项（坑）

3、管理员的修改

3.1 controller

3.2 前端页面

4、删除管理员

4.1 controller

4.2 前端页面

三、完整版

1. 完整版的 module

2. 完整版的 schema

3. 完整版的 service

4. 完整版的 interface

5. 完整版的 controller

更多推荐文章

相关免费在线工具

NestJS 管理员增删改查功能实现

一、重点

二、前后台联调，管理员表的增删改查

1、增加管理员

1.1 admin.controller

1.2 前端页面

2、展示管理员列表 (表关联)

2.1 controller

2.2 前端页面

2.3 重点注意事项（坑）

3、管理员的修改

3.1 controller

3.2 前端页面

4、删除管理员

4.1 controller

4.2 前端页面

三、完整版

1. 完整版的 module

2. 完整版的 schema

3. 完整版的 service

4. 完整版的 interface

5. 完整版的 controller

微信扫一扫，关注极客日志

更多推荐文章

相关免费在线工具