项目架构接上一篇文章
Vue+springboot+mybatis-pus增改删
解决上一篇遗留问题-分页查询的错误
上一篇笔记记录了springboot集成mybatis-plus,但是在分页查询的时候有点问题,所以需要在config中新建MybatisPlusConfig类,代码如下:
package com.zhuoaninfo.vueDemo.config;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class MybatisPlusConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor(){
MybatisPlusInterceptor interceptor=new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MARIADB));
return interceptor;
}
}
分页查询可以正常使用。
在vue项目中安装axios,并封装request.js
我使用的还是vscode编辑器,使用ctrl+~键,打开终端窗口,输入npm install axios -s
安装成功后,在src文件下新建util文件夹,该文件名可以自定义起,为了见文知意,起名为util。在util下新建request.js,结构如下:
request.js的代码为:
import axios from "axios";
const request=axios.create({
baseURL:'http://localhost:8181',
timeout:5000
})
// request拦截器
// 可以自请求发送前对请求做一些处理
request.interceptors.request.use(config=>{
config.headers['Content-Type']='application/json;charset=utf-8';
return config
},error=>{
return Promise.reject(error)
}
);
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
}
return res;
},error=>{
console.log(error);
return Promise.reject(error);
}
)
export default request
然后在前端总入口main.js调用request.js.代码如下:
import Vue from 'vue'
import App from './App.vue'
import router from './router'
import ElementUI from 'element-ui';
import 'element-ui/lib/theme-chalk/index.css';
import request from './util/request';
import './assets/gloable.css'
Vue.config.productionTip = false
Vue.use(ElementUI,{size:"mini"})
Vue.prototype.Req=request;
new Vue({
router,
render: h => h(App),
}).$mount('#app')
在vue前端项目中实现分页查询
然后优化前端代码,使用request,把table中的数据进行绑定 :data=“tableData”
<el-table :data="tableData" :header-cell-class-name="rowbgclass" >
<el-table-column prop="id" label="ID" width="140"></el-table-column>
<el-table-column prop="name" label="姓名" width="140">
</el-table-column>
<el-table-column prop="realName" label="真实姓名" width="120">
</el-table-column>
<el-table-column prop="address" label="地址">
</el-table-column>
<el-table-column label="操作">
<template slot-scope="scope">
<el-button type="success" @click="handleEditUser(scope.row)"><i class="el-icon-edit mr" ></i> 编辑</el-button>
<el-button class="ml" type="danger" ><i class="el-icon-delete mr"></i>删除</el-button></el-popconfirm>
</template>
</el-table-column>
</el-table>
然后在data中增加tableData
查询代码为:
data() {
return {
tableData: [],
}
},
然后在el-pagination绑定数据,代码如下:
<el-pagination
@size-change="handleSizeChange"
@current-change="handleCurrentChange"
:current-page="pageNum"
:page-sizes="[2, 5, 10, 15]"
:page-size="pageSize"
layout="total, sizes, prev, pager, next, jumper"
:total="totalSize">
</el-pagination>
在data中增加数据项:
data() {
return {
tableData: [],
totalSize:0,
pageNum:1,
pageSize:2
}
},
新建load()方法:
load(){
// fetch("http://localhost:8181/vueDemo/getPages?pageNum="+this.pageNum+"&pageSize="+this.pageSize+"&name="+this.username+"&real_name="+this.real_name).then(res=>res.json()).then(
this.Req.get('/vueDemo/getPages',{
params: {
"pageNum": this.pageNum,
"pageSize":this.pageSize,
"name":this.username,
"real_name":this.real_name
}
}).then(res=>{
this.totalSize=res.total;
this.tableData=res.records;
})
},
在params中有些资料前面的参数,比如"pageNum"不见引号,但我调试的时候会报错,加上双引号后,正常使用。
在create()中调用load().
created(){
this.load();
}
启动项目,访问http://localhost:8081/
分页查询功能正常。
在vue前端项目中实现新增
使用elementUi控件中的el-dialog弹出框,对话框的确定按钮绑定点击事件。
<el-dialog :title="userDialogTitle" :visible.sync="dialogFormVisible">
<el-form :model="form" label-width="80px">
<el-form-item label="用户名" >
<el-input v-model="form.name" autocomplete="off"></el-input>
</el-form-item>
<el-form-item label="真实姓名" >
<el-input v-model="form.realName" 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="handleSaveUser()">确 定</el-button>
</div>
</el-dialog>
在data()中增加dialogFormVisible,form,初始值分别为false和空对象。
data(){
return {
tableData: [],
totalSize:0,
pageNum:1,
pageSize:2,
userDialogTitle,
dialogFormVisible:false,
form:{},
}}
给新建按钮绑定点击事件
<el-button type="warning" @click="handleAddUser()"><i class="el-icon-circle-plus-outline mr
"></i>新增</el-button>
在方法中实现新增按钮和对话框确定按钮绑定的事件
handleAddUser(){
this.dialogFormVisible=true;
this.userDialogTitle="新增用户信息";
this.form={};
},
handleSaveUser(){
this.dialogFormVisible=false;
this.Req.post('/vueDemo/user',this.form).then(res=>{
if(res){
this.$message("保存成功");
this.load();
}else{
this.$message("保存失败")
}
})
}
保存代码,访问页面,测试成功。
vue实现改功能
在编辑按钮中绑定事件,这里有个小坑,有时候不注意会把绑定事件绑定到标签上,导致点击无法响应。
<el-button type="success" @click="handleEditUser(scope.row)"><i class="el-icon-edit mr" ></i> 编辑</el-button>
在method中实现绑定事件
handleEditUser(row){
this.dialogFormVisible=true;
this.userDialogTitle="编辑用户信息";
this.form=row; #把行数据赋值给form对象,所以对应的对象属性需要保持一致
},
保存代码测试成功。
vue前端实现删除操作
为了减少直接删除的风险,增加一个确认框,点击删除按钮先弹出确认框,在确定框的确认事件上绑定事件。
<el-popconfirm
confirm-button-text='确定'
cancel-button-text='再考虑考虑'
icon="el-icon-info"
icon-color="red"
title="确定删除吗?"
@confirm ="delUser(scope.row.id)"
>
<el-button class="ml" type="danger" slot="reference" ><i class="el-icon-delete mr"></i>删除</el-button></el-popconfirm>
这里的坑是按钮中 slot=“reference” 是必须得,否则按钮不显示。
在方法中实现事件
delUser(id){
this.Req.delete('/vueDemo/'+id).then(
res=>{
if(res){
this.$message("删除成功!");
this.load();
}else{
this.$message("删除失败,请联系管理员!");
}
}
)
},
测试成功。
vue前端实现批量删除
为避免之间删除,和删除按钮一样,也增加一个确认框,在确认框的确认事件上绑定事件。
<el-popconfirm
confirm-button-text='确定'
cancel-button-text='再考虑考虑'
icon="el-icon-info"
icon-color="red"
title="确定删除吗?"
@confirm ="delBatch"
>
<el-button type="info" slot="reference" class="ml mr" >
<i class="el-icon-remove-outline mr" ></i>
批量删除</el-button></el-popconfirm>
在方法中实现绑定的事件
delBatch(){
var ids=this.multipleSelection.map(val=>val.id);
this.Req.post('/vueDemo/del/delbatch',ids).then(
res=>{
if(res){
this.$message("批量删除成功");
this.load()
}else{
this.$message("批量删除成功,请检查");
}
}
)
// 后台接收的参数应该是requestBody类型,否则也会报错,猜测是跨域中不让传List类型的对象
}
因为这里有一个坑,所以单独写了一下,这里按照正常思路是和删除用户一样,使用的req.delete方法,但delete方法传参数(无论是requestparpm还是requestbody),都有错误。所以使用了post方法,而且需要后台接收的参数是requestBody类型。
后台对应的代码为:
@PostMapping ("/del/delbatch")
public Boolean deleteUsers(@RequestBody List<Integer> ids)
{
return userService.removeByIds(ids);
}
保存后台代码,重启后台。
保存前端代码,刷新页面测试成功。
helloworld.vue的代码整体代码如下:
<template>
<div>
<el-container style="height:100vh">
<el-aside :width="sideWidth +'px'" style="background-color: rgb(238, 241, 246);" >
<el-menu :default-openeds="['1', '3']" style="min-height:100%;overflow-x:hidden;width:100%"
background-color="rgb(48,65,86)"
text-color="#fff"
active-text-color="#ffd04b"
:collapse-transition="false"
:collapse="isCollapse"
>
<div style="height:60px;line-height:60px;text-align:center">
<img src="../assets/logo.png" alt="" style="width:20px;position:relative;top:5px;margin-right:5px">
<b style="color:white;" v-show="logotext">后台管理系统</b>
</div>
<el-submenu index="1">
<template slot="title">
<i class="el-icon-location"></i>
<span slot="title">导航一</span>
</template>
<el-menu-item-group>
<template slot="title">
分组一</template>
<el-menu-item index="1-1">选项1</el-menu-item>
<el-menu-item index="1-2">选项2</el-menu-item>
</el-menu-item-group>
<el-menu-item-group title="分组2">
<el-menu-item index="1-3">选项3</el-menu-item>
</el-menu-item-group>
<el-submenu index="1-4">
<template slot="title">选项4</template>
<el-menu-item index="1-4-1">选项4-1</el-menu-item>
</el-submenu>
</el-submenu>
<el-submenu index="2">
<template slot="title">
<i class="el-icon-menu"></i>
<span slot="title">导航二</span>
</template>
<el-menu-item-group>
<template slot="title">分组一</template>
<el-menu-item index="2-1">选项1</el-menu-item>
<el-menu-item index="2-2">选项2</el-menu-item>
</el-menu-item-group>
<el-menu-item-group title="分组2">
<el-menu-item index="2-3">选项3</el-menu-item>
</el-menu-item-group>
<el-submenu index="2-4">
<template slot="title">选项4</template>
<el-menu-item index="2-4-1">选项4-1</el-menu-item>
</el-submenu>
</el-submenu>
<el-submenu index="3">
<template slot="title">
<i class="el-icon-document"></i>
<span slot="title">导航三</span>
</template>
<el-menu-item-group>
<template slot="title">分组一</template>
<el-menu-item index="3-1">选项1</el-menu-item>
<el-menu-item index="3-2">选项2</el-menu-item>
</el-menu-item-group>
<el-menu-item-group title="分组2">
<el-menu-item index="3-3">选项3</el-menu-item>
</el-menu-item-group>
<el-submenu index="3-4">
<template slot="title">选项4</template>
<el-menu-item index="3-4-1">选项4-1</el-menu-item>
</el-submenu>
</el-submenu>
</el-menu>
</el-aside>
<el-container>
<el-header style="font-size: 12px;border-bottom:1px solid #ccc; line-height: 60px; display: flex">
<div style="flex:1;font-size:28px">
<span :class="collapseBtnClass" style="cursor:poiner" @click="collapse"></span>
</div>
<div style="width:70px;font-size:14px">
<span>王小虎</span>
<el-dropdown trigger="click" >
<i :class="arrowClass" style="margin-left:5px" @click="changeIClass"></i>
<el-dropdown-menu slot="dropdown" >
<el-dropdown-item>查看</el-dropdown-item>
<el-dropdown-item>新增</el-dropdown-item>
<el-dropdown-item>删除</el-dropdown-item>
</el-dropdown-menu>
</el-dropdown>
</div>
</el-header>
<el-main>
<el-breadcrumb separator="/">
<el-breadcrumb-item :to="{ path: '/' }">首页</el-breadcrumb-item>
<el-breadcrumb-item>用户管理</el-breadcrumb-item>
</el-breadcrumb>
<div class="pard">
<el-input style="width:200px" suffix-icon="el-icon-search" v-model="username" placeholder="请输入查询用户名"></el-input>
<el-input style="width:200px" class="ml" suffix-icon="el-icon-search" v-model="real_name" placeholder="请输入查询真实姓名"></el-input>
<el-button class="ml" type="primary" @click="load">搜索</el-button>
</div>
<div class="pard">
<el-button type="warning" @click="handleAddUser()"><i class="el-icon-circle-plus-outline mr
"></i>新增</el-button>
<el-popconfirm
confirm-button-text='确定'
cancel-button-text='再考虑考虑'
icon="el-icon-info"
icon-color="red"
title="确定删除吗?"
@confirm ="delBatch"
>
<el-button type="info" slot="reference" class="ml mr" >
<i class="el-icon-remove-outline mr" ></i>
批量删除</el-button></el-popconfirm>
<el-button type="primary"><i class="el-icon-bottom mr"></i>导入</el-button>
<el-button type="primary"><i class="el-icon-top mr"></i>导出</el-button>
</div>
<el-table :data="tableData" :header-cell-class-name="rowbgclass" @selection-change="handleSelectionChange">
<el-table-column
type="selection"
width="55">
</el-table-column>
<el-table-column prop="id" label="ID" width="140"></el-table-column>
<el-table-column prop="name" label="姓名" width="140">
</el-table-column>
<el-table-column prop="realName" label="真实姓名" width="120">
</el-table-column>
<el-table-column prop="address" label="地址">
</el-table-column>
<el-table-column label="操作">
<template slot-scope="scope">
<el-button type="success" @click="handleEditUser(scope.row)"><i class="el-icon-edit mr" ></i> 编辑</el-button>
<el-popconfirm
confirm-button-text='确定'
cancel-button-text='再考虑考虑'
icon="el-icon-info"
icon-color="red"
title="确定删除吗?"
@confirm ="delUser(scope.row.id)"
>
<el-button class="ml" type="danger" slot="reference" ><i class="el-icon-delete mr"></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, 15]"
:page-size="pageSize"
layout="total, sizes, prev, pager, next, jumper"
:total="totalSize">
</el-pagination>
</div>
</el-main>
</el-container>
</el-container>
<el-dialog :title="userDialogTitle" :visible.sync="dialogFormVisible">
<el-form :model="form" label-width="80px">
<el-form-item label="用户名" >
<el-input v-model="form.name" autocomplete="off"></el-input>
</el-form-item>
<el-form-item label="真实姓名" >
<el-input v-model="form.realName" 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="handleSaveUser()">确 定</el-button>
</div>
</el-dialog>
</div>
</template>
<script>
export default {
name: 'HelloWorld',
data() {
return {
tableData: [],
totalSize:0,
pageNum:1,
pageSize:2,
collapseBtnClass:'el-icon-s-fold',
isCollapse: false,
sideWidth:200,
logotext:true,
arrowClass:"el-icon-arrow-down",
rowbgclass:"rowcbgclass",
username:'' ,
real_name:'' ,
dialogFormVisible:false,
form:{},
userDialogTitle:'',
multipleSelection: []
}
},
created(){
this.load();
},
methods:{
collapse(){
this.isCollapse=!this.isCollapse;
if(!this.isCollapse){
this.collapseBtnClass="el-icon-s-fold"
this.sideWidth=200;
this.logotext=true;
}else{
this.collapseBtnClass="el-icon-s-unfold"
this.sideWidth=64;
this.logotext=false;
}
},
handleSizeChange(pageSize) {
this.pageSize=pageSize;
this.load();
},
handleCurrentChange(pageNum) {
this.pageNum=pageNum;
this.load();
},
load(){
this.Req.get('/vueDemo/getPages',{
params: {
"pageNum": this.pageNum,
"pageSize":this.pageSize,
"name":this.username,
"real_name":this.real_name
// 前面的参数一定要加引号,否则会报错
}
}).then(res=>{
this.totalSize=res.total;
this.tableData=res.records;
})
},
changeIClass(){
if(this.arrowClass=='el-icon-arrow-down')
{
this.arrowClass='el-icon-arrow-up'}
else{
this.arrowClass='el-icon-arrow-down'
}
},
handleAddUser(){
this.dialogFormVisible=true;
this.userDialogTitle="新增用户信息";
this.form={};
},
handleSaveUser(){
this.dialogFormVisible=false;
this.Req.post('/vueDemo/user',this.form).then(res=>{
if(res){
this.$message("保存成功");
this.load();
}else{
this.$message("保存失败")
}
})
},
handleEditUser(row){
this.dialogFormVisible=true;
this.userDialogTitle="编辑用户信息";
this.form=row;
},
delUser(id){
this.Req.delete('/vueDemo/'+id).then(
res=>{
if(res){
this.$message("删除成功!");
this.load();
}else{
this.$message("删除失败,请联系管理员!");
}
}
)
},
handleSelectionChange(val){
this.multipleSelection=val;
},
delBatch(){
var ids=this.multipleSelection.map(val=>val.id);
this.Req.post('/vueDemo/del/delbatch',ids).then(
res=>{
console.log(res)
if(res){
this.$message("批量删除成功");
this.load()
}else{
this.$message("批量删除成功,请检查");
}
}
)
// 后台接收的参数应该是requestBody类型,否则也会报错,猜测是跨域中不让传List类型的对象
}
}
}
</script>
<!-- Add "scoped" attribute to limit CSS to this component only -->
<style scoped>
.el-header {
/* background-color: #B3C0D1; */
border-bottom: 1px solid #C0C0C0;
color: #333;
line-height: 60px;
}
.el-aside {
color: #333;
}
</style>