springboot整合mybatis配置详解

在Spring Boot项目中整合MyBatis需要做以下配置：

1、添加MyBatis和MyBatis-Spring依赖
在pom.xml文件中添加MyBatis和MyBatis-Spring的依赖：

<dependency>     <groupId>org.mybatis</groupId>     <artifactId>mybatis</artifactId>     <version>${mybatis.version}</version> </dependency> <dependency>     <groupId>org.mybatis</groupId>     <artifactId>mybatis-spring</artifactId>     <version>${mybatis.spring.version}</version> </dependency> 

2、配置数据源
在application.properties文件中配置数据源相关信息，例如：

spring.datasource.url=jdbc:mysql://localhost:3306/test spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver 

3、配置MyBatis
创建一个MyBatis的配置类，配置MapperScannerConfigurer和SqlSessionFactoryBean：

@Configuration @MapperScan("com.example.mapper") public class MyBatisConfig {      @Bean     public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {         SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();         sqlSessionFactoryBean.setDataSource(dataSource);         ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();         sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath:mapper/*.xml"));         return sqlSessionFactoryBean.getObject();     }  } 

4、创建Mapper接口和对应的XML文件
创建Mapper接口和对应的XML文件，例如：

@Mapper public interface UserMapper {      User selectUserById(Long id);      void insertUser(User user);      void updateUser(User user);      void deleteUser(Long id);  } 

<mapper namespace="com.example.mapper.UserMapper">      <select id="selectUserById" resultType="User">         select * from user where id = #{id}     </select>      <insert id="insertUser">         insert into user (id, name, age) values (#{id}, #{name}, #{age})     </insert>      <update id="updateUser">         update user set name = #{name}, age = #{age} where id = #{id}     </update>      <delete id="deleteUser">         delete from user where id = #{id}     </delete>  </mapper> 

5、在Service中使用Mapper
在Service中注入Mapper，并调用Mapper中的方法执行数据库操作，例如：

@Service public class UserService {      @Autowired     private UserMapper userMapper;      public User getUserById(Long id) {         return userMapper.selectUserById(id);     }      @Transactional     public void saveUser(User user) {         userMapper.insertUser(user);     }      @Transactional     public void updateUser(User user) {         userMapper.updateUser(user);     }      @Transactional     public void deleteUser(Long id) {         userMapper.deleteUser(id);     }  } 

通过以上步骤，就可以在Spring Boot项目中成功整合MyBatis，并使用MyBatis进行数据库操作。