懒羊羊
2023-12-12 b26949b3738a7eb34f8550a073d8d3b03c2fbf3e
提交 | 用户 | 时间
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
24                  url: jdbc:jtds:sqlserver://172.20.1.10:1433;DatabaseName=MideaMes
25                  username: sa
26                  password: admin@123
27                  # 连接池大小根据实际情况调整
28                  max-active: 100
29                  max-pool-prepared-statement-per-connection-size: 100
30                  flyway:
31                    locations: classpath:db/migration/sqlserver
32
33 #SQLServer配置
34 #spring:
35 #  datasource:
36 #    jdbc-url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=MD
37 #    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
38 #    username: sa
39 #    password: admin@123
40
41 #PostgreSQL配置
42 #spring:
43 #  datasource:
44 #    driverClassName: org.postgresql.Driver
45 #    url: jdbc:postgresql://127.0.0.1:5432/guns
46 #    username: postgres
47 #    password: 123456
48 #    filters: wall,mergeStat
49
50 # Mysql数据库
51 #spring:
52 #  datasource:
53 #    driver-class-name: com.mysql.cj.jdbc.Driver
54 #    url: jdbc:mysql://127.0.0.1:3306/guns?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
55 #    username: root
56 #    password: root
57 #    filters: wall,mergeStat
58
59 # Mysql数据库
60 #spring:
61 #  datasource:
62 #    driver-class-name: com.mysql.cj.jdbc.Driver
63 ##    url: jdbc:mysql://192.168.0.234:3306/guns_advanced?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
64 #    url: jdbc:mysql://127.0.0.1:3306/guns_advanced?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
65 #    username: root
66 #    password: root
67 #    filters: wall,mergeStat
68 #
69 #    # 连接池大小根据实际情况调整
70 #    max-active: 20
71 #    max-pool-prepared-statement-per-connection-size: 20
72 #
73 #  # 邮件发送配置(改为自己的账号和密码)
74 #  mail:
75 #    host: smtp.qq.com
76 #    port: 587
77 #    username: sn93@qq.com
78 #    password: xxxpassword
79 #
80 ## 邮件发送(改为自己的账号)
81 #mail:
82 #  from: sn93@qq.com