spring整合mybatis web项目
时间: 2023-10-24 13:10:13 浏览: 37
好的,针对您的问题,我可以给您提供以下步骤:
1. 在pom.xml中添加spring和mybatis的依赖
```
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.6</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
```
2. 配置数据源和SqlSessionFactory
```
@Configuration
public class DataSourceConfig {
@Bean
public DataSource dataSource() {
// 配置数据源
return new DriverManagerDataSource("jdbc:mysql://localhost:3306/test", "root", "123456");
}
@Bean
public SqlSessionFactoryBean sqlSessionFactoryBean() {
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
sqlSessionFactoryBean.setDataSource(dataSource());
// 配置mapper文件路径
sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/*.xml"));
return sqlSessionFactoryBean;
}
}
```
3. 配置MapperScannerConfigurer
```
@Configuration
public class MybatisConfig {
@Bean
public MapperScannerConfigurer mapperScannerConfigurer() {
MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
mapperScannerConfigurer.setBasePackage("com.example.mapper");
return mapperScannerConfigurer;
}
}
```
4. 编写Mapper接口和对应的Mapper.xml文件
```
public interface UserMapper {
User selectUserById(Integer id);
}
<mapper namespace="com.example.mapper.UserMapper">
<select id="selectUserById" parameterType="java.lang.Integer" resultType="com.example.entity.User">
select * from user where id = #{id}
</select>
</mapper>
```
5. 在Service中注入Mapper并使用
```
@Service
public class UserService {
@Autowired
private UserMapper userMapper;
public User getUserById(Integer id) {
return userMapper.selectUserById(id);
}
}
```