# Mysql数据库配置yml示例
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://172.25.176.1:3306/iiot-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowPublicKeyRetrieval=true&serverTimezone=GMT%2B8
username: root
password: 000000,zml
druid:
initial-size: 5
min-idle: 5
max-active: 20
max-wait: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
validation-query: SELECT 1 FROM DUAL
test-while-idle: true
test-on-borrow: false
test-on-return: false
main:
allow-circular-references: true
allow-bean-definition-overriding: true
jpa:
hibernate:
ddl-auto: update
show-sql: true
database-platform: org.hibernate.dialect.MySQLDialect
properties:
hibernate:
dialect: org.hibernate.dialect.MySQLDialect
# PostgreSQL 数据库配置yml示例
spring:
datasource:
driver-class-name: org.postgresql.Driver
url: jdbc:postgresql://172.25.176.1:5432/iiot-cloud-dev?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
username: root
password: 000000,zml
druid:
initial-size: 5
min-idle: 5
max-active: 20
max-wait: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
validation-query: SELECT 1 FROM DUAL
test-while-idle: true
test-on-borrow: false
test-on-return: false
main:
allow-circular-references: true
allow-bean-definition-overriding: true
jpa:
hibernate:
ddl-auto: update
show-sql: true
database-platform: org.hibernate.dialect.PostgreSQLDialect
properties:
hibernate:
dialect: org.hibernate.dialect.PostgreSQLDialect
# Oracle 数据库配置yml示例
spring:
datasource:
driver-class-name: oracle.jdbc.OracleDriver
url: jdbc:oracle:thin:@//172.25.176.1:1521/XE?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
username: iiot_cloud_dev
password: 000000,zml
druid:
initial-size: 5
min-idle: 5
max-active: 20
max-wait: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
validation-query: SELECT 1 FROM DUAL
test-while-idle: true
test-on-borrow: false
test-on-return: false
main:
allow-circular-references: true
allow-bean-definition-overriding: true
jpa:
hibernate:
ddl-auto: update
show-sql: true
database-platform: org.hibernate.dialect.OracleDialect
properties:
hibernate:
dialect: org.hibernate.dialect.OracleDialect
default_schema: iiot_cloud_dev
# Oracle特有配置
format_sql: true
jdbc:
lob:
non_contextual_creation: true
# Oracle序列生成策略
id:
new_generator_mappings: true
# Dameng 数据库配置yml示例
spring:
datasource:
driver-class-name: dm.jdbc.driver.DmDriver
url: jdbc:dm://172.25.176.1:5236/iiot-cloud-dev?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8
username: SYSDBA
password: 000000,Zml
druid:
initial-size: 5
min-idle: 5
max-active: 20
max-wait: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
validation-query: SELECT 1 FROM DUAL
test-while-idle: true
test-on-borrow: false
test-on-return: false
main:
allow-circular-references: true
allow-bean-definition-overriding: true
jpa:
hibernate:
ddl-auto: update
show-sql: true
# 明确指定使用Oracle方言
database-platform: org.hibernate.dialect.OracleDialect
properties:
hibernate:
# 同时在properties中也指定方言
dialect: org.hibernate.dialect.OracleDialect
java -jar -Dfile.encoding=utf-8 iiot-gateway.jarjava -jar -Dfile.encoding=utf-8 iiot-auth.jarjava -jar -Dfile.encoding=utf-8 system.jarjava -jar -Dfile.encoding=utf-8 iiot-file.jarjava -jar -Dfile.encoding=utf-8 iiot-license-exec.jar server {
listen 80;
server_name localhost;
#charset koi8-r;
#access_log logs/host.access.log main;
#web
location / {
root html;
index index.html index.htm;
add_header X-Frame-Options ALLOWALL;
try_files $uri $uri/ /index.html;
}
#gateway server
location /prod-api/{
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header REMOTE-HOST $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
add_header Access-Control-Allow-Methods *;
add_header Access-Control-Allow-Origin $http_origin;
proxy_pass http://localhost:8080/;
}
#file server
location /file-api/{
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header REMOTE-HOST $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
add_header Access-Control-Allow-Methods *;
add_header Access-Control-Allow-Origin $http_origin;
proxy_pass http://localhost:9300/;
}
}
(1)首次申请
zhuml@ufc.com.cn抄送ligf@ufc.com.cn申请系统许可。




java -jar -Dfile.encoding=utf-8 iiot-ai-server.jar
server {
listen 81;
server_name 172.25.176.1;
#charset koi8-r;
#access_log logs/host.access.log main;
#web
location / {
root /usr/share/nginx/html/app-ai;
index index.html index.htm;
# 允许特定域名访问
add_header 'Access-Control-Allow-Origin' 'http://localhost' always;
add_header 'Access-Control-Allow-Methods' 'GET, POST, OPTIONS, PUT, DELETE' always;
add_header 'Access-Control-Allow-Headers' 'Content-Type, Authorization, X-Requested-With' always;
add_header 'Access-Control-Allow-Credentials' 'true' always;
if ($request_method = 'OPTIONS') {
add_header 'Access-Control-Allow-Origin' 'http://localhost';
add_header 'Access-Control-Allow-Methods' 'GET, POST, OPTIONS, PUT, DELETE';
add_header 'Access-Control-Allow-Headers' 'Content-Type, Authorization, X-Requested-With';
add_header 'Access-Control-Allow-Credentials' 'true';
add_header 'Access-Control-Max-Age' 1728000;
return 204;
}
try_files $uri $uri/ /index.html;
}
}
{
"name": "aiApp",
"entry": "//localhost:81",
"container": "#appContainer",
"activeRule": "/app-ai"
}



