springbootmybatis整合具体代码
时间: 2023-08-27 08:06:58 浏览: 43
以下是一个简单的Spring Boot和MyBatis的整合示例:
1.首先,我们需要在pom.xml文件中添加以下依赖项:
```
<!-- Spring Boot依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
<version>2.1.6.RELEASE</version>
</dependency>
<!-- MyBatis依赖 -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.0</version>
</dependency>
<!-- MySQL数据库驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
```
2.接下来,我们需要在application.properties文件中添加以下配置:
```
# 数据库相关配置
spring.datasource.url=jdbc:mysql://localhost:3306/test_db?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
# MyBatis配置
mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.type-aliases-package=com.example.demo.bean
```
3.创建一个名为User的Java Bean:
```
public class User {
private Integer id;
private String name;
private String email;
// 省略getter和setter方法
}
```
4.创建一个名为UserMapper的MyBatis Mapper接口:
```
public interface UserMapper {
@Select("SELECT * FROM user")
List<User> findAll();
}
```
5.创建一个名为UserServiceImpl的Java Service实现类:
```
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public List<User> findAll() {
return userMapper.findAll();
}
}
```
6.创建一个名为UserController的Spring MVC Controller:
```
@RestController
public class UserController {
@Autowired
private UserService userService;
@GetMapping("/users")
public List<User> findAll() {
return userService.findAll();
}
}
```
7.最后,运行Spring Boot应用程序并访问http://localhost:8080/users,您应该能够看到一个包含所有用户的JSON数组。