From 0120a42fc52d9e55bc22a450e35a24b2d844b8ad Mon Sep 17 00:00:00 2001
From: 邹裕 <2723363702@qq.com>
Date: 星期二, 22 九月 2026 17:32:55 +0800
Subject: [PATCH] 修复ucanaccess查询中文排序mdb数据库导致索引失效查询缓慢问题

---
 README.md |  150 +++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 124 insertions(+), 26 deletions(-)

diff --git a/README.md b/README.md
index c602ddf..8a98dda 100644
--- a/README.md
+++ b/README.md
@@ -1,47 +1,145 @@
 ## data-acquisition
 
-浜ㄦ椇鐗瑰MES鏁版嵁閲囬泦鍣�
+浜ㄦ椇鐗瑰 MES 鏁版嵁閲囬泦鍣紙Spring Boot 2.6.3 / Java 8锛�
 
-### 涓插彛閲囬泦锛堟墜鍔ㄧ洃鍚級
+- 閲囬泦鏂瑰紡锛氫覆鍙ｏ紙鎵嬪姩鐩戝惉锛夈�丄ccess 鏁版嵁搴撱�丳ostgreSQL
+- 鏈嶅姟绔彛锛�9527锛坄server.port`锛�
+- 鏃ュ織鐩綍锛歚logging.file-location`锛堥粯璁� `D:\mes-acquistion\logs`锛�
+- 缁熶竴杩斿洖鏍煎紡锛歚{ "code": 0, "msg": null, "data": ... }`锛宍code=0` 鎴愬姛锛宍code=1` 澶辫触锛堝師鍥犲湪 `msg` 閲岋級
 
-涓插彛涓嶅啀闅忛」鐩惎鍔ㄨ嚜鍔ㄧ洃鍚紝鏀逛负鎵嬪姩鐩戝惉锛氳皟鐢ㄩ噰闆嗘帴鍙ｆ椂寮�鍚洃鍚紝閲囬泦缁撴潫鍚庤皟鐢ㄥ叧闂帴鍙ｃ��
+### 涓�銆佷覆鍙ｉ噰闆嗭紙鎵嬪姩鐩戝惉锛�
+
+涓插彛涓嶉殢椤圭洰鍚姩鑷姩鐩戝惉锛氳皟鐢ㄥ紑鍚帴鍙ｆ墦寮�涓插彛骞跺彇鏁帮紝閲囬泦缁撴潫鍚庤皟鐢ㄥ叧闂帴鍙ｉ噴鏀句覆鍙ｃ��
 
 | 鎺ュ彛 | 璇存槑 |
 | --- | --- |
-| `GET /lims/getFile?fileExtension=.serialPort` | 閲囬泦鎺ュ彛锛氳皟鐢ㄦ椂鑷姩寮�鍚洃鍚紝骞惰繑鍥炴湰娆￠噰闆嗗埌鐨勬暟鎹紱娌℃湁鏁版嵁鏃惰繑鍥炵┖闆嗗悎锛岀敱鍓嶇杞鍙栨暟 |
-| `GET /lims/openSerialPort` | 鎵嬪姩寮�鍚洃鍚紝骞惰繑鍥炲綋鍓嶆帴鏀跺埌鐨勬暟鎹垪琛紙骞傜瓑锛屽弬鏁颁竴鑷存椂澶嶇敤宸叉墦寮�鐨勪覆鍙ｏ級 |
-| `GET /lims/closeSerialPort` | 鎵嬪姩鍏抽棴鐩戝惉锛堝箓绛夛紝閲囬泦缁撴潫鍚庤皟鐢紝閬垮厤涓插彛涓�鐩磋鍗犵敤锛� |
-| `GET /lims/serialPortStatus` | 鏌ヨ鐩戝惉鐘舵�侊細`listenName` / `listening` / `portOpen` / `dataSize` |
+| `GET /collection/openSerialPort` | 寮�鍚覆鍙ｇ洃鍚苟杩斿洖褰撳墠鎺ユ敹鍒扮殑鏁版嵁鍒楄〃锛堟病鏈夋暟鎹椂杩斿洖绌洪泦鍚堬紝鐢卞墠绔疆璇㈠彇鏁帮級銆傚箓绛夛細鍙傛暟涓�鑷存椂澶嶇敤宸叉墦寮�鐨勪覆鍙ｏ紝鍙傛暟鍙樺寲鏃舵寜鏂板弬鏁伴噸鏂版墦寮�锛屽绾跨▼骞跺彂璋冪敤涔熷彧浼氭墦寮�涓�娆� |
+| `GET /collection/closeSerialPort` | 鍏抽棴涓插彛鐩戝惉锛堝箓绛夛紝鏈紑鍚椂璋冪敤涔熻繑鍥炴垚鍔燂級 |
+| `GET /collection/serialPortStatus` | 鏌ヨ鐩戝惉鐘舵�侊紝杩斿洖 `listenName` / `listening` / `portOpen` / `dataSize` |
 
-涓插彛鍙傛暟鍏ㄩ儴鐢辨帴鍙ｄ紶鍏ワ紝`/lims/getFile`锛坄fileExtension=.serialPort` 鏃讹級鍜� `/lims/openSerialPort` 閮芥敮鎸侊紝
-涓嶄紶鐨勫瓧娈典娇鐢ㄩ粯璁ゅ�硷紙`listenName` 蹇呬紶锛夈�俛pplication.yml 涓殑 `serialPort` 閰嶇疆宸蹭笉鍐嶇敓鏁堬紝鍙互鍒犻櫎銆�
+#### 涓插彛鍙傛暟锛堝叏閮ㄧ敱鎺ュ彛浼犲叆锛屼笉浼犵殑瀛楁鐢ㄩ粯璁ゅ�硷級
 
 | 鍙傛暟 | 榛樿鍊� | 璇存槑 |
 | --- | --- | --- |
-| `listenName` | 蹇呬紶 | 涓插彛鍚嶇О锛屽 `COM12`锛涗笉浼犱細杩斿洖鈥滀覆鍙ｅ悕绉颁笉鑳戒负绌衡�� |
+| `serialPortName` | 蹇呬紶 | 涓插彛鍚嶇О锛屽 `COM12`锛涗笉浼犱細杩斿洖鈥滀覆鍙ｅ悕绉颁笉鑳戒负绌衡�� |
 | `baudRate` | `9600` | 娉㈢壒鐜� |
 | `dataBits` | `8` | 鏁版嵁浣嶏紝5~8 |
 | `stopBits` | `1` | 鍋滄浣嶏紝1銆�2銆�3(1.5 浣�) |
-| `parity` | `NONE` | 鏍￠獙浣嶏細`NONE`/`ODD`/`EVEN`/`MARK`/`SPACE`锛屼篃鍏煎 0~4 |
-| `flowControl` | `NONE` | 娴佹帶锛歚NONE`/`RTS_CTS`/`XON_XOFF`锛屼篃鍏煎鏁板瓧甯搁噺 |
+| `parity` | `NONE` | 鏍￠獙浣嶏細`NONE`/`ODD`/`EVEN`/`MARK`/`SPACE`锛堜笉鍖哄垎澶у皬鍐欙級锛屼篃鍏煎 0~4 |
+| `flowControl` | `NONE` | 娴佹帶锛歚NONE`/`RTS_CTS`/`XON_XOFF`锛堜笉鍖哄垎澶у皬鍐欙級锛屼篃鍏煎鏁板瓧甯搁噺 |
 | `readTimeout` | `1000` | 璇诲彇瓒呮椂锛堟绉掞級 |
-| `endMark` | `*` | 涓�甯ф暟鎹殑缁撴潫鏍囧織锛岀壒娈婂瓧绗︾敤 URL 缂栫爜锛屽鎹㈣ `%0A` |
-| `maxCount` | `6` | 鏁版嵁缂撳瓨闃熷垪闀垮害锛氶槦鍒楁弧鏃舵彃鍏ユ渶鏂颁竴鏉°�佺Щ闄ゆ渶鏃т竴鏉� |
+| `endMark` | `*` | 涓�甯ф暟鎹殑缁撴潫鏍囧織锛岀壒娈婂瓧绗︾敤 URL 缂栫爜浼犲叆锛屽鎹㈣ `%0A` |
+| `maxCount` | `1` | 鏁版嵁缂撳瓨闃熷垪闀垮害锛氶槦鍒楁弧鏃舵彃鍏ユ渶鏂颁竴鏉°�佺Щ闄ゆ渶鏃т竴鏉★紱榛樿 `1` 鍗冲彧杩斿洖璁惧鏈�鏂扮殑涓�鏉� |
 | `frameIdleMillis` | `200` | 甯х┖闂茶ˉ甯ф椂闂达紙姣锛夛細瓒呰繃璇ユ椂闂存病鏈夋柊鏁版嵁锛屽氨鎶婄紦鍐插尯鍓╀綑鏁版嵁褰撴垚涓�甯у彇鍑猴紱`0` 琛ㄧず鍏抽棴 |
 
-绀轰緥锛歚/lims/getFile?fileExtension=.serialPort&listenName=COM12&baudRate=19200&parity=EVEN&endMark=%0A&maxCount=6`
+璋冪敤绀轰緥锛�
 
-鍙傛暟涓庡綋鍓嶇敓鏁堝弬鏁颁竴鑷存椂澶嶇敤宸茬粡鎵撳紑鐨勪覆鍙ｏ紙涓嶄細閲嶅鎵撳紑锛夛紱鍙傛暟鍙樺寲鏃朵細鑷姩鎸夋柊鍙傛暟閲嶆柊鎵撳紑涓插彛锛�
-鍙傛暟闈炴硶鏃舵帴鍙ｇ洿鎺ヨ繑鍥炲叿浣撳師鍥狅紙濡� `涓插彛鍙傛暟 dataBits 闈炴硶锛�9锛屽彇鍊艰寖鍥� 5~8`锛夈��
+```
+# 寮�鍚洃鍚苟鍙栨暟锛�9600 8N1銆佺粨鏉熸爣蹇� *锛岄粯璁ゅ彧鍙栨渶鏂颁竴鏉★級
+http://127.0.0.1:9527/collection/openSerialPort?serialPortName=COM12
 
-閲囬泦鍒扮殑鏁版嵁鎸夐槦鍒楃紦瀛橈細鎻掑叆鏈�鏂扮殑涓�鏉★紝瓒呰繃 `maxCount` 鏉★紙榛樿 6 鏉★級鏃剁Щ闄ゆ渶鏃х殑涓�鏉★紝
-鍥犳鎺ュ彛姣忔鏈�澶氳繑鍥� `maxCount` 鏉℃渶鏂扮殑鏁版嵁锛堟寜鎺ユ敹鍏堝悗椤哄簭锛夛紱鏁版嵁琚彇璧板悗闃熷垪娓呯┖锛岄噸鏂板紑濮嬬紦瀛樸��
+# 19200 鍋舵牎楠屻�佷互鎹㈣缁撳熬銆佹渶澶氬彇 6 鏉�
+http://127.0.0.1:9527/collection/openSerialPort?serialPortName=COM12&baudRate=19200&parity=EVEN&endMark=%0A&maxCount=6
 
-鏁版嵁甯ф寜 `endMark` 鍒囧垎銆傚鏋滆澶囨槸銆屾瘡甯т互鏌愪釜瀛楃寮�澶淬�嶈�屼笉鏄粨灏撅紙渚嬪鍙� `*0 1 0`銆乣*0 2 0`锛�
-`*` 鐢ㄤ簬鍒嗛殧鍓嶅悗涓ゅ抚锛夛紝閭ｄ箞鏈�鍚庝竴甯у悗闈㈡病鏈夋柊鐨� `*` 鏉ヨЕ鍙戝垏鍒嗭紝鍙潬缁撴潫鏍囧織浼氭紡鎺夋渶鍚庝竴鏉★紱
-姝ゆ椂鐢� `frameIdleMillis`锛堥粯璁� 200ms锛夊厹搴曪細涓插彛绌洪棽瓒呰繃璇ユ椂闂村悗锛屾妸鎺ユ敹缂撳啿鍖洪噷鍓╀笅鐨勬暟鎹綋浣滀竴甯у彇鍑恒��
-濡傛灉璁惧姣忓抚閮戒互缁撴潫鏍囧織缁撳熬锛岀紦鍐插尯姣忔鍒囧垎鍚庨兘鏄┖鐨勶紝绌洪棽琛ュ抚涓嶄細鍋氫换浣曚簨銆�
+# 鏌ョ湅鐩戝惉鐘舵�� / 鍏抽棴涓插彛
+http://127.0.0.1:9527/collection/serialPortStatus
+http://127.0.0.1:9527/collection/closeSerialPort
+```
 
-骞跺彂璇存槑锛氬紑鍚� / 鍏抽棴涓插彛鐢卞悓涓�鎶婇攣淇濇姢锛屽绾跨▼骞跺彂璋冪敤閲囬泦鎺ュ彛涔熷彧浼氭墦寮�涓�娆′覆鍙ｏ紝涓嶄細閲嶅娉ㄥ唽鐩戝惉鍣紱
-閲囬泦缁撴灉瀛樻斁鍦ㄥ悓姝ラ泦鍚堜腑锛屽绾跨▼鍚屾椂鍙栨暟鏃跺悓涓�鏉℃暟鎹彧浼氳涓�涓嚎绋嬪彇璧帮紝涓嶄細閲嶅涔熶笉浼氫涪澶便��
-璋冪敤鍏抽棴鎺ュ彛鍚庡啀娆¤皟鐢ㄩ噰闆嗘帴鍙ｄ細閲嶆柊寮�鍚洃鍚紝骞舵竻鎺変笂涓�杞畫鐣欑殑鍗婂寘鏁版嵁鍜屾湭鍙栬蛋鐨勬暟鎹紝淇濊瘉姣忔閲囬泦鐨勬暟鎹彧灞炰簬鏈疆銆�
+#### 鍙栨暟涓庡垏甯ц鍒�
+
+- 鏁版嵁鎸� `endMark` 鍒囨垚涓�甯т竴甯э紱
+- 鍒囧嚭鏉ョ殑鏁版嵁鏀捐繘闃熷垪缂撳瓨锛氭彃鍏ユ渶鏂扮殑涓�鏉★紝瓒呰繃 `maxCount` 鏉℃椂绉婚櫎鏈�鏃х殑涓�鏉★紝
+  鍥犳鎺ュ彛姣忔鏈�澶氳繑鍥� `maxCount` 鏉℃渶鏂扮殑鏁版嵁锛堟寜鎺ユ敹鍏堝悗椤哄簭锛夛紱鏁版嵁琚彇璧板悗闃熷垪娓呯┖锛岄噸鏂板紑濮嬬紦瀛橈紱
+- 璁惧鏈�鍚庝竴甯у鏋滀笉甯︾粨鏉熸爣蹇楋紙渚嬪姣忓抚浠� `*` 寮�澶淬�侀潬涓嬩竴涓� `*` 鍒嗛殧鍓嶅悗涓ゅ抚锛夛紝鍙潬缁撴潫鏍囧織浼氭紡鎺夋渶鍚庝竴鏉★紝
+  姝ゆ椂鐢� `frameIdleMillis` 鍏滃簳锛氫覆鍙ｇ┖闂茶秴杩囪鏃堕棿灏辨妸鎺ユ敹缂撳啿鍖洪噷鍓╀笅鐨勬暟鎹綋浣滀竴甯у彇鍑猴紱
+  濡傛灉璁惧姣忓抚閮戒互缁撴潫鏍囧織缁撳熬锛岀紦鍐插尯姣忔鍒囧垎鍚庨兘鏄┖鐨勶紝绌洪棽琛ュ抚涓嶄細鍋氫换浣曚簨锛�
+- 鍙傛暟涓庡綋鍓嶇敓鏁堝弬鏁颁竴鑷存椂澶嶇敤宸茬粡鎵撳紑鐨勪覆鍙ｏ紙涓嶄細閲嶅鎵撳紑锛夛紱鍙傛暟鍙樺寲鏃舵寜鏂板弬鏁伴噸鏂版墦寮�锛�
+- 鍐嶆寮�鍚洃鍚椂浼氭竻鎺変笂涓�杞畫鐣欑殑鍗婂寘鏁版嵁鍜屾湭鍙栬蛋鐨勬暟鎹紝淇濊瘉姣忔閲囬泦鐨勬暟鎹彧灞炰簬鏈疆锛�
+- 鍙傛暟闈炴硶鏃舵帴鍙ｇ洿鎺ヨ繑鍥炲叿浣撳師鍥狅紙濡� `涓插彛鍙傛暟 dataBits 闈炴硶锛�9锛屽彇鍊艰寖鍥� 5~8`锛夈��
+
+#### 骞跺彂璇存槑
+
+- 寮�鍚� / 鍏抽棴涓插彛鐢卞悓涓�鎶婇攣淇濇姢锛岄噸澶嶈皟鐢ㄥ彧浼氱湡姝ｆ墦寮�涓�娆′覆鍙ｏ紝涓嶄細閲嶅娉ㄥ唽鐩戝惉鍣紱
+- 閲囬泦缁撴灉瀛樻斁鍦ㄥ悓姝ラ泦鍚堜腑锛屽绾跨▼鍚屾椂鍙栨暟鏃跺悓涓�鏉℃暟鎹彧浼氳涓�涓嚎绋嬪彇璧帮紝涓嶄細閲嶅涔熶笉浼氫涪澶憋紱
+- 鐩戝惉鐘舵�佷娇鐢� volatile 鏍囪锛屽叧闂覆鍙ｅ悗鍥炶皟绾跨▼涓嶅啀澶勭悊鏁版嵁銆�
+
+### 浜屻�佹暟鎹簱閲囬泦
+
+| 鎺ュ彛 | 璇存槑 |
+| --- | --- |
+| `GET /collection/getAccessData` | 閲囬泦 Access 鏁版嵁搴擄紙.mdb/.accdb锛夎〃鏁版嵁锛岃繑鍥� `List<Map<String,Object>>` |
+| `GET /collection/getPostgreSqlData` | 閲囬泦 PostgreSQL 琛ㄦ暟鎹紝杩斿洖 `List<Map<String,Object>>` |
+
+鍙傛暟锛坄DatabaseDTO`锛夛細
+
+| 鍙傛暟 | 璇存槑 |
+| --- | --- |
+| `filePath` | Access 鏁版嵁搴撴枃浠惰矾寰勶紙浠� `getAccessData`锛� |
+| `ipAddress` / `serverPort` / `databaseName` | PostgreSQL 杩炴帴淇℃伅锛堜粎 `getPostgreSqlData`锛� |
+| `userName` / `password` | 鏁版嵁搴撶敤鎴峰悕銆佸瘑鐮侊紱Access 鐨勬枃浠舵墦寮�瀵嗙爜鏀惧湪 `password`锛坄userName` 瀵� Access 鏂囦欢鍔犲瘑鏃犱綔鐢級 |
+| `tableName` | 鏁版嵁琛ㄥ悕 |
+| `pointColumns` | 瑕侀噰闆嗙殑瀛楁锛屽涓敤閫楀彿鍒嗛殧 |
+| `mainColumn` + `batchCode` | 鎸夋壒娆¤繃婊わ細`mainColumn = batchCode` |
+| `orderColumn` / `orderRule` | 鎺掑簭瀛楁涓庤鍒欙紙`ASC`/`DESC`锛屼笉浼犻粯璁� `ASC`锛� |
+
+#### Access 璇诲彇鏂瑰紡锛坄mes.access.read-mode`锛�
+
+- `jackcess`锛堥粯璁わ級锛歫ackcess 鍙鐩磋锛坄DatabaseBuilder.setReadOnly(true).setAutoSync(false)`锛夛紝鎵撳紑鏂囦欢鍚庨『搴忔壂鎻忓崟琛ㄣ�佸彧鍙栭渶瑕佺殑鍒楋紝涓嶆瀯寤� HSQLDB 闀滃儚锛屽彧鍙栨煇寮犺〃鍑犲垪鏃舵渶蹇紱
+- `ucanaccess`锛氳蛋 UCanAccess 鐨� SQL 璺緞锛岄渶瑕� Access SQL銆侀摼鎺ヨ〃 `remap` 绛夊満鏅椂浣跨敤銆�
+
+jackcess 妯″紡鐨勫樊寮傦細
+
+- 鎸� `mainColumn` 杩囨护鏄暣琛ㄦ壂鎻忥細鏈簱鏂囨湰绱㈠紩鐨勬帓搴忚鍒欐槸涓枃 2052锛宩ackcess 涓嶆敮鎸侊紙绱㈠紩鍙銆佺储寮曟父鏍囩洿鎺ユ姏寮傚父锛夛紝娌℃湁鍙敤鐨勭储寮曟煡璇㈣矾寰勶紱`orderColumn` 鎺掑簭鍦� Java 渚у畬鎴愶紱
+- `OLE` 瀛楁涓庡師鏉ヤ竴鏍疯繑鍥� `null`锛屼笖涓嶄細璇诲彇瀹冪殑闀垮�硷紱
+- 鏃堕棿瀛楁缁熶竴杩斿洖 `java.sql.Timestamp`锛圝SON 閲屼粛鏄� `yyyy-MM-dd HH:mm:ss.SSS`锛夛紱
+- 璁剧疆浜嗘墦寮�瀵嗙爜鐨勫簱浼氳嚜鍔ㄧ敤 `jackcess-encrypt` 鎵撳紑锛堝瘑鐮佸彇 `password` 鍙傛暟锛汚ccess 鐨勬枃浠跺姞瀵嗗彧鏈夆�滄墦寮�瀵嗙爜鈥濅竴涓蹇碉紝`userName` 涓嶅弬涓庯紝.mdw 宸ヤ綔缁勭骇瀹夊叏鎬� jackcess 涓嶆敮鎸侊級锛沗ucanaccess` 妯″紡涓嬫湁 `jackcess-encrypt` 鍦� classpath 涓婏紝`password` 鍙傛暟鍚屾牱瀵瑰姞瀵嗗簱鐢熸晥锛�
+- 閾炬帴琛ㄧ殑琛屼负涓� UCanAccess 鐨� `remap` 涓嶅悓锛岄亣鍒伴棶棰樺垏鍥� `ucanaccess` 妯″紡鍗冲彲銆�
+
+### 涓夈�佹墭鐩樺浘鏍�
+
+绋嬪簭鍚姩鍚庝换鍔℃爮鍙充笅瑙掍細鍑虹幇鎵樼洏鍥炬爣锛坄SystemTrayInitializer`锛夛紝鍙抽敭鑿滃崟锛�
+
+| 鑿滃崟椤� | 璇存槑 |
+| --- | --- |
+| 鏌ョ湅涓插彛鐘舵�� | 寮瑰嚭鐘舵�佺獥鍙ｏ細涓插彛鍚嶇О / 鐩戝惉鐘舵�� / 涓插彛杩炴帴 / 缂撳瓨鏉℃暟锛屾瘡绉掕嚜鍔ㄥ埛鏂� |
+| 鍏抽棴涓插彛 | 鍙叧闂覆鍙ｇ洃鍚紙涓嶉��鍑虹▼搴忥級锛屾柟渚跨幇鍦烘妸涓插彛閲婃斁缁欏埆鐨勭▼搴忕敤锛涚粨鏋滅敤鎵樼洏姘旀场鎻愮ず |
+| 鎵撳紑鏃ュ織鐩綍 | 鎵撳紑 `logging.file-location` 閰嶇疆鐨勬棩蹇楃洰褰� |
+| 閫�鍑� | 鍏堝叧闂� Spring 瀹瑰櫒锛堣Е鍙� `@PreDestroy`锛氬叧闂覆鍙ｃ�佸仠姝㈣ˉ甯х嚎绋嬶級锛屽啀缁撴潫杩涚▼ |
+
+- 鍙屽嚮鎵樼洏鍥炬爣 = 鏌ョ湅涓插彛鐘舵�侊紱
+- 鑿滃崟寮瑰嚭鍦ㄥ厜鏍囦笂鏂广�佸彸杈圭紭瀵归綈锛岀偣鑿滃崟澶栭潰 / 鎸� ESC / 鍐嶅彸閿竴娆￠兘浼氭敹璧凤紱
+- 鍥炬爣浼樺厛鐢� `src/main/resources/tray.png`锛堟斁涓�寮� 32x32 鐨� png 鍗冲彲鎹㈡垚鑷繁鐨勫浘鏍囷級锛屾病鏈夊氨鐢ㄤ唬鐮佺敾鐨勯粯璁ゅ浘鏍囷紱
+- 鎵樼洏渚濊禆 AWT锛屽惎鍔ㄧ被閲屽凡缁� `setHeadless(false)`锛涗互 Windows 鏈嶅姟鏂瑰紡杩愯锛堟病鏈夋闈細璇濓級鏃舵墭鐩樹笉鏄剧ず锛屾帴鍙ｄ笉鍙楀奖鍝嶃��
+
+### 鍥涖�佹瀯寤轰笌杩愯
+
+```bash
+# 鎵撳寘锛堜骇鐗� target/data-acquisition.jar锛屽彲鐩存帴 java -jar 杩愯锛�
+mvn clean package -DskipTests
+
+# 杩愯锛堥渶瑕� Java 8锛�
+java -jar target/data-acquisition.jar
+```
+
+- **鍙屽嚮 jar 杩愯**锛氶渶瑕佹妸 `.jar` 鐨勯粯璁ゆ墦寮�鏂瑰紡鎸囧悜 **Java 8 鐨� javaw.exe**
+  锛堝彸閿� jar 鈫� 鎵撳紑鏂瑰紡 鈫� 閫夋嫨鍏朵粬搴旂敤 鈫� 鏇村搴旂敤 鈫� 鍦ㄨ繖鍙扮數鑴戜笂鏌ユ壘鍏朵粬搴旂敤 鈫� `<jdk8>\bin\javaw.exe` 鈫� 鍕鹃�夆�滃缁堜娇鐢ㄦ搴旂敤鎵撳紑 .jar 鏂囦欢鈥濓級銆�
+  娉ㄦ剰涓嶈鎸囧悜楂樼増鏈� JDK锛堟湰椤圭洰鏄� Spring Boot 2.6.3锛屽彧鏀寔 Java 8~17锛夛紝涔熶笉瑕佺敤鍘嬬缉杞欢鎵撳紑锛�
+- 鐢� javaw 鍚姩娌℃湁鎺у埗鍙帮紝**鍚姩澶辫触浼氬脊绐楁彁绀�**锛堜緥濡傜鍙ｈ鍗犵敤銆佹棩蹇楃洰褰曚笉鍙啓锛夛紝璇︾粏閿欒鐪� `logging.file-location` 鐩綍涓嬬殑鏃ュ織锛�
+- 閫�鍑鸿鐢ㄦ墭鐩樿彍鍗曠殑銆岄��鍑恒�嶏紙浼氭甯稿叧闂覆鍙ｏ級锛涚洿鎺ョ粨鏉熻繘绋嬩笉浼氳蛋杩欏娓呯悊娴佺▼銆�
+
+### 浜斻�侀厤缃紙application.yml锛�
+
+```yaml
+server:
+  port: 9527                              # 鏈嶅姟绔彛
+
+logging:
+  file-location: D:\mes-acquistion\logs   # 鏃ュ織鐩綍锛堟墭鐩樷�滄墦寮�鏃ュ織鐩綍鈥濅篃鐢ㄥ畠锛�
+
+#mes:
+#  access:
+#    read-mode: jackcess                   # Access 璇诲彇鏂瑰紡锛歫ackcess锛堥粯璁わ紝鐩磋鍗曡〃锛�/ ucanaccess锛圫QL 妯″紡锛�
+```
+
+> 涓插彛鍙傛暟锛堜覆鍙ｅ悕銆佹尝鐗圭巼銆佹暟鎹綅銆佹牎楠屼綅銆佺粨鏉熸爣蹇楃瓑锛夊叏閮ㄧ敱鎺ュ彛浼犲叆锛岄厤缃枃浠堕噷涓嶉渶瑕佷覆鍙ｇ浉鍏抽厤缃��

--
Gitblit v1.9.3