From 662df6f81f2b39cf70909a47c0d7d913e7c89ef6 Mon Sep 17 00:00:00 2001 From: tjx <t2856754968@163.com> Date: 星期一, 22 十二月 2025 15:10:23 +0800 Subject: [PATCH] 更改脚本 --- README.md | 135 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 133 insertions(+), 2 deletions(-) diff --git a/README.md b/README.md index a2d1ce1..66f130a 100644 --- a/README.md +++ b/README.md @@ -1,4 +1,135 @@ -## NumericalCollection2 +# NumericalCollection -sql server+java鐗堟湰鐨勬暟閲囧钩鍙� +鍩轰簬 Spring Boot + MyBatis-Plus + SQL Server 鐨勫伐涓氳澶囨暟鎹噰闆嗗钩鍙般�� +## 椤圭洰绠�浠� + +鏈」鐩槸涓�涓� MES锛堝埗閫犳墽琛岀郴缁燂級鏁版嵁閲囬泦妯″潡锛屼富瑕佺敤浜庯細 +- 璁惧瀹炴椂鏁版嵁閲囬泦涓庡悓姝� +- 宸ュ崟鐢熶骇鏁版嵁绠$悊 +- 璁惧鏁呴殰璁板綍涓庤拷韪� +- 鐢熶骇鎸囨爣缁熻鍒嗘瀽 + +## 鎶�鏈爤 + +| 鎶�鏈� | 鐗堟湰 | 璇存槑 | +|------|------|------| +| Spring Boot | 2.6.13 | 鍩虹妗嗘灦 | +| MyBatis-Plus | 3.5.4 | ORM 妗嗘灦 | +| Druid | 1.2.16 | 鏁版嵁搴撹繛鎺ユ睜 | +| SQL Server | - | 鏁版嵁搴� | +| Lombok | - | 绠�鍖栦唬鐮� | +| Hutool | 5.8.18 | 宸ュ叿绫诲簱 | +| OkHttp | 4.9.3 | HTTP 瀹㈡埛绔� | +| FastJson | 2.0.32 | JSON 澶勭悊 | +| POI | 4.1.2 | Excel 澶勭悊 | +| PDFBox | 2.0.27 | PDF 澶勭悊 | + +## 椤圭洰缁撴瀯 + +``` +src/main/java/com/hk/NumericalCollection/ +鈹溾攢鈹� config/ # 閰嶇疆绫伙紙鏁版嵁婧愩�丮yBatis绛夛級 +鈹溾攢鈹� controller/ # REST 鎺ュ彛鎺у埗鍣� +鈹溾攢鈹� dto/ # 鏁版嵁浼犺緭瀵硅薄 +鈹溾攢鈹� entity/ # 鏁版嵁搴撳疄浣撶被 +鈹溾攢鈹� mapper/ # MyBatis Mapper 鎺ュ彛 +鈹溾攢鈹� service/ # 涓氬姟閫昏緫灞� +鈹� 鈹斺攢鈹� impl/ # 鏈嶅姟瀹炵幇绫� +鈹斺攢鈹� task/ # 瀹氭椂浠诲姟 + +src/main/resources/ +鈹溾攢鈹� application.yml # 搴旂敤閰嶇疆 +鈹斺攢鈹� mapper/ # MyBatis XML 鏄犲皠鏂囦欢 + +database/ # 鏁版嵁搴撹剼鏈� +``` + +## 鏍稿績鍔熻兘妯″潡 + +### 1. 璁惧绠$悊 +- `Device` / `DevMachine` - 璁惧鍩虹淇℃伅 +- `DeviceStatus` - 璁惧鐘舵�佺洃鎺� +- `DeviceMetrics` - 璁惧鎸囨爣鏁版嵁 +- `DeviceError` - 璁惧鏁呴殰璁板綍 + +### 2. 宸ュ崟绠$悊 +- `Womdaa` - 宸ュ崟鎸囦护琛� +- `VOrder` / `VOrderDetail` - 璁㈠崟瑙嗗浘 +- `MesOrderSelect` - 宸ュ崟閫夋嫨璁板綍 + +### 3. 鏁版嵁閲囬泦 +- `MesNumerical` - 閲囬泦鏁版嵁璁板綍 +- `Devicedatastandardmoditem` - 鏁版嵁鏍囧噯椤� + +## API 鎺ュ彛 + +鍩虹璺緞锛歚/Numerical` + +| 鎺ュ彛 | 鏂规硶 | 璇存槑 | +|------|------|------| +| `/manualSynchronization` | POST | 鎵嬪姩鍚屾璁惧鏁版嵁 | +| `/manualSynchronizationBycl` | POST | 鎵嬪姩鍚屾璁惧鏁版嵁(澶囩敤) | +| `/RefreshDev` | POST | 鍒锋柊璁惧鏁版嵁 | +| `/RefreshDevBycl` | POST | 鍒锋柊璁惧鏁版嵁(澶囩敤) | +| `/PdfToBase64` | POST | PDF 杞� Base64 | +| `/getDeviceErrorList` | POST | 鑾峰彇璁惧鏁呴殰鍒楄〃 | + +## 蹇�熷紑濮� + +### 鐜瑕佹眰 +- JDK 1.8+ +- Maven 3.6+ +- SQL Server 2019+ + +### 閰嶇疆鏁版嵁搴� + +淇敼 `src/main/resources/application.yml` 涓殑鏁版嵁搴撹繛鎺ヤ俊鎭細 + +```yaml +spring: + datasource: + url: jdbc:sqlserver://[host]:[port];databaseName=[dbname];encrypt=false + username: [username] + password: [password] +``` + +### 鍒濆鍖栨暟鎹簱 + +鎵ц `database/` 鐩綍涓嬬殑 SQL 鑴氭湰鍒涘缓鎵�闇�琛ㄧ粨鏋勩�� + +### 鏋勫缓杩愯 + +```bash +# 缂栬瘧鎵撳寘 +mvn clean install + +# 鏈湴杩愯锛堢鍙� 9095锛� +mvn spring-boot:run + +# 浠呯紪璇戯紙璺宠繃娴嬭瘯锛� +mvn clean compile -DskipTests +``` + +### 杩愯娴嬭瘯 + +```bash +mvn test +``` + +## 瀹氭椂浠诲姟 + +椤圭洰鍖呭惈浠ヤ笅瀹氭椂浠诲姟锛堜綅浜� `task/ScheduledTasks.java`锛夛細 + +| 浠诲姟 | 鎵ц鍛ㄦ湡 | 璇存槑 | +|------|----------|------| +| 鏁版嵁娓呯悊 | 姣忓懆鏃� 0:00 | 娓呯悊涓�鍛ㄥ墠鐨勯噰闆嗘暟鎹� | +| 宸ュ崟鍚屾 | 姣忓ぉ 1:00 | 鍚屾褰撴棩宸ュ崟鍒伴�夋嫨琛� | +| 鏃ョ粺璁� | 姣忓ぉ 2:00 | 缁熻鍓嶄竴澶╄澶囨暟鎹� | +| 瀹炴椂閲囬泦 | 姣� 2 鍒嗛挓 | 閲囬泦璁惧瀹炴椂鏁版嵁 | + +## 娉ㄦ剰浜嬮」 + +- 鐢熶骇鐜璇烽�氳繃鐜鍙橀噺鎴� Maven Profile 閰嶇疆鏁版嵁搴撳嚟璇� +- 鏃ュ織鍜� SQL 杈撳嚭涓渶鑴辨晱瀹㈡埛鏁忔劅淇℃伅 +- 鎻愪氦浠g爜鍓嶈鏈湴杩愯鍏ㄩ儴娴嬭瘯 -- Gitblit v1.9.3