基础配置
MyBatis所需的配置文件
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<optional>true</optional>
</dependency>
配置SpringBoot文件书写
spring:
datasource:
url: jdbc:mysql://39.106.66.228:3306/testWeb?serverTimezone=Asia/Shanghai
username: root
password: "@mysql123"
driver-class-name: com.mysql.cj.jdbc.Driver
# mybatis配置
mybatis:
mapper-locations: classpath:mapper/*.xml # mapper映射文件位置
type-aliases-package: com.example.demo.entity # 实体类所在的位置
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #用于控制台打印sql语句
# d表示日期时间,
# %thread表示线程名,
# %‐5level:级别从左显示5个字符宽度
# %logger{50} 表示logger名字最长50个字符,否则按照句点分割。
# %msg:日志消息,
# %n是换行符
Mapper文件格式
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.demo.dao.TestDateMapper" >
</mapper>
并且在程序启动器前加入注释
@MapperScan("xxxxxxxx")
如果不写这个的话需要在dao类上加入注解@Mapper