#Oracle配置
|
#spring:
|
# datasource:
|
# driverClassName: oracle.jdbc.OracleDriver
|
# url: jdbc:oracle:thin:@127.0.0.1:1521:ORCLCDB
|
# username: GUNS
|
# password: GUNS
|
# filters: wall,mergeStat
|
|
#SQLServer配置 DESKTOP-5M23NIS
|
#spring:
|
# datasource:
|
# driverClassName: net.sourceforge.jtds.jdbc.Driver
|
# url: jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=MD
|
# username: sa
|
# password: admin@123
|
# filters: wall,mergeStat
|
|
# Sql Server数据库
|
spring:
|
datasource:
|
driverClassName: net.sourceforge.jtds.jdbc.Driver
|
# url: jdbc:jtds:sqlserver://120.48.135.247:1433;DatabaseName=festo_guns
|
# url: jdbc:jtds:sqlserver://172.20.1.10:1433;DatabaseName=MideaMes
|
# url: jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=MideaMesT1
|
url: jdbc:jtds:sqlserver://192.168.0.189:1433;DatabaseName=Jcdm019-Mes
|
username: sa
|
# password: admin@123
|
password: JCDM@2023
|
# 连接池大小根据实际情况调整
|
max-active: 100
|
max-pool-prepared-statement-per-connection-size: 100
|
flyway:
|
locations: classpath:db/migration/sqlserver
|
|
#SQLServer配置
|
#spring:
|
# datasource:
|
# jdbc-url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=MD
|
# driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
|
# username: sa
|
# password: admin@123
|
|
#PostgreSQL配置
|
#spring:
|
# datasource:
|
# driverClassName: org.postgresql.Driver
|
# url: jdbc:postgresql://127.0.0.1:5432/guns
|
# username: postgres
|
# password: 123456
|
# filters: wall,mergeStat
|
|
# Mysql数据库
|
#spring:
|
# datasource:
|
# driver-class-name: com.mysql.cj.jdbc.Driver
|
# url: jdbc:mysql://127.0.0.1:3306/guns?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
|
# username: root
|
# password: root
|
# filters: wall,mergeStat
|
|
# Mysql数据库
|
#spring:
|
# datasource:
|
# driver-class-name: com.mysql.cj.jdbc.Driver
|
## url: jdbc:mysql://192.168.0.234:3306/guns_advanced?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
|
# url: jdbc:mysql://127.0.0.1:3306/guns_advanced?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
|
# username: root
|
# password: root
|
# filters: wall,mergeStat
|
#
|
# # 连接池大小根据实际情况调整
|
# max-active: 20
|
# max-pool-prepared-statement-per-connection-size: 20
|
#
|
# # 邮件发送配置（改为自己的账号和密码）
|
# mail:
|
# host: smtp.qq.com
|
# port: 587
|
# username: sn93@qq.com
|
# password: xxxpassword
|
#
|
## 邮件发送（改为自己的账号）
|
#mail:
|
# from: sn93@qq.com
|
