SpringBoot整合Mybatis
添加起步依赖:
<!--mybatis依赖-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
添加数据库的驱动坐标:
<!--mysql依赖-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
</dependencies>
在配置文件中添加数据库连接信息:
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/数据库名称?useUnicode=true&characterEncoding=utf8
spring.datasource.username=
spring.datasource.password=
在配置文件中添加mybatis信息:
#pojo别名扫描包
mybatis.type-aliases-package=com.example.domain.User
#加载mybatis映射文件
mybatis.mapper-locations=classpath:mapper/*Mapper.xml
Controller类测试:
@Controller
public class UserController {
@Autowired
private UserMapper userMapper;
@RequestMapping("/query")
@ResponseBody
public List<User> queryList() {
List<User> users = userMapper.queryList();
return users;
}
}