Spring Boot和Vue前后端分离项目架构的全过程
时间:2023-01-18 11:00:25|栏目:JAVA代码|点击: 次
Spring Boot+Vue 前后端分离项目架构
项目流程:
1. SpringBoot 后端项目
1、新建一个 SpringBoot 工程,并添加项目开发过程中需要的相关依赖;
2、数据库新建 book 数据表;
-- ---------------------------- -- Table structure for book -- ---------------------------- DROP TABLE IF EXISTS `book`; CREATE TABLE `book` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `publish` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `authors` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `createTime` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTime` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of book -- ---------------------------- INSERT INTO `book` VALUES (2, '数据结构', '浙江出版社', '严威', '2022-03-18 14:38:22', '2022-03-18 14:38:25'); INSERT INTO `book` VALUES (5, '计算机组成原理', '机械工业出版社', '唐朔飞', '2022-03-14 14:38:28', '2022-03-15 14:38:36'); INSERT INTO `book` VALUES (6, '机器学习', '人民邮电出版社', '周志华', '2022-03-16 14:38:41', '2022-03-16 14:38:45'); INSERT INTO `book` VALUES (7, '图论及其应用', '科学技术出版社', '徐俊明', '2022-03-03 14:38:49', '2022-03-18 18:33:57'); INSERT INTO `book` VALUES (8, '推荐系统开发实战', '电子工业出版社', '高团阳', '2022-03-14 14:38:57', '2022-03-16 14:39:02'); INSERT INTO `book` VALUES (9, '大数据导论', '机械工业出版社', '曾诚', '2022-03-10 14:39:06', '2022-03-12 14:39:09'); INSERT INTO `book` VALUES (13, 'Java从零基础到实战', '中国工信出版集团', '宁楠', '2022-03-18 17:05:18', '2022-03-18 17:05:18');
3、application.yml 配置数据源和项目启动的端口号;
# 修改服务启动的端口 server: port: 8181 spring: datasource: url: jdbc:mysql://localhost:3306/book?useUnicode=true&characterEncoding=UTF-8 username: root password: 123456 driver-class-name: com.mysql.jdbc.Driver # 配置日志,打印执行的sql语句 mybatis-plus: configuration: log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
项目整体的目录结构如下:
4、创建实体类 Book.java;
@AllArgsConstructor @NoArgsConstructor @Data @TableName(value = "book") public class Book { @TableId(type = IdType.AUTO) private Long id; private String title; private String publish; private String authors; @TableField(value = "createTime", fill = FieldFill.INSERT) private Date createTime; @TableField(value = "updateTime", fill = FieldFill.INSERT_UPDATE) private Date updateTime; }
5、添加 MyBatis Plus 自动填充的处理器 config/DataHandler.java;
import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler; import org.apache.ibatis.reflection.MetaObject; import org.springframework.stereotype.Component; import java.util.Date; @Component public class DataHandler implements MetaObjectHandler{ //插入时的填充策略 @Override public void insertFill(MetaObject metaObject) { this.setFieldValByName("createTime", new Date(), metaObject); this.setFieldValByName("updateTime", new Date(), metaObject); } //更新时的填充策略 @Override public void updateFill(MetaObject metaObject) { this.setFieldValByName("updateTime", new Date(), metaObject); } }
6、持久化层 mapper/BookMapper.java;
import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.trainingl.entity.Book; import org.springframework.stereotype.Repository; @Repository //持久层注解 public interface BookMapper extends BaseMapper<Book> { //所有的CRUD操作都已经编写好了 }
7、服务层 service;
service/BookService.java
import com.trainingl.entity.Book; import java.util.List; //数据的增删改查接口 public interface BookService { public List<Book> findAll(); public Book findById(Long id); public int insert(Book book); public int deleteById(Long id); public int updateById(Book book); }
service/Impl/BookServiceImpl.java
import com.trainingl.entity.Book; import com.trainingl.mapper.BookMapper; import com.trainingl.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class BookServiceImpl implements BookService { @Autowired private BookMapper bookMapper; @Override public List<Book> findAll() { //查询搜索记录 return bookMapper.selectList(null); } @Override public Book findById(Long id) { return bookMapper.selectById(id); } @Override public int insert(Book book) { return bookMapper.insert(book); } @Override public int deleteById(Long id) { return bookMapper.deleteById(id); } @Override public int updateById(Book book) { return bookMapper.updateById(book); } }
8、控制层 Controller;
controller/BookController.java
import com.trainingl.entity.Book; import com.trainingl.service.BookService; import org.apache.ibatis.annotations.Param; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.*; import java.util.HashMap; import java.util.List; import java.util.Map; @RestController @CrossOrigin //跨域注解 public class BookController { @Autowired private BookService bookService; @RequestMapping("/booklist") public List<Book> booklist(){ return bookService.findAll(); } @RequestMapping("/addbook") public int addbook(@RequestBody Book book){ return bookService.insert(book); } @DeleteMapping("/deleteById/{id}") public int deleteById(@PathVariable("id") Long id){ Integer result = 0; result = bookService.deleteById(id); //删除成功则返回受影响的行数 return result; } @GetMapping("/findById/{id}") public Book findById(@PathVariable("id") Long id){ return bookService.findById(id); } @PutMapping("/updateById") public int updateById(@RequestBody Book book){ //返回修改的条数 return bookService.updateById(book); } }
2. Vue 前端项目
1、主页面 App.vue
<template> <div id="app"> <router-view/> </div> </template> <script> export default { name: 'App', components: { }, data(){ return{ } }, } </script>
2、数据列表视图 views/table.vue
<template> <div> <el-table :data="tableData" border style="width: 70%"> <el-table-column fixed prop="id" label="编号" width="80"> </el-table-column> <el-table-column prop="title" label="书籍名称" width="160"> </el-table-column> <el-table-column prop="publish" label="出版社" width="150"> </el-table-column> <el-table-column prop="authors" label="作者" width="120"> </el-table-column> <el-table-column prop="createTime" label="创建时间" width="150"> </el-table-column> <el-table-column prop="updateTime" label="修改时间" width="150"> </el-table-column> <el-table-column fixed="right" label="操作" width="150"> <template slot-scope="scope"> <el-button @click="del(scope.row)" type="danger" size="small">删除</el-button> <el-button @click="edit(scope.row)" type="success" size="small">编辑</el-button> </template> </el-table-column> </el-table> <el-button type="primary" @click="addBook" icon="el-icon-edit" size="small">添加记录</el-button> </div> </template> <script> export default { name: "table", methods: { addBook(){ this.$router.push("/addbook") }, del(row) { let _this = this; this.$confirm('此操作将永久删除该记录, 是否继续?', '提示', { confirmButtonText: '确定', cancelButtonText: '取消', type: 'warning' }).then(() => { this.$axios.delete("http://localhost:8181/deleteById/" + row.id).then(function (response) { if (response.data == 1) { //刷新页面 location.reload(); } else { _this.$message({ showClose: true, message: '删除信息失败!', type: 'danger' }); } }) }) }, edit(row) { this.$router.push("/edit?id=" + row.id); } }, data() { return { tableData: [] } }, created(){ let _this = this; this.$axios.get("http://localhost:8181/booklist").then(function (response) { _this.tableData = response.data; }) } } </script> <style scoped> </style>
3、新增视图文件 views/addBook.vue
<template> <div> <h2 style="padding-left: 200px">新增图书信息</h2> <el-form :model="ruleForm" style="width: 500px;" status-icon :rules="rules" ref="ruleForm" label-width="100px" class="demo-ruleForm"> <el-form-item label="书籍名称" prop="title"> <el-input type="text" v-model="ruleForm.title" autocomplete="off"></el-input> </el-form-item> <el-form-item label="出版社" prop="publish"> <el-input type="text" v-model="ruleForm.publish" autocomplete="off"></el-input> </el-form-item> <el-form-item label="作者信息" prop="authors"> <el-input v-model.number="ruleForm.authors"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="submitForm('ruleForm')">提交</el-button> <el-button @click="resetForm('ruleForm')">重置</el-button> </el-form-item> </el-form> </div> </template> <script> export default { name: "addBook", data() { var checkAuthor = (rule, value, callback) => { if (value === '') { callback(new Error('请输入作者信息')); } else { callback(); } }; var validateTitle = (rule, value, callback) => { if (value === '') { callback(new Error('请输入书籍名称')); } else { callback(); } }; var validatePublish = (rule, value, callback) => { if (value === '') { callback(new Error('请输入出版社')); } else { callback(); } }; return { ruleForm: { title: '', publish: '', authors: '' }, rules: { title: [ { validator: validateTitle, trigger: 'blur' } ], publish: [ { validator: validatePublish, trigger: 'blur' } ], authors: [ { validator: checkAuthor, trigger: 'blur' } ] } }; }, methods: { submitForm(formName) { let _this = this; this.$refs[formName].validate((valid) => { if (valid) { this.$axios.post("http://localhost:8181/addbook", _this.ruleForm).then(function (response) { if(response.data == 1){ //跳转到表格页面 _this.$router.push('/table') } }) } else { console.log('error submit!!'); return false; } }); }, resetForm(formName) { this.$refs[formName].resetFields(); } } } </script> <style scoped> </style>
4、编辑或修改视图文件 views/edit.vue
<template> <div> <h2 style="padding-left: 200px">修改图书信息</h2> <el-form :model="ruleForm" style="width: 500px;" status-icon :rules="rules" ref="ruleForm" label-width="100px" class="demo-ruleForm"> <el-form-item label="图书编号"> <el-input type="text" readonly v-model="ruleForm.id" autocomplete="off"></el-input> </el-form-item> <el-form-item label="书籍名称" prop="title"> <el-input type="text" v-model="ruleForm.title" autocomplete="off"></el-input> </el-form-item> <el-form-item label="出版社" prop="publish"> <el-input type="text" v-model="ruleForm.publish" autocomplete="off"></el-input> </el-form-item> <el-form-item label="作者信息" prop="authors"> <el-input v-model.number="ruleForm.authors"></el-input> </el-form-item> <el-form-item label="创建时间"> <el-input readonly v-model.number="ruleForm.createTime"></el-input> </el-form-item> <el-form-item label="修改时间"> <el-input readonly v-model.number="ruleForm.updateTime"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="submitForm('ruleForm')">提交</el-button> <el-button @click="resetForm('ruleForm')">重置</el-button> </el-form-item> </el-form> </div> </template> <script> export default { name: "edit", data() { var checkAuthor = (rule, value, callback) => { if (value === '') { callback(new Error('请输入作者信息')); } else { callback(); } }; var validateTitle = (rule, value, callback) => { if (value === '') { callback(new Error('请输入书籍名称')); } else { callback(); } }; var validatePublish = (rule, value, callback) => { if (value === '') { callback(new Error('请输入出版社')); } else { callback(); } }; return { ruleForm: { id: '', title: '', publish: '', authors: '', createTime: '', updateTime: '' }, rules: { title: [ { validator: validateTitle, trigger: 'blur' } ], publish: [ { validator: validatePublish, trigger: 'blur' } ], authors: [ { validator: checkAuthor, trigger: 'blur' } ] } }; }, methods: { submitForm(formName) { let _this = this; this.$refs[formName].validate((valid) => { if (valid) { this.$axios.put("http://localhost:8181/updateById", _this.ruleForm).then(function (response) { if(response.data === 1){ //跳转到表格页面 _this.$router.push('/table') } }) } else { console.log('error submit!!'); return false; } }); }, resetForm(formName) { this.$refs[formName].resetFields(); } }, mounted(){ let _this = this; this.$axios.get("http://localhost:8181/findById/" + this.$route.query.id).then(function (response) { _this.ruleForm = response.data; }); } } </script> <style scoped> </style>
5、路由文件 router.js
import Vue from 'vue' //1.导入路由依赖,安装 vue-router组件后系统带有的依赖 import VueRouter from 'vue-router' //2.导入两个页面 import Login from "@/views/login"; import Second from "@/views/Second"; import Table from "@/views/table"; import AddBook from "@/views/addBook"; import Edit from "@/views/edit"; // 3.使用路由 Vue.use(VueRouter); //4.创建路由对象,new VueRouter为上面import设置的名称 const router = new VueRouter({ //没有history,访问URL会有# mode: "history", routes: [ { path:"/login", component: Login }, { path:"/second", component: Second }, { path:"/table", component: Table }, { path:"/addbook", component: AddBook }, { path:"/edit", component: Edit }, ] }); export default router;
6、组件的全局配置 main.js
import Vue from 'vue' import App from './App.vue' import router from "./router/index" import ElementUI from 'element-ui'; import 'element-ui/lib/theme-chalk/index.css'; import axios from "axios" import qstring from "querystring" // Vue 全局Vue对象,prototype原型设置全局属性 Vue.prototype.$axios = axios Vue.prototype.$qstring=qstring Vue.config.productionTip = false; Vue.use(ElementUI); new Vue({ router, render: h => h(App), }).$mount('#app')