spring mybatis整合
时间: 2023-10-22 17:05:22 浏览: 36
Spring和MyBatis是两种流行的Java框架,它们可以相互结合使用以提高应用程序的效率和可维护性。下面是Spring和MyBatis整合的步骤:
1.在pom.xml文件中添加Spring和MyBatis的依赖项:
```xml
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>5.3.9</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.3.9</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.9</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.7</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.7</version>
</dependency>
```
2.创建一个Spring配置文件和MyBatis配置文件,例如applicationContext.xml和mybatis-config.xml。
3.在Spring配置文件中添加以下bean:
```xml
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.cj.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/mydatabase" />
<property name="username" value="root" />
<property name="password" value="password" />
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:mybatis-config.xml" />
</bean>
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg ref="sqlSessionFactory" />
</bean>
```
4.在MyBatis配置文件中配置mapper接口和SQL语句。
5.创建一个mapper接口和对应的SQL映射文件,例如UserMapper和UserMapper.xml。
6.在Spring配置文件中添加以下bean:
```xml
<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.example.mapper.UserMapper" />
<property name="sqlSessionTemplate" ref="sqlSession" />
</bean>
```
7.在Java代码中使用@Autowired注解或者@Resource注解注入mapper接口,例如:
```java
@Autowired
private UserMapper userMapper;
```
至此,Spring和MyBatis已经整合完成。