| | |
| | | sql_city_bus.sql åå¸å®¢è¿-å
¬äº¤æåº¦è¡¨ï¼å¿
é¡»æ§è¡ï¼ |
| | | sql_city_taxi.sql åå¸å®¢è¿-åºç§æåº¦è¡¨/åºç§ææè¡¨ï¼å¿
é¡»æ§è¡ï¼ |
| | | sql_wyc.sql ç½çº¦è½¦å
¨çæ»é表/订ååå¸å·è¡¨ï¼å¿
é¡»æ§è¡ï¼ |
| | | sql_holiday.sql ä¸é¡¹ç»è®¡-éè¦èåæ¥è¡¨ï¼æ§åºç¼ºè¡¨æ¶æ§è¡ï¼ |
| | | sql_holiday_decimal_migration.sql è忥æ°å¼å精度è¿ç§»ï¼æ§åºåçº§ï¼ |
| | | sql_holiday_comparison_base_migration.sql èåæ¥ç¯æ¯åºæå段è¿ç§»ï¼æ§åºåçº§ï¼ |
| | | README-é¨ç½²è¯´æ.txt |
| | | |
| | | ãé¨ç½²æºç¯å¢è¦æ±ã |
| | |
| | | mysql --default-character-set=utf8mb4 -u root -p traffic_audit < db/sql_city_bus.sql |
| | | mysql --default-character-set=utf8mb4 -u root -p traffic_audit < db/sql_city_taxi.sql |
| | | mysql --default-character-set=utf8mb4 -u root -p traffic_audit < db/sql_wyc.sql |
| | | 注ï¼å
¨æ°åºç init.sql å·²å«è忥 4 å¼ è¡¨ï¼è¥æ¯å¨æ©æçæ¬åºä¸è¡¥èåæ¥æ¨¡åï¼åæ§è¡ db/sql_holiday.sqlï¼å¹¶æéæ§è¡ä¸¤ä¸ªè¿ç§»èæ¬ã |
| | | é¢ç½®è´¦å·ï¼admin / admin123ï¼é¦æ¬¡ç»å½å请æ¹å¯ç ï¼ |
| | | |
| | | 2. æ¹é
ç½® backend/application.yml |
| | |
| | | 注æï¼å
¨é dump ä¼å¸¦ä¸æ¬æºçè´¦å·å¯ç ï¼è¦ç init.sql é¢ç½®ç admin è´¦å·ã |
| | | |
| | | ã常è§é®é¢ã |
| | | 0. å¯å¨æ¥ java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)ï¼ |
| | | âusing password: NOâ = å端æ¿å°çæ°æ®åºå¯ç æ¯ç©ºä¸²ï¼ä¸æ¯å¯ç éï¼ã |
| | | æ£æ¥ backend/application.yml æ¯å¦ä¸ jar åçº§ä¸ spring.datasource.password 已填çå®å¯ç ï¼ |
| | | è¥æªæ¹ application.ymlï¼ä¹å¯ç¨ç¯å¢åé TRAFFIC_DB_PASSWORD 代æ¿ãæ¹å®éå¯å³å¯ï¼æ ééæ°æå
ã |
| | | 1. å¯å¨æ¥ãæªæ¾å°æ°æ®ç®å½ docsã/ å¯¼åºæ¥ãæªæ¾å°æ¨¡æ¿æä»¶ãï¼ |
| | | å¿
é¡»å¨ backend ç®å½ä¸å¯å¨ï¼jar ä¸ docs å级ï¼ï¼ä¸è¦åªæ· jarã |
| | | 2. æ¥è¡¨å¯¼åºæ¥ãæªæ¾å°æ±æ»è¡¨æ¯çãYYYYå¹´Mæéè·¯è¿è¾éæ±æ»è¡¨.xlsxããï¼ |