From 2bb42c9235f920679d00362cc76c8cfd5eab9931 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 25 十月 2022 15:32:53 +0800
Subject: [PATCH] 1
---
data/db_fn.sql | 36 ++++++------------
说明.txt | 32 ++++++++++++++++
2 files changed, 44 insertions(+), 24 deletions(-)
diff --git a/data/db_fn.sql b/data/db_fn.sql
index e81b261..335da85 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -50,7 +50,6 @@
select * from pg_class order by relnamespace;
select relnamespace,relkind,relname from pg_class where relnamespace in (select oid from pg_namespace) and relkind='r' order by 1,2;
-
select c.relname as "琛ㄥ悕", cast(obj_description(c.oid) as varchar) as "琛ㄥ悕鎻忚堪",
a.attnum as "搴忓彿", a.attname as "鍒楀悕",
concat_ws('', t.typname, SUBSTRING(format_type(a.atttypid, a.atttypmod) from '\(.*\)')) as "瀛楁绫诲瀷",
@@ -103,12 +102,10 @@
end;
$$ language plpgsql;
-select fn_rec_query(1, 'dep');
-select fn_rec_query(21, 'dep');
+select fn_rec_query(1, 'dep'); select fn_rec_query(21, 'dep');
select * from lf.sys_dep order by id;
-select fn_rec_query(10, 'dir');
-select fn_rec_query(28, 'dir');
+select fn_rec_query(10, 'dir'); select fn_rec_query(28, 'dir');
select * from lf.sys_dir order by id;
select a.*, fn_rec_query(a.depid, 'dep') depName from lf.sys_user a order by a.id;
@@ -153,9 +150,8 @@
$$ language plpgsql;
select fn_rec_array(1, 'dep');
-select * from lf.sys_user a where a.depid=ANY(fn_rec_array(15,'dep'));
-
select fn_rec_array(10, 'dir');
+select * from lf.sys_user a where a.depid=ANY(fn_rec_array(15,'dep'));
----------------------------------------------------------------------------------------------------- g.绱㈠紩
alter table lf.sys_role_user add constraint idx_unique_role_user unique (roleid, userid); -- 鑱斿悎鍞竴绱㈠紩
insert into lf.sys_role_user (roleid,userid) values (1,1); -- 娴嬭瘯
@@ -183,24 +179,10 @@
select a.*,fn_rec_query(a.depid, 'dep') depName,fn_rec_query(a.dirid, 'dir') dirName from lf.sys_style a;
------------------------------------------------------------
-select * from lf.sys_auth;
-select * from lf.sys_menu;
-select * from lf.sys_menu_auth;
-
select * from lf.sys_auth a left join lf.sys_menu;
select a.* from lf.sys_auth a where not exists (select b.id from lf.sys_menu_auth b where b.authid = a.id and b.menuid = 1);
-------------------------------------------------------------
-select * from lf.sys_res;
-select * from lf.sys_role;
-select * from lf.sys_role_res;` `
select a.* from lf.sys_res a where not exists (select b.id from lf.sys_role_res b where b.resid = a.id and b.roleid = 1);
-
-select * from lf.sys_role;
-select * from lf.sys_menu;
-select * from lf.sys_auth;
-select * from lf.sys_menu_auth;
-select * from lf.sys_role_menu_auth;
select a.*,c.name from lf.sys_menu_auth a inner join lf.sys_auth c on a.authid = c.id
where not exists (select b.id from lf.sys_role_menu_auth b where b.menu_auth_id = a.id and b.roleid = 1) and a.menuid = 1 order by c.id;
@@ -215,7 +197,6 @@
delete from lf.sys_operate where modular1 is null or modular2 is null;
-----------------------------------------------------------------------------------------------------
select gid,gb,name,st_astext(a.geom) from bd.dlg_agnp a;
-select * from lf.sys_menu;
-- 鏍规嵁鐢ㄦ埛Uid鏌ヨ璧勬簮
select distinct d.id,d.name,d.server from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid
@@ -248,12 +229,12 @@
inner join lf.sys_menu e on d.menuid = e.id
inner join lf.sys_auth f on d.authid = f.id
where a.uid = 'admin';
-
+---------------------------------------------------------------------------------------------- 鏁版嵁缁熻
select modular2,count(*) from lf.sys_operate group by modular2;
select to_char(optime,'yyyy-mm-dd') as optime,count(*) from lf.sys_login where optime between (select optime - interval '30 day')
and optime group by to_char(optime, 'yyyy-mm-dd') order by to_char(optime, 'yyyy-mm-dd') asc;
-
+-----------------------------------------------------------------------------------------------------
select * from lf.sys_user;
select * from lf.sys_menu order by id;
@@ -261,3 +242,10 @@
+
+
+
+
+
+
+
diff --git "a/\350\257\264\346\230\216.txt" "b/\350\257\264\346\230\216.txt"
index 68d261d..a179e54 100644
--- "a/\350\257\264\346\230\216.txt"
+++ "b/\350\257\264\346\230\216.txt"
@@ -118,6 +118,38 @@
琛ㄥ崟鏍￠獙锛歷alidator
private static final String SQLSERVER_URL = "jdbc:sqlserver://192.168.0.77\\ZKZS;databaseName=xian";
+------------------------------------------------------------------------------------------------ 鏉冮檺
+缁煎悎灞曠ず\缁煎悎灞曠ず\鏌ヨ锛� 涓嬭浇銆佷笂浼�
+缁煎悎灞曠ず\缁煎悎灞曠ず\鏍囩粯锛� 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼�
+缁煎悎灞曠ず\涓撻鍥撅細 缁熻
+缁煎悎灞曠ず\璧勬枡棣嗭細 涓嬭浇
+-------------------------------------------
+鏁版嵁绠＄悊\鏁版嵁涓婁紶锛� 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼犮�佷笅杞�
+鏁版嵁绠＄悊\鐩綍绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
+鏁版嵁绠＄悊\鏁版嵁妫�绱細 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼犮�佷笅杞�
+鏁版嵁绠＄悊\鐗堟湰绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
+鏁版嵁绠＄悊\瀛楀吀绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
+鏁版嵁绠＄悊\鍏冩暟鎹鐞�: 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼犮�佷笅杞�
+鏁版嵁绠＄悊\鏍峰紡绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼犮�佷笅杞�
+-------------------------------------------
+杩愮淮绠＄悊\绯荤粺绠＄悊\鑿滃崟绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\绯荤粺绠＄悊\鐢ㄦ埛绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\绯荤粺绠＄悊\鍗曚綅绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\绯荤粺绠＄悊\璧勬簮绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄ゃ�佷笂浼�
+杩愮淮绠＄悊\绯荤粺绠＄悊\瑙掕壊绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\绯荤粺绠＄悊\鏉冮檺绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
+
+杩愮淮绠＄悊\鎺堟潈绠＄悊\鐢ㄦ埛瑙掕壊鎺堟潈锛氭柊澧炪�佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\鎺堟潈绠＄悊\鑿滃崟鏉冮檺鎺堟潈锛氭柊澧炪�佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\鎺堟潈绠＄悊\瑙掕壊鑿滃崟鎺堟潈锛氭柊澧炪�佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\鎺堟潈绠＄悊\瑙掕壊璧勬簮鎺堟潈锛氭柊澧炪�佷慨鏀广�佸垹闄�
+
+杩愮淮绠＄悊\杩愮淮鐩戞帶\鐧诲綍鏃ュ織锛� 鏂板銆佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\杩愮淮鐩戞帶\鎿嶄綔鏃ュ織锛� 鏂板銆佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\杩愮淮鐩戞帶\璧勬簮鏃ュ織锛� 鏂板銆佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\杩愮淮鐩戞帶\浠ょ墝绠＄悊锛� 鏂板銆佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\杩愮淮鐩戞帶\榛戠櫧/鍚嶅崟锛� 鏂板銆佷慨鏀广�佸垹闄�
+杩愮淮绠＄悊\绯荤粺閰嶇疆: 淇敼
----------------------------------------------------------------------------------------------------
{
"id": 2,
--
Gitblit v1.9.3