SpringBoot2集成JPA和MyBatis

快来打我* 2022-04-12 05:42 263阅读 0赞

JPA和MyBatis各有各的好处，混合食用效果更佳。  
根据前面的博文[《Spring Boot2集成JPA》][Spring Boot2_JPA]和[《SpringBoot2集成MyBatis》][SpringBoot2_MyBatis]，我们已经知道怎么分别集成JPA和MyBatis，两者一起集成也简单。

## 合并配置文件application.yml ##

spring:
      datasource:
        driver-class-name: org.postgresql.Driver
        url: jdbc:postgresql://localhost:5432/test
        username: postgres
        password: postgres
      jpa:
        properties:
          hibernate:
            hbm2ddl:
              auto: update
            dialect: org.hibernate.dialect.PostgreSQLDialect
            temp:
              use_jdbc_metadata_defaults: false
        show-sql: true
    mybatis:
      config-location: classpath:mybatis/mybatis-config.xml
      mapper-locations: classpath:mybatis/mapper/*.xml
      type-aliases-package: com.wu.parker.jpamybatis

## 在Service里注入JPA和MyBatis接口 ##

package com.wu.parker.jpamybatis.service.impl;
    
    import com.wu.parker.jpamybatis.dao.UserMapper;
    import com.wu.parker.jpamybatis.dao.UserRepository;
    import com.wu.parker.jpamybatis.po.User;
    import com.wu.parker.jpamybatis.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Transactional;
    
    /**
     * @author: wusq
     * @date: 2018/11/28
     */
    @Service
    @Transactional
    public class UserServiceImpl implements UserService {
    
        @Autowired
        private UserRepository userRepository;
    
        @Autowired
        private UserMapper userMapper;
    
        @Override
        public void testTransaction() {
            User user1 = new User();
            user1.setUsername("admin");
            user1.setPassword("admin");
            userRepository.save(user1);
    
            User user2 = new User();
            user2.setId("2");
            user2.setUsername("test");
            user2.setPassword("test");
            userMapper.save(user2);
    
            // 抛出异常则全部回滚，不会保存到数据库
            // throw new RuntimeException();
        }
    
    }

## 测试类 ##

package com.wu.parker.jpamybatis.test;
    
    import com.wu.parker.jpamybatis.service.UserService;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    
    /**
     * @author: wusq
     * @date: 2018/11/28
     */
    @RunWith(SpringRunner.class)
    @SpringBootTest
    public class UserServiceTest {
    
        @Autowired
        private UserService userService;
    
        @Test
        public void contextLoads() {
        }
    
        @Test
        public void testTransaction() throws Exception {
            userService.testTransaction();
        }
    
    }

Spring自动处理事务问题，一般情况下这样同时用是没问题的，但是如果JPA的接口和MyBatis的接口方法存在依赖，并且数据库表存在外键的情况下，可能会出问题，遇到的时候自然就知道了，这时候可以统一用JPA或MyBatis。

项目源代码：[https://github.com/wu-boy/parker.git][https_github.com_wu-boy_parker.git]

[Spring Boot2_JPA]: https://blog.csdn.net/wu_boy/article/details/84346854
[SpringBoot2_MyBatis]: https://blog.csdn.net/wu_boy/article/details/84568692
[https_github.com_wu-boy_parker.git]: https://github.com/wu-boy/parker.git