灝辨槸鍦?A Left join B inner JOIN C 鐨勬椂鍊? 濡傛灉 B 鐨?C 瀛楁鏄繀濉殑璇? 閭d箞灝辯浉褰撲簬 left join銆?濡傛灉涓嶆槸蹇呭~鐨勮瘽 浣犲繀欏繪墜鍔ㄧ殑鎸囩ず left join (+) 銆?br />===================================================================== 琛ュ厖 2012/10/19 鍙戠幇浠ヤ笂鐨勭悊瑙d笉鍏ㄩ潰
A--B(+) 鎰忔€濇寚B 绔彲涓虹┖錛?濡傛灉 瀵笲 -- C 涓嬮潰鐨勫厓绱犺繘琛岃禌閫夛紝 鍦ㄥ眬閮ㄧ湅 B 鍜?C 鐨勫叧緋繪槸涓ゆ閮藉繀欏誨瓨鍦ㄧ殑錛?浣嗘槸鍦ˋ -- B(+) 鐨勫墠鎻愪笅 C鍙互涓虹┖鐨? 鎵€浠ラ渶瑕佷嬌鐢?B --- C(+) 鏉ヨ繘琛屽叧鑱?nbsp; 榪欐牱鐨勫潖澶勬槸鍙兘浼氬姞杞藉嚭 B (瀛樺湪)-- C (涓嶅瓨鍦? 榪欐牱鐨勯敊璇暟鎹€?褰撶劧濡傛灉緋葷粺涓湁瀵硅繖縐嶆暟鎹湁紜疄淇濋殰鐨勬椂鍊欏彲浠ュ拷鐣ヨ闂
濡傛灉娌℃湁紜垏鐨勪繚闅滅殑璇? 鍙兘灝遍渶瑕佷嬌鐢?A --- D(+) 鍏朵腑D 涓?nbsp; select * from B,C where B = C 榪欐牱鐨勮繃婊ゆ柟寮忥紝 浣嗘槸榪欐牱灝卞鍔犱簡澶嶆潅搴︼紝 浣犻渶瑕佸皢鍙兘鐢ㄥ埌鐨勬煡璇㈡潯浠跺拰鏌ヨ緇撴灉闆嗗湪D涓?select 涓€涓€鍒楀嚭鏉?
鍦?Select A.*,R1,R2,R3 from A ,(select B.A_Aid,c1,c2,c3,R1,R2,R3 from B,C where B.C_AID= C.Aid) D where A.Aid = B.A_Aid and c1 = ? and c2 = ? ....
鍦∕YSQL 涓?select 鍙互鏄劇ず 涓嶆槸group by 涓殑鍒嗙粍瀛楁錛?鍙互鏄換鎰忕殑鏁版嵁鍒楋紝鍏蜂綋鏁版嵁鏄劇ず鐨勬槸鍒嗙粍鍚庣殑絎竴琛屾暟鎹?/div>
鍦∣RACLE涓?select 鏄弗鏍肩殑 鍙兘鏄劇ずgroup by 涓殑瀛楁銆?/div>
鍚屾牱鏁堟灉鐨勪袱琛宻ql --- 璁╄嚜宸辨敞鎰忔彁楂樿嚜宸辯殑浣跨敤鐏墊椿鎬?/div>
1. select a.aid AAid,nvl(b.cot,0) countline from po_draft_order a,(select AID_DRAFT_ORDER_PO BAID,count(*) cot from po_draft_line group by AID_DRAFT_ORDER_PO) b WHERE A.AID = B.BAID(+);
2. select a.aid, (select count(*) from po_draft_line where AID_DRAFT_ORDER_PO = a.aid ) c from po_draft_order a;
]]>Richfaces4.2 綆€鍗曚粙緇?/title><link>http://www.aygfsteel.com/alter/archive/2012/09/10/387407.html</link><dc:creator>a_alter</dc:creator><author>a_alter</author><pubDate>Mon, 10 Sep 2012 09:20:00 GMT</pubDate><guid>http://www.aygfsteel.com/alter/archive/2012/09/10/387407.html</guid><wfw:comment>http://www.aygfsteel.com/alter/comments/387407.html</wfw:comment><comments>http://www.aygfsteel.com/alter/archive/2012/09/10/387407.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/alter/comments/commentRss/387407.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/alter/services/trackbacks/387407.html</trackback:ping><description><![CDATA[浠婂ぉ鐪婻ichface4.2鏂囨。鐨勬椂鍊?鍙戠幇鍙樺姩寰堝ぇ 綰綍涓?br /><br /><div><div><div><div><h2><a id="sect-Component_Reference-RichFaces_overview-Full_technical_requirements">3.1. Full technical requirements</a></h2></div></div></div><p><a id="sect-Component_Reference-RichFaces_overview-Full_technical_requirements"> RichFaces has been developed with an open architecture to be compatible with a wide variety of environments. </a></p><div><div><div><div><h3><a id="sect-Component_Reference-RichFaces_overview-Server_requirements">3.1.1. Server requirements</a></h3></div></div></div><p><a id="sect-Component_Reference-RichFaces_overview-Server_requirements"> RichFaces 4 requires either of the following server technologies: </a></p><div><ul><li><p><a id="sect-Component_Reference-RichFaces_overview-Server_requirements"> An application server compliant with Java Platform, Enterprise Edition 6 (<acronym>JEE6</acronym> or <acronym>JEE6</acronym>), such as JBoss Application Server 7. </a></p></li><li><p><a id="sect-Component_Reference-RichFaces_overview-Server_requirements"> A major servlet container, such as Jetty 8 or Apache Tomcat 7.<span style="color: red;"> (鐪嬪埌榪欎釜鍙兘瀵硅嚜宸辯殑TOMCAT 6 鏈涙湜錛?7 榪樻敮鎸?Servlet3.0 瑙勮寖錛屼笉鐭ラ亾鐜板湪鏀寔servlet3.0 鐨勬鏋舵湁鍝簺 榪樻病娉ㄦ剰 涓€鐩寸敤2.5)</span><br /></a></p></li></ul></div></div><div><div><div><div><h3><a id="sect-Component_Reference-RichFaces_overview-Client_requirements">3.1.2. Client requirements</a></h3></div></div></div><p><a id="sect-Component_Reference-RichFaces_overview-Client_requirements"> Clients accessing RichFaces applications require a web browser. RichFaces supports the following web browsers: </a></p><div><a id="item-Developer_Guide-Technical_Requirements-Linux_environments"><p><strong>Linux environments</strong></p><ul><li><p> Firefox 3.6 or Firefox 7.0 and higher </p></li><li><p> Google Chrome 14 and higher </p></li></ul></a></div><div><a id="item-Developer_Guide-Technical_Requirements-Mac_OS_environments"><p><strong>Mac OS environments</strong></p><ul><li><p> Safari 5.1 and higher </p></li></ul></a></div><div><a id="item-Developer_Guide-Technical_Requirements-Microsoft_Windows_environments"><p><strong>Microsoft Windows environments</strong></p><ul><li><p> Firefox 3.6 or Firefox 7.0 and higher </p></li><li><p> Google Chrome 14 and higher </p></li><li><p> Internet Explorer 8.0 and higher <span style="color: red;">榪欎釜涓浗鐨勭敤鎴風湡鏄娉ㄦ剰浜?/span><span style="color: red;"> 濡傛灉闇€瑕佹敮鎸両E6+ 鍙兘浣跨敤richface3.3.</span><br /></p></li></ul></a></div><p><a id="item-Developer_Guide-Technical_Requirements-Microsoft_Windows_environments"> Other browsers and versions are partially supported. </a></p></div><div><div><div><h3><a id="sect-Component_Reference-RichFaces_overview-Development_requirements">3.1.3. Development requirements</a></h3></div></div></div><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> Developing applications with the RichFaces framework requires the Java Development Kit (<acronym>JDK</acronym>), an implementation of JavaServer Faces (<acronym>JSF</acronym>), and a development environment. </a></p><dl><dt><a id="sect-Component_Reference-RichFaces_overview-Development_requirements">Java Development Kit (<acronym>JDK</acronym>)</a></dt><dd><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> RichFaces supports the following JDK versions: </a></p><div><ul><li><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> JDK 1.6 and higher <span style="color: red;"> JDK1.5 鐨勭敤鎴峰彧鑳芥湜鏈涗簡</span><br /></a></p></li></ul></div><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> </a></p></dd><dt><a id="sect-Component_Reference-RichFaces_overview-Development_requirements">JavaServer Faces (<acronym>JSF</acronym>)</a></dt><dd><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> RichFaces supports the following JSF implementations and frameworks: </a></p><div><ul><li><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> MyFaces 2.x <br /></a></p></li><li><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> Seam 3.x <span style="color: red;">2.* 鐨剆eam 榪樻槸byebye</span><br /></a></p></li><li><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> Mojara 2.x </a></p></li></ul></div><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> </a></p></dd><dt><a id="sect-Component_Reference-RichFaces_overview-Development_requirements">Development environment</a></dt><dd><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> RichFaces can be developed using most Java development environments. The following are recommended, and used for examples in this guide: </a></p><div><ul><li><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> JBoss Tools 3.3 and higher<span style="color: red;"> (榪欎釜鑲穼錛岃繛甯clipse鐨勭増鏈兘瑕佹洿鏂幫紝闇€瑕?.7 濡傛灉娌¤閿欑殑璇濓紝 榪樻湁webtool)</span><br /></a></p></li><li><p><a id="sect-Component_Reference-RichFaces_overview-Development_requirements"> Maven 3.0.3 and higher <br /></a></p></li></ul></div></dd></dl></div><br /><br /><br /><br /><br /><br /><img src ="http://www.aygfsteel.com/alter/aggbug/387407.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/alter/" target="_blank">a_alter</a> 2012-09-10 17:20 <a href="http://www.aygfsteel.com/alter/archive/2012/09/10/387407.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>Eclipse 鏂囦歡 xmln鐨勬敮鎸併€?/title><link>http://www.aygfsteel.com/alter/archive/2012/09/07/387247.html</link><dc:creator>a_alter</dc:creator><author>a_alter</author><pubDate>Fri, 07 Sep 2012 06:30:00 GMT</pubDate><guid>http://www.aygfsteel.com/alter/archive/2012/09/07/387247.html</guid><wfw:comment>http://www.aygfsteel.com/alter/comments/387247.html</wfw:comment><comments>http://www.aygfsteel.com/alter/archive/2012/09/07/387247.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/alter/comments/commentRss/387247.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/alter/services/trackbacks/387247.html</trackback:ping><description><![CDATA[ 鍦‥clipse 緙栬緫鍣ㄤ腑鍔犲叆xmln 鎻愮ず鍔熻兘鏀寔 <br /><br /> 鏄拡瀵歸」鐩瀹氱殑錛?鍙沖嚮欏圭洰閫夋嫨 Properties --銆?Project Facets 鍕鵑€変綘闇€瑕佷嬌鐢ㄧ殑 schema瀹氫箟銆?img src ="http://www.aygfsteel.com/alter/aggbug/387247.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/alter/" target="_blank">a_alter</a> 2012-09-07 14:30 <a href="http://www.aygfsteel.com/alter/archive/2012/09/07/387247.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>seam 綆€鍗曚粙緇?http://www.aygfsteel.com/alter/archive/2012/08/30/386563.htmla_altera_alterThu, 30 Aug 2012 01:38:00 GMThttp://www.aygfsteel.com/alter/archive/2012/08/30/386563.htmlhttp://www.aygfsteel.com/alter/comments/386563.htmlhttp://www.aygfsteel.com/alter/archive/2012/08/30/386563.html#Feedback0http://www.aygfsteel.com/alter/comments/commentRss/386563.htmlhttp://www.aygfsteel.com/alter/services/trackbacks/386563.html鍓嶅簭
Seam is a powerful open source development platform for building rich Internet applications in Java. Seam integrates technologies such as Asynchronous JavaScript and XML (AJAX), JavaServer Faces (JSF), Java Persistence (JPA), Enterprise Java Beans (EJB 3.0) and Business Process Management (BPM) into a unified full-stack solution, complete with sophisticated tooling.
Seam has been designed from the ground up to eliminate complexity at both architecture and API levels. It enables developers to assemble complex web applications using simple annotated Java classes, a rich set of UI components, and very little XML. Seam's unique support for conversations and declarative state management can introduce a more sophisticated user experience while at the same time eliminating common bugs found in traditional web applications.