admin
2024-01-10 7f291910791bdb9a545dc12ef36c3c359cfa4e59
提交 | 用户 | 时间
71e81e 1 #Oracle配置
2 #spring:
3 #  datasource:
4 #    driverClassName: oracle.jdbc.OracleDriver
5 #    url: jdbc:oracle:thin:@127.0.0.1:1521:ORCLCDB
6 #    username: GUNS
7 #    password: GUNS
8 #    filters: wall,mergeStat
9
10 #SQLServer配置 DESKTOP-5M23NIS
11 #spring:
12 #  datasource:
13 #    driverClassName: net.sourceforge.jtds.jdbc.Driver
14 #    url: jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=MD
15 #    username: sa
16 #    password: admin@123
17 #    filters: wall,mergeStat
18
19 # Sql Server数据库
20 spring:
21   datasource:
22                  driverClassName: net.sourceforge.jtds.jdbc.Driver
23                  #    url: jdbc:jtds:sqlserver://120.48.135.247:1433;DatabaseName=festo_guns
39a1db 24 #                 url: jdbc:jtds:sqlserver://172.20.1.10:1433;DatabaseName=MideaMes
25 #                 url: jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=MideaMesT1
26                  url: jdbc:jtds:sqlserver://192.168.0.189:1433;DatabaseName=Jcdm019-Mes
71e81e 27                  username: sa
39a1db 28 #                 password: admin@123
29                  password: JCDM@2023
30     # 连接池大小根据实际情况调整
71e81e 31                  max-active: 100
32                  max-pool-prepared-statement-per-connection-size: 100
33                  flyway:
34                    locations: classpath:db/migration/sqlserver
35
36 #SQLServer配置
37 #spring:
38 #  datasource:
39 #    jdbc-url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=MD
40 #    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
41 #    username: sa
42 #    password: admin@123
43
44 #PostgreSQL配置
45 #spring:
46 #  datasource:
47 #    driverClassName: org.postgresql.Driver
48 #    url: jdbc:postgresql://127.0.0.1:5432/guns
49 #    username: postgres
50 #    password: 123456
51 #    filters: wall,mergeStat
52
53 # Mysql数据库
54 #spring:
55 #  datasource:
56 #    driver-class-name: com.mysql.cj.jdbc.Driver
57 #    url: jdbc:mysql://127.0.0.1:3306/guns?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
58 #    username: root
59 #    password: root
60 #    filters: wall,mergeStat
61
62 # Mysql数据库
63 #spring:
64 #  datasource:
65 #    driver-class-name: com.mysql.cj.jdbc.Driver
66 ##    url: jdbc:mysql://192.168.0.234:3306/guns_advanced?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
67 #    url: jdbc:mysql://127.0.0.1:3306/guns_advanced?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
68 #    username: root
69 #    password: root
70 #    filters: wall,mergeStat
71 #
72 #    # 连接池大小根据实际情况调整
73 #    max-active: 20
74 #    max-pool-prepared-statement-per-connection-size: 20
75 #
76 #  # 邮件发送配置(改为自己的账号和密码)
77 #  mail:
78 #    host: smtp.qq.com
79 #    port: 587
80 #    username: sn93@qq.com
81 #    password: xxxpassword
82 #
83 ## 邮件发送(改为自己的账号)
84 #mail:
85 #  from: sn93@qq.com