From f2620a59a4e12ee645a659bf2d501e87baf5c60d Mon Sep 17 00:00:00 2001 From: tjx <t2856754968@163.com> Date: 星期一, 10 十一月 2025 13:22:09 +0800 Subject: [PATCH] 更改为sql server的方式并且补充缺失的类 --- README.md | 174 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 173 insertions(+), 1 deletions(-) diff --git a/README.md b/README.md index 1950f9b..f1cf79d 100644 --- a/README.md +++ b/README.md @@ -1,2 +1,174 @@ -# gs-simple +# LBKBSql_Service - 鑿滃崟绠＄悊绯荤粺 + +鍩轰簬 Spring Boot 3.1.5 鐨勮彍鍗曠鐞嗘湇鍔★紝鎻愪緵鏍戝舰缁撴瀯鐨勮彍鍗曟暟鎹鐞嗗拰鏌ヨ鍔熻兘銆� + +## 鎶�鏈爤 + +- **Spring Boot** 3.1.5 +- **Java** 17 +- **SQL Server** 2019 +- **MyBatis Plus** 3.5.6 +- **Druid** 杩炴帴姹� +- **Lombok** 绠�鍖栦唬鐮� + +## 蹇�熷紑濮� + +### 1锔忊儯 鎵撳寘椤圭洰 + +```bash +mvn clean package -DskipTests +``` + +### 2锔忊儯 淇敼閰嶇疆 + +缂栬緫 `startup.bat` 涓殑鏁版嵁搴撻厤缃細 + +```bat +set DB_HOST=192.168.0.51 # 鏁版嵁搴揑P +set DB_PORT=1433 # 鏁版嵁搴撶鍙� +set DB_NAME=TEST_MES # 鏁版嵁搴撳悕 +set DB_USERNAME=sa # 鐢ㄦ埛鍚� +set DB_PASSWORD=LanBao@2025 # 瀵嗙爜 +``` + +### 3锔忊儯 鍚姩搴旂敤 + +```bash +# Windows +startup.bat + +# 鎴栬�呬竴閿紑鍙戝惎鍔紙鑷姩缂栬瘧+鍚姩锛� +dev-start.bat +``` + +### 4锔忊儯 璁块棶鎺ュ彛 + +``` +http://localhost:9091/simple/getTree # 鑾峰彇鑿滃崟鏍� +http://localhost:9091/simple/list # 鑾峰彇鑿滃崟鍒楄〃 +``` + +## 馃摉 鏂囨。 + +- **[蹇�熷紑濮�.txt](蹇�熷紑濮�.txt)** - 3鍒嗛挓蹇�熼儴缃叉寚鍗� +- **[浣跨敤鎵嬪唽.md](浣跨敤鎵嬪唽.md)** - 瀹屾暣浣跨敤鏂囨。锛堥厤缃�侀儴缃层�丄PI銆丗AQ锛� +- **[CLAUDE.md](CLAUDE.md)** - 寮�鍙戣�呮寚鍗楋紙鏋舵瀯銆佸懡浠ゃ�佹妧鏈粏鑺傦級 + +## 椤圭洰缁撴瀯 + +``` +LBKBSql_Service/ +鈹溾攢鈹� src/ +鈹� 鈹溾攢鈹� main/ +鈹� 鈹� 鈹溾攢鈹� java/com/gs/simple/ +鈹� 鈹� 鈹� 鈹溾攢鈹� controller/ # REST鎺у埗鍣� +鈹� 鈹� 鈹� 鈹溾攢鈹� service/ # 涓氬姟閫昏緫灞� +鈹� 鈹� 鈹� 鈹溾攢鈹� mapper/ # MyBatis Mapper +鈹� 鈹� 鈹� 鈹溾攢鈹� domain/ # 瀹炰綋绫� +鈹� 鈹� 鈹� 鈹斺攢鈹� common/ # 閫氱敤宸ュ叿绫� +鈹� 鈹� 鈹斺攢鈹� resources/ +鈹� 鈹� 鈹溾攢鈹� mapper/ # MyBatis XML +鈹� 鈹� 鈹斺攢鈹� application.yml # 閰嶇疆鏂囦欢 +鈹� 鈹斺攢鈹� test/ # 娴嬭瘯浠ｇ爜 +鈹溾攢鈹� startup.bat # 鍚姩鑴氭湰锛堟帹鑽愶級 +鈹溾攢鈹� dev-start.bat # 寮�鍙戝惎鍔ㄨ剼鏈� +鈹溾攢鈹� MES_SIMPLE_CREATE_TABLE.sql # 鑿滃崟琛ㄥ缓琛ㄨ剼鏈� +鈹溾攢鈹� MES_SIMPLE_CCB_CREATE_TABLE.sql # BiView琛ㄥ缓琛ㄨ剼鏈� +鈹斺攢鈹� pom.xml # Maven閰嶇疆 + +``` + +## 涓昏鍔熻兘 + +鉁� 鏍戝舰鑿滃崟缁撴瀯绠＄悊 +鉁� 澶氱骇鑿滃崟鏁版嵁鏌ヨ +鉁� 鑿滃崟鏉冮檺鎺у埗 +鉁� 鍔ㄦ�佹暟鎹簱閰嶇疆 +鉁� RESTful API鎺ュ彛 +鉁� 璺ㄥ煙璇锋眰鏀寔 + +## API 鎺ュ彛 + +### 鑾峰彇鑿滃崟鏍� + +```http +POST /simple/getTree +``` + +杩斿洖鏍戝舰缁撴瀯鐨勮彍鍗曟暟鎹紝鍖呭惈鐖跺瓙灞傜骇鍏崇郴銆� + +### 鑾峰彇鑿滃崟鍒楄〃 + +```http +POST /simple/list +``` + +杩斿洖骞抽摵鐨勮彍鍗曞垪琛ㄦ暟鎹�� + +## 鏁版嵁搴撳垵濮嬪寲 + +棣栨閮ㄧ讲闇�瑕佹墽琛屼互涓婼QL鑴氭湰鍒涘缓鏁版嵁琛細 + +```sql +-- 1. 鑿滃崟缁存姢琛� +source MES_SIMPLE_CREATE_TABLE.sql + +-- 2. BiView鏁版嵁琛� +source MES_SIMPLE_CCB_CREATE_TABLE.sql +``` + +## 閰嶇疆璇存槑 + +搴旂敤閰嶇疆鍦� `application.yml` 涓紝鏀寔閫氳繃 JVM 鍙傛暟瑕嗙洊锛� + +```bash +java -jar simple.jar \ + -Dspring.datasource.url="jdbc:sqlserver://HOST:PORT;..." \ + -Dspring.datasource.username=USER \ + -Dspring.datasource.password=PASS \ + -Dserver.port=9091 +``` + +## 寮�鍙戠幆澧� + +### 杩愯寮�鍙戞ā寮� + +```bash +mvn spring-boot:run +``` + +### 杩愯娴嬭瘯 + +```bash +mvn test +``` + +### 鏋勫缓鐢熶骇鍖� + +```bash +mvn clean package -DskipTests +``` + +## 甯歌闂 + +**Q: 绔彛琚崰鐢ㄦ�庝箞鍔烇紵** +A: 淇敼 `startup.bat` 娣诲姞 `-Dserver.port=8080` 鏇存敼绔彛 + +**Q: 鏁版嵁搴撹繛鎺ュけ璐ワ紵** +A: 妫�鏌ユ暟鎹簱鏈嶅姟銆侀槻鐏銆乀CP/IP杩炴帴鏄惁鍚敤 + +**Q: 鎵句笉鍒癑AR鏂囦欢锛�** +A: 纭繚鍏堟墽琛� `mvn clean package` 鐢熸垚JAR鍖� + +鏇村闂璇锋煡鐪� [浣跨敤鎵嬪唽.md](浣跨敤鎵嬪唽.md) + +## 鐗堟湰淇℃伅 + +- **鐗堟湰**: 1.0.2-SNAPSHOT +- **绔彛**: 9091 +- **缂栫爜**: UTF-8 + +## License + +Copyright 漏 2023-2024 -- Gitblit v1.9.3