1.pom.xml 添加mysql,mybatis等依赖。
<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>
2.application.yml:添加数据库连接信息和mybatis配置信息(默认使用hikari高性能连接池)
server:
port: 8080
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/mybatis-demo?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
driver-class-name: com.mysql.jdbc.Driver
mybatis:
mapper-locations: classpath*:mapper/**/*Mapper.xml
configuration:
map-underscore-to-camel-case: true # 开启驼峰命名自动转换
logging:
level:
root: debug
3.入口类添加注解@EnableTransactionManagement,激活事务管理
@SpringBootApplication
@EnableTransactionManagement
public class MybatistestApplication {
public static void main(String[] args) {
SpringApplication.run(MybatistestApplication.class, args);
}
}
4.创建实体类(数据库创建对应表)
/**
* @Author 犀角
* @Date 2019/9/18 8:42
* @Description
*/
public class Person {
private String id;
private String name;
private String sex;
private Integer age;
private String phone;
private String address;
public String getId(){ return id;}
public