SpringBoot：阿里数据源配置、JPA显示sql语句、格式化JPA查询的sql语句

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

1 数据源和JPA配置

1.1 显示sql配置和格式化sql配置

者两个配置都是属于hibernate的配置，但是springdatajpa给我们简化了；所有hibernate的配置都在jpa下面的properties中；若果直接配置到jpa下面可能不会生效

eureka:
client:
service-url:
defaultZone: http://localhost:8761/eureka/ # 注册中心
instance:
hostname: productClient
spring:
application:
name: product datasource:
url: jdbc:mysql://xxxxx:3306/spring_cloud_sell?useUnicode=true&characterEncoding=UTF-8&useSSL=false
# url: jdbc:mysql://xxxxx:3306/dev?useUnicode=true&characterEncoding=UTF-8&&useSSL=false
# url: jdbc:mysql://xxxxx:3306/qcbx?useUnicode=true&characterEncoding=UTF-8&&useSSL=false
driver-class-name: com.mysql.jdbc.Driver
# username: root
# password: uAiqwVwjJ8-i
username: dev
password: Dev-182838
jpa:
properties:
hibernate:
format_sql: true
show_sql: true