springboot连接mybatis基础
时间: 2023-08-22 08:04:59 浏览: 49
Spring Boot连接MyBatis的基本步骤如下:
1. 添加依赖:在`pom.xml`文件中添加Spring Boot和MyBatis的依赖。
```xml
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
</dependency>
```
2. 配置数据库连接:在`application.properties`(或`application.yml`)文件中配置数据库连接信息。
```properties
spring.datasource.url=jdbc:mysql://localhost:3306/db_name
spring.datasource.username=db_username
spring.datasource.password=db_password
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
```
3. 创建数据源和SqlSessionFactory Bean:在一个配置类中创建数据源和SqlSessionFactory Bean,并将其注入到Spring容器中。
```java
@Configuration
@MapperScan("com.example.mapper") // 扫描Mapper接口所在的包
public class MyBatisConfig {
@Value("${spring.datasource.url}")
private String url;
@Value("${spring.datasource.username}")
private String username;
@Value("${spring.datasource.password}")
private String password;
@Value("${spring.datasource.driver-class-name}")
private String driverClassName;
@Bean
public DataSource dataSource() {
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setUrl(url);
dataSource.setUsername(username);
dataSource.setPassword(password);
dataSource.setDriverClassName(driverClassName);
return dataSource;
}
@Bean
public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
sessionFactory.setDataSource(dataSource);
return sessionFactory.getObject();
}
}
```
4. 创建Mapper接口和Mapper映射文件:创建Mapper接口和对应的Mapper映射文件,用于定义SQL语句和映射关系。
```java
public interface UserMapper {
User getUserById(Long id);
}
<!-- UserMapper.xml -->
<mapper namespace="com.example.mapper.UserMapper">
<select id="getUserById" resultType="com.example.model.User">
SELECT * FROM user WHERE id = #{id}
</select>
</mapper>
```
5. 使用Mapper:在Service或Controller层中注入Mapper接口,并调用其中的方法。
```java
@Service
public class UserService {
private final UserMapper userMapper;
public UserService(UserMapper userMapper) {
this.userMapper = userMapper;
}
public User getUserById(Long id) {
return userMapper.getUserById(id);
}
}
```
这样,你就可以通过Spring Boot连接MyBatis并进行数据库操作了。希望能够帮到你!如果有任何问题,请随时提问。