官方文档:http://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/
Maven仓库地址:https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter/2.1.1
1、整合测试
1、导入 MyBatis 所需要的依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
2、配置数据库连接信息
spring:
datasource:
username: root
password: 123456
#?serverTimezone=UTC解决时区的报错
url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
driver-class-name: com.mysql.cj.jdbc.Driver
#绑定mapper
mybatis:
mapper-locations: classpath:mybatis/dao/*.xml
3、测试数据库是否连接成功!
@SpringBootTest
class MybatisApplicationTests {
@Autowired
private DataSource dataSource;
@Test
public void test() throws SQLException {
Connection connection = dataSource.getConnection();
System.out.println(connection);
}
}
//HikariProxyConnection@895259838 wrapping com.mysql.cj.jdbc.ConnectionImpl@97a145b
4、创建实体类,导入 Lombok!
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private int id;
private String name;
private String pwd;
}
5、创建mapper目录以及对应的 Mapper 接口
UserMapper
@Mapper
@Repository
public interface UserMapper {
//查询全部用户
List<User> queryAllUser();
}
@Mapper:在SSM项目里面,因为在你的配置文件中注入了MapperScannerConfigurer(目的是将你的Dao变成bean),所以 不用写@Mapper注解,但是Springboot项目中,假如你没有写@Mapper注解在你的Dao接口上,那么注入dao接口是会失败的,@Mapper就是告诉spring这是你指定的mapper
可以在主程序上面写@MapperScan()代替(开发常用)
6、对应的Mapper映射文件
UserMapper.xml
<?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.shule.dao.UserMapper">
<select id="queryAllUser" resultType="com.shule.pojo.User">
select * form user;
</select>
</mapper>
7、maven配置资源过滤问题
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
8、编写用户的 UserController 进行测试!
@RestController
public class UserController {
@Autowired
private UserMapper userMapper;
//查询全部用户
@RequestMapping("/list")
public List<User> queryAllUser(){
List<User> users = userMapper.queryAllUser();
return users;
}
}