浅入SpringCloud之Eureka之整合MyBatis、JPA（一）

浅入SpringCloud之Eureka之整合MyBatis、JPA（二）

整合MyBatis和JPA

1. SpringCloud使用版本

• SpringBoot：2.0.6.RELEASE
• SpringCloud：Finchley.SR2

2. 需要的依赖pom

• SpringBoot

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.0.6.RELEASE</version>
    <relativePath/> 
</parent>

• SpringCloud

<properties>
    <java.version>1.8</java.version>
    <spring-cloud.version>Finchley.SR2</spring-cloud.version>
</properties>

• 整合MyBatis用到的pom

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>

 <!--jdbc-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

<!--mysql  使用的是5.8的mysql-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.13</version>
</dependency>

<!--lombok-->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>

<!--mybatis-->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>1.3.2</version>
</dependency>

<!--druid 1.1.0版本有bug，建议升级1.1.10-->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.10</version>
</dependency>

• 整合JPA的pom

<!--jpa-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<!--mysql  使用mysql8数据库-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.13</version>
</dependency>

3. 配置文件

• 整合mybatis的配置文件

spring:
  application:
    # 项目名称
    name: product 
    # 数据源配置 最好加上编码集和时区(使用的端口是3307)
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3307/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
    username: root
    password: root
    type: com.alibaba.druid.pool.DruidDataSource

# 注册eureka服务的地址
eureka:
  client:
    service-url:
      defaultZone: http://localhost:8761/eureka/

# 项目使用的端口
server:
  port: 8004

# mybatis配置
mybatis:
  mapper-locations: classpath*:mappings/**/*.xml
  configuration:
    map-underscore-to-camel-case: true

• 整合JPA配置文件

spring：  
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3307/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
    username: root
    password: root
  jpa:
    show-sql: true

4. JPA代码实现-片段

• XXXRepository 继承 JpaRepostory 类