毕业设计Day7--MyBatisPlus实现增删改查

小温爱摸鱼

已于 2023-06-26 15:29:44 修改

阅读量439

点赞数 1

分类专栏：毕业设计文章标签： spring boot 课程设计 mybatis

于 2023-04-14 15:32:10 首次发布

本文链接：https://blog.csdn.net/weixin_46434074/article/details/130153341

版权

毕业设计专栏收录该内容

14 篇文章 1 订阅

订阅专栏

文章目录

集成MybatisPlus

官网链接
在maven中添加依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.5.1</version>
</dependency>

在config包下建立MybatisPlusConfig类，如下

package com.ww.car.config;

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.ww.car.mapper")
public class MybatisPlusConfig {


    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();
        paginationInnerInterceptor.setDbType(DbType.MYSQL);
        //分页查询超过最大页码 显示第一页
        paginationInnerInterceptor.setOverflow(true);
        interceptor.addInnerInterceptor(paginationInnerInterceptor);
        return interceptor;
    }




}

更换SQL打印配置
（在application.yml中）

在这里插入图片描述
Postman测试即可

UserService继承ServiceImpl

在这里插入图片描述

controller类也需做对于修改

在这里插入图片描述

Postman测试报错500

在这里插入图片描述

报错原因：
在这里插入图片描述
mybatis-plus默认表名为实体类user名，因此在数据库中未查找到对应表格，，需要在实体类中通过注释写出表名，主键也需加上注释

在这里插入图片描述
Postman测试成功

在这里插入图片描述

数据库表中列名与实体类属性名不一致

例：数据库列名carnum，实体类属性名abc，通过如下注释来实现对应关系
在这里插入图片描述

引入swaggerUI

参考链接
在pom中增加配置

<!--swagger-->
<!--swagger-->
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-boot-starter</artifactId>
            <version>3.0.0</version>
        </dependency>

config包中添加SwaggerConfig类

package com.ww.car.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
import springfox.documentation.oas.annotations.EnableOpenApi;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.service.Contact;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;
import springfox.documentation.swagger2.annotations.EnableSwagger2;

@Configuration

@EnableOpenApi
public class SwaggerConfig {

    /**
     * 创建API应用
     * apiInfo() 增加API相关信息
     * 通过select()函数返回一个ApiSelectorBuilder实例,用来控制哪些接口暴露给Swagger来展现，
     * 本例采用指定扫描的包路径来定义指定要建立API的目录。
     *
     * @return
     */
    @Bean
    public Docket restApi() {
        return new Docket(DocumentationType.SWAGGER_2)
                .groupName("标准接口")
                .apiInfo(apiInfo("Spring Boot中使用Swagger2构建RESTful APIs", "1.0"))
                .useDefaultResponseMessages(true)
                .forCodeGeneration(false)
                .select()
                .apis(RequestHandlerSelectors.basePackage("com.ww.car.controller"))
                .paths(PathSelectors.any())
                .build();
    }

    /**
     * 创建该API的基本信息（这些基本信息会展现在文档页面中）
     * 访问地址：http://ip:port/swagger-ui.html
     *
     * @return
     */
    private ApiInfo apiInfo(String title, String version) {
        return new ApiInfoBuilder()
                .title(title)
                .description("更多请关注: https://blog.csdn.net/weixin_46434074?spm=1018.2226.3001.5343")
                .termsOfServiceUrl("https://blog.csdn.net/weixin_46434074?spm=1018.2226.3001.5343")
                .contact(new Contact("wenxin", "https://blog.csdn.net/weixin_46434074?spm=1018.2226.3001.5343", "2420274697@qq.com"))
                .version(version)
                .build();
    }
}

在地址栏输入http://localhost:9090/swagger-ui/index.html，显示swagger界面

在这里插入图片描述
测试

Mybatis-plus实现增删改查

直接用service中自带的函数即可

在这里插入图片描述

mybatis-plus实现分页查询

在这里插入图片描述
postman测试500

在这里插入图片描述

报错500解决办法

由于mapper里重写了selectPage导致报错，将mapper中内容全都注释掉，再次尝试即可成功

在这里插入图片描述

or查询

此查询不推荐使用，若输入某一条件，其余条件约等于失效

在这里插入图片描述

and查询

（各条件缺一不可，缺一个条件就会报错400）

在这里插入图片描述
若缺少某一条件，会报错400

报错400解决办法

在这里插入图片描述

给查询时的各条件赋上默认值null即可

在这里插入图片描述

当数据库表中某值为null时，上述方法可能缺少部分数据，因此可以对数据进行非空判断

在这里插入图片描述

代码总结

UserController.java

package com.ww.car.controller;

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.ww.car.entity.User;
import com.ww.car.mapper.UserMapper;
import com.ww.car.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.bind.annotation.*;

import java.util.HashMap;
import java.util.List;
import java.util.Map;


@RestController
@RequestMapping("/user")
public class UserController {

//    @Autowired
//    private UserMapper userMapper;

    @Autowired
    private UserService userService;

    //新增&修改
    @PostMapping
    public  boolean save(@RequestBody User user){
        //新增或更新均可
        return userService.saveUser(user);
    }

    //查询所有数据
    @GetMapping
    public List<User> findAll(){

        return userService.list();
    }

    //删除数据
    @DeleteMapping("/{id}")
    public boolean delete(@PathVariable Integer id){
        return userService.removeById(id);
    }


    //接口路径:/user/page
    //分页查询
    //@RequestParam接收  ？pageNum=1&pageSize=10
    //pageNum是指起始数据的位置（默认值为0，即从第一条数据开始查询），pageSize是指每页数量
    //每页第一个数据：（pageNum-1）*pageSize
//    @GetMapping("/page")
//
//    public Map<String, Object> findPage(@RequestParam Integer pageNum,
//                                        @RequestParam Integer pageSize,
//                                        @RequestParam String username){
//
//        pageNum=(pageNum - 1) * pageSize;
//        List<User> data=userMapper.selectPage(pageNum,pageSize,username);
//        Integer total = userMapper.selectTotal(username);
//        Map<String, Object> res = new HashMap<>();
//        res.put("data",data);
//        res.put("total",total);
//        return res;
//
//    }

    //mybatis-plus实现分页查询
    @GetMapping("/page")
    public IPage<User> findPage(@RequestParam Integer pageNum,
                                @RequestParam Integer pageSize,
                                @RequestParam(defaultValue = "") String username,
                                @RequestParam(defaultValue = "") String email,
                                @RequestParam(defaultValue = "") String carnum){
        IPage<User> page = new Page<>(pageNum,pageSize);
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        if(!"".equals(username)){
            queryWrapper.like("username",username);
        }
        if(!"".equals(email)){
            queryWrapper.like("email",email);
        }
        if(!"".equals(carnum)){
            queryWrapper.like("carnum",carnum);
        }
        return userService.page(page,queryWrapper);

    }
}

HomeView.vue

<template>
 <div style="height:100%">
   <el-container style="height: 100vh  ">
     <el-aside width="sideWidth+'px'" style="background-color: rgb(238, 241, 246);height:100% ;box-shadow: rgba(0,21,41,0.35) 2px 0px 6px;">
       <el-menu :default-openeds="['1', '3']"
                style="min-height:100%; overflow-x:hidden;"
                background-color="rgb(251,185,197)"
                active-text-color="rgb(255,224,230)"
                :collapse-transition="false"
                :collapse="isCollapse"
       >
         <div style="height:60px;line-height: 60px;text-align: center">
           <img src="../assets/car.png" alt="" style="width:20px;position:relative;top:5px;margin-right: 5px;">
           <b v-show="!isCollapse">小温的停车场管理系统</b>
         </div>

         <el-submenu index="1">
           <template slot="title"><i class="el-icon-message"></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-setting"></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:20px">
           <span :class="collapseBtnClass" style="cursor: pointer" @click="collapse"></span>
         </div>
         <el-dropdown style="width: 70px;cursor:pointer">
           <span>小温</span>
           <i class="el-icon-arrow-down" style="margin-left: 5px"></i>
           <el-dropdown-menu slot="dropdown">
             <el-dropdown-item>个人信息</el-dropdown-item>
             <el-dropdown-item>退出</el-dropdown-item>

           </el-dropdown-menu>
         </el-dropdown>

       </el-header>

       <el-main>

         <div style="margin-bottom:10px">
           <el-breadcrumb separator-class="el-icon-arrow-right">
             <el-breadcrumb-item :to="{ path: '/' }">首页</el-breadcrumb-item>
             <el-breadcrumb-item>用户管理</el-breadcrumb-item>
           </el-breadcrumb>
         </div>

         <div style="padding: 10px 0;margin-bottom:5px">
           <el-input style="width: 280px" placeholder="请输入姓名" suffix-icon="el-icon-search" v-model="username"></el-input>
           <el-input style="width: 280px" placeholder="请输入邮箱" suffix-icon="el-icon-message" class="ml-10"></el-input>
           <el-input style="width: 280px" placeholder="请输入车牌号" suffix-icon="el-icon-truck" class="ml-10"></el-input>
           <el-button class="ml-10" type="primary" @click="load">搜索</el-button>
         </div>

         <div class="ml-5" style="margin-bottom: 15px">
           <el-button type="primary">新增 <i class="el-icon-circle-plus-outline"></i></el-button>
           <el-button type="danger">批量删除 <i class="el-icon-remove-outline"></i></el-button>
           <el-button type="primary">导入<i class="el-icon-top"></i></el-button>
           <el-button type="primary">导出<i class="el-icon-bottom"></i></el-button>
         </div>
         <el-table :data="tableData" style="margin-top: 10px " border stripe   :row-class-name="tableRowClassName" >

           <el-table-column prop="id" label="ID" width="80">
           </el-table-column>

           <el-table-column prop="username" label="车主姓名" width="120">
           </el-table-column>

           <el-table-column prop="nickname" label="昵称" width="140">
           </el-table-column>

           <el-table-column prop="email" label="邮箱">
           </el-table-column>

           <el-table-column prop="address" label="地址">
           </el-table-column>

           <el-table-column prop="carnum" label="车牌号">
           </el-table-column>

           <el-table-column  label="操作">
             <template slot-scope="scope">
               <el-button type="success">编辑<i class="el-icon-edit"></i> </el-button>
               <el-button type="danger" >删除<i class="el-icon-remove-outline"></i></el-button>
             </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, 10, 15, 20]"
               :page-size="pageSize"
               layout="total, sizes, prev, pager, next, jumper"
               :total="total">
           </el-pagination>
         </div>
       </el-main>
     </el-container>
   </el-container>




 </div>
</template>
<style>
.el-table .warning-row {
  background: oldlace;
}

.el-table .success-row {
  background: #f0f9eb;
}
.headerBg{
  background: #42b983!important;
}


</style>
<script>
// @ is an alias to /src
import HelloWorld from '@/components/HelloWorld.vue'

export default {
  name: 'HomeView',
  components: {
    HelloWorld
  },
  data(){
    return{
      tableData: [],
      total:0,
      username:"",
      pageNum:1,
      pageSize:2,
      msg:"hello 小温",
      collapseBtnClass:'el-icon-s-fold',
      isCollapse:false,
      sideWidth:200
    }
  },
  created() {
    //请求分页查询数据
    this.load()
  },
  methods:{
    collapse(){   // 点击收缩按钮触发
      this.isCollapse=!this.isCollapse
      if(this.isCollapse){
        this.sideWidth = 60
        this.collapseBtnClass = 'el-icon-s-unfold'
      }else{
        this.sideWidth=200
        this.collapseBtnClass='el-icon-s-fold'
      }
    },
    load(){
      fetch("http://localhost:9090/user/page?pageNum="+this.pageNum+"&pageSize="+this.pageSize+"&username="+this.username)
          .then(res => res.json()).then(res =>{
        console.log(res)
        this.tableData=res.data
        this.total=res.total
      })
    },
    handleSizeChange(pageSize){
      console.log(pageSize)
      this.pageSize=pageSize
      this.load()
    },
    handleCurrentChange(pageNum){
      console.log(pageNum)
      this.pageNum=pageNum
      this.load()
    },
    tableRowClassName({row, rowIndex}) {
      if (rowIndex === 1) {
        return 'warning-row';
      } else if (rowIndex === 3) {
        return 'success-row';
      }
      return '';
    }
  }
}
</script>

CorsConfig.java

package com.ww.car.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.cors.CorsConfiguration;
import org.springframework.web.cors.UrlBasedCorsConfigurationSource;
import org.springframework.web.filter.CorsFilter;

@Configuration
public class CorsConfig {

    // 当前跨域请求最大有效时长。这里默认1天
    private static final long MAX_AGE = 24 * 60 * 60;

    @Bean
    public CorsFilter corsFilter() {
        UrlBasedCorsConfigurationSource source = new UrlBasedCorsConfigurationSource();
        CorsConfiguration corsConfiguration = new CorsConfiguration();
        corsConfiguration.addAllowedOrigin("*"); // 1 设置访问源地址
        corsConfiguration.addAllowedHeader("*"); // 2 设置访问源请求头
        corsConfiguration.addAllowedMethod("*"); // 3 设置访问源请求方法
        corsConfiguration.setMaxAge(MAX_AGE);
        source.registerCorsConfiguration("/**", corsConfiguration); // 4 对接口配置跨域设置
        return new CorsFilter(source);
    }
}

MybatisPlusConfig.java

package com.ww.car.config;

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.ww.car.mapper")
public class MybatisPlusConfig {


    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();
        paginationInnerInterceptor.setDbType(DbType.MYSQL);
        //分页查询超过最大页码 显示第一页
        paginationInnerInterceptor.setOverflow(true);
        interceptor.addInnerInterceptor(paginationInnerInterceptor);
        return interceptor;
    }




}

SwaggerConfig.java

package com.ww.car.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
import springfox.documentation.oas.annotations.EnableOpenApi;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.service.Contact;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;
import springfox.documentation.swagger2.annotations.EnableSwagger2;

@Configuration

@EnableOpenApi
public class SwaggerConfig {

    /**
     * 创建API应用
     * apiInfo() 增加API相关信息
     * 通过select()函数返回一个ApiSelectorBuilder实例,用来控制哪些接口暴露给Swagger来展现，
     * 本例采用指定扫描的包路径来定义指定要建立API的目录。
     *
     * @return
     */
    @Bean
    public Docket restApi() {
        return new Docket(DocumentationType.SWAGGER_2)
                .groupName("标准接口")
                .apiInfo(apiInfo("Spring Boot中使用Swagger2构建RESTful APIs", "1.0"))
                .useDefaultResponseMessages(true)
                .forCodeGeneration(false)
                .select()
                .apis(RequestHandlerSelectors.basePackage("com.ww.car.controller"))
                .paths(PathSelectors.any())
                .build();
    }

    /**
     * 创建该API的基本信息（这些基本信息会展现在文档页面中）
     * 访问地址：http://ip:port/swagger-ui.html
     *
     * @return
     */
    private ApiInfo apiInfo(String title, String version) {
        return new ApiInfoBuilder()
                .title(title)
                .description("更多请关注: https://blog.csdn.net/weixin_46434074?spm=1018.2226.3001.5343")
                .termsOfServiceUrl("https://blog.csdn.net/weixin_46434074?spm=1018.2226.3001.5343")
                .contact(new Contact("wenxin", "https://blog.csdn.net/weixin_46434074?spm=1018.2226.3001.5343", "2420274697@qq.com"))
                .version(version)
                .build();
    }
}

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>
    <groupId>com.ww</groupId>
    <artifactId>car</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>car</name>
    <description>car</description>
    <properties>
        <java.version>1.8</java.version>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <spring-boot.version>2.6.13</spring-boot.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <!--mybatis plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>
        <!--swagger-->
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-boot-starter</artifactId>
            <version>3.0.0</version>
        </dependency>


        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>${spring-boot.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.8.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>${spring-boot.version}</version>
                <configuration>
                    <mainClass>com.ww.car.CarApplication</mainClass>
                    <skip>true</skip>
                </configuration>
                <executions>
                    <execution>
                        <id>repackage</id>
                        <goals>
                            <goal>repackage</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>

    <repositories>
        <repository>
            <id>nexus-aliyun</id>
            <name>nexus-aliyun</name>
            <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
            <releases>
                <enabled>true</enabled>
            </releases>
            <snapshots>
                <enabled>false</enabled>
            </snapshots>
        </repository>
    </repositories>

    <pluginRepositories>
        <pluginRepository>
            <id>public</id>
            <name>aliyun nexus</name>
            <url>http://maven.aliyun.com.nexus/content/groups/public/</url>
            <releases>
                <enabled>true</enabled>
            </releases>
            <snapshots>
                <enabled>false</enabled>
            </snapshots>
        </pluginRepository>
    </pluginRepositories>
</project>