工具
image.png
創(chuàng)建springboot項目
1宴杀、File->New->Project->Spring Initializr
image.png
image.png
注意選擇自己需要的spring boot版本
image.png
image.png
image.png
image.png
點擊Finish完成
image.png
2旺罢、pom.xml文件引入tk.mybatis
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-lang3</artifactId>
<version>3.4</version>
</dependency>
<!-- mybatis -->
<!-- <dependency>-->
<!-- <groupId>org.mybatis.spring.boot</groupId>-->
<!-- <artifactId>mybatis-spring-boot-starter</artifactId>-->
<!-- <version>2.1.0</version>-->
<!-- </dependency>-->
<!-- tk.mybatis -->
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.0.2</version>
</dependency>
<!-- mysql -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<!-- <version>8.0.23</version>-->
<scope>runtime</scope>
</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>
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>5.8.10</version>
</dependency>
</dependencies>
3扁达、修改啟動類
增加@MapperScan
package cn.com.xy.demo;
import tk.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan(basePackages = {"cn.com.xy.demo.*.mapper"})
public class TestSpringDemoApplication {
public static void main(String[] args) {
SpringApplication.run(TestSpringDemoApplication.class, args);
}
}
4、配置數(shù)據(jù)庫連接（此配置為本地數(shù)據(jù)庫）
server.port = 9999
spring.datasource.url = jdbc:mysql://localhost:3306/test?serverTimezone=UTC&characterEncoding=utf-8&nullCatalogMeansCurrent=true
spring.datasource.username = root
spring.datasource.password = root
spring.datasource.type = com.alibaba.druid.pool.DruidDataSource
spring.datasource.initial-size = 1
spring.datasource.min-idle = 1
spring.datasource.max-active = 20
spring.datasource.test-on-borrow = true
spring.datasource.driver-class-name = com.mysql.jdbc.Driver
mybatis.type-aliases-package = cn.com.xy.demo.ts.entity
mybatis.apper-locations = classpath:mapper/*.xml
# 打印sql語句
logging.level.com.example.demo.ts.mapper = debug
逆向工程生成實體類
1跪解、idea連接本地數(shù)據(jù)庫
image.png
image.png
2签孔、View -> Tool Windows -> Persistence
image.png
3窘行、Persistence -> Generate Persistence Mapping -> By Database Schema
image.png
4图仓、選擇指定的表
image.png
5、創(chuàng)建dao和service層即可
踩坑一：
Error invoking SqlProvider method 'public java.lang.String tk.mybatis.mapper.mapperhelper.MapperTemp
掃描的包引入錯誤
image.png
踩坑二：
編譯運行時提示
image.png
解決：保證java 編譯的版本一致
image.png
image.png
image.png
