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
Ïà¹ØÎĵµ£º
ÎÒ½ñÌìѧϰÁËÐìÀÏʦ½²µÄejb3µÄ֪ʶ£¬ÎÒ×öÁ˼òµ¥µÄ±Ê¼Ç£º
ÉÏÎç½²µÄÊÇjpaµÄ֪ʶ£¬ÏÂÎç½²µÄÊÇEJB3µÄ֪ʶ£º
JPQLÓï¾ä£ºhibernateµÄHQLÓï¾äÒ»Ñù¡£
¼òµ¥²éѯ:
Query query = em.createQuery("SELECT c from Customer c");
retur ......
ÎÒ½ñÌìѧϰÁËÐìÀÏʦ½²µÄUMLͳһ½¨Ä£ÓïÑÔ£¬ÎÒ×öÁ˼òµ¥µÄ±Ê¼Ç£º
Èí¼þÉúÃüÖÜÆÚ: Èí¼þµÄ²úÉúÖ±µ½±¨·ÏµÄÉúÃüÖÜÆÚ
Èí¼þÉúÃüÖÜÆÚÄÚÓÐÎÊÌⶨÒå, ¿ÉÐÐÐÔ·ÖÎö, ×ÜÌåÃèÊö, ϵͳÉè¼Æ,±àÂë, µ÷ÊԺͲâÊÔ, ÑéÊÕÓëÔËÐÐ, ά»¤Éý¼¶µ½·ÏÆúµÈ½×¶Î
Èí¼þ¹¤³Ì¿ÉÒÔ·ÖΪÈý¸ö´óµÄ½×¶Î:ÐèÇó; Éè¼Æ; ²âÊÔÓëά»¤
Èí¼þµÄÉúÃüÖÜÆÚÏê½â£º
ÎÊÌâµ ......
1.Áоٳö 10¸öJAVAÓïÑÔµÄÓÅÊÆ
a:Ãâ·Ñ£¬¿ªÔ´£¬¿çƽ̨(ƽ̨¶ÀÁ¢ÐÔ)£¬¼òµ¥Ò×Ó㬹¦ÄÜÍêÉÆ£¬ÃæÏò¶ÔÏ󣬽¡×³ÐÔ£¬¶àỊ̈߳¬½á¹¹ÖÐÁ¢£¬ÆóÒµÓ¦ÓõijÉÊìÆ½Ì¨, ÎÞÏßÓ¦ÓÃ
2.ÁоٳöJAVAÖÐ10¸öÃæÏò¶ÔÏó±à³ÌµÄÊõÓï
a:°ü£¬À࣬½Ó¿Ú£¬¶ÔÏó£¬ÊôÐÔ£¬·½·¨£¬¹¹ÔìÆ÷£¬¼Ì³Ð£¬·â×°£¬¶à̬£¬³éÏ󣬷¶ÐÍ
3.ÁоٳöJAVAÖÐ6¸ö±È½Ï³£Óõİü
Java. ......
1.
Ôö¼ÓJavaÓ¦ÓÃ
ÔÚandroid_2.1/packages/appsÔö¼Ó¸ÃÏîÄ¿£»
ÔÚbuild/target/product/generic.mkµÄPRODUCT_PACKAGESºóÃæÔö¼Ó¶ÔÓ¦°üµÄÃû×Ö¡£
1.1
´ÓÃüÁîÐ ......
JavaÁ¬½ÓmysqlÊý¾Ý¿â£¬´úÂë¾¹ýÔËÐÐ׼ȷÎÞÎó¡£
ÏÂÃæÎªÊµÀý---->
ÓÃÊý¾Ý¿â²Ù×ݹ¤¾ß£¨Àý£ºSQLyogEnt£©²Ù×Ýmysql½¨±í£¬»òdosϽ¨£¬ÈçÏ£º
Êý¾Ý¿âÃû£ºscutcs
±íÃû£ºstudent
±íÄÚÈÝ£º
sno char[7] NO NULL Primary Key;
sname varchar[8] NO NULL;
sex char[2] NO NULL; ......