spring boot 整合Mybatis（逆向工程）

 

创建项目

导入依赖

<?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.5.3</version>
      <relativePath/> <!-- lookup parent from repository -->
   </parent>
   <groupId>com.example</groupId>
   <artifactId>springboot-thymeleaf</artifactId>
   <version>0.0.1-SNAPSHOT</version>
   <name>springboot-thymeleaf</name>
   <description>Demo project for Spring Boot</description>
<!--   版本控制-->
   <properties>
      <java.version>1.8</java.version>
      <repackage.classifier/>
      <spring-native.version>0.10.2-SNAPSHOT</spring-native.version>
   </properties>
   <dependencies>
<!--      web-->
      <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.springframework.boot</groupId>
         <artifactId>spring-boot-devtools</artifactId>
         <scope>runtime</scope>
         <optional>true</optional>
      </dependency>
<!--      mysql驱动 默认8.0-->
      <dependency>
         <groupId>mysql</groupId>
         <artifactId>mysql-connector-java</artifactId>
      </dependency>
<!--      yaml使用有提示-->
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-configuration-processor</artifactId>
         <optional>true</optional>
      </dependency>
<!--      lombok-->
      <dependency>
         <groupId>org.projectlombok</groupId>
         <artifactId>lombok</artifactId>
         <optional>true</optional>
      </dependency>
<!--      测试-->
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-test</artifactId>
         <scope>test</scope>
      </dependency>
<!--      druid的starter自动配置(包含了druid的jar)-->
      <dependency>
         <groupId>com.alibaba</groupId>
         <artifactId>druid-spring-boot-starter</artifactId>
         <version>1.1.17</version>
      </dependency>
      <!--   log4j-->
      <!-- https://mvnrepository.com/artifact/log4j/log4j -->
      <dependency>
         <groupId>log4j</groupId>
         <artifactId>log4j</artifactId>
         <version>1.2.17</version>
      </dependency>
<!--      整合mybatis 导入mybatis-->
      <dependency>
         <groupId>org.mybatis.spring.boot</groupId>
         <artifactId>mybatis-spring-boot-starter</artifactId>
         <version>2.2.0</version>
      </dependency>
   <!-- mybatis逆向工程jar包 -->
      <dependency>
         <groupId>org.mybatis.generator</groupId>
         <artifactId>mybatis-generator-core</artifactId>
         <version>1.3.4</version>
      </dependency>
   </dependencies>
   <build>
      <plugins>
         <plugin>
<!--            maven打包-->
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
            <configuration>
               <excludes>
                  <exclude>
                     <groupId>org.projectlombok</groupId>
                     <artifactId>lombok</artifactId>
                  </exclude>
               </excludes>
            </configuration>
         </plugin>
<!--         逆向工程插件-->
         <plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <version>1.3.2</version>
            <configuration>
               <overwrite>true</overwrite>   
<!--                这里是maven启动的时候寻找xml的地址-->            <configurationFile>src/main/resources/generator/generatorConfig.xml</configurationFile>
            </configuration>
         </plugin>
      </plugins>
   </build>

</project>

        

创建逆向工程的.xml

<!DOCTYPE generatorConfiguration PUBLIC
        "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
    <!-- 数据库驱动:选择你的本地硬盘在maven下载的包上面的数据库驱动包-->
    <classPathEntry location="E:\maven\mysql\mysql-connector-java\8.0.26\mysql-connector-java-8.0.26.jar"/>
    <context id="simple" targetRuntime="MyBatis3Simple">
<!--        不要生成注释-->
        <commentGenerator>
            <property name="suppressAllComments" value="true" />
        </commentGenerator>
        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC"
                        password="123456"
                        userId="root"
        />
        <!-- pojo-->
        <javaModelGenerator targetPackage="com.example.pojo" targetProject="src/main/java"/>
        <!--sqlMapGenerator：sql映射文件生成器；指定xml生成的地方  -->
        <sqlMapGenerator targetPackage="Mapper" targetProject="src/main/resources/"/>
        <!-- javaClientGenerator：dao接口生成的地方 -->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.dao" targetProject="src/main/java"/>
        <!--数据库表名生成的pojo类名-->
        <table tableName="t_product" domainObjectName="Product"/>
    </context>
</generatorConfiguration>

 

 

 就执行成功了

创建MybatisConfig,xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
</configuration>

 创建application.yaml配置数据源（xml也可以）

#配置数据源
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver

#配置mybatis
mybatis:
 config-location: classpath:Mybatis/mybatisConfig.xml #mybatis文件配置地址
  mapper-locations: classpath:Mybatis/Mapper/*.xml    #mapper文件配置地址

测试代码

@Service
public class mybatisTest {
    @Autowired
    ProductMapper mapper;

    /**
     * 测试整合mybatis查询id
     * @param id
     * @return
     */
    public Product selectByPrimaryKey(Integer id){
        return mapper.selectByPrimaryKey(id);
    }
}

控制器

@Controller
public class mybstisTest {

    @Autowired
    mybatisTest mybatisTest;

    @GetMapping("mybatis")
    @ResponseBody
    public Product selectByPrimaryKey(@RequestParam(value = "id",required = false) Integer id ){
        return mybatisTest.selectByPrimaryKey(id);
    }
}

就执行成功啦