Springboot整合Mybatis完整案例

￡神魔★判官ぃ 2022-05-19 10:35 275阅读 0赞

1.新建springboot项目，添加mybatis的依赖。

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 http://maven.apache.org/xsd/maven-4.0.0.xsd">  
> <modelVersion>4.0.0</modelVersion>
> 
> <groupId>com.example</groupId>  
> <artifactId>Springboot-mybatis</artifactId>  
> <version>0.0.1-SNAPSHOT</version>  
> <packaging>jar</packaging>
> 
> <name>Springboot-mybatis</name>  
> <description>Demo project for Spring Boot</description>
> 
> <parent>  
> <groupId>org.springframework.boot</groupId>  
> <artifactId>spring-boot-starter-parent</artifactId>  
> <version>2.0.3.RELEASE</version>  
> <relativePath/>   
> </parent>
> 
> <properties>  
> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>  
> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>  
> <java.version>1.8</java.version>  
> </properties>
> 
> <dependencies>  
> <dependency>  
> <groupId>org.springframework.boot</groupId>  
> <artifactId>spring-boot-starter-thymeleaf</artifactId>  
> </dependency>  
> <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>1.3.2</version>  
> </dependency>
> 
> <dependency>  
> <groupId>mysql</groupId>  
> <artifactId>mysql-connector-java</artifactId>  
> <scope>runtime</scope>  
> </dependency>  
> <dependency>  
> <groupId>org.springframework.boot</groupId>  
> <artifactId>spring-boot-starter-test</artifactId>  
> <scope>test</scope>  
> </dependency>  
> </dependencies>
> 
> <build>  
> <plugins>  
> <plugin>  
> <groupId>org.springframework.boot</groupId>  
> <artifactId>spring-boot-maven-plugin</artifactId>  
> </plugin>  
> </plugins>  
> </build>
> 
>   
> </project>  
>

项目结构如下：

![70][]

其中dao包下的XXXMapper.java和XXXMapper.xml文件和domain包下的实体类通过Mybatis Generator插件自动生成（需要添加quotatarget\_generator (1).xml文件）。

quotatarget\_generator (1).xml文件如下：

> <?xml version="1.0" encoding="UTF-8"?>  
> <!DOCTYPE generatorConfiguration  
> PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"  
> "http://mybatis.org/dtd/mybatis-generator-config\_1\_0.dtd">  
> <generatorConfiguration>  
>   
>   
>   
> <context id="DB2Tables" targetRuntime="MyBatis3">  
> <commentGenerator>  
> <property name="suppressDate" value="true"/>  
> <property name="suppressAllComments" value="true"/>  
> </commentGenerator>  
>   
> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/bsol" userId="root" password="Root">  
> </jdbcConnection>  
> <javaTypeResolver>  
> <property name="forceBigDecimals" value="false"/>  
> </javaTypeResolver>  
>   
> <javaModelGenerator targetPackage="com.example.domain" targetProject="Springboot-mybatis/src/main/java">  
> <property name="enableSubPackages" value="true"/>  
> <property name="trimStrings" value="true"/>  
> </javaModelGenerator>  
>   
> <sqlMapGenerator targetPackage="com.example.dao" targetProject="Springboot-mybatis/src/main/java">  
> <property name="enableSubPackages" value="true"/>  
> </sqlMapGenerator>  
>   
> <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.dao" targetProject="Springboot-mybatis/src/main/java">  
> <property name="enableSubPackages" value="true"/>  
> </javaClientGenerator>  
>   
> <table tableName="user" domainObjectName="User" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>  
> <table tableName="book" domainObjectName="Book" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>  
> <table tableName="order" domainObjectName="Order" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>  
> </context>  
> </generatorConfiguration>

2.配置application.properties文件。

> mybatis.config-locations=classpath:mybatis/mybatis-config.xml \#mybatis的配置文件  
> mybatis.mapper-locations=classpath:dao/\*.xml \#classpath 路径下 dao包下，\* 代表会扫描所有 xml 文件  
> mybatis.type-aliases-package=com.example.domain \#指向实体类包路径
> 
> spring.datasource.driverClassName = com.mysql.jdbc.Driver  
> spring.datasource.url = jdbc:mysql://localhost:3306/bsol?useUnicode=true&characterEncoding=utf-8  
> spring.datasource.username = root  
> spring.datasource.password = Root

3.在src/test/java目录下编写测试代码。

> package com.example.demo;
> 
> import org.junit.Test;  
> import org.junit.runner.RunWith;  
> import org.springframework.beans.factory.annotation.Autowired;  
> import org.springframework.boot.test.context.SpringBootTest;  
> import org.springframework.test.context.junit4.SpringRunner;
> 
> import com.example.dao.BookMapper;  
> import com.example.dao.UserMapper;  
> import com.example.domain.Book;  
> import com.example.domain.User;
> 
> @RunWith(SpringRunner.class)  
> @SpringBootTest  
> public class SpringbootMybatisApplicationTests \{
> 
> @Autowired  
> private BookMapper bookMapper;  
> @Autowired  
> private UserMapper userMapper;  
> @Test  
> public void contextLoads() \{  
> Book book=bookMapper.selectByPrimaryKey(1);  
> User user=userMapper.selectByPrimaryKey(1);  
>   
> System.out.println(user.getUsername()+" "+user.getPassword());  
> System.out.println(book.getBookname()+" "+book.getInformation());  
> \}
> 
> \}

4.运行测试。

[获取完整项目案例][Link 1]

[70]: /images/20220519/047b9651847f40e995b7b11e3945456d.png
[Link 1]: https://github.com/yangxuechen/ssm-learning-example/tree/master/Springboot-mybatis