• Springboot 整合Mytbatis与Mybatis-Plus

    目录

    1. springboot整合mybatis  

     1.1 添加pom.xml依赖

     1.2 新建jdbc.properties 文件添加以下内容

     1.3 新建generatorConfig.xml 文件添加以下内容 (自动生成代码类) 

     1.4 修改application.properties 文件 添加以下内容

     1.5 修改主类MapperScan

     1.6 编写接口实现类进行测试 

    2. springboot整合mybatis-plus

      2.1 添加pom.xml依赖 

      2.2 自动生成代码类

      2.3 修改application.properties 文件 添加以下内容

      2.4 修改主方法MapperScan

      2.5 编写测试类开始测试

    前言

     如果你想要复制我的代码来操作实验的话请看以下说明：

        springboot整合mybatis主包名要为 com.jmh.ssm

     

        springboot整合mybatis-plus主包名为 com.jmh.ssmmp

     

    1. springboot整合mybatis  

      1.1 添加pom.xml依赖

    1.     <dependencies>
    2.         <dependency>
    3.             <groupId>org.springframework.bootgroupId>
    4.             <artifactId>spring-boot-starter-jdbcartifactId>
    5.         dependency>
    6.         <dependency>
    7.             <groupId>org.springframework.bootgroupId>
    8.             <artifactId>spring-boot-starter-webartifactId>
    9.         dependency>
    10.         <dependency>
    11.             <groupId>org.mybatis.spring.bootgroupId>
    12.             <artifactId>mybatis-spring-boot-starterartifactId>
    13.             <version>2.2.2version>
    14.         dependency>
    15.         <dependency>
    16.             <groupId>mysqlgroupId>
    17.             <artifactId>mysql-connector-javaartifactId>
    18.             <scope>runtimescope>
    19.         dependency>
    20.         <dependency>
    21.             <groupId>org.projectlombokgroupId>
    22.             <artifactId>lombokartifactId>
    23.             <optional>trueoptional>
    24.         dependency>
    25.     dependencies>
    2.             <plugin>
    3.                 <groupId>org.mybatis.generatorgroupId>
    4.                 <artifactId>mybatis-generator-maven-pluginartifactId>
    5.                 <version>1.3.2version>
    6.                 <dependencies>
    7.                     
    8.                     <dependency>
    9.                         <groupId>mysqlgroupId>
    10.                         <artifactId>mysql-connector-javaartifactId>
    11.                         <version>5.1.44version>
    12.                     dependency>
    13.                 dependencies>
    14.                 <configuration>
    15.                     <overwrite>trueoverwrite>
    16.                 configuration>
    17.             plugin>

      1.2 新建jdbc.properties 文件添加以下内容

    1. jdbc.driver=com.mysql.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/数据库名称?useUnicode=true&characterEncoding=UTF-8
    3. jdbc.username=数据库账号
    4. jdbc.password=数据库密码

      1.3 新建generatorConfig.xml 文件添加以下内容 (自动生成代码类) 

    1. "1.0" encoding="UTF-8" ?>
    2. generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    4. <generatorConfiguration>
    5.     
    6.     <properties resource="jdbc.properties"/>
    7.  
    8.     
    9.  
    10.     
    11.     <classPathEntry location="E:\\mysql"/>
    12.  
    13.     
    14.     <context id="infoGuardian">
    15.         
    16.         <commentGenerator>
    17.             <property name="suppressAllComments" value="true"/>
    18.             <property name="suppressDate" value="true"/> 
    19.         commentGenerator>
    20.  
    21.         
    22.         <jdbcConnection driverClass="${jdbc.driver}"
    23.                         connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    24.  
    25.         
    26.         <javaTypeResolver>
    27.             
    28.             <property name="forceBigDecimals" value="false"/>
    29.         javaTypeResolver>
    30.  
    31.         
    32.         
    33.         
    34.  
    35.         
    36.         <javaModelGenerator targetPackage="com.jmh.ssm.model"
    37.                             targetProject="src/main/java">
    38.             
    39.             <property name="enableSubPackages" value="false"/>
    40.             
    41.             <property name="constructorBased" value="true"/>
    42.             
    43.             <property name="trimStrings" value="false"/>
    44.             
    45.             <property name="immutable" value="false"/>
    46.         javaModelGenerator>
    47.  
    48.         
    49.  
    50.         
    51.         <sqlMapGenerator targetPackage="mapper"
    52.                          targetProject="src/main/test">
    53.             
    54.             <property name="enableSubPackages" value="false"/>
    55.         sqlMapGenerator>
    56.  
    57.         
    58.         
    59.         
    60.         
    61.  
    62.         
    63.         <javaClientGenerator targetPackage="com.jmh.ssm.mapper"
    64.                              targetProject="src/main/java" type="XMLMAPPER">
    65.             
    66.             <property name="enableSubPackages" value="false"/>
    67.         javaClientGenerator>
    68.  
    69.         
    70.         
    71.         
    72.         
    73.         
    74.         <table schema="" tableName="t_book_vue" domainObjectName="Book"
    75.                enableCountByExample="false" enableDeleteByExample="false"
    76.                enableSelectByExample="false" enableUpdateByExample="false">
    77.             
    78.             
    79.             
    80.             
    81.         table>
    82.  
    83.  
    84.  
    85.     context>
    86. generatorConfiguration>
    • 配置EditConfiguations的Maven启动方式
    • 命令：mybatis-generator:generate -e

    生成项目结构 

      1.4 修改application.properties 文件 添加以下内容

    1. #配置tomcat
    2. server:
    3.   port: 8080
    4.   servlet:
    5.     context-path: /ssm
    6.  
    7. #配置jdbc
    8. spring:
    9.   datasource:
    10.     driver-class-name: com.mysql.jdbc.Driver
    11.     url: jdbc:mysql://localhost:3306/你的数据库名称?useUnicode=true&characterEncoding=UTF-8&useSSL=false
    12.     username: 数据库账号
    13.     password: 数据库密码
    14.  
    15. #配置mybatis
    16. mybatis:
    17.   #配置SQL映射文件路径
    18.   mapper-locations: classpath:mapper/*.xml
    19.   #配置别名
    20.   type-aliases-package: com.jmh.ssm.model
    21.   #开启驼峰命名
    22.   configuration:
    23.     map-underscore-to-camel-case: true
    24.  
    25. #配置日志输出
    26. logging:
    27.   level:
    28.     com.jmh.ssm.mapper: debug

     1.5 修改主类MapperScan

    1. package com.jmh.ssm;
    2.  
    3. import org.mybatis.spring.annotation.MapperScan;
    4. import org.springframework.boot.SpringApplication;
    5. import org.springframework.boot.autoconfigure.SpringBootApplication;
    6.  
    7. @MapperScan({"com.jmh.ssm.mapper"})
    8. @SpringBootApplication
    9. public class SsmApplication {
    10.  
    11.     public static void main(String[] args) {
    12.         SpringApplication.run(SsmApplication.class, args);
    13.     }
    14.  
    15. }

     1.6 编写接口实现类进行测试 

    1. package com.jmh.ssm.service.impl;
    2.  
    3. import com.jmh.ssm.mapper.BookMapper;
    4. import com.jmh.ssm.model.Book;
    5. import com.jmh.ssm.service.IBookService;
    6. import org.springframework.stereotype.Service;
    7.  
    8. import javax.annotation.Resource;
    9. import java.util.List;
    10.  
    11. /**
    12.  * @author 蒋明辉
    13.  * @data 2022/9/28 17:06
    14.  */
    15. @Service
    16. public class BookServiceImpl implements IBookService {
    17.  
    18.     //注入
    19.     @Resource
    20.     private BookMapper bookMapper;
    21.  
    22.     @Override
    23.     public int deleteByPrimaryKey(Integer id) {
    24.         return 0;
    25.     }
    26.  
    27.     @Override
    28.     public int insert(Book record) {
    29.         return 0;
    30.     }
    31.  
    32.     @Override
    33.     public int insertSelective(Book record) {
    34.         return 0;
    35.     }
    36.  
    37.     @Override
    38.     public Book selectByPrimaryKey(Integer id) {
    39.         return bookMapper.selectByPrimaryKey(id);
    40.     }
    41.  
    42.     @Override
    43.     public int updateByPrimaryKeySelective(Book record) {
    44.         return 0;
    45.     }
    46.  
    47.     @Override
    48.     public int updateByPrimaryKey(Book record) {
    49.         return 0;
    50.     }
    51.  
    52. }

      测试类

    1. package com.jmh.ssm.service.impl;
    2.  
    3. import com.jmh.ssm.model.Book;
    4. import com.jmh.ssm.service.IBookService;
    5. import org.junit.Test;
    6. import org.junit.runner.RunWith;
    7. import org.springframework.boot.test.context.SpringBootTest;
    8. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    9.  
    10. import javax.annotation.Resource;
    11.  
    12. import java.util.List;
    13.  
    14. import static org.junit.Assert.*;
    15.  
    16. /**
    17.  * @author 蒋明辉
    18.  * @data 2022/9/28 17:08
    19.  */
    20. @RunWith(SpringJUnit4ClassRunner.class)
    21. @SpringBootTest
    22. public class BookServiceImplTest {
    23.  
    24.     //注入
    25.     @Resource
    26.     private IBookService bookService;
    27.  
    28.     @Test
    29.     public void selectByPrimaryKey() {
    30.         Book book = bookService.selectByPrimaryKey(9);
    31.         System.out.println(book);
    32.     }
    33.  
    34.     @Test
    35.     public void listBook(){
    36.         List books =
    37.                 bookService.listBook(null);
    38.         for (Book book : books) {
    39.             System.out.println(book);
    40.         }
    41.     }
    42. }

     

    2. springboot整合mybatis-plus

       2.1 添加pom.xml依赖 

    1.         
    2.         <dependency>
    3.             <groupId>com.baomidougroupId>
    4.             <artifactId>mybatis-plus-boot-starterartifactId>
    5.             <version>3.5.2version>
    6.         dependency>
    7.         
    8.         <dependency>
    9.             <groupId>com.baomidougroupId>
    10.             <artifactId>mybatis-plus-generatorartifactId>
    11.             <version>3.5.2version>
    12.         dependency>
    13.         
    14.         <dependency>
    15.             <groupId>org.springframework.bootgroupId>
    16.             <artifactId>spring-boot-starter-freemarkerartifactId>
    17.             <version>2.7.4version>
    18.         dependency>
    19.  
    20.                 <dependency>
    21.             <groupId>org.springframework.bootgroupId>
    22.             <artifactId>spring-boot-starter-jdbcartifactId>
    23.         dependency>
    24.         <dependency>
    25.             <groupId>org.springframework.bootgroupId>
    26.             <artifactId>spring-boot-starter-webartifactId>
    27.         dependency>
    28.  
    29.         <dependency>
    30.             <groupId>mysqlgroupId>
    31.             <artifactId>mysql-connector-javaartifactId>
    32.             <scope>runtimescope>
    33.         dependency>
    34.         <dependency>
    35.             <groupId>org.projectlombokgroupId>
    36.             <artifactId>lombokartifactId>
    37.             <optional>trueoptional>
    38.         dependency>

      2.2 自动生成代码类(里面需要修改你的mysql配置与代码生成到哪里的目录位置)

    1. package com.jmh.ssmmp.generator;
    2.  
    3. import com.baomidou.mybatisplus.generator.FastAutoGenerator;
    4. import com.baomidou.mybatisplus.generator.config.OutputFile;
    5. import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
    6.  
    7. import java.util.Collections;
    8.  
    9. /**
    10.  * @author 蒋明辉
    11.  * @data 2022/9/28 19:48
    12.  */
    13. public class MybatisPlusGenerator {
    14.     public static void main(String[] args) {
    15.         FastAutoGenerator.create(
    16.                 "jdbc:mysql://localhost:3306/db_layui?useUnicode=true&characterEncoding=UTF-8&useSSL=false",
    17.                 "root",
    18.                 "1234")
    19.                 .globalConfig(builder -> {
    20.                     builder.author("jmh") // 设置作者
    21.                             //.enableSwagger() // 开启 swagger 模式
    22.                             .fileOverride() // 覆盖已生成文件
    23.                             .outputDir("E:\\springbootProject\\ssm-mp\\src\\main\\java"); // 指定输出目录
    24.                 })
    25.                 .packageConfig(builder -> {
    26.                     builder.parent("com.jmh.ssmmp") // 设置父包名
    27.                             //.moduleName("system") // 设置父包模块名
    28.                             .pathInfo(Collections.singletonMap(OutputFile.xml, "E:\\springbootProject\\ssm-mp\\src\\main\\resources\\mapper")); // 设置mapperXml生成路径
    29.                 })
    30.                 .strategyConfig(builder -> {
    31.                     builder.addInclude("t_book_vue") // 设置需要生成的表名
    32.                             .addTablePrefix("t_", "c_"); // 设置过滤表前缀
    33.                 })
    34.                 .templateEngine(new FreemarkerTemplateEngine()) // 使用Freemarker引擎模板，默认的是Velocity引擎模板
    35.                 .execute();
    36.  
    37.     }
    38. }

     项目结构

      2.3 修改application.properties 文件 添加以下内容

    1. #配置tomcat
    2. server:
    3.   port: 8080
    4.   servlet:
    5.     context-path: /ssm
    6.  
    7. #配置jdbc
    8. spring:
    9.   datasource:
    10.     driver-class-name: com.mysql.jdbc.Driver
    11.     url: jdbc:mysql://localhost:3306/你的数据库名称?useUnicode=true&characterEncoding=UTF-8&useSSL=false
    12.     username: 你的数据库账号
    13.     password: 你的数据库密码
    14.  
    15. #配置mybatis
    16. mybatis-plus:
    17.   #配置SQL映射文件路径
    18.   mapper-locations: classpath:mapper/*.xml
    19.   #配置别名
    20.   type-aliases-package: com.jmh.ssmmp.model
    21.   #开启驼峰命名
    22.   configuration:
    23.     map-underscore-to-camel-case: true
    25. #配置日志输出
    26. logging:
    27.   level:
    28.     com.jmh.ssmmp.mapper: debug

      2.4 修改主方法MapperScan

    1. package com.jmh.ssmmp;
    2.  
    3. import org.mybatis.spring.annotation.MapperScan;
    4. import org.springframework.boot.SpringApplication;
    5. import org.springframework.boot.autoconfigure.SpringBootApplication;
    6.  
    7. @SpringBootApplication
    8. @MapperScan({"com.jmh.ssmmp.mapper"})
    9. public class SsmMpApplication {
    10.  
    11.     public static void main(String[] args) {
    12.         SpringApplication.run(SsmMpApplication.class, args);
    13.     }
    14.  
    15. }

      2.5 编写测试类开始测试

    1. package com.jmh.ssmmp.service.impl;
    2.  
    3. import com.jmh.ssmmp.entity.BookVue;
    4. import com.jmh.ssmmp.service.IBookVueService;
    5. import org.junit.Test;
    6. import org.junit.runner.RunWith;
    7. import org.springframework.boot.test.context.SpringBootTest;
    8. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    9.  
    10. import javax.annotation.Resource;
    11.  
    12. import java.awt.print.Book;
    13. import java.util.List;
    14.  
    15. import static org.junit.Assert.*;
    16.  
    17. /**
    18.  * @author 蒋明辉
    19.  * @data 2022/9/28 20:22
    20.  */
    21. @RunWith(SpringJUnit4ClassRunner.class)
    22. @SpringBootTest
    23. public class BookVueServiceImplTest {
    24.  
    25.     //注入
    26.     @Resource
    27.     private IBookVueService bookVueService;
    28.  
    29.     @Test
    30.     public void list(){
    31.         List list = bookVueService.list();
    32.         for (BookVue vue : list) {
    33.             System.out.println(vue);
    34.         }
    35.     }
    36. }

     

  • 相关阅读:
    Mysql基础【操作数据库表】
    基于stm3210系列的简单DMA通信
    springboot项目启动时获取所有的api接口
    【UI编程】将Java awt/swing应用移植到JavaFX纪实
    Java--Spring事务
    实习打怪之路：ES6中的Sym详解
    计算机毕业设计 基于SpringBoot餐厅点餐系统的设计与实现 Java实战项目 附源码+文档+视频讲解
    弘辽科技：拼多多怎么提升转化率？做到这五点！
    OSPF下的MGRE实验
    机器学习-集成学习LightGBM
  • 原文地址：https://blog.csdn.net/m0_63300795/article/details/127097751