Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

javaÊ÷Ðνṹ

×î½ü¿´µ½Ò»¸öÓÐÒâ˼µÄÊ÷Ðνṹ£¬ÎªÃ¿¸ö½ÚµãÌí¼ÓÁËlftºÍrgtÁ½¸öÊôÐÔ¡£ÕâÑù²éÕҸýڵãµÄ×ӽڵ㡢²éÕҸýڵãËùÓи¸½Úµã£¬¾Í²»ÓÃÈ¥µÝ¹é²éѯ£¬Ö»ÐèÒªÓÃbetween¡¢andÓï¾ä¾Í¿ÉÒÔʵÏÖ¡£ÏÂÃæÒÔ´´½¨Ò»¸öÀ¸Ä¿Ê÷ΪÀý£¬ÒÔÏÂÊÇÎÒµÄÀí½â¡£
¡¡¡¡Ò»°ãÀ´½²£¬ÎÒÃÇ´´½¨À¸Ä¿Ê÷µÄʱºò£¬´ó¶àÖ»ÐèÒªÒ»¸öÍâ¼üparentidÀ´Çø·Ö¸Ã½ÚµãÊôÓÚÄĸö¸¸½Úµã¡£Êý¾Ý¿âµÄÉè¼ÆÈçÏÂͼ£º
ÕâÑùÒ»À´£¬


1.²éÕҸýڵãµÄËùÓÐ×ӽڵ㣬ÔòÐèÒª²ÉÓÃsqlµÄµÝ¹éÓï¾ä£º

Sql´úÂë
select * from tableName connect by prior id=sj_parent_id start with  id=1  
select * from tableName connect by prior id=sj_parent_id start with id=1
 (oracle Ð´·¨£¬mysqlÄ¿Ç°²»Ö§³Ö£¬Èç¹ûmysqlÏë²éÕÒÊ÷ÐΣ¬¿ÉÒÔÀûÓô洢¹ý³Ì).

2.²éÕҸýڵãµÄ¸¸½ÚµãµÄsqlµÝ¹éÓï¾ä£º

Sql´úÂë
select * from tableName connect by prior sj_parent_id =id start with  id=1  
select * from tableName connect by prior sj_parent_id =id start with id=1
 
¡¡Èç¹ûÊý¾ÝÁ¿¹ý´ó»òÕß²ã´ÎÌ«¶à£¬ÄÇôÕâÑù²Ù×÷ÊÇ»áÓ°ÏìÐÔÄܵġ£

¡¡¡¡“ÈκÎÊ÷Ðνṹ¶¼¿ÉÒÔÓöþ²æÊ÷À´±íʾ”¡£ÆäʵÎÒÃÇ´´½¨µÄÀ¸Ä¿Ê÷¾ÍÊÇÒ»¸ö¼òÐ͵Ķþ²æÊ÷¡£¸ù¾ÝÊý¾Ý½á¹¹ÀïÃæ¶þ²æÊ÷µÄ±éÀú£¬ÔÙÉÔ΢ÐÞ¸ÄÏ£¬½«Êý¾Ý¿âÉè¼ÆÈçÏÂͼËùʾ£º

ÕâÑùÎÒÃDzéÕҸýڵãµÄËùÓÐ×ӽڵ㣬ÔòÖ»ÐèÒª²éÕÒidÔÚlftºÍrgtÖ®¼äµÄËùÓнڵ㼴¿É¡£
<!--EndFragment-->
Sql´úÂë
select * from tb_subject s,tb_subject t where s.lft between t.lft and t.rgt and t.id=1  
select * from tb_subject s,tb_subject t where s.lft between t.lft and t.rgt and t.id=1
 
2.²éÕҸýڵãµÄËùÓи¸½ÚµãµÄsqlÓï¾äΪ£º
<!--EndFragment-->
Sql´úÂë
select s.* from tb_subject s,tb_subject t where s.lft<t.lft and (s.rgt-s.lft)>1 and s.rgt>t.rgt and t.id=1  
select s.* from tb_subject s,tb_subject t where s.lft<t.lft and (s.rgt-s.lft)>1 and s.rgt>t.rgt and t.id=1
 
¡¡ÏÂÃæÀ


Ïà¹ØÎĵµ£º

Java½Ó¿ÚºÍJava³éÏóÀà

ÔÚûÓкúõØÑÐÏ°ÃæÏò¶ÔÏóÉè¼ÆµÄÉè¼Æģʽ֮ǰ£¬ÎÒ¶ÔJava½Ó¿ÚºÍJava³éÏóÀàµÄÈÏʶ»¹ÊǺÜÄ£ºý£¬ºÜ²»¿ÉÀí½â¡£
¸ÕѧJavaÓïÑÔʱ£¬¾ÍºÜÄÑÀí½âΪʲôҪÓнӿÚÕâ¸ö¸ÅÄËä˵ÊÇ¿ÉÒÔʵÏÖËùνµÄ¶à¼Ì³Ð£¬¿ÉÒ»¸öÖ»Óз½·¨Ãû£¬Ã»Óз½·¨ÌåµÄ¶«Î÷£¬ÎÒʵÏÖËüÓÖÓÐʲôÓÃÄØ£¿ÎÒ´ÓËüÄÇʲôҲµÃ²»µ½£¬³ýÁËһЩ·½·¨Ãû£¬ÎÒÖ±½ÓÔÚ¾ßÌåÀàÀï¼ÓÈëÕâЩ·½ ......

Flex Spring JAVA BLAZEDSÕûºÏ

Ô­ÎĵØÖ·£ºhttp://www.javaeye.com/topic/392836
¹ØÓÚFlex
Adobe FlexÊÇÒ»Ì×´´½¨¸»¿Í»§¶ËÓ¦ÓÃ(RIAs)µÄ¿ò¼Ü.FlexÉú³ÉµÄswfÎļþ¿ÉÒÔÖ±½ÓÔËÐÐÔÚFlash PlayerÖ®ÖС£Ïà±È½Ï»ùÓÚʱ¼äÖáµÄFlash¿ª·¢£¬Flex¿ò¼Ü¸üÊʺÏÄÇЩÓô«Í³·½Ê½¿ª·¢Ó¦ÓóÌÐòµÄ¿ª·¢ÈËÔ±¡£FlexÓ¦ÓÿÉÒÔʹÓÃFlex builderÀ´¿ª·¢¡£ÕâÌ×IDEÊÇ»ùÓÚEclipseƽ̨¿ª·¢µÄ¡£ ......

JavaÖÐͨ¹ýDWR»ñÈ¡session¡¢request¡¢response

ÔÚDWRÖÐÐèÒªÓõ½session,requestµÈÕâЩ¶«Î÷µÄʱºò£¬¿ÉÒÔÓÃÒÔÏ·½·¨»ñÈ¡:
1. ʹÓÃDWRµÄAPI (ºÜ¶àÈ˶¼²»ÍƼöÕâÖÖ×ö·¨,¾­²âÊÔ,ʹÓÃÆðÀ´¿Ï¶¨Ã»ÎÊÌâ)
import uk.ltd.getahead.dwr.WebContext;
import uk.ltd.getahead.dwr.WebContextFactory;
WebContext ctx = WebContextFactory.get();
ctx.getSession()
ctx.getHttp ......

DWRÖÐJava·½·¨µÄ²ÎÊý¼°·µ»ØÖµÉÏƪ

DWRÊÇÒ»¸ö¿ò¼Ü£¬¼òµ¥µÄ˵¾ÍÊÇÄܹ»ÔÚjavascriptÖ±½Óµ÷ÓÃjava·½·¨£¬¶ø²»±Øȥдһ´ó¶ÑµÄjavascript´úÂë¡£ËüµÄʵÏÖÊÇ»ùÓÚajaxµÄ£¬¿ÉÒÔʵÏÖÎÞË¢ÐÂЧ¹û¡£
ÍøÉÏÓв»ÉÙDWRµÄÀý×Ó£¬µ«´ó¶¼Ö»ÊÇijÖÖ·½·¨µÄµ÷Ó㬱¾ÎÄÖ»ÔÚʹÓòãÃæÉϽéÉÜDWR£¬²¢²»Éæ¸ü¶àµÄ¼¼ÊõÓëÉè¼Æ£¬ÆäÄ¿µÄÊÇÈóõѧÕßÄܹ»ºÜ¿ìµÄѧ»á¸÷ÖÖjava·½·¨ÔÚjavascriptÖÐÊÇÈçºÎµ ......

Java]JAVA»ñÈ¡Ïà¶Ô·¾¶ÎÊÌâµÄ½â¾ö

(ת£ºhttp://blog.csdn.net/alex197963/archive/2008/03/26/2219994.aspx)
1.»ù±¾¸ÅÄîµÄÀí½â
¡¡¡¡¾ø¶Ô·¾¶:¾ø¶Ô·¾¶¾ÍÊÇÄãµÄÖ÷Ò³ÉϵÄÎļþ»òĿ¼ÔÚÓ²ÅÌÉÏÕæÕýµÄ·¾¶,(URLºÍÎïÀí·¾¶)ÀýÈç:
C:xyz est.txt ´ú±íÁËtest.txtÎļþµÄ¾ø¶Ô·¾¶.http://www.sun.com/index.htmÒ²´ú±íÁËÒ»¸ö
URL¾ø¶Ô·¾¶.
¡¡¡¡Ïà¶Ô·¾¶:Ïà¶ÔÓëij¸ö» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ