From b6b0cb226fcf184525ee7b36af3a09471e9c0057 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 25 三月 2024 11:29:33 +0800
Subject: [PATCH] 修改数据统计的查询条件
---
说明.txt | 129 +++++++++++++++---------------------------
1 files changed, 47 insertions(+), 82 deletions(-)
diff --git "a/\350\257\264\346\230\216.txt" "b/\350\257\264\346\230\216.txt"
index a9302fc..a4311eb 100644
--- "a/\350\257\264\346\230\216.txt"
+++ "b/\350\257\264\346\230\216.txt"
@@ -1,8 +1,36 @@
+------------------------------------------------------------------------------- 涓撻鍥�
+case "A0": return 1200;
+case "A1": return 850;
+case "A2": return 600;
+case "A3": return 424;
+case "A4": return 300;
+------------------------------------------------------------------------------- 浼樺寲缃戠粶
+gpedit.msc
+璁＄畻鏈篭绠＄悊妯℃澘\缃戠粶\Qos鏁版嵁鍖呰鍒掔▼搴廫闄愬埗鍙繚鐣欏甫瀹� -> 鍚敤锛�0%
+netsh interface tcp show global # 鏌ョ湅鑷姩浼樺寲绾у埆
+
+銆愮綉缁滆繛鎺ャ�戔啋鍙抽敭銆愬睘鎬с�戔啋銆愰厤缃�戔啋銆愰珮绾с�戔啋銆愬睘鎬с�戔啋銆怲CP/UDP 鏍￠獙鍜屽嵏杞斤紙IPv6鎴栬�匢Pv4锛夈�戔啋鍙宠竟鐨勩�愬�笺�戦�夋嫨绂佺敤銆�
+銆� 婕父涓诲姩鎬� 銆戔啋銆愭渶浣庡�笺��
+銆愰�熷害/鍙屽伐銆戠殑銆愬�笺�戔啋銆�100MB 鍏ㄥ弻宸ャ�戙��
+銆愮數婧愮鐞嗐�戝叧闂�"鍏佽璁＄畻鏈哄叧闂璁惧浠ヨ妭绾︾敤鐢�".
+
+ipconfig /flushdns # 鍒锋柊DNS缂撳瓨
+TCPOptimizer.exe锛岃嚜鍔ㄤ紭鍖�
+
+regedit.msc
+HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows
+鏂板缓椤圭洰 Psched锛屽彸鍑绘柊寤� NonBestEfortLimit锛孌WORD(32-浣�)鍊间负 0銆�
+------------------------------------------------------------------------------- Postgres淇敼Data
+https://www.landui.com/docs-1599
+HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\postgresql-x64-14
+淇敼 ImagePath锛�"C:\Program Files\PostgreSQL\14cm\bin\pg_ctl.exe" runservice -N "postgresql-x64-14" -D "C:\Program Files\PostgreSQL\14cm\data" -w
+net start postgresql-x64-14 # 閲嶅惎
-------------------------------------------------------------------------------
Access锛歨ttps://blog.csdn.net/weixin_43407520/article/details/122165848
GDAL锛歨ttps://www.cnblogs.com/unlockth/p/14062076.html
-
E:\terrait\TianJin\Zip\release-1928-x64-dev\release-1928-x64\bin
+
+https://start.spring.io -> https://start.aliyun.com
-------------------------------------------------------------------------------
mklink /d "C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\geoserver\data\data\tiles" E:\TaiRui\LFData\2d\tiles
@@ -14,59 +42,32 @@
https://blog.csdn.net/qq_43444401/article/details/125649414
https://blog.csdn.net/qq_43961619/article/details/124627871
-http://127.0.0.1:12316/dict/selectCount?tab=sys_user
-http://127.0.0.1:12316/Dict/selectByPage?tab=sys_user&pageSize=10&pageIndex=0
-
-http://127.0.0.1:12316/Style/selectCount?name=edp
-http://127.0.0.1:12316/Style/selectByPage?name=edp&pageSize=10&pageIndex=0
-
-http://127.0.0.1/lf/sg/login.html
+Druid锛歨ttp://127.0.0.1:12316/server/druid/index.html
http://127.0.0.1:12316/swagger-ui.html
-http://192.168.20.106:12316/swagger-ui.html
-http://localhost:12316/sign/toIndex
-http://localhost:12316/sign/toLogin
http://127.0.0.1:12316/sign/toLogin?service=http://www.sina.com.cn
-------------------------------------------------------------------------------- 闂璁板綍
-1.鍦ㄧ嚎鍒跺浘锛氬嚭鍥炬垚鍔熻鎻愮ず淇℃伅锛岃姹傝兘澶熷畾鍒跺瓧浣撳ぇ灏忋�佺鍙锋樉绀虹瓑
-2.绯荤粺鐩戞帶锛氱姸鎬佷俊鎭厑璁稿鍑鸿〃鏍� *
-3.鍦颁笅妯″紡锛氭寕杞藉湴涓嬫ā鍨�
-4.涓夌淮鐗瑰畾鏍煎紡锛�3dm锛宔ff
-5.鏁版嵁鍙戝竷锛氭彁渚沇MS鏈嶅姟鍦板潃锛�100.10.1.169锛�103.85.165.99:8050
-6.Druid锛歨ttp://127.0.0.1:12316/server/druid/index.html
-7.Index锛歨ttp://103.85.165.99:8052/web
------------------------------------------------------------------------------- Java涓嶱ostgres绫诲瀷瀵瑰簲
- java8 postgreSQL
-1 LocalDate date
-2 LocalTime time
-3 LocalDateTime timestamp without timezone
-4 OffsetDateTime timestamp with timezone
-5 String varchar
-6 String text
-7 Integer int2
-8 Integer int4
-9 Long int8
-10 Float float4
-11 Double float8
-12 BigDecimal numeric
-13 Boolean bool
-------------------------------------------------------------------------------- 鏈搴旂殑Controller
-data/DownloadController
-data/MetaFileController
-sys/AttachController
-sys/MsgController
-
-http://127.0.0.1/data/test.kml锛岃法鍩燂細
+java8 postgreSQL
+LocalDate date
+LocalTime time
+LocalDateTime timestamp without timezone
+OffsetDateTime timestamp with timezone
+String varchar
+String text
+Integer int2
+Integer int4
+Long int8
+Float float4
+Double float8
+BigDecimal numeric
+Boolean bool
+------------------------------------------------------------------------------- 璺ㄥ煙
chrome://flags/#block-insecure-private-network-requests
Block insecure private network requests. -> Disabled
杩涘叆bin鐩綍锛岃緭鍏ワ細ogrinfo --formats锛屼腑鍥界煶娌瑰ぉ鐒舵皵绠￠亾宸ョ▼鏈夐檺鍏徃
--------------------------------------------------------------------------------
+
java鍜宩s瀹炵幇aes鍔犲瘑瑙ｅ瘑锛�
https://blog.csdn.net/weixin_30663839/article/details/114049667
-
-http://192.168.20.39:12306/
-http://192.168.20.39:12315/
-http://192.168.20.39:12316/
http://192.168.20.39:12316/server/druid/sql.html
-------------------------------------------------------------------------------
String path = System.getProperty("user.dir");
@@ -98,46 +99,10 @@
鏈嶅姟绔細鏍稿績妗嗘灦锛歋pringBoot锛屾寔涔呭眰妗嗘灦锛歁ybatis锛屽畨鍏ㄦ鏋讹細Shiro锛岀紦瀛橈細redis
鍓嶇锛欽S妗嗘灦锛歷ue.js锛屼富椤垫鏋讹細adminLTE(鍩轰簬Bootstrap)锛岃〃鏍兼彃浠讹細jqGrid锛屾爲褰㈣〃鏍硷細tree-table锛屾爲褰㈡彃浠讹細ztree锛屽脊绐楃粍浠讹細layer锛岃〃鍗曟牎楠岋細validator
private static final String SQLSERVER_URL = "jdbc:sqlserver://192.168.0.77\\ZKZS; databaseName=xian";
-------------------------------------------------------------------------------- floatserver
+
http://localhost:12316/floatserver/checkout/license
String str = EntityUtils.toString(entity, "UTF-8");
java -jar C:\360\luyten054\luyten-0.5.4.jar
-
-璇锋眰锛�8dfb75298185cbcc4b2d485fdb4f25627f7aeb4dd41329076b5015586e4d56cf755f0dfd19be0d80e2573e0a2a22edca35215b390607b0ff68deab90c69296df60934315036bd8a64ee668a39502754b701be7534d0ca2e790161194d673d9454c44c570a1dbe604ac5952be731ca15809f9f4d43ad1b023f69981ce77abacc50e8e5217627eb236d5f6d114e00585d9a597f3a195b0b0c0ff8cf1e2445ca12e
-鍝嶅簲锛�8dfb75298185cbcc4b2d485fdb4f25627f7aeb4dd41329076b5015586e4d56cfe2c56f12cd9852c447904210117b41fe2672b24d7e82fd581ad5a0983b501b5bcbe97d65dbbe770dbdc4a98e80d2966a71ecd0041a5282283bff853d70caf7aed671bc9c9d4bedf6d1d0294394861af40f195d68a965d957d53c78aa50ada3afc65d1a526c54648e6e081e8f7f7ab1c31b9f75916170e638b0b9216d30204864afe3a7a1bc8a6563bf44daf6a29e27c19f798c4f82dbb904ea4aa4fcc87a82226d9bf3e891ecb97b94263064fec025e3aa7c440d7c0e8ed559b84ae2438ec0fc438444a03c992883170ecdde20e08552efcf9d584de469930b27c81f946548d5c6e63e815671182b03b5e6e622ddb10a3f6a35ad3f44ec247a3b2dee0e936020d48efb7abc2d2abfb555f61d54c85eca
-
-{"machineId":"dba5c0f908f92fbdb6f0a3f58a5a3193","isRegistered":true,"registeredModules":[1,3,4,9,10,11,12,13,17,25,30,33,37],"modules":[{"id":1,"name":"wms","group":"GISServer","title":"鍔ㄦ�佸湴鍥炬湇鍔�"},{"id":3,"name":"tms","group":"GISServer","title":"鐡︾墖鍦板浘鏈嶅姟"},{"id":9,"name":"wfs","group":"GISServer","title":"瑕佺礌鏈嶅姟"},{"id":12,"name":"wns","group":"GISServer","title":"缃戠粶鍒嗘瀽鏈嶅姟"},{"id":13,"name":"geocode","group":"GISServer","title":"鍦扮悊缂栫爜鏈嶅姟"},{"id":17,"name":"wcs","group":"GISServer","title":"鏍呮牸鏈嶅姟"},{"id":25,"name":"c3d","group":"GISServer","title":"涓夌淮妯″瀷鏈嶅姟"},{"id":30,"name":"cts","group":"GISServer","title":"涓夌淮鍦板舰鏈嶅姟"},{"id":33,"name":"cimservice","group":"CIMSuite","title":"璇箟妯″瀷鏈嶅姟"},{"id":37,"name":"websdk","group":"WEBSDK","title":"WEBSDK"},{"id":38,"name":"pw","group":"Parallelworld","title":" Parallelworld"},{"id":50,"name":"ext","group":"extension","title":"extension"}],"expireDate":1668486201730,"isFloating":true,"floatServerIp":"192.168.20.106","floatServerPort":12316,"message":"OK","success":true}
-{"id":"dba5c0f908f92fbdb6f0a3f58a5a3193","expireDate":"2023-01-17","localId":"192.168.20.106|E0-70-EA-AA-B6-43","availableNum":12,"time":1668394770458,"licenseCode":"78a82f0920de0f557f8177bec1e48601c4dc25e4054a00728e4314b56528d3a1632de5298edee38a65412277977a174fea5d91c452b19ef138dbc2ba089ba632"}
-------------------------------------------------------------------------------- 鏉冮檺
-绠￠亾鍩虹澶ф暟鎹钩鍙帮細 鍒犻櫎
-缁煎悎灞曠ず\缁煎悎灞曠ず\鏌ヨ锛� 涓嬭浇銆佷笂浼�
-缁煎悎灞曠ず\缁煎悎灞曠ず\鏍囩粯锛� 鏂板銆佷慨鏀广�佸垹闄�
-缁煎悎灞曠ず\涓撻鍥撅細 缁熻
-缁煎悎灞曠ず\璧勬枡棣嗭細 涓嬭浇
--------------------------------------------
-鏁版嵁绠＄悊\鏁版嵁涓婁紶锛� 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼犮�佷笅杞�
-鏁版嵁绠＄悊\鐩綍绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
-鏁版嵁绠＄悊\鏁版嵁妫�绱細 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼犮�佷笅杞�
-鏁版嵁绠＄悊\鐗堟湰绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
-鏁版嵁绠＄悊\瀛楀吀绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
-鏁版嵁绠＄悊\鍏冩暟鎹鐞�: 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼犮�佷笅杞�
-鏁版嵁绠＄悊\鏍峰紡绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼犮�佷笅杞�
--------------------------------------------
-杩愮淮绠＄悊\绯荤粺绠＄悊\鑿滃崟绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
-杩愮淮绠＄悊\绯荤粺绠＄悊\鐢ㄦ埛绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
-杩愮淮绠＄悊\绯荤粺绠＄悊\鍗曚綅绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
-杩愮淮绠＄悊\绯荤粺绠＄悊\璧勬簮绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼�
-杩愮淮绠＄悊\绯荤粺绠＄悊\瑙掕壊绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
-杩愮淮绠＄悊\绯荤粺绠＄悊\鏉冮檺绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
-
-杩愮淮绠＄悊\鎺堟潈绠＄悊\鐢ㄦ埛瑙掕壊鎺堟潈锛氭柊澧炪�佷慨鏀广�佸垹闄�
-杩愮淮绠＄悊\鎺堟潈绠＄悊\鑿滃崟鏉冮檺鎺堟潈锛氭柊澧炪�佷慨鏀广�佸垹闄�
-杩愮淮绠＄悊\鎺堟潈绠＄悊\瑙掕壊鑿滃崟鎺堟潈锛氭柊澧炪�佷慨鏀广�佸垹闄�
-杩愮淮绠＄悊\鎺堟潈绠＄悊\瑙掕壊璧勬簮鎺堟潈锛氭柊澧炪�佷慨鏀广�佸垹闄�
-
-杩愮淮绠＄悊\杩愮淮鐩戞帶\浠ょ墝绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
-杩愮淮绠＄悊\杩愮淮鐩戞帶\榛戠櫧/鍚嶅崟锛� 鏂板銆佷慨鏀广�佸垹闄�
-杩愮淮绠＄悊\绯荤粺閰嶇疆: 淇敼
------------------------------------------------------------------------------- Java Web鎿嶄綔
String getMethod() // 鑾峰彇璇锋眰鏂瑰紡: GET
// 鑾峰彇铏氭嫙鐩綍(涓婁笅鏂囩洰褰�)锛氳櫄鎷熻矾寰勯�氳繃鍦╝pplication閰嶇疆褰撲腑鍙互閰嶇疆
--
Gitblit v1.9.3