#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