springboot+vue+mybatis-plus+axios实现商品的CRUD

野性酷女 2024-03-29 14:26 3阅读 0赞

## springboot+vue+mybatis-plus+axios实现商品的CRUD ##

### 简介 ###

这是一篇案例，这个案例，在这个案例之中，我向大家展示，传统的增删除改，在springboot，vue, mybatis-plus, axios这几个框架下，可以有多么的简单，相信大家看完之后，也会觉得编程最难的还是业务逻辑和算法，不论是前端还是后端。

### 环境准备 ###

#### 数据库 ####

选择这个商品类型的数据库一个是比较贴合实际，另一个原因是这个数据库里面有一个status属性，我会在下面文章中演示一下这个属性在开发中，怎么进行处理。

/*
     Navicat MySQL Data Transfer
    
     Source Server         : 本机
     Source Server Type    : MySQL
     Source Server Version : 80024
     Source Host           : localhost:3306
     Source Schema         : mybatis
    
     Target Server Type    : MySQL
     Target Server Version : 80024
     File Encoding         : 65001
    
     Date: 12/01/2023 14:09:13
    */
    
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for tb_brand
    -- ----------------------------
    DROP TABLE IF EXISTS `brand`;
    CREATE TABLE `brand`  (
      `id` int NOT NULL AUTO_INCREMENT,
      `brand_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
      `company_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
      `ordered` int NULL DEFAULT NULL,
      `description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
      `status` int NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of tb_brand
    -- ----------------------------
    INSERT INTO `brand` VALUES (1, '三只松鼠', '三只松鼠股份有限公司', 5, '好吃不上火', 0);
    INSERT INTO `brand` VALUES (2, '华为', '华为技术有限公司', 100, '华为致力于把数字世界带入每个人、每个家庭、每个组织，构建万物互联的智能世界', 1);
    INSERT INTO `brand` VALUES (3, '小米', '小米科技有限公司', 50, 'are you ok', 1);
    
    SET FOREIGN_KEY_CHECKS = 1;

![在这里插入图片描述][468fb7a60b204caf936ec7fb889a3e56.png]

#### 创建项目 ####

![在这里插入图片描述][d436ad4868624cc0ae00d9b9b5e934ca.png]

##### pom.xml #####

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.7.7</version>
            <relativePath/> 
        </parent>
        <groupId>com.example</groupId>
        <artifactId>SpringBootCRUD</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>SpringBootCRUD</name>
        <description>SpringBootCRUD</description>
        <properties>
            <java.version>1.8</java.version>
        </properties>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
            </dependency>
    
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.4.3</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>1.2.62</version>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

##### application.properties #####

spring.datasource.username=root
    spring.datasource.password=123456
    spring.datasource.url=jdbc:mysql://localhost:3306/projectdatabase?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

#### 前端 ####

![在这里插入图片描述][deb8995f590d4c0aad4185f65d865744.png]

##### js #####

[vue.js下载链接][vue.js]  
![在这里插入图片描述][b6936c87d0fd45ec8a8a67244d5349f5.png]  
**axios.js源码**

/* axios v0.18.0 | (c) 2018 by Matt Zabriskie */
    !function(e,t){
        "object"==typeof exports&&"object"==typeof module?module.exports=t():"function"==typeof define&&define.amd?define([],t):"object"==typeof exports?exports.axios=t():e.axios=t()}(this,function(){
        return function(e){
        function t(r){
        if(n[r])return n[r].exports;var o=n[r]={
        exports:{
        },id:r,loaded:!1};return e[r].call(o.exports,o,o.exports,t),o.loaded=!0,o.exports}var n={
        };return t.m=e,t.c=n,t.p="",t(0)}([function(e,t,n){
        e.exports=n(1)},function(e,t,n){
        "use strict";function r(e){
        var t=new s(e),n=i(s.prototype.request,t);return o.extend(n,s.prototype,t),o.extend(n,t),n}var o=n(2),i=n(3),s=n(5),u=n(6),a=r(u);a.Axios=s,a.create=function(e){
        return r(o.merge(u,e))},a.Cancel=n(23),a.CancelToken=n(24),a.isCancel=n(20),a.all=function(e){
        return Promise.all(e)},a.spread=n(25),e.exports=a,e.exports.default=a},function(e,t,n){
        "use strict";function r(e){
        return"[object Array]"===R.call(e)}function o(e){
        return"[object ArrayBuffer]"===R.call(e)}function i(e){
        return"undefined"!=typeof FormData&&e instanceof FormData}function s(e){
        var t;return t="undefined"!=typeof ArrayBuffer&&ArrayBuffer.isView?ArrayBuffer.isView(e):e&&e.buffer&&e.buffer instanceof ArrayBuffer}function u(e){
        return"string"==typeof e}function a(e){
        return"number"==typeof e}function c(e){
        return"undefined"==typeof e}function f(e){
        return null!==e&&"object"==typeof e}function p(e){
        return"[object Date]"===R.call(e)}function d(e){
        return"[object File]"===R.call(e)}function l(e){
        return"[object Blob]"===R.call(e)}function h(e){
        return"[object Function]"===R.call(e)}function m(e){
        return f(e)&&h(e.pipe)}function y(e){
        return"undefined"!=typeof URLSearchParams&&e instanceof URLSearchParams}function w(e){
        return e.replace(/^\s*/,"").replace(/\s*$/,"")}function g(){
        return("undefined"==typeof navigator||"ReactNative"!==navigator.product)&&("undefined"!=typeof window&&"undefined"!=typeof document)}function v(e,t){
        if(null!==e&&"undefined"!=typeof e)if("object"!=typeof e&&(e=[e]),r(e))for(var n=0,o=e.length;n<o;n++)t.call(null,e[n],n,e);else for(var i in e)Object.prototype.hasOwnProperty.call(e,i)&&t.call(null,e[i],i,e)}function x(){
        function e(e,n){
        "object"==typeof t[n]&&"object"==typeof e?t[n]=x(t[n],e):t[n]=e}for(var t={
        },n=0,r=arguments.length;n<r;n++)v(arguments[n],e);return t}function b(e,t,n){
        return v(t,function(t,r){
        n&&"function"==typeof t?e[r]=E(t,n):e[r]=t}),e}var E=n(3),C=n(4),R=Object.prototype.toString;e.exports={
        isArray:r,isArrayBuffer:o,isBuffer:C,isFormData:i,isArrayBufferView:s,isString:u,isNumber:a,isObject:f,isUndefined:c,isDate:p,isFile:d,isBlob:l,isFunction:h,isStream:m,isURLSearchParams:y,isStandardBrowserEnv:g,forEach:v,merge:x,extend:b,trim:w}},function(e,t){
        "use strict";e.exports=function(e,t){
        return function(){
        for(var n=new Array(arguments.length),r=0;r<n.length;r++)n[r]=arguments[r];return e.apply(t,n)}}},function(e,t){
        function n(e){
        return!!e.constructor&&"function"==typeof e.constructor.isBuffer&&e.constructor.isBuffer(e)}function r(e){
        return"function"==typeof e.readFloatLE&&"function"==typeof e.slice&&n(e.slice(0,0))}/*!
     * Determine if an object is a Buffer
     *
     * @author   Feross Aboukhadijeh <https://feross.org>
     * @license  MIT
     */
        e.exports=function(e){
        return null!=e&&(n(e)||r(e)||!!e._isBuffer)}},function(e,t,n){
        "use strict";function r(e){
        this.defaults=e,this.interceptors={
        request:new s,response:new s}}var o=n(6),i=n(2),s=n(17),u=n(18);r.prototype.request=function(e){
        "string"==typeof e&&(e=i.merge({
        url:arguments[0]},arguments[1])),e=i.merge(o,{
        method:"get"},this.defaults,e),e.method=e.method.toLowerCase();var t=[u,void 0],n=Promise.resolve(e);for(this.interceptors.request.forEach(function(e){
        t.unshift(e.fulfilled,e.rejected)}),this.interceptors.response.forEach(function(e){
        t.push(e.fulfilled,e.rejected)});t.length;)n=n.then(t.shift(),t.shift());return n},i.forEach(["delete","get","head","options"],function(e){
        r.prototype[e]=function(t,n){
        return this.request(i.merge(n||{
        },{
        method:e,url:t}))}}),i.forEach(["post","put","patch"],function(e){
        r.prototype[e]=function(t,n,r){
        return this.request(i.merge(r||{
        },{
        method:e,url:t,data:n}))}}),e.exports=r},function(e,t,n){
        "use strict";function r(e,t){
        !i.isUndefined(e)&&i.isUndefined(e["Content-Type"])&&(e["Content-Type"]=t)}function o(){
        var e;return"undefined"!=typeof XMLHttpRequest?e=n(8):"undefined"!=typeof process&&(e=n(8)),e}var i=n(2),s=n(7),u={
        "Content-Type":"application/x-www-form-urlencoded"},a={
        adapter:o(),transformRequest:[function(e,t){
        return s(t,"Content-Type"),i.isFormData(e)||i.isArrayBuffer(e)||i.isBuffer(e)||i.isStream(e)||i.isFile(e)||i.isBlob(e)?e:i.isArrayBufferView(e)?e.buffer:i.isURLSearchParams(e)?(r(t,"application/x-www-form-urlencoded;charset=utf-8"),e.toString()):i.isObject(e)?(r(t,"application/json;charset=utf-8"),JSON.stringify(e)):e}],transformResponse:[function(e){
        if("string"==typeof e)try{
        e=JSON.parse(e)}catch(e){
        }return e}],timeout:0,xsrfCookieName:"XSRF-TOKEN",xsrfHeaderName:"X-XSRF-TOKEN",maxContentLength:-1,validateStatus:function(e){
        return e>=200&&e<300}};a.headers={
        common:{
        Accept:"application/json, text/plain, */*"}},i.forEach(["delete","get","head"],function(e){
        a.headers[e]={
        }}),i.forEach(["post","put","patch"],function(e){
        a.headers[e]=i.merge(u)}),e.exports=a},function(e,t,n){
        "use strict";var r=n(2);e.exports=function(e,t){
        r.forEach(e,function(n,r){
        r!==t&&r.toUpperCase()===t.toUpperCase()&&(e[t]=n,delete e[r])})}},function(e,t,n){
        "use strict";var r=n(2),o=n(9),i=n(12),s=n(13),u=n(14),a=n(10),c="undefined"!=typeof window&&window.btoa&&window.btoa.bind(window)||n(15);e.exports=function(e){
        return new Promise(function(t,f){
        var p=e.data,d=e.headers;r.isFormData(p)&&delete d["Content-Type"];var l=new XMLHttpRequest,h="onreadystatechange",m=!1;if("undefined"==typeof window||!window.XDomainRequest||"withCredentials"in l||u(e.url)||(l=new window.XDomainRequest,h="onload",m=!0,l.onprogress=function(){
        },l.ontimeout=function(){
        }),e.auth){
        var y=e.auth.username||"",w=e.auth.password||"";d.Authorization="Basic "+c(y+":"+w)}if(l.open(e.method.toUpperCase(),i(e.url,e.params,e.paramsSerializer),!0),l.timeout=e.timeout,l[h]=function(){
        if(l&&(4===l.readyState||m)&&(0!==l.status||l.responseURL&&0===l.responseURL.indexOf("file:"))){
        var n="getAllResponseHeaders"in l?s(l.getAllResponseHeaders()):null,r=e.responseType&&"text"!==e.responseType?l.response:l.responseText,i={
        data:r,status:1223===l.status?204:l.status,statusText:1223===l.status?"No Content":l.statusText,headers:n,config:e,request:l};o(t,f,i),l=null}},l.onerror=function(){
        f(a("Network Error",e,null,l)),l=null},l.ontimeout=function(){
        f(a("timeout of "+e.timeout+"ms exceeded",e,"ECONNABORTED",l)),l=null},r.isStandardBrowserEnv()){
        var g=n(16),v=(e.withCredentials||u(e.url))&&e.xsrfCookieName?g.read(e.xsrfCookieName):void 0;v&&(d[e.xsrfHeaderName]=v)}if("setRequestHeader"in l&&r.forEach(d,function(e,t){
        "undefined"==typeof p&&"content-type"===t.toLowerCase()?delete d[t]:l.setRequestHeader(t,e)}),e.withCredentials&&(l.withCredentials=!0),e.responseType)try{
        l.responseType=e.responseType}catch(t){
        if("json"!==e.responseType)throw t}"function"==typeof e.onDownloadProgress&&l.addEventListener("progress",e.onDownloadProgress),"function"==typeof e.onUploadProgress&&l.upload&&l.upload.addEventListener("progress",e.onUploadProgress),e.cancelToken&&e.cancelToken.promise.then(function(e){
        l&&(l.abort(),f(e),l=null)}),void 0===p&&(p=null),l.send(p)})}},function(e,t,n){
        "use strict";var r=n(10);e.exports=function(e,t,n){
        var o=n.config.validateStatus;n.status&&o&&!o(n.status)?t(r("Request failed with status code "+n.status,n.config,null,n.request,n)):e(n)}},function(e,t,n){
        "use strict";var r=n(11);e.exports=function(e,t,n,o,i){
        var s=new Error(e);return r(s,t,n,o,i)}},function(e,t){
        "use strict";e.exports=function(e,t,n,r,o){
        return e.config=t,n&&(e.code=n),e.request=r,e.response=o,e}},function(e,t,n){
        "use strict";function r(e){
        return encodeURIComponent(e).replace(/%40/gi,"@").replace(/%3A/gi,":").replace(/%24/g,"$").replace(/%2C/gi,",").replace(/%20/g,"+").replace(/%5B/gi,"[").replace(/%5D/gi,"]")}var o=n(2);e.exports=function(e,t,n){
        if(!t)return e;var i;if(n)i=n(t);else if(o.isURLSearchParams(t))i=t.toString();else{
        var s=[];o.forEach(t,function(e,t){
        null!==e&&"undefined"!=typeof e&&(o.isArray(e)?t+="[]":e=[e],o.forEach(e,function(e){
        o.isDate(e)?e=e.toISOString():o.isObject(e)&&(e=JSON.stringify(e)),s.push(r(t)+"="+r(e))}))}),i=s.join("&")}return i&&(e+=(e.indexOf("?")===-1?"?":"&")+i),e}},function(e,t,n){
        "use strict";var r=n(2),o=["age","authorization","content-length","content-type","etag","expires","from","host","if-modified-since","if-unmodified-since","last-modified","location","max-forwards","proxy-authorization","referer","retry-after","user-agent"];e.exports=function(e){
        var t,n,i,s={
        };return e?(r.forEach(e.split("\n"),function(e){
        if(i=e.indexOf(":"),t=r.trim(e.substr(0,i)).toLowerCase(),n=r.trim(e.substr(i+1)),t){
        if(s[t]&&o.indexOf(t)>=0)return;"set-cookie"===t?s[t]=(s[t]?s[t]:[]).concat([n]):s[t]=s[t]?s[t]+", "+n:n}}),s):s}},function(e,t,n){
        "use strict";var r=n(2);e.exports=r.isStandardBrowserEnv()?function(){
        function e(e){
        var t=e;return n&&(o.setAttribute("href",t),t=o.href),o.setAttribute("href",t),{
        href:o.href,protocol:o.protocol?o.protocol.replace(/:$/,""):"",host:o.host,search:o.search?o.search.replace(/^\?/,""):"",hash:o.hash?o.hash.replace(/^#/,""):"",hostname:o.hostname,port:o.port,pathname:"/"===o.pathname.charAt(0)?o.pathname:"/"+o.pathname}}var t,n=/(msie|trident)/i.test(navigator.userAgent),o=document.createElement("a");return t=e(window.location.href),function(n){
        var o=r.isString(n)?e(n):n;return o.protocol===t.protocol&&o.host===t.host}}():function(){
        return function(){
        return!0}}()},function(e,t){
        "use strict";function n(){
        this.message="String contains an invalid character"}function r(e){
        for(var t,r,i=String(e),s="",u=0,a=o;i.charAt(0|u)||(a="=",u%1);s+=a.charAt(63&t>>8-u%1*8)){
        if(r=i.charCodeAt(u+=.75),r>255)throw new n;t=t<<8|r}return s}var o="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=";n.prototype=new Error,n.prototype.code=5,n.prototype.name="InvalidCharacterError",e.exports=r},function(e,t,n){
        "use strict";var r=n(2);e.exports=r.isStandardBrowserEnv()?function(){
        return{
        write:function(e,t,n,o,i,s){
        var u=[];u.push(e+"="+encodeURIComponent(t)),r.isNumber(n)&&u.push("expires="+new Date(n).toGMTString()),r.isString(o)&&u.push("path="+o),r.isString(i)&&u.push("domain="+i),s===!0&&u.push("secure"),document.cookie=u.join("; ")},read:function(e){
        var t=document.cookie.match(new RegExp("(^|;\\s*)("+e+")=([^;]*)"));return t?decodeURIComponent(t[3]):null},remove:function(e){
        this.write(e,"",Date.now()-864e5)}}}():function(){
        return{
        write:function(){
        },read:function(){
        return null},remove:function(){
        }}}()},function(e,t,n){
        "use strict";function r(){
        this.handlers=[]}var o=n(2);r.prototype.use=function(e,t){
        return this.handlers.push({
        fulfilled:e,rejected:t}),this.handlers.length-1},r.prototype.eject=function(e){
        this.handlers[e]&&(this.handlers[e]=null)},r.prototype.forEach=function(e){
        o.forEach(this.handlers,function(t){
        null!==t&&e(t)})},e.exports=r},function(e,t,n){
        "use strict";function r(e){
        e.cancelToken&&e.cancelToken.throwIfRequested()}var o=n(2),i=n(19),s=n(20),u=n(6),a=n(21),c=n(22);e.exports=function(e){
        r(e),e.baseURL&&!a(e.url)&&(e.url=c(e.baseURL,e.url)),e.headers=e.headers||{
        },e.data=i(e.data,e.headers,e.transformRequest),e.headers=o.merge(e.headers.common||{
        },e.headers[e.method]||{
        },e.headers||{
        }),o.forEach(["delete","get","head","post","put","patch","common"],function(t){
        delete e.headers[t]});var t=e.adapter||u.adapter;return t(e).then(function(t){
        return r(e),t.data=i(t.data,t.headers,e.transformResponse),t},function(t){
        return s(t)||(r(e),t&&t.response&&(t.response.data=i(t.response.data,t.response.headers,e.transformResponse))),Promise.reject(t)})}},function(e,t,n){
        "use strict";var r=n(2);e.exports=function(e,t,n){
        return r.forEach(n,function(n){
        e=n(e,t)}),e}},function(e,t){
        "use strict";e.exports=function(e){
        return!(!e||!e.__CANCEL__)}},function(e,t){
        "use strict";e.exports=function(e){
        return/^([a-z][a-z\d\+\-\.]*:)?\/\//i.test(e)}},function(e,t){
        "use strict";e.exports=function(e,t){
        return t?e.replace(/\/+$/,"")+"/"+t.replace(/^\/+/,""):e}},function(e,t){
        "use strict";function n(e){
        this.message=e}n.prototype.toString=function(){
        return"Cancel"+(this.message?": "+this.message:"")},n.prototype.__CANCEL__=!0,e.exports=n},function(e,t,n){
        "use strict";function r(e){
        if("function"!=typeof e)throw new TypeError("executor must be a function.");var t;this.promise=new Promise(function(e){
        t=e});var n=this;e(function(e){
        n.reason||(n.reason=new o(e),t(n.reason))})}var o=n(23);r.prototype.throwIfRequested=function(){
        if(this.reason)throw this.reason},r.source=function(){
        var e,t=new r(function(t){
        e=t});return{
        token:t,cancel:e}},e.exports=r},function(e,t){
        "use strict";e.exports=function(e){
        return function(t){
        return e.apply(null,t)}}}])});
    //# sourceMappingURL=axios.min.map

##### html #####

前端的话，由于我们这个是一个基础的演示样例，所以了这个前端就做的不是特别好看，这样也有好处，因为使用eleement-ui来写前端的话，会让前端很庞杂，不适合入门教学，我这里写的就是最纯粹的，那些花里花哨的前端框架还没有出来的时候，当时大家是怎么前后端发送请求的。

**项目结构**  
![在这里插入图片描述][6116e3ece2e14ea4b65e4d18ca8afd87.png]  
重要的是观察我这里的增加，删除，更新按钮，和mouted里面的axios怎么写的，怎么给后端发送请求的，特别是删除，更新事件如何传送id到后端。  
**index.html**

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
    </head>
    <body>
    <div id="app">
        <a href="/add"><input type="button" value="新增"></a><br>
        <hr>
        <table id="brandTable" border="1" cellspacing="0" width="100%">
            <tr>
                <th>序号</th>
                <th>品牌名称</th>
                <th>企业名称</th>
                <th>排序</th>
                <th>品牌介绍</th>
                <th>状态</th>
                <th>操作</th>
            </tr>
            
            <tr v-for="(brand,i) in brands" align="center" >
                <td>{
       {i + 1}}</td>
                <td>{
       {brand.brandName}}</td>
                <td>{
       {brand.companyName}}</td>
                <td>{
       {brand.ordered}}</td>
                <td>{
       {brand.description}}</td>
                <td>{
       {brand.statusStr}}</td>
                <td><input type="button" id="update" @click="updateId(brand.id)" value="修改"> <input type="button" id="delete" @click="deleteId(brand.id)" value="删除"></td>
            </tr>
        </table>
    </div>
    <script src="js/axios-0.18.0.js"></script>
    <script src="js/vue.js"></script>
    </body>
    
    <script>
        new Vue({
          
            el:"#app", // 这里写那个上面网页的div的id名称
            data(){
          
                return{
          
                    brands:[]
                }
            },
            mounted(){
           // 当网页加载的时候加载
                let _this = this; // 制作一个临时的this指针
                axios({
          
                    method:"get",
                    url:"http://localhost:8080/selectAll"
                }).then(function (response){
          
                    console.log(response.data)
                    _this.brands = response.data;
                })
            },
            methods: {
          
                updateId(id){
          
                    let _this = this;
                    axios({
          
                        method:"get",
                        url:"http://localhost:8080/update?id"+id,
                        data:id
                    }).then(resp=>{
          
                        location.href = "http://localhost:8080/update"
                    })
                },
                deleteId(id) {
          
                    let _this = this;
                    axios({
          
                        method:"post",
                        url:"http://localhost:8080/delete",
                        data:id
                    }).then(resp=>{
          
                        if (resp.data){
          
                            location.href = "http://localhost:8080/"
                        } else {
          
                            alert("删除失败")
                        }
                    })
                }
            }
        })
    
    </script>
    </html>

**update.html**

<!DOCTYPE html>
     <html lang="en">
    
     <head>
         <meta charset="UTF-8">
         <title>更新商品</title>
     </head>
     <body>
     <div id="app">
         <h3>更新商品</h3>
         <form action="" method="post">
             商品名称：<input id="brandName" v-model="brand.brandName" name="brandName"><br>
             企业名称：<input id="companyName" v-model="brand.companyName" name="companyName"><br>
             排序：<input id="ordered" v-model="brand.ordered" name="ordered"><br>
             描述信息：<textarea rows="5" cols="20" id="description" v-model="brand.description" name="description"></textarea><br>
             状态：
             <input type="radio" name="status" v-model="brand.status" value="0">禁用
             <input type="radio" name="status" v-model="brand.status" value="1">启用<br>
    
             
             <input type="button" id="btn" @click="submitForm" value="提交">
         </form>
     </div>
     <script src="js/axios-0.18.0.js"></script>
    
     <script src="js/vue.js"></script>
    
     <script>
    
         new Vue({
          
             el:"#app",
             data() {
          
                 return{
          
                     brand:{
          
    
                     }
                 }
             },
             methods:{
          
                 submitForm() {
          
                     var _this = this;
                     axios({
          
                         method: "post",
                         url:"http://localhost:8080/addBrand",
                         data:_this.brand
                     }).then(function (response) {
          
                         if (rresp.data){
           // 添加成功之后返回原来的页面
                             location.href="http://localhost:8080/";
                         } else{
          
                             alert("添加失败");
                         }
                     })
                 }
             }
         })
     </script>
     </body>
     </html>

**addBrand.html**

<!DOCTYPE html>
    <html lang="en">
    
    <head>
        <meta charset="UTF-8">
        <title>添加商品</title>
    </head>
    <body>
    <div id="app">
        <h3>添加商品</h3>
        <form action="" method="post">
            商品名称：<input id="brandName" v-model="brand.brandName" name="brandName"><br>
            企业名称：<input id="companyName" v-model="brand.companyName" name="companyName"><br>
            排序：<input id="ordered" v-model="brand.ordered" name="ordered"><br>
            描述信息：<textarea rows="5" cols="20" id="description" v-model="brand.description" name="description"></textarea><br>
            状态：
            <input type="radio" name="status" v-model="brand.status" value="0">禁用
            <input type="radio" name="status" v-model="brand.status" value="1">启用<br>
    
            
            <input type="button" id="btn" @click="submitForm" value="提交">
        </form>
    </div>
    <script src="js/axios-0.18.0.js"></script>
    
    <script src="js/vue.js"></script>
    
    <script>
    
        new Vue({
          
            el:"#app",
            data() {
          
                return{
          
                    brand:{
          
    
                    }
                }
            },
            methods:{
          
                submitForm() {
          
                    var _this = this;
                    axios({
          
                        method: "post",
                        url:"http://localhost:8080/addBrand",
                        data:_this.brand
                    }).then(function (response) {
          
                        if (resp.data){
           // 添加成功之后返回原来的页面
                            location.href="http://localhost:8080/";
                        } else {
          
                            alert("添加失败")
                        }
                    })
                }
            }
        })
    </script>
    </body>
    </html>

#### 后端 ####

##### Brand #####

对于Bean这些类类说，需要注意的是，在没有自己写resultMap的情况下，对于数据库中没有用下划线分割的属性名，需要保留原名，对于用来下划线命名的属性，需要使用驼峰命名法。

package com.example.springbootcrud.Bean;
    
    import com.baomidou.mybatisplus.annotation.IdType;
    import com.baomidou.mybatisplus.annotation.TableId;
    import lombok.AllArgsConstructor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    
    @Data
    @AllArgsConstructor
    @NoArgsConstructor
    public class Brand {
        
        private Integer id;
        private String brandName; // 需要注意的是具体类的命名不能有下划线要采取驼峰命名法 不然数据查不到
        private String companyName;
        private Integer ordered;
        private String description;
        // 状态：0：禁用  1：启用
        private Integer status;
    
        // 用于判断对status进行数据处理
        public String getStatusStr() {
        
    
            if(this.status == 1){
        
                return "启用";
            }
    
            return "禁用";
        }
    }

##### BrandDao #####

这个没啥可以说的，只能说mybatis-plus永远的神。

package com.example.springbootcrud.Dao;
    
    import com.baomidou.mybatisplus.core.conditions.Wrapper;
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import com.example.springbootcrud.Bean.Brand;
    import org.apache.ibatis.annotations.Mapper;
    
    import java.util.List;
    
    @Mapper
    public interface BrandDao extends BaseMapper<Brand> {
        
    
    }

##### **BrandController** #####

对于BrandController类来说，如果希望上面每个按钮或者超链接对应的网页链接，不会404的话，需要自己再写一个引导方法，因为在运行过程中访问地址的时候需要的写路径名称，全路径的话需要把自己的项目名字都加上去，那样太麻烦了，所以后面想出来了，这种写引导方法的办法。

package com.example.springbootcrud.Controller;
    
    import com.alibaba.fastjson.JSON;
    import com.example.springbootcrud.Bean.Brand;
    import com.example.springbootcrud.Dao.BrandDao;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.*;
    
    import javax.servlet.ServletException;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    import java.io.BufferedReader;
    import java.io.IOException;
    import java.util.List;
    
    
    
    @Controller
    public class BrandController {
        
    
        @Autowired
        BrandDao brandDao;
        @RequestMapping("/") // 设置默认页面
        public String index(){
        
            return "index.html";
        }
    
        @RequestMapping("/add")
        public String add(){
        
            return "addBrand.html";
        }
        @RequestMapping("/update")
        public String update(){
        
            return "updateBrand.html";
        }
    
        @ResponseBody
        @GetMapping("/selectAll")
        public List<Brand> selectAll(){
        
    
            System.out.println(brandDao.selectList(null).toString());
    //        return JSON.toJSONString(brandDao.selectList(null));
            return brandDao.selectList(null);
        }
        @RequestMapping("/addBrand")
        @ResponseBody
        public String addBrand(HttpServletRequest request)throws ServletException, IOException {
        
            BufferedReader reader = request.getReader();
            String params = reader.readLine();
            Brand brand = JSON.parseObject(params, Brand.class);
    
            System.out.println(brand);
            brandDao.insert(brand);
            return "success";
        }
    
        @RequestMapping("/updateId")
        @ResponseBody
        public String updateBrand(HttpServletRequest request)throws ServletException, IOException{
        
            BufferedReader reader = request.getReader();
            String params = reader.readLine();
            Brand brand = JSON.parseObject(params, Brand.class);
    
            System.out.println(brand);
            brandDao.updateById(brand);
            return "success";
        }
    
        @RequestMapping("/delete")
        @ResponseBody
        public String deleteBrand(HttpServletRequest request)throws ServletException, IOException{
        
            BufferedReader reader = request.getReader();
            String params = reader.readLine();
            System.out.println(params);
    
            if (brandDao.deleteById(Integer.parseInt(params)) > 0) return "success";
            return "false";
        }
    }

#### 测试部分 ####

##### BrandDaoTestCase #####

写项目一定要写测试类，则很重要的，测试参与的每一个方法是否正确。

package com.example.springbootcrud.Dao;
    
    import com.example.springbootcrud.Bean.Brand;
    import org.junit.jupiter.api.Test;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    
    @SpringBootTest
    public class BrandDaoTestCase {
        
        @Autowired
        private BrandDao brandDao;
    
        @Test
        void testSelectAll(){
        
            System.out.println(brandDao.selectList(null));
        }
    
        @Test
        void testSave(){
        
            Brand brand = new Brand();
            brand.setBrandName("测试数据1");
            brand.setCompanyName("测试数据2");
            brand.setOrdered(1);
            brand.setDescription("测试数据3");
            brand.setStatus(1);
            System.out.println(brand);
            brandDao.insert(brand);
        }
    
        @Test
        void testUpdate(){
        
            Brand brand = new Brand();
            brand.setId(7);
            brand.setBrandName("1");
            brand.setCompanyName("测试数据2");
            brand.setOrdered(1);
            brand.setDescription("测试数据3");
            brand.setStatus(1);
            System.out.println(brand);
            brandDao.updateById(brand);
        }
    
        @Test
        void testDelete(){
        
            brandDao.deleteById(4);
        }
    }

运行结果：  
![在这里插入图片描述][ca44df758a954e82b696ef1f8903a4d3.png]

![在这里插入图片描述][3a9eeefbd8b34a53a0bc864f468f630f.png]

[468fb7a60b204caf936ec7fb889a3e56.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/28/f991f391185842f9add644d6b63da40f.png
[d436ad4868624cc0ae00d9b9b5e934ca.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/28/1cfa7320042d4248b84b1b842ad230c3.png
[deb8995f590d4c0aad4185f65d865744.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/28/1e6906c9d6b14ac4aeea5beb6f742aa7.png
[vue.js]: https://v1-cn.vuejs.org/guide/installation.html
[b6936c87d0fd45ec8a8a67244d5349f5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/28/76ff89750cfa47a0bffb3288de82cac8.png
[6116e3ece2e14ea4b65e4d18ca8afd87.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/28/918a4d3414894b45a482968cd56fc1b4.png
[ca44df758a954e82b696ef1f8903a4d3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/28/a6c5ef6a66d944eb9761397f24f6047a.png
[3a9eeefbd8b34a53a0bc864f468f630f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/28/ce9be645a433402f89ddc215c339eafe.png