19. SpringBoot+Vue集成富文本编辑器
新建一个表 news
CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '简介',
`content` text COLLATE utf8mb4_unicode_ci COMMENT '内容',
`authorid` int(11) DEFAULT NULL COMMENT '发布人id',
`time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发布时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='新闻信息';
创建 entity 跟表对应
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.Data;
@Data
public class News {
@TableId(type= IdType.AUTO)
private Integer id;
private String title;
private String description;
private String content;
private Integer authorid;
private String time;
}
创建对应的 Mapper Service Controller
NewsMapper
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot.entity.News;
import com.example.springboot.entity.User;
public interface NewsMapper extends BaseMapper<News> {
}
NewsService
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.springboot.entity.News;
import com.example.springboot.mapper.NewsMapper;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
@Service
public class NewsService extends ServiceImpl<NewsMapper, News> {
@Resource
NewsMapper newsMapper;
}
NewsController
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.springboot.common.Result;
import com.example.springboot.entity.News;
import com.example.springboot.service.NewsService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;
@RestController
@RequestMapping("/news")
public class NewsController {
@Autowired
NewsService newsService;
/**
* 新增信息
*/
@PostMapping("/add")
public Result add(@RequestBody News news) {
newsService.save(news);
return Result.success();
}
/**
* 修改信息
*/
@PutMapping("/update")
public Result update(@RequestBody News news) {
newsService.updateById(news);
return Result.success();
}
/**
* 删除信息
*/
@DeleteMapping("/delete/{id}")
public Result delete(@PathVariable Integer id) {
newsService.removeById(id);
return Result.success();
}
/**
* 批量删除信息
*/
@DeleteMapping("/delete/batch")
public Result batchDelete(@RequestBody List<Integer> ids) {
newsService.removeBatchByIds(ids);
return Result.success();
}
/**
* 查询全部信息
*/
@GetMapping("/selectAll")
public Result selectAll() {
List<News> userList = newsService.list(new QueryWrapper<News>().orderByDesc("id"));
return Result.success(userList);
}
/**
* 根据ID查询信息
*/
@GetMapping("/selectById/{id}")
public Result selectById(@PathVariable Integer id) {
News news = newsService.getById(id);
return Result.success(news);
}
/**
* 多条件模糊查询信息
* pageNum 当前的页码
* pageSize 每页查询的个数
*/
@GetMapping("/selectByPage")
public Result selectByPage(@RequestParam Integer pageNum,
@RequestParam Integer pageSize,
@RequestParam String title) {
QueryWrapper<News> queryWrapper = new QueryWrapper<News>().orderByDesc("id"); // 默认倒序,让最新的数据在最上面
queryWrapper.like(StrUtil.isNotBlank(title), "title", title);
Page<News> page = newsService.page(new Page<>(pageNum, pageSize), queryWrapper);
return Result.success(page);
}
}
News.vue
<template>
<div>
<div>
<el-input style="width: 200px" placeholder="查询标题" v-model="title"></el-input>
<el-button type="primary" style="margin-left: 10px" @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="title" label="标题"></el-table-column>
<el-table-column prop="description" label="简介"></el-table-column>
<el-table-column prop="content" label="内容"></el-table-column>
<el-table-column prop="author" label="发布人"></el-table-column>
<el-table-column prop="time" 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-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="title">
<el-input v-model="form.title" placeholder="标题"></el-input>
</el-form-item>
<el-form-item label="简介" prop="content">
<el-input v-model="form.description" placeholder="简介"></el-input>
</el-form-item>
<el-form-item label="内容" prop="content">
<el-input v-model="form.content" placeholder="内容"></el-input>
</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: "News",
data() {
return {
tableData: [], // 所有的数据
pageNum: 1, // 当前的页码
pageSize: 5, // 每页显示的个数
username: '',
title: '',
total: 0,
fromVisible: false,
form: {},
user: JSON.parse(localStorage.getItem('honey-user') || '{}'),
rules: {
title: [
{ 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('/news/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('/news/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 = {} // 新增数据的时候清空数据
this.fromVisible = true // 打开弹窗
},
save() { // 保存按钮触发的逻辑 它会触发新增或者更新
this.$refs.formRef.validate((valid) => {
if (valid) {
this.$request({
url: this.form.id ? '/news/update': '/news/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.title = ''
this.load()
},
load(pageNum) { // 分页查询
if (pageNum) this.pageNum = pageNum
this.$request.get('/news/selectByPage', {
params: {
pageNum: this.pageNum,
pageSize: this.pageSize,
title: this.title
}
}).then(res => {
this.tableData = res.data.records
this.total = res.data.total
})
},
handleCurrentChange(pageNum) {
this.load(pageNum)
},
}
}
</script>
<style scoped>
</style>
wangeditor
https://www.wangeditor.com/v4/
安装
npm i wangeditor --save

使用
<div id="editor"></div>
import E from "wangeditor"
export default {
data() {
return {
editor: null
}
}
this.editor = new E(`#editor`)
// 设置参数
this.editor.create() // 创建

销毁编辑器
// 在dialog销毁时调用
closeDialog() {
// 销毁编辑器
this.editor.destroy()
this.editor = null
},
配置代码高亮
npm install highlight.js -S
import hljs from 'highlight.js'
// 在main.js 引入css
import 'highlight.js/styles/monokai-sublime.css'
this.editor.highlight = hljs
设置和获取内容
this.editor.txt.html('') // 设置html
this.editor.txt.html() // 获取内容
show-overflow-tooltip 表格处理文本比较多的情形
富文本内容显示
<el-dialog title="内容" :visible.sync="fromVisible1" width="60%">
<div class="w-e-text">
<div v-html="content"></div>
</div>
<div slot="footer" class="dialog-footer">
<el-button type="primary" @click="fromVisible1 = false">确 定</el-button>
</div>
</el-dialog>
配置图片上传接口
this.editor.config.uploadImgServer = this.$baseUrl + '/file/editor/upload'
this.editor.config.uploadFileName = 'file'
this.editor.config.uploadImgHeaders = {
token: this.user.token
}

因为 401 了,后台鉴权不通过
server 接口返回格式,重要!!!
{
"errno": 0,
"data": [
{
url: "图片地址"
}
]
}
上传的接口
@PostMapping("/editor/upload")
public Dict editorUpload(MultipartFile file) throws IOException {
String originalFilename = file.getOriginalFilename(); // 文件的原始名称
// aaa.png
String mainName = FileUtil.mainName(originalFilename); // aaa
String extName = FileUtil.extName(originalFilename);// png
if (!FileUtil.exist(ROOT_PATH)) {
FileUtil.mkdir(ROOT_PATH); // 如果当前文件的父级目录不存在,就创建
}
if (FileUtil.exist(ROOT_PATH + File.separator + originalFilename)) { // 如果当前上传的文件已经存在了,那么这个时候我就要重名一个文件名称
originalFilename = System.currentTimeMillis() + "_" + mainName + "." + extName;
}
File saveFile = new File(ROOT_PATH + File.separator + originalFilename);
file.transferTo(saveFile); // 存储文件到本地的磁盘里面去
String url = "http://" + ip + ":" + port + "/file/download/" + originalFilename;
if ("img".equals(type)) { // 上传图片
return Dict.create().set("errno", 0).set("data", CollUtil.newArrayList(Dict.create().set("url", url)));
} else if ("video".equals(type)) {
return Dict.create().set("errno", 0).set("data", Dict.create().set("url", url));
}
return Dict.create().set("errno", 0);
}
上传参数
this.editor.config.uploadImgHeaders = {
token: this.user.token
}
配置视频上传
this.editor.config.uploadVideoServer = this.$baseUrl + '/file/editor/upload'
this.editor.config.uploadVideoName = 'file'
this.editor.config.uploadVideoHeaders = {
token: this.user.token
}
上传参数
editor.config.uploadVideoHeaders = {
token: this.user.token
}
完整的富文本前端代码
Vue 完整的封装的富文本的代码
setRichText() {
this.$nextTick(() => {
this.editor = new E(`#editor`)
this.editor.highlight = hljs
this.editor.config.uploadImgServer = this.$baseUrl + '/file/editor/upload'
this.editor.config.uploadFileName = 'file'
this.editor.config.uploadImgHeaders = {
token: this.user.token
}
this.editor.config.uploadImgParams = {
type: 'img',
}
this.editor.config.uploadVideoServer = this.$baseUrl + '/file/editor/upload'
this.editor.config.uploadVideoName = 'file'
this.editor.config.uploadVideoHeaders = {
token: this.user.token
}
this.editor.config.uploadVideoParams = {
type: 'video',
}
this.editor.create() // 创建
})
},
注意编辑的时候需要延迟加载:
this.setRichText()
setTimeout(() => {
this.editor.txt.html(row.content) // 设置富文本内容
}, 0)