懒羊羊
2023-11-14 abb175b29054b9708af27136c035b1b7351dcd20
提交 | 用户 | 时间
1ac2bc 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://127.0.0.1:1433;DatabaseName=MD
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://192.168.0.189:3306/jc_mes_base?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT
65     username: root
66     password: 123456
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