实战七：Vue实现增删改查，批量删除，导入，导出，查看选课，查看授课，分页

本文链接：https://blog.youkuaiyun.com/shieryue_2016/article/details/134880757

1、request.js工具

import axios from 'axios'
import ElementUI from 'element-ui';
import { serverIp } from '../../public/config';

const request = axios.create({
  baseURL: 'http://localhost:9090',
  timeout: 5000
})

//request拦截器
//可以请求发送前对请求做一些处理

request.interceptors.request.use(config => {
  config.headers['Content-Type'] = 'application/json;charset=utf-8';
  let user = localStorage.getItem("user") ? JSON.parse(localStorage.getItem("user")) : null
  if (user) {
    config.headers['token'] = user.token;
  }
  return config
}, error => {
  return Promise.reject(error)
});


//response拦截器
request.interceptors.response.use(
  response => {
    let res = response.data;
    if (response.config.responseType === 'blob') {
      return res
    }
    if (typeof res === 'String') {
      res = res ? JSON.parse(res) : res
    }
    //当权限校验不通过，给出提示

    if (res.code == '401') {
      ElementUI.Message({
        message: res.msg,
        type: 'error'

      })
    }
    return res
  }, error => {
    console.log('err' + error)
    return Promise.reject(error)
  }
)

export default request

2、main.js挂载request

3、User.vue

查询，新增，批量删除，导入，导出，更新，删除，查看选课，查看授课，分页

<template>
  <div>
    <div style="margin: 10px 0;">
      <el-input suffix-icon="el-icon-search" style="width: 200px;" placeholder="请输入姓名" class="search" v-model="username"
        clearable></el-input>
      <el-input suffix-icon="el-icon-message" style="width: 200px;" placeholder="请输入邮箱" class="search" v-model="email"
        clearable></el-input>
      <el-input suffix-icon="el-icon-position" style="width: 200px;" placeholder="请输入地址" class="search" v-model="address"
        clearable></el-input>
      <el-button class="ml-5" type="primary" @click="load">查询</el-button>
      <el-button class="ml-5" type="warning" @click="reset">重置</el-button>

    </div>
    <div style="margin: 10px 0">
      <el-button type="primary" @click="handleAdd">新增<i class="el-icon-circle-plus-outline"></i></el-button>
      <el-popconfirm class="ml-5" confirm-button-text='确认' cancel-button-text='我再想想' icon="el-icon-info" icon-color="red"
        title="您确定删除吗？" @confirm="delBatch">
        <el-button type="danger" slot="reference">批量删除<i class="el-icon-remove-outline"></i></el-button>
      </el-popconfirm>
      <el-upload action="http://localhost:9090/user/import" :show-file-list="false" :accept="'xlsx'"
        :on-success="handleExcelImportSuccess" style="display: inline-block;">
        <el-button type="primary" class="ml-5">导入<i class="el-icon-bottom"></i></el-button>
      </el-upload>
      <el-button type="primary" class="ml-5" @click="exp">导出<i class="el-icon-top"></i></el-button>

    </div>
    <el-table :data="tableData" border stripe :header-cell-class-name="headerBg"
      @selection-change="handleSelectionChange">
      >
      <el-table-column type="selection" width="55"> </el-table-column>

      <el-table-column prop="id" label="ID" width="80px" align="center">
      </el-table-column>
      <el-table-column prop="username" label="用户名" width="140px" align="center">
      </el-table-column>
      <el-table-column prop="nickname" label="昵称" width="120px" align="center">
      </el-table-column>
      <el-table-column prop="role" label="角色" width="140px" align="center">
        <template slot-scope="scope">
          <el-tag type="primary" v-if="scope.row.role === 'ROLE_ADMIN'">管理员</el-tag>
          <el-tag type="warning" v-if="scope.row.role === 'ROLE_TEACHER'">老师</el-tag>
          <el-tag type="success" v-if="scope.row.role === 'ROLE_STUDENT'">学生</el-tag>
        </template>
      </el-table-column>
      <el-table-column prop="email" label="邮箱" width="120px" align="center">
      </el-table-column>
      <el-table-column prop="phone" label="电话" width="120px" align="center">
      </el-table-column>
      <el-table-column prop="address" label="地址" width="200px" align="center">
      </el-table-column>
      <el-table-column label="操作" width="500px" align="center">
        <template slot-scope="scope">
          <el-button type="primary" @click="lookCourse(scope.row.courses)" v-if="scope.row.role === 'ROLE_TEACHER'">查看教授课程<i
              class="el-icon-document"></i></el-button>
          <el-button type="warning" @click="lookStuCourse(scope.row.stuCourses)"
            v-if="scope.row.role === 'ROLE_STUDENT'">查看已选课程<i class="el-icon-document"></i></el-button>
          <el-button type="success" @click="handleEdit(scope.row)">编辑<i class="el-icon-edit"></i></el-button>
          <el-popconfirm class="ml-5" confirm-button-text='确认' cancel-button-text='我再想想' icon="el-icon-info"
            icon-color="red" title="您确定删除吗？" @confirm="del(scope.row.id)">
            <el-button type="danger" slot="reference">删除<i class="el-icon-remove-outline"></i></el-button>
          </el-popconfirm>
        </template>
      </el-table-column>
    </el-table>
    <div style="padding: 10px 0;">
      <el-pagination @size-change="handleSizeChange" @current-change="handleCurrentChange" :current-page="pageNum"
        :page-sizes="[2, 5, 10, 20]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper"
        :total="total">
      </el-pagination>
    </div>
    <el-dialog title="用户信息" :visible.sync="dialogFormVisible" width="30%">
      <el-form label-width="80px" size="small">
        <el-form-item label="用户名">
          <el-input v-model="form.username" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="角色">
          <el-select clearable v-model="form.role" placeholder="请选择角色" style="100%">
            <el-option v-for="item in roles" :key="item.name" :label="item.name" :value="item.flag">
            </el-option>
          </el-select>
        </el-form-item>
        <el-form-item label="昵称">
          <el-input v-model="form.nickname" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="邮箱">
          <el-input v-model="form.email" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="电话">
          <el-input v-model="form.phone" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="地址">
          <el-input v-model="form.address" autocomplete="off"></el-input>
        </el-form-item>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button @click="dialogFormVisible = false">取 消</el-button>
        <el-button type="primary" @click="save">确 定</el-button>
      </div>
    </el-dialog>
    <el-dialog title="课程信息" :visible.sync="vis" width="30%">
      <el-table :data="courses" border stripe>
        <el-table-column prop="name" label="课程名称"></el-table-column>
        <el-table-column prop="score" label="学分"></el-table-column>
      </el-table>
    </el-dialog>
    <el-dialog title="课程信息" :visible.sync="stuVis" width="30%">
      <el-table :data="stuCourses" border stripe>
        <el-table-column prop="name" label="课程名称"></el-table-column>
        <el-table-column prop="score" label="学分"></el-table-column>
      </el-table>
    </el-dialog>
  </div>
</template>
<script>
export default {
  data() {
    return {
      tableData: [],
      total: 0,
      pageNum: 1,
      pageSize: 10,
      username: '',
      nickname: '',
      email: '',
      phone: '',
      address: '',
      dialogFormVisible: false,
      form: {},
      multipleSelection: [],
      headerBg: 'headerBg',
      roles: [],
      courses: [],
      stuCourses: [],
      vis: false,
      stuVis: false
    }
  },
  created() {
    this.load()
  },
  methods: {
    lookCourse(courses) {
      this.courses = courses
      this.vis = true

    },
    lookStuCourse(stuCourses) {
      this.stuCourses = stuCourses
      this.stuVis = true

    },
    handleSizeChange(pageSize) {
      console.log(pageSize);
      this.pageSize = pageSize;
      this.load();
    },
    handleCurrentChange(pageNum) {
      console.log(pageNum);
      this.pageNum = pageNum;
      this.load();
    },
    load() {
      this.request.get("/user/page", {
        params: {
          pageNum: this.pageNum,
          pageSize: this.pageSize,
          username: this.username,
          email: this.email,
          address: this.address
        }
      }).then(res => {
        console.log(res);
        this.tableData = res.data.records;
        this.total = res.data.total;
      })

      this.request.get("/role").then(res => {
        this.roles = res.data

      })
    },
    reset() {
      this.username = '',
        this.email = '',
        this.address = '',
        this.load();
    },
    handleAdd() {
      this.dialogFormVisible = true,
        this.form = {};
    },
    save() {
      this.request.post("/user", this.form).then(res => {
        if (res.code === '200') {
          this.$message.success("保存成功");
          this.dialogFormVisible = false;
          this.load();
        }
        else {
          this.$message.error("保存失败");
          this.dialogFormVisible = false;
          this.load();
        }
      });
    },
    handleEdit(row) {
      this.form = row;
      this.dialogFormVisible = true;
    },
    del(id) {
      this.request.delete("/user/" + id).then(res => {
        if (res.code === '200') {
          this.$message.success("删除成功");
          this.load();
        }
        else {
          this.$message.error("删除失败");
        }
      });
    },
    handleSelectionChange(val) {
      console.log(val);
      this.multipleSelection = val;
    },
    delBatch() {
      let ids = this.multipleSelection.map(v => v.id); //[1,2,3]
      this.request.post("/user/del/batch", ids).then(res => {
        if (res.code === '200') {
          this.$message.success("删除成功");
          this.load();
        }
        else {
          this.$message.error("删除失败");
        }
      });
    },
    exp() {
      window.open("http://localhost:9090/user/export")
    },
    handleExcelImportSuccess() {
      this.$message.success("导入成功")
      this.load()
    }

  }

}
</script>
<style scoped>
.headerBg {
  background: #eee !important;
}
</style>