• SpringBoot 整合mybatis，mybatis-plus

    前言

    在真实的项目开发中，使用SpringBoot可以说非常普遍了，而在框架整合中，与数据库的交互无外乎使用jpa,mybatis，mybatis-plus这几种，虽然hibernate仍然有在使用，毕竟框架毕竟重，而且用起来相较于mybatis还是差了那么点意思；

    接下来演示下使用 SpringBoot 同时与mybatis，mybatis-plus的整合步骤；

    准备工作

    1、准备如下一个数据表

    1. CREATE TABLE `student` (
    2.   `id` varchar(32) NOT NULL,
    3.   `gender` varchar(32) DEFAULT NULL,
    4.   `age` int(12) DEFAULT NULL,
    5.   `nick_name` varchar(32) DEFAULT NULL,
    6.   `name` varchar(32) DEFAULT NULL,
    7.   PRIMARY KEY (`id`)
    8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    9.

    2、插入几条测试数据

     

    整合步骤

    工程的完整包结构如图所示

     

    1、导入maven依赖

    1.     <parent>
    2.         <groupId>org.springframework.boot</groupId>
    3.         <artifactId>spring-boot-starter-parent</artifactId>
    4.         <version>2.1.1.RELEASE</version>
    5.         <relativePath/> <!-- lookup parent from repository -->
    6.     </parent>
    7.  
    8.  
    9.     <properties>
    10.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    11.         <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    12.         <java.version>1.8</java.version>
    13.         <mysql-connector-java.version>8.0.11</mysql-connector-java.version>
    14.         <commons-lang3.version>3.7</commons-lang3.version>
    15.         <fastjson.version>1.2.47</fastjson.version>
    16.         <mybatis-plus-boot-starter.version>3.3.0</mybatis-plus-boot-starter.version>
    17.         <mybatis-plus-generator.version>3.3.0</mybatis-plus-generator.version>
    18.         <druid.version>1.1.14</druid.version>
    19.         <lombok.version>1.18.0</lombok.version>
    20.         <dubbo-spring-boot-starter.version>2.0.0</dubbo-spring-boot-starter.version>
    21.         <swagger.version>2.9.2</swagger.version>
    22.         <swagger-bootstrap-ui.version>1.9.6</swagger-bootstrap-ui.version>
    23.     </properties>
    24.  
    25.     <dependencies>
    26.         <dependency>
    27.             <groupId>org.apache.commons</groupId>
    28.             <artifactId>commons-lang3</artifactId>
    29.             <version>3.4</version>
    30.         </dependency>
    31.  
    32.         <dependency>
    33.             <groupId>org.springframework.boot</groupId>
    34.             <artifactId>spring-boot-starter-web</artifactId>
    35.         </dependency>
    36.  
    37.         <!--mysql依赖-->
    38.         <dependency>
    39.             <groupId>mysql</groupId>
    40.             <artifactId>mysql-connector-java</artifactId>
    41.             <version>${mysql-connector-java.version}</version>
    42.         </dependency>
    43.  
    44.         <!--阿里巴巴fastjosn依赖-->
    45.         <dependency>
    46.             <groupId>com.alibaba</groupId>
    47.             <artifactId>fastjson</artifactId>
    48.             <version>${fastjson.version}</version>
    49.         </dependency>
    50.  
    51.         <!--阿里巴巴数据库连接池依赖-->
    52.         <!-- Druid -->
    53.         <dependency>
    54.             <groupId>com.alibaba</groupId>
    55.             <artifactId>druid-spring-boot-starter</artifactId>
    56.             <version>${druid.version}</version>
    57.         </dependency>
    58.  
    59.         <dependency>
    60.             <groupId>org.mybatis.spring.boot</groupId>
    61.             <artifactId>mybatis-spring-boot-starter</artifactId>
    62.             <version>2.1.1</version>
    63.         </dependency>
    64.  
    65.         <!-- MyBatis增强工具-->
    66.         <dependency>
    67.             <groupId>com.baomidou</groupId>
    68.             <artifactId>mybatis-plus-boot-starter</artifactId>
    69.             <version>${mybatis-plus-boot-starter.version}</version>
    70.         </dependency>
    71.         <dependency>
    72.             <groupId>com.baomidou</groupId>
    73.             <artifactId>mybatis-plus-generator</artifactId>
    74.             <version>${mybatis-plus-generator.version}</version>
    75.         </dependency>
    76.  
    77.         <!-- lombok -->
    78.         <dependency>
    79.             <groupId>org.projectlombok</groupId>
    80.             <artifactId>lombok</artifactId>
    81.             <version>${lombok.version}</version>
    82.         </dependency>
    83.  
    84.         <!--swagger-ui-->
    85.         <dependency>
    86.             <groupId>io.springfox</groupId>
    87.             <artifactId>springfox-swagger2</artifactId>
    88.             <version>${swagger.version}</version>
    89.         </dependency>
    90.  
    91.         <dependency>
    92.             <groupId>io.springfox</groupId>
    93.             <artifactId>springfox-swagger-ui</artifactId>
    94.             <version>${swagger.version}</version>
    95.         </dependency>
    96.  
    97.         <dependency>
    98.             <groupId>com.github.xiaoymin</groupId>
    99.             <artifactId>swagger-bootstrap-ui</artifactId>
    100.             <version>${swagger-bootstrap-ui.version}</version>
    101.         </dependency>
    102.  
    103.     </dependencies>

    2、配置文件 application.yml

    1.  
    2. server:
    3.   port: 8083
    4.  
    5. logging:
    6.   config: classpath:logback-spring.xml  #日志
    7.  
    8. spring:
    9.   datasource:
    10.     driver-class-name: com.mysql.cj.jdbc.Driver
    11.     url: jdbc:mysql://IP:3306/school?autoReconnect=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false
    12.     username: root
    13.     password: root
    14.     druid:
    15.       max-active: 100
    16.       initial-size: 10
    17.       max-wait: 60000
    18.       min-idle: 5
    19.  
    20.  
    21.   #设置单个文件最大上传大小
    22.   servlet:
    23.     multipart:
    24.       max-file-size: 20MB
    25.  
    26.  
    27. mybatis-plus:
    28.   mapper-locations: classpath*:mapper/*.xml
    29.   global-config:
    30.     db-column-underline: true  #开启驼峰转换
    31.     db-config:
    32.       id-type: uuid
    33.       field-strategy: not_null
    34.     refresh: true
    35.   configuration:
    36.     map-underscore-to-camel-case: true
    37.     #log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #打印sql语句便于调试

    3、为了方便后面调试接口，增加一个swagger的配置

    1. import org.springframework.context.annotation.Bean;
    2. import org.springframework.context.annotation.Configuration;
    3. import springfox.documentation.builders.ApiInfoBuilder;
    4. import springfox.documentation.builders.PathSelectors;
    5. import springfox.documentation.builders.RequestHandlerSelectors;
    6. import springfox.documentation.service.ApiInfo;
    7. import springfox.documentation.spi.DocumentationType;
    8. import springfox.documentation.spring.web.plugins.Docket;
    9. import springfox.documentation.swagger2.annotations.EnableSwagger2;
    10.  
    11. /**
    12.  * swagger文档，项目启动后，浏览器访问:http://localhost:8083/swagger-ui.html
    13.  */
    14. @Configuration
    15. @EnableSwagger2
    16. public class ApiSwagger2 {
    17.  
    18.     @Bean
    19.     public Docket createRestBmbsApi() {
    20.         return new Docket(DocumentationType.SWAGGER_2)
    21.                 .groupName("users")
    22.                 .apiInfo(apiInfo())
    23.                 .select()
    24.                 .apis(RequestHandlerSelectors.basePackage("com.congge.controller"))
    25.                 .paths(PathSelectors.any())
    26.                 .build();
    27.     }
    28.  
    29.     private ApiInfo apiInfo() {
    30.         return new ApiInfoBuilder()
    31.                 .title("后端相关API")
    32.                 .version("1.0")
    33.                 .build();
    34.     }
    35.  
    36. }

    4、实体类

    1. import com.baomidou.mybatisplus.annotation.TableField;
    2. import lombok.Data;
    3.  
    4. @Data
    5. public class Student {
    6.  
    7.     @TableField("id")
    8.     private String id;
    9.  
    10.     @TableField("name")
    11.     private String name;
    12.  
    13.     @TableField("gender")
    14.     private String gender;
    15.  
    16.     @TableField("age")
    17.     private int age;
    18.  
    19.     @TableField("nick_name")
    20.     private String nickName;
    21.  
    22. }

    5、dao接口，里面添加一个查询所有数据的方法

    1. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    2. import com.congge.entity.Student;
    3. import org.apache.ibatis.annotations.Mapper;
    4.  
    5. import java.util.List;
    6.  
    7. @Mapper
    8. public interface StudentMapper extends BaseMapper<Student> {
    9.  
    10.     List<Student> queryAll();
    11.  
    12. }

    6、mybatis层，写sql的文件

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    3. <mapper namespace="com.congge.dao.StudentMapper">
    4.  
    5.     <select id="queryAll" resultType="com.congge.entity.Student">
    6. 		select * from student
    7. 	</select>
    8.  
    9. </mapper>

    7、业务实现类

    在本次的业务实现中，同时可以使用mybatis的方式以及mybatis-plus的方式进行，具体使用的时候结合自身的需求进行选择；

    1. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    2. import com.congge.dao.StudentMapper;
    3. import com.congge.entity.Student;
    4. import com.congge.service.StudentService;
    5. import org.springframework.stereotype.Service;
    6.  
    7. import javax.annotation.Resource;
    8. import java.util.List;
    9.  
    10. @Service
    11. public class StudentServiceImpl implements StudentService {
    12.  
    13.     @Resource
    14.     private StudentMapper studentMapper;
    15.  
    16.     @Override
    17.     public List<Student> queryAllStudent() {
    18.         QueryWrapper<Student> queryWrapper = new QueryWrapper();
    19.         List<Student> students = studentMapper.selectList(queryWrapper);
    20.         return students;
    21.         //return studentMapper.queryAll();
    22.     }
    23.  
    24.     @Override
    25.     public List<Student> getByName(String name) {
    26.         QueryWrapper<Student> queryWrapper = new QueryWrapper();
    27.         queryWrapper.like("name",name);
    28.         return studentMapper.selectList(queryWrapper);
    29.     }
    30.  
    31.     public Student getById(String id) {
    32.         QueryWrapper<Student> queryWrapper = new QueryWrapper();
    33.         queryWrapper.like("id",id);
    34.         return studentMapper.selectOne(queryWrapper);
    35.     }
    36. }

    8、添加一个测试接口

    1. @RestController
    2. public class StudentController {
    3.  
    4.     @Autowired
    5.     private StudentService studentService;
    6.  
    7.     @GetMapping("/getAll")
    8.     public List<Student> getAll(){
    9.         return studentService.queryAllStudent();
    10.     }
    11.  
    12.     @GetMapping("/getByName")
    13.     public List<Student> getByName(@RequestParam String name){
    14.         return studentService.getByName(name);
    15.     }
    16.  
    17.     @GetMapping("/getById")
    18.     public Student getById(@RequestParam String id){
    19.         return studentService.getById(id);
    20.     }
    21. }

    9、启动类

    1. import org.springframework.boot.SpringApplication;
    2. import org.springframework.boot.autoconfigure.SpringBootApplication;
    3.  
    4. @SpringBootApplication
    5. public class App {
    6.  
    7.     public static void main(String[] args) {
    8.         SpringApplication.run(App.class,args);
    9.     }
    10.  
    11. }

    接下来，将工程运行起来做一下测试吧

    10、启动之后，打开swagger界面

     

     

    不妨随机测试两个接口吧，测试下获取所有学生的数据接口

     

    本篇到这里基本上就结束了，更多的业务大家可以结合自身的实际情况，继续在代码中补充即可

  • 相关阅读:
    qt简易网络聊天室 数据库的练习
    CV计算机视觉每日开源代码Paper with code速览-2023.10.20
    基于PSO的UAV三维路径规划（Matlab代码实现）
    多标签与多分类的区别
    Maven——采用profile设定不同的开发环境切换
    FPGA project : flash_secter_erase
    ​​​​​​​等级保护差距测评工作实施方案
    英语什么时候加s和es
    YbtOJ「动态规划」第1章 背包问题
    2防火墙：基础知识
  • 原文地址：https://blog.csdn.net/congge_study/article/details/125433452