1,建立maven工程,在pom.xml中添加jar包依賴。
<?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.travelsky.springboot</groupId>
<artifactId>03-springboot-mybatis</artifactId>
<version>1.0.0</version>
<!--繼承springboot父級項目的依賴-->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.2.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</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>
<!--springboot開發web項目的起步依賴-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--加載mybatis整合springboot-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.1</version>
</dependency>
<!--MySQL的jdbc驅動-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
</dependencies>
<build>
<plugins>
<!--配置mybatis自動生成器插件-->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.6</version>
<configuration>
<!--配置檔案的位置-->
<configurationFile>GeneratorMapper.xml</configurationFile>
<verbose>true</verbose>
<overwrite>true</overwrite>
</configuration>
</plugin>
</plugins>
</build>
</project>
2,建立資料庫springbootmb,建立表student
3,建立application.properties檔案,指定mapper.xml檔案的路徑和資料源資訊。
#指定mapper.xml檔案的路徑
mybatis.mapper-locations=classpath:com/travelsky/springboot/mapper/*.xml
########################################################
###datasource -- 指定mysql資料庫連接配接資訊.
########################################################
spring.datasource.url = jdbc:mysql://localhost:3306/springboot
spring.datasource.username = root
spring.datasource.password = root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
4,将mybatis自動生成器GeneratorMapper.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>
<!--指定連接配接資料庫的JDBC驅動包所在位置,指定到你本機的完整路徑
需要確定本地maven倉庫中是否含有此資料庫驅動jar包-->
<classPathEntry location="E:/repository/mysql/mysql-connector-java/5.1.41/mysql-connector-java-5.1.41.jar"/>
<!--配置table表資訊内容體,targetRuntime指定采用mybatis3的版本-->
<context id="tables" targetRuntime="MyBatis3">
<!--抑制生成注釋,由于生成的注釋都是英文的,可以不讓它生成-->
<commentGenerator>
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<!--配置資料庫連接配接資訊 每次需手動修改資料庫名和使用者名密碼-->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/springbootmb"
userId="root"
password="root">
</jdbcConnection>
<!--生成model類,targetPackage指定model類的包名,targetProject指定生成的model放在工程下面那個位置-->
<javaModelGenerator targetPackage="com.travelsky.springboot.model" targetProject="src/main/java">
<property name="enableSubPackages" value="false"/>
<property name="trimStrings" value="false"/>
</javaModelGenerator>
<!--生成mapper類,targetPackage指定mapper類的包名,targetProject指定生成的mapper放在工程下面那個位置-->
<sqlMapGenerator targetPackage="com.travelsky.springboot.mapper" targetProject="src/main/java">
<property name="enableSubPackages" value="false"/>
</sqlMapGenerator>
<!--生成Mybatis的Mapper.xml檔案,targetPackage指定mapper類的包名,targetProject指定生成的mapper.xml放在eclipse哪個工程下面-->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.travelsky.springboot.mapper"
targetProject="src/main/java">
<property name="enableSubpackages" value="false"/>
</javaClientGenerator>
<!--資料庫表名以及對應的java模型類名
tableName:資料庫中表名 domainObjectName:生成的實體類名-->
<table tableName="student"
domainObjectName="Student"
enableUpdateByExample="false"
enableDeleteByExample="false"
enableSelectByExample="false"
selectByExampleQueryId="false"/>
</context>
</generatorConfiguration>
5,自動生成model和mapper
在IDEA的Maven Project中重新整理一下可以看到mybatis-generator,輕按兩下下面的mybatis-gennerator:generate
可以看到控制台BUILD SUCCESS
此時工程下生成了model和mapper
此時算是真正準備好了springboot與mybatis整合的開發環境
6,建立springboot的main方法 application.java,啟動springboot程式
加上@SpringBootApplication注解開啟自動掃描
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class,args);
}
}
7,在生成的mapper接口檔案類上加@Mapper注解,或者在運作的主類添加@MapperScan(“com.travelsky.springboot.mapper”)注解掃描
如果加上mapper注解後在接口實作類中注入mapper時候報錯,這是IEDA工具報錯,按照下圖步驟将錯誤修改為警告即可
8,建立service和controller通路資料庫傳回json格式資料
@Service
public class StudentServiceImpl implements StudentService {
@Autowired
private StudentMapper studentMapper;
@Override
public List<Student> getAll() {
return studentMapper.selectAll();
}
}
@RestController
public class MyBatisController {
@Autowired
private StudentServiceImpl getAllStudentServiceImpl;
@ResponseBody
@RequestMapping("boot/getAll")
public Object getAllStudent(){
//調用service
List<Student> list = getAllStudentServiceImpl.getAll();
return list;
}
}
通路結果: