16. SpringBoot+Vue管理系统实现增删改查
使用 Mybatis-plus
官网：https://www.baomidou.com/pages/226c21/
pom 依赖
<!-- mybatis-plus -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.3.2</version>
</dependency>
实体类注解：
- @TableName("user")
- @TableId(type=IdType.AUTO)
分页插件
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
@MapperScan("com.example.springboot.mapper")
public class MybatisPlusConfig {
/**
* 添加分页插件
*/
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));//如果配置多个插件,切记分页最后添加
return interceptor;
}
}
注意，你的实体类里面多出来的字段需要加上一个注解：@TableField(exist = false)
改造 Mapper
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot.entity.User;
public interface UserMapper extends BaseMapper<User> {
}
改造 Service
package com.example.springboot.service;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.springboot.entity.User;
import com.example.springboot.exception.ServiceException;
import com.example.springboot.mapper.UserMapper;
import com.example.springboot.utils.TokenUtils;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
@Service
public class UserService extends ServiceImpl<UserMapper, User> {
@Resource
UserMapper userMapper;
public User selectByUsername(String username) {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("username", username); // eq => == where username = #{username}
// 根据用户名查询数据库的用户信息
return getOne(queryWrapper); // select * from user where username = #{username}
}
// 验证用户账户是否合法
public User login(User user) {
User dbUser = selectByUsername(user.getUsername());
if (dbUser == null) {
// 抛出一个自定义的异常
throw new ServiceException("用户名或密码错误");
}
if (!user.getPassword().equals(dbUser.getPassword())) {
throw new ServiceException("用户名或密码错误");
}
// 生成token
String token = TokenUtils.createToken(dbUser.getId().toString(), dbUser.getPassword());
dbUser.setToken(token);
return dbUser;
}
public User register(User user) {
User dbUser = selectByUsername(user.getUsername());
if (dbUser != null) {
// 抛出一个自定义的异常
throw new ServiceException("用户名已存在");
}
user.setName(user.getUsername());
userMapper.insert(user);
return user;
}
public void resetPassword(User user) {
User dbUser = selectByUsername(user.getUsername());
if (dbUser == null) {
// 抛出一个自定义的异常
throw new ServiceException("用户不存在");
}
if (!user.getPhone().equals(dbUser.getPhone())) {
throw new ServiceException("验证错误");
}
dbUser.setPassword("123"); // 重置密码
updateById(dbUser);
}
}
改造 Controller
package com.example.springboot.controller;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.springboot.common.Result;
import com.example.springboot.entity.User;
import com.example.springboot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.DuplicateKeyException;
import org.springframework.web.bind.annotation.*;
import java.util.List;
@CrossOrigin
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
UserService userService;
/**
* 新增用户信息
*/
@PostMapping("/add")
public Result add(@RequestBody User user) {
try {
userService.save(user);
} catch (Exception e) {
if (e instanceof DuplicateKeyException) {
return Result.error("插入数据库错误");
} else {
return Result.error("系统错误");
}
}
return Result.success();
}
/**
* 修改用户信息
*/
@PutMapping("/update")
public Result update(@RequestBody User user) {
userService.updateById(user);
return Result.success();
}
/**
* 删除用户信息
*/
@DeleteMapping("/delete/{id}")
public Result delete(@PathVariable Integer id) {
userService.removeById(id);
return Result.success();
}
/**
* 批量删除用户信息
*/
@DeleteMapping("/delete/batch")
public Result batchDelete(@RequestBody List<Integer> ids) { // [7, 8]
userService.removeBatchByIds(ids);
return Result.success();
}
/**
* 查询全部用户信息
*/
@GetMapping("/selectAll")
public Result selectAll() {
List<User> userList = userService.list(new QueryWrapper<User>().orderByDesc("id")); // select * from user order by id desc
return Result.success(userList);
}
/**
* 根据ID查询用户信息
*/
@GetMapping("/selectById/{id}")
public Result selectById(@PathVariable Integer id) {
User user = userService.getById(id);
return Result.success(user);
}
/**
* 多条件模糊查询用户信息
* pageNum 当前的页码
* pageSize 每页查询的个数
*/
@GetMapping("/selectByPage")
public Result selectByPage(@RequestParam Integer pageNum,
@RequestParam Integer pageSize,
@RequestParam String username,
@RequestParam String name) {
QueryWrapper<User> queryWrapper = new QueryWrapper<User>().orderByDesc("id");
queryWrapper.like(StrUtil.isNotBlank(username), "username", username);
queryWrapper.like(StrUtil.isNotBlank(name), "name", name);
// select * from user where username like '%#{username}%' and name like '%#{name}%'
Page<User> page = userService.page(new Page<>(pageNum, pageSize), queryWrapper);
return Result.success(page);
}
}
开始编写 Vue 的增删改查
报错
需要这样的一个参数 pageSize，但是没传 所以报错了
错误：
因为代码没写
前端 User.vue
<template>
<div>
<div>
<el-input style="width: 200px" placeholder="查询用户名" v-model="username"></el-input>
<el-input style="width: 200px; margin: 0 5px" placeholder="查询姓名" v-model="name"></el-input>
<el-button type="primary" @click="load(1)">查询</el-button>
<el-button type="info" @click="reset">重置</el-button>
</div>
<div style="margin: 10px 0">
<el-button type="primary" plain @click="handleAdd">新增</el-button>
<el-button type="danger" plain @click="delBatch">批量删除</el-button>
</div>
<el-table :data="tableData" stripe :header-cell-style="{ backgroundColor: 'aliceblue', color: '#666' }" @selection-change="handleSelectionChange">
<el-table-column type="selection" width="55" align="center"></el-table-column>
<el-table-column prop="id" label="序号" width="70" align="center"></el-table-column>
<el-table-column prop="username" label="用户名"></el-table-column>
<el-table-column prop="name" label="姓名"></el-table-column>
<el-table-column prop="phone" label="手机号"></el-table-column>
<el-table-column prop="email" label="邮箱"></el-table-column>
<el-table-column prop="address" label="地址"></el-table-column>
<el-table-column label="头像">
<template v-slot="scope">
<div style="display: flex; align-items: center">
<el-image style="width: 50px; height: 50px; border-radius: 50%" v-if="scope.row.avatar" :src="scope.row.avatar" :preview-src-list="[scope.row.avatar]"></el-image>
</div>
</template>
</el-table-column>
<el-table-column prop="role" label="角色"></el-table-column>
<el-table-column label="操作" align="center" width="180">
<template v-slot="scope">
<el-button size="mini" type="primary" plain @click="handleEdit(scope.row)">编辑</el-button>
<el-button size="mini" type="danger" plain @click="del(scope.row.id)">删除</el-button>
</template>
</el-table-column>
</el-table>
<div style="margin: 10px 0">
<el-pagination
@current-change="handleCurrentChange"
:current-page="pageNum"
:page-sizes="[100, 200, 300, 400]"
:page-size="pageSize"
layout="total, prev, pager, next"
:total="total">
</el-pagination>
</div>
<el-dialog title="收货地址" :visible.sync="fromVisible" width="30%">
<el-form :model="form" label-width="80px" style="padding-right: 20px" :rules="rules" ref="formRef">
<el-form-item label="用户名" prop="username">
<el-input v-model="form.username" placeholder="用户名"></el-input>
</el-form-item>
<el-form-item label="姓名" prop="name">
<el-input v-model="form.name" placeholder="姓名"></el-input>
</el-form-item>
<el-form-item label="电话" prop="phone">
<el-input v-model="form.phone" placeholder="电话"></el-input>
</el-form-item>
<el-form-item label="邮箱" prop="email">
<el-input v-model="form.email" placeholder="邮箱"></el-input>
</el-form-item>
<el-form-item label="地址" prop="address">
<el-input type="textarea" v-model="form.address" placeholder="地址"></el-input>
</el-form-item>
<el-form-item label="角色" prop="role">
<el-radio-group v-model="form.role">
<el-radio label="管理员"></el-radio>
<el-radio label="用户"></el-radio>
</el-radio-group>
</el-form-item>
<el-form-item label="头像">
<el-upload
class="avatar-uploader"
action="http://localhost:9090/file/upload"
:headers="{ token: user.token }"
:file-list="form.avatar? [form.avatar] : []"
list-type="picture"
:on-success="handleAvatarSuccess"
>
<el-button type="primary">上传头像</el-button>
</el-upload>
</el-form-item>
</el-form>
<div slot="footer" class="dialog-footer">
<el-button @click="fromVisible = false">取 消</el-button>
<el-button type="primary" @click="save">确 定</el-button>
</div>
</el-dialog>
</div>
</template>
<script>
export default {
name: "User",
data() {
return {
tableData: [], // 所有的数据
pageNum: 1, // 当前的页码
pageSize: 5, // 每页显示的个数
username: '',
name: '',
total: 0,
fromVisible: false,
form: {},
user: JSON.parse(localStorage.getItem('honey-user') || '{}'),
rules: {
username: [
{ required: true, message: '请输入账号', trigger: 'blur' },
]
},
ids: []
}
},
created() {
this.load()
},
methods: {
delBatch() {
if (!this.ids.length) {
this.$message.warning('请选择数据')
return
}
this.$confirm('您确认批量删除这些数据吗？', '确认删除', {type: "warning"}).then(response => {
this.$request.delete('/user/delete/batch', { data: this.ids }).then(res => {
if (res.code === '200') { // 表示操作成功
this.$message.success('操作成功')
this.load(1)
} else {
this.$message.error(res.msg) // 弹出错误的信息
}
})
}).catch(() => {})
},
handleSelectionChange(rows) { // 当前选中的所有的行数据
this.ids = rows.map(v => v.id)
},
del(id) {
this.$confirm('您确认删除吗？', '确认删除', {type: "warning"}).then(response => {
this.$request.delete('/user/delete/' + id).then(res => {
if (res.code === '200') { // 表示操作成功
this.$message.success('操作成功')
this.load(1)
} else {
this.$message.error(res.msg) // 弹出错误的信息
}
})
}).catch(() => {})
},
handleEdit(row) { // 编辑数据
this.form = JSON.parse(JSON.stringify(row)) // 给form对象赋值 注意要深拷贝数据
this.fromVisible = true // 打开弹窗
},
handleAdd() { // 新增数据
this.form = { role: '用户' } // 新增数据的时候清空数据
this.fromVisible = true // 打开弹窗
},
save() { // 保存按钮触发的逻辑 它会触发新增或者更新
this.$refs.formRef.validate((valid) => {
if (valid) {
this.$request({
url: this.form.id ? '/user/update': '/user/add',
method: this.form.id ? 'PUT' : 'POST',
data: this.form
}).then(res => {
if (res.code === '200') { // 表示成功保存
this.$message.success('保存成功')
this.load(1)
this.fromVisible = false
} else {
this.$message.error(res.msg) // 弹出错误的信息
}
})
}
})
},
reset() {
this.name = ''
this.username = ''
this.load()
},
load(pageNum) { // 分页查询
if (pageNum) this.pageNum = pageNum
this.$request.get('/user/selectByPage', {
params: {
pageNum: this.pageNum,
pageSize: this.pageSize,
username: this.username,
name: this.name
}
}).then(res => {
this.tableData = res.data.records
this.total = res.data.total
})
},
handleCurrentChange(pageNum) {
this.load(pageNum)
},
handleAvatarSuccess(response, file, fileList) {
// 把user的头像属性换成上传的图片的链接
this.form.avatar = response.data
},
}
}
</script>
<style scoped>
</style>
后台判断不能删除当前登录的用户信息
User currentUser = TokenUtils.getCurrentUser();
if (id.equals(currentUser.getId())) {
throw new ServiceException("不能删除当前的用户");
}