javaÊ÷Ðνṹ Ëã·¨
×î½ü¿´µ½Ò»¸öÓÐÒâ˼µÄÊ÷Ðνṹ£¬ÎªÃ¿¸ö½ÚµãÌí¼ÓÁËlft
ºÍ
rgt
Á½¸öÊôÐÔ¡£ÕâÑù²éÕҸýڵãµÄ×ӽڵ㡢
²éÕҸýڵãËùÓи¸½Úµã£¬¾Í²»ÓÃÈ¥µÝ¹é²éѯ£¬Ö»ÐèÒªÓÃ
between
¡¢
and
Óï¾ä¾Í¿ÉÒÔʵÏÖ¡£ÏÂÃæÒÔ´´½¨Ò»¸öÀ¸Ä¿Ê÷ΪÀý£¬ÒÔÏÂÊÇÎÒµÄÀí½â¡£
¡¡¡¡Ò»°ãÀ´½²£¬ÎÒÃÇ´´½¨À¸Ä¿Ê÷µÄʱºò£¬´ó¶àÖ»ÐèÒªÒ»¸öÍâ¼üparentid
À´Çø·Ö¸Ã½ÚµãÊôÓÚÄĸö¸¸½Úµã¡£Êý¾Ý¿âµÄÉè¼ÆÈçÏÂͼ£º
ÕâÑùÒ»À´£¬
1.²éÕҸýڵãµÄËùÓÐ×ӽڵ㣬ÔòÐèÒª²ÉÓÃ
sql
µÄµÝ¹éÓï¾ä£º
Sql´úÂë < type="application/x-shockwave-flash" width="14" height="15" src="http://www.javaeye.com/javascripts/syntaxhighlighter/clipboard_new.swf" src="http://www.javaeye.com/javascripts/syntaxhighlighter/clipboard_new.swf" flashvars="clipboard=select%20*%20from%20tableName%20connect%20by%20prior%20id%3Dsj_parent_id%20start%20with%20%20id%3D1" quality="high" allowscriptaccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" width="14" height="15">
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´úÂë < type="application/x-shockwave-flash" width="14" height="15" src="http://www.javaeye.com/javascripts/syntaxhighlighter/clipboard_new.swf" src="http://www.javaeye.com/javascripts/syntaxhighlighter/clipboard_new.swf" flashvars="clipboard=select%20*%20from%20tableName%20connect%20by%20prior%20sj_parent_id%20%3Did%20start%20with%20%20id%3D1" quality="high" allowscriptaccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" width="14" height="15">
select
*
from
tableName
connect
by
prior
sj_parent_id =id start
with
id=1
select * from tableName c
Ïà¹ØÎĵµ£º
javaÈ¥³ý×Ö·û´®ÖеĿոñ¡¢»Ø³µ¡¢»»Ðзû¡¢ÖƱí·û
import java.util.regex.Matcher;
import java.util.regex.Pattern;
public class StringUtil {
public static void replaceBlank()
{
Pattern p = Pattern.compile("\\s*|\t|\r|\n");
String str="I am a, I am Hello ok, \n new line ffdsa!";
System.out.p ......
ͨ¹ýʹÓÃһЩ¸¨ÖúÐÔ¹¤¾ßÀ´ÕÒµ½³ÌÐòÖÐµÄÆ¿¾±£¬È»ºó¾Í¿ÉÒÔ¶ÔÆ¿¾±²¿·ÖµÄ´úÂë½øÐÐÓÅ»¯¡£Ò»°ãÓÐÁ½ÖÖ·½°¸£º¼´ÓÅ»¯´úÂë»ò¸ü¸ÄÉè¼Æ·½·¨¡£ÎÒÃÇÒ»°ã»áÑ¡ÔñºóÕߣ¬ÒòΪ²»È¥µ÷ÓÃÒÔÏ´úÂëÒª±Èµ÷ÓÃһЩÓÅ»¯µÄ´úÂë¸üÄÜÌá¸ß³ÌÐòµÄÐÔÄÜ¡£¶øÒ»¸öÉè¼ÆÁ¼ºÃµÄ³ÌÐòÄܹ»¾«¼ò´úÂ룬´Ó¶øÌá¸ßÐÔÄÜ¡£
ÏÂÃæ½«ÌṩһЩÔÚJAVA³ÌÐòµÄÉè¼ÆºÍ±àÂëÖУ¬ÎªÁËÄܹ» ......
JavaÃæÊÔÖУ¬×î³£±»ÈËÎʵ½µÄ¼¸¸öÎÊÌ⣺
1. java.util.*°üµÄUML½á¹¹Í¼¡£
2. VectorºÍArrayList¡¢LinkedListÇø±ð Hashtable ºÍ HashMapÖ®¼äµÄÇø±ð
3. String¡¢StringBuffer£¬StringBuilderÖ®¼äÇø±ð¡£
--»Ø´ð--
1.
Collection
|
|_List
| |_LinkedList
| | ......
ÀàÊǹ㷺µÄ¸ÅÄ±íʾһ¸öÓй²Í¬ÐÔÖʵÄȺÌå¡£È磺ÈËÀà¡£
´úÂ룺
// ÉùÃ÷Ò»¸öÀà“Human”
class Human{
priv ......
//ת×Ôhttp://pterodactyl.javaeye.com/blog/345892
stack ºÍ heep ¶¼ÊÇÄÚ´æµÄÒ»²¿·Ö
stack ¿Õ¼äС£¬ËٶȱȽϿ죬 ÓÃÀ´·Å¶ÔÏóµÄÒýÓÃ
heep ´ó£¬Ò»°ãËùÓд´½¨µÄ¶ÔÏó¶¼·ÅÔÚÕâÀï¡£
Õ»(stack):ÊÇÒ»¸öÏȽøºó³öµÄÊý¾Ý½á¹¹,ͨ³£ÓÃÓÚ±£´æ·½·¨(º¯Êý)ÖеIJÎÊý,¾Ö²¿±äÁ¿.
ÔÚjavaÖÐ,ËùÓлù±¾ÀàÐͺÍÒýÓÃÀàÐͶ¼ÔÚÕ»Öд洢.Õ»ÖÐÊý¾ÝµÄÉ ......