oracle高级递归结算，求写法！！！

ksdy138141314 2016-05-26 03:38:28
表和数据：
with table1 as (

     select 'A' as parent_no, 'B' as no from dual union all

     select 'A' as parent_no, 'C' as no from dual union all

     select 'B' as parent_no, 'D' as no from dual union all

     select 'C' as parent_no, 'E' as no from dual union all

     select 'A' as parent_no, 'F' as no from dual union all

     select 'C' as parent_no, 'G' as no from dual union all

     select 'G' as parent_no, 'H' as no from dual

),

table2 as (

       select 'A' AS NO,3 AS no_level from dual union all

       select 'B' AS NO,NULL AS no_level from dual union all

       select 'C' AS NO,2 AS no_level from dual union all

       select 'D' AS NO,null AS no_level from dual union all

       select 'E' AS NO,null AS no_level from dual union all

       select 'F' AS NO,1 AS no_level from dual union all

       select 'G' AS NO,2 AS no_level from dual union all

       select 'H' AS NO,null AS no_level from dual

),

table3 as (

       select 'A' as no,100 as money from dual union all

       select 'B' as no,200 as money from dual union all

       select 'C' as no,300 as money from dual union all

       select 'D' as no,400 as money from dual union all

       select 'E' as no,500 as money from dual union all

       select 'F' as no,600 as money from dual union all

       select 'G' as no,700 as money from dual union all

       select 'H' as no,800 as money from dual        

)



关系图：


有如上3张表，table1表示用户之间的关系，table2表示用户的等级，table3表示用户的钱。


现在需要结算有等级的用户(没有等级的用户没有提成)，比如A用户等级是3，那A用户就根据这个关系，提下级用户的成，提成规则如下：
其他用户都是A用户的下级，A的等级为3，表示A需要提成3个层级的用户。但这个层级不是图中看到的层级关系。因为A的下级用户C,F,G都有等级，提成第一层money的时候，提B,C,F 三个用户的money，提成第二层money的时候，提E,G，提成第三层money的时候，提H用户的money。

说明一下，提成第一层的时候，没有悬念。提成第二层的时候，为什么只提成E,G，不提成D呢？？因为D的直属是B，而B没有等级，所以在提成第一层B的时候，就已经计算过B的直属下级没有等级会员的money，就不能重复提D了。E也没有等级，但E的直属上级C有等级，在提成C的时候，因为C有等级，所以只提了C。C的所有下级并没有提，所以在提成第二层的时候，E就要提成了。G也一样需要提成。那为什么在提成第二层的时候，H没有提成？因为G有等级。所以有等级的用户，只能提自己的money，如果用户等级够高，还能继续往下提成，就可以提H用户的money。但如果图中还有一个用户I是E的下级且没有等级，那提成第三层的时候，是不能提I用户的。因为I用户的money已经算在E用户里面了。

A的期望结果：

用户 所得提成(比如提成都是5%) 提供提成的会员
A 10 B
A 15 C
A 30 F
A 25 E
A 35 G
A 40 H

PS: 如果可以一个sql更好，可以多个sql
...全文
188 10 打赏 收藏 转发到动态 举报
写回复
用AI写文章
10 条回复
切换为时间正序
请发表友善的回复…
发表回复
ghx287524027 2016-05-27
  • 打赏
  • 举报
 回复 


with table1 as

 (select 'A' as parent_no, 'B' as no from dual union all

  select 'A' as parent_no, 'C' as no from dual union all

  select 'B' as parent_no, 'D' as no from dual union all

  select 'C' as parent_no, 'E' as no from dual union all

  select 'A' as parent_no, 'F' as no from dual union all

  select 'C' as parent_no, 'G' as no from dual union all

  select 'G' as parent_no, 'H' as no from dual union all

  select 'H' as parent_no, 'I' as no from dual),

table2 as

 (select 'A' AS NO, 3 AS no_level from dual union all

  select 'B' AS NO, NULL AS no_level from dual union all

  select 'C' AS NO, 2 AS no_level from dual union all

  select 'D' AS NO, null AS no_level from dual union all

  select 'E' AS NO, null AS no_level from dual union all

  select 'F' AS NO, 1 AS no_level from dual union all

  select 'G' AS NO, 2 AS no_level from dual union all

  select 'H' AS NO, null AS no_level from dual UNION ALL

  select 'I' AS NO, 1 AS no_level from dual),

table3 as

 (select 'A' as no, 100 as money from dual union all

  select 'B' as no, 200 as money from dual union all

  select 'C' as no, 300 as money from dual union all

  select 'D' as no, 400 as money from dual union all

  select 'E' as no, 500 as money from dual union all

  select 'F' as no, 600 as money from dual union all

  select 'G' as no, 700 as money from dual union all

  select 'H' as no, 800 as money from dual UNION ALL

  select 'I' as no, 900 as money from dual)

,

table4 as

(

select CONNECT_BY_ROOT(a.parent_no) root, a.no, level lv

  from (select b.parent_no,b.no from table1 b where b.parent_no in (select c.no from table2 c where c.no=b.parent_no and c.no_level is not null)) a

connect by prior a.no = a.parent_no 

union all

select a.no root,a.no,1 as lv from table2 a

where a.no_level is not null and a.no not in (select parent_no from table1 )

)



select t4.root, t4.no, t3.money * 0.05 as money

  from table4 t4, table1 t1, table2 t2, table3 t3

 where t4.no = t1.no

   and t1.parent_no = t2.no

   and t1.no = t3.no

   and (lv = 1 or (lv > 1 and not t2.no_level is null))


结果如下：

ksdy138141314 2016-05-27
  • 打赏
  • 举报
 回复
如果E下面有个用户J，J没有等级的话，那A是取不到J的，因为在取E的时候，就已经把J算进去了。
引用 6 楼 ghx287524027 的回复:
A能不能提取到I 呢？
ksdy138141314 2016-05-27
  • 打赏
  • 举报
 回复
引用 6 楼 ghx287524027 的回复:
A能不能提取到I 呢？
可以取到，取到I这个用户的money
ghx287524027 2016-05-27
  • 打赏
  • 举报
 回复
A能不能提取到I 呢？
ksdy138141314 2016-05-27
  • 打赏
  • 举报
 回复
引用 4 楼 ghx287524027 的回复:
[quote=引用 3 楼 ksdy138141314 的回复:] [quote=引用 1 楼 snbxp 的回复:] 

with table1 as
 (select 'A' as parent_no, 'B' as no from dual union all
  select 'A' as parent_no, 'C' as no from dual union all
  select 'B' as parent_no, 'D' as no from dual union all
  select 'C' as parent_no, 'E' as no from dual union all
  select 'A' as parent_no, 'F' as no from dual union all
  select 'C' as parent_no, 'G' as no from dual union all
  select 'G' as parent_no, 'H' as no from dual),
table2 as
 (select 'A' AS NO, 3 AS no_level from dual union all
  select 'B' AS NO, NULL AS no_level from dual union all
  select 'C' AS NO, 2 AS no_level from dual union all
  select 'D' AS NO, null AS no_level from dual union all
  select 'E' AS NO, null AS no_level from dual union all
  select 'F' AS NO, 1 AS no_level from dual union all
  select 'G' AS NO, 2 AS no_level from dual union all
  select 'H' AS NO, null AS no_level from dual),
table3 as
 (select 'A' as no, 100 as money from dual union all
  select 'B' as no, 200 as money from dual union all
  select 'C' as no, 300 as money from dual union all
  select 'D' as no, 400 as money from dual union all
  select 'E' as no, 500 as money from dual union all
  select 'F' as no, 600 as money from dual union all
  select 'G' as no, 700 as money from dual union all
  select 'H' as no, 800 as money from dual),
table4 as
(
select CONNECT_BY_ROOT(parent_no) root, no, level lv
  from table1 a
connect by prior no = a.parent_no
)
select t4.root, t4.no, t3.money * 0.05
  from table4 t4, table1 t1, table2 t2, table3 t3
 where t4.no = t1.no
   and t1.parent_no = t2.no
   and t1.no = t3.no
   and (lv = 1 or (lv > 1 and not t2.no_level is null))
   and t4.root='A'
首先感谢哥们，但我发现有一种情况没有统计到。如果H用户下面还有一个有等级的用户I。按照你给的sql。统计不到I用户的提成，数据如下： 
with table1 as
 (select 'A' as parent_no, 'B' as no from dual union all
  select 'A' as parent_no, 'C' as no from dual union all
  select 'B' as parent_no, 'D' as no from dual union all
  select 'C' as parent_no, 'E' as no from dual union all
  select 'A' as parent_no, 'F' as no from dual union all
  select 'C' as parent_no, 'G' as no from dual union all
  select 'G' as parent_no, 'H' as no from dual union all
  select 'H' as parent_no, 'I' as no from dual),
table2 as
 (select 'A' AS NO, 3 AS no_level from dual union all
  select 'B' AS NO, NULL AS no_level from dual union all
  select 'C' AS NO, 2 AS no_level from dual union all
  select 'D' AS NO, null AS no_level from dual union all
  select 'E' AS NO, null AS no_level from dual union all
  select 'F' AS NO, 1 AS no_level from dual union all
  select 'G' AS NO, 2 AS no_level from dual union all
  select 'H' AS NO, null AS no_level from dual UNION ALL
  select 'I' AS NO, 1 AS no_level from dual),
table3 as
 (select 'A' as no, 100 as money from dual union all
  select 'B' as no, 200 as money from dual union all
  select 'C' as no, 300 as money from dual union all
  select 'D' as no, 400 as money from dual union all
  select 'E' as no, 500 as money from dual union all
  select 'F' as no, 600 as money from dual union all
  select 'G' as no, 700 as money from dual union all
  select 'H' as no, 800 as money from dual UNION ALL
  select 'I' as no, 900 as money from dual)
[/quote] 如果I在H下面，那么要提取I的话，H不应该要有等级的吗？[/quote] 要不要提取奖金，和下级会员的等级没关系，只要能提这么多层就可以。提G这个用户的时候，只提了G这个点，提H这个用户的时候，如果下级用户I有等级，那也只能提H用户这个点，如果还能提下一层，那就是I这个点。
ghx287524027 2016-05-27
  • 打赏
  • 举报
 回复
引用 3 楼 ksdy138141314 的回复:
[quote=引用 1 楼 snbxp 的回复:] 

with table1 as
 (select 'A' as parent_no, 'B' as no from dual union all
  select 'A' as parent_no, 'C' as no from dual union all
  select 'B' as parent_no, 'D' as no from dual union all
  select 'C' as parent_no, 'E' as no from dual union all
  select 'A' as parent_no, 'F' as no from dual union all
  select 'C' as parent_no, 'G' as no from dual union all
  select 'G' as parent_no, 'H' as no from dual),
table2 as
 (select 'A' AS NO, 3 AS no_level from dual union all
  select 'B' AS NO, NULL AS no_level from dual union all
  select 'C' AS NO, 2 AS no_level from dual union all
  select 'D' AS NO, null AS no_level from dual union all
  select 'E' AS NO, null AS no_level from dual union all
  select 'F' AS NO, 1 AS no_level from dual union all
  select 'G' AS NO, 2 AS no_level from dual union all
  select 'H' AS NO, null AS no_level from dual),
table3 as
 (select 'A' as no, 100 as money from dual union all
  select 'B' as no, 200 as money from dual union all
  select 'C' as no, 300 as money from dual union all
  select 'D' as no, 400 as money from dual union all
  select 'E' as no, 500 as money from dual union all
  select 'F' as no, 600 as money from dual union all
  select 'G' as no, 700 as money from dual union all
  select 'H' as no, 800 as money from dual),
table4 as
(
select CONNECT_BY_ROOT(parent_no) root, no, level lv
  from table1 a
connect by prior no = a.parent_no
)
select t4.root, t4.no, t3.money * 0.05
  from table4 t4, table1 t1, table2 t2, table3 t3
 where t4.no = t1.no
   and t1.parent_no = t2.no
   and t1.no = t3.no
   and (lv = 1 or (lv > 1 and not t2.no_level is null))
   and t4.root='A'
首先感谢哥们，但我发现有一种情况没有统计到。如果H用户下面还有一个有等级的用户I。按照你给的sql。统计不到I用户的提成，数据如下： 
with table1 as
 (select 'A' as parent_no, 'B' as no from dual union all
  select 'A' as parent_no, 'C' as no from dual union all
  select 'B' as parent_no, 'D' as no from dual union all
  select 'C' as parent_no, 'E' as no from dual union all
  select 'A' as parent_no, 'F' as no from dual union all
  select 'C' as parent_no, 'G' as no from dual union all
  select 'G' as parent_no, 'H' as no from dual union all
  select 'H' as parent_no, 'I' as no from dual),
table2 as
 (select 'A' AS NO, 3 AS no_level from dual union all
  select 'B' AS NO, NULL AS no_level from dual union all
  select 'C' AS NO, 2 AS no_level from dual union all
  select 'D' AS NO, null AS no_level from dual union all
  select 'E' AS NO, null AS no_level from dual union all
  select 'F' AS NO, 1 AS no_level from dual union all
  select 'G' AS NO, 2 AS no_level from dual union all
  select 'H' AS NO, null AS no_level from dual UNION ALL
  select 'I' AS NO, 1 AS no_level from dual),
table3 as
 (select 'A' as no, 100 as money from dual union all
  select 'B' as no, 200 as money from dual union all
  select 'C' as no, 300 as money from dual union all
  select 'D' as no, 400 as money from dual union all
  select 'E' as no, 500 as money from dual union all
  select 'F' as no, 600 as money from dual union all
  select 'G' as no, 700 as money from dual union all
  select 'H' as no, 800 as money from dual UNION ALL
  select 'I' as no, 900 as money from dual)
[/quote] 如果I在H下面，那么要提取I的话，H不应该要有等级的吗？
ghx287524027 2016-05-27
  • 打赏
  • 举报
 回复 

with table1 as
 (select 'A' as parent_no, 'B' as no from dual union all
  select 'A' as parent_no, 'C' as no from dual union all
  select 'B' as parent_no, 'D' as no from dual union all
  select 'C' as parent_no, 'E' as no from dual union all
  select 'A' as parent_no, 'F' as no from dual union all
  select 'C' as parent_no, 'G' as no from dual union all
  select 'G' as parent_no, 'H' as no from dual union all
  select 'H' as parent_no, 'I' as no from dual),
table2 as
 (select 'A' AS NO, 3 AS no_level from dual union all
  select 'B' AS NO, NULL AS no_level from dual union all
  select 'C' AS NO, 2 AS no_level from dual union all
  select 'D' AS NO, null AS no_level from dual union all
  select 'E' AS NO, null AS no_level from dual union all
  select 'F' AS NO, 1 AS no_level from dual union all
  select 'G' AS NO, 2 AS no_level from dual union all
  select 'H' AS NO, null AS no_level from dual UNION ALL
  select 'I' AS NO, 1 AS no_level from dual),
table3 as
 (select 'A' as no, 100 as money from dual union all
  select 'B' as no, 200 as money from dual union all
  select 'C' as no, 300 as money from dual union all
  select 'D' as no, 400 as money from dual union all
  select 'E' as no, 500 as money from dual union all
  select 'F' as no, 600 as money from dual union all
  select 'G' as no, 700 as money from dual union all
  select 'H' as no, 800 as money from dual UNION ALL
  select 'I' as no, 900 as money from dual)
,
table4 as
(
select b.root,b.no,b.lv from
(select CONNECT_BY_ROOT(a.parent_no) root, a.no, level lv
  from table1 a
connect by prior a.no = a.parent_no ) b
where b.root in (select c.no from table2 c where c.no=b.root and c.no_level is not null)
)
  
select distinct t4.root, t4.no, t3.money * 0.05 as money
  from table4 t4, table1 t1, table2 t2, table3 t3
 where t4.no = t1.no
   and t1.no = t3.no
   and ((t1.parent_no = t2.no and t2.no_level is not null) or (t4.no=t2.no and t2.no_level is not null))
ksdy138141314 2016-05-26
  • 打赏
  • 举报
 回复
引用 1 楼 snbxp 的回复:

with table1 as
 (select 'A' as parent_no, 'B' as no from dual union all
  select 'A' as parent_no, 'C' as no from dual union all
  select 'B' as parent_no, 'D' as no from dual union all
  select 'C' as parent_no, 'E' as no from dual union all
  select 'A' as parent_no, 'F' as no from dual union all
  select 'C' as parent_no, 'G' as no from dual union all
  select 'G' as parent_no, 'H' as no from dual),
table2 as
 (select 'A' AS NO, 3 AS no_level from dual union all
  select 'B' AS NO, NULL AS no_level from dual union all
  select 'C' AS NO, 2 AS no_level from dual union all
  select 'D' AS NO, null AS no_level from dual union all
  select 'E' AS NO, null AS no_level from dual union all
  select 'F' AS NO, 1 AS no_level from dual union all
  select 'G' AS NO, 2 AS no_level from dual union all
  select 'H' AS NO, null AS no_level from dual),
table3 as
 (select 'A' as no, 100 as money from dual union all
  select 'B' as no, 200 as money from dual union all
  select 'C' as no, 300 as money from dual union all
  select 'D' as no, 400 as money from dual union all
  select 'E' as no, 500 as money from dual union all
  select 'F' as no, 600 as money from dual union all
  select 'G' as no, 700 as money from dual union all
  select 'H' as no, 800 as money from dual),
table4 as
(
select CONNECT_BY_ROOT(parent_no) root, no, level lv
  from table1 a
connect by prior no = a.parent_no
)
select t4.root, t4.no, t3.money * 0.05
  from table4 t4, table1 t1, table2 t2, table3 t3
 where t4.no = t1.no
   and t1.parent_no = t2.no
   and t1.no = t3.no
   and (lv = 1 or (lv > 1 and not t2.no_level is null))
   and t4.root='A'
首先感谢哥们，但我发现有一种情况没有统计到。如果H用户下面还有一个有等级的用户I。按照你给的sql。统计不到I用户的提成，数据如下： 
with table1 as
 (select 'A' as parent_no, 'B' as no from dual union all
  select 'A' as parent_no, 'C' as no from dual union all
  select 'B' as parent_no, 'D' as no from dual union all
  select 'C' as parent_no, 'E' as no from dual union all
  select 'A' as parent_no, 'F' as no from dual union all
  select 'C' as parent_no, 'G' as no from dual union all
  select 'G' as parent_no, 'H' as no from dual union all
  select 'H' as parent_no, 'I' as no from dual),
table2 as
 (select 'A' AS NO, 3 AS no_level from dual union all
  select 'B' AS NO, NULL AS no_level from dual union all
  select 'C' AS NO, 2 AS no_level from dual union all
  select 'D' AS NO, null AS no_level from dual union all
  select 'E' AS NO, null AS no_level from dual union all
  select 'F' AS NO, 1 AS no_level from dual union all
  select 'G' AS NO, 2 AS no_level from dual union all
  select 'H' AS NO, null AS no_level from dual UNION ALL
  select 'I' AS NO, 1 AS no_level from dual),
table3 as
 (select 'A' as no, 100 as money from dual union all
  select 'B' as no, 200 as money from dual union all
  select 'C' as no, 300 as money from dual union all
  select 'D' as no, 400 as money from dual union all
  select 'E' as no, 500 as money from dual union all
  select 'F' as no, 600 as money from dual union all
  select 'G' as no, 700 as money from dual union all
  select 'H' as no, 800 as money from dual UNION ALL
  select 'I' as no, 900 as money from dual)
ksdy138141314 2016-05-26
  • 打赏
  • 举报
 回复
引用 1 楼 snbxp 的回复:

with table1 as
 (select 'A' as parent_no, 'B' as no from dual union all
  select 'A' as parent_no, 'C' as no from dual union all
  select 'B' as parent_no, 'D' as no from dual union all
  select 'C' as parent_no, 'E' as no from dual union all
  select 'A' as parent_no, 'F' as no from dual union all
  select 'C' as parent_no, 'G' as no from dual union all
  select 'G' as parent_no, 'H' as no from dual),
table2 as
 (select 'A' AS NO, 3 AS no_level from dual union all
  select 'B' AS NO, NULL AS no_level from dual union all
  select 'C' AS NO, 2 AS no_level from dual union all
  select 'D' AS NO, null AS no_level from dual union all
  select 'E' AS NO, null AS no_level from dual union all
  select 'F' AS NO, 1 AS no_level from dual union all
  select 'G' AS NO, 2 AS no_level from dual union all
  select 'H' AS NO, null AS no_level from dual),
table3 as
 (select 'A' as no, 100 as money from dual union all
  select 'B' as no, 200 as money from dual union all
  select 'C' as no, 300 as money from dual union all
  select 'D' as no, 400 as money from dual union all
  select 'E' as no, 500 as money from dual union all
  select 'F' as no, 600 as money from dual union all
  select 'G' as no, 700 as money from dual union all
  select 'H' as no, 800 as money from dual),
table4 as
(
select CONNECT_BY_ROOT(parent_no) root, no, level lv
  from table1 a
connect by prior no = a.parent_no
)
select t4.root, t4.no, t3.money * 0.05
  from table4 t4, table1 t1, table2 t2, table3 t3
 where t4.no = t1.no
   and t1.parent_no = t2.no
   and t1.no = t3.no
   and (lv = 1 or (lv > 1 and not t2.no_level is null))
   and t4.root='A'
非常感谢，我替换到开发环境中看看实际的数据。先谢过
snbxp 2016-05-26
  • 打赏
  • 举报
 回复 

with table1 as
 (select 'A' as parent_no, 'B' as no from dual union all
  select 'A' as parent_no, 'C' as no from dual union all
  select 'B' as parent_no, 'D' as no from dual union all
  select 'C' as parent_no, 'E' as no from dual union all
  select 'A' as parent_no, 'F' as no from dual union all
  select 'C' as parent_no, 'G' as no from dual union all
  select 'G' as parent_no, 'H' as no from dual),
table2 as
 (select 'A' AS NO, 3 AS no_level from dual union all
  select 'B' AS NO, NULL AS no_level from dual union all
  select 'C' AS NO, 2 AS no_level from dual union all
  select 'D' AS NO, null AS no_level from dual union all
  select 'E' AS NO, null AS no_level from dual union all
  select 'F' AS NO, 1 AS no_level from dual union all
  select 'G' AS NO, 2 AS no_level from dual union all
  select 'H' AS NO, null AS no_level from dual),
table3 as
 (select 'A' as no, 100 as money from dual union all
  select 'B' as no, 200 as money from dual union all
  select 'C' as no, 300 as money from dual union all
  select 'D' as no, 400 as money from dual union all
  select 'E' as no, 500 as money from dual union all
  select 'F' as no, 600 as money from dual union all
  select 'G' as no, 700 as money from dual union all
  select 'H' as no, 800 as money from dual),
table4 as
(
select CONNECT_BY_ROOT(parent_no) root, no, level lv
  from table1 a
connect by prior no = a.parent_no
)
select t4.root, t4.no, t3.money * 0.05
  from table4 t4, table1 t1, table2 t2, table3 t3
 where t4.no = t1.no
   and t1.parent_no = t2.no
   and t1.no = t3.no
   and (lv = 1 or (lv > 1 and not t2.no_level is null))
   and t4.root='A'
项目学习及其总结（黎明）
概念：递归就是一种算法或函数调用自身的过程。在递归过程中，程序会将问题分解成更小的子问题，并通过递归调用自身来解决这些子问题，直到子问题规模足够小并能够直接求解，从而得到原始问题的解；优点：是它可以帮助简化复杂的问题，因为它可以将大问题分解为小问题。递归还可以使代码更加简洁和易于理解，因为它可以更自然地表达问题本身。缺点：递归算法的效率通常较低，因为在递归过程中会产生额外的开销，如函数调用和栈空间的使用。如果递归深度太大，程序可能会因为栈溢出而崩溃。
【Java基础】全网最详细 - 从入门到转行
Java是一种通用的、高级的、面向对象的编程语言，最初由Sun Microsystems（目前为Oracle公司）于1995年发布。它被设计成一种可以在各种不同的环境中运行的语言，不论是桌面应用程序、企业级应用程序、移动设备或集群服务器，都可以使用Java来开发。Java的特点包括：简单性：Java的语法相对于其他编程语言比较简单，易于学习和理解。面向对象：Java是一种完全的面向对象编程语言，支持类、继承、封装和多态等核心特性。平台无关性：Java编写的程序可以在不同的操作系统和硬件平台上运行。
Java面试宝典
新建(new)：新创建了一个线程对象。可运行(runnable)：线程对象创建后，其他线程(比如main线程）调用了该对象的start()方法。该状态的线程位于可运行线程池中，等待被线程调度选中，获取cpu的使用权。运行(running)：可运行状态(runnable)的线程获得了cpu时间片（timeslice），执行程序代码。阻塞(block)：阻塞状态是指线程因为某种原因放弃了cpu使用权，也即让出了cpu timeslice，暂时停止运行。直到线程进入可运行(runnable。
设计模式学习（全）-七大基本原则-23种设计模式 超两万字总结！
设计模式（Design pattern）代表了最佳的实践，通常被有经验的面向对象的软件开发人员所采用。设计模式是软件开发人员在软件开发过程中面临的一般问题的解决方案。 Java版本设计模式超两万字学习笔记！...
php面试题汇总
8、redis集群怎么做 1、Redis集群提供了以下两个好处1、将数据自动切分(split)到多个节点2、当集群中的某一个节点故障时，redis还可以继续处理客户端的请求。2、集群的方案： redis-cluster集群,采用无中心结构，每个节点保存数据和整个集群状态,每个节点都和其他所有节点连接,主要通过节点的配置，辅以redis的主从来完成集群。由于这块东西我使用得...
Oracle 高级技术

3,491

社区成员

18,714

社区内容

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章