锘??xml version="1.0" encoding="utf-8" standalone="yes"?>BlogJava-Java涓栫晫http://www.67529968.com/rabbit/瀛範绗旇zh-cnWed, 20 Feb 2019 21:49:54 GMTWed, 20 Feb 2019 21:49:54 GMT60tips鎮仠http://www.67529968.com/rabbit/archive/2014/05/07/413378.htmlRabbitRabbitWed, 07 May 2014 14:23:00 GMThttp://www.67529968.com/rabbit/archive/2014/05/07/413378.htmlhttp://www.67529968.com/rabbit/comments/413378.htmlhttp://www.67529968.com/rabbit/archive/2014/05/07/413378.html#Feedback0http://www.67529968.com/rabbit/comments/commentRss/413378.htmlhttp://www.67529968.com/rabbit/services/trackbacks/413378.html


http://vadikom.com/demos/poshytip/


  • ?#33034;鍑烘枃鏈?#28103;伅鎻愮锛?
    tipsWindown("鎻愮","text:鎻愮淇伅鍐呭","250","150","true","","true","msg")
  • ?#33034;鍑?#26916;甸潰涓?#37928;?#37836;?#28051;ID鐨刪tml锛?
    tipsWindown("鏍囬","id:testID","300","200","true","","true","id")
  • ?#33034;鍑哄?#21095;墖锛?
    tipsWindown("鍥剧墖","img:鍥剧墖璺緞","250","150","true","","true","img")
  • get鍔犺浇涓涓?html?#26499;?#27426;锛堜篃鍙?#28000;槸.php/.asp?id=4涔嬬被鐨?#38171;?#38171;?
    tipsWindown("鏍囬","url:get?test.html","250","150","true","","true","text");
  • 鍔犺浇涓涓?#26916;甸潰鍒版?#21976;灦鏄剧锛?br />
    tipsWindown("鏍囬","iframe:http://www.nowamagic.net","900","580","true","","true","leotheme");
  • ?#33034;鍑?#28051;涓?#28051;?#38003;芥嫋鍔?#28051;旀病鏈夐伄?#20725;鑳屾櫙鐨勬枃鏈?#28103;伅?#30512;锛?
    tipsWindown("鎻愮","text:鎻愮淇伅鍐呭","250","150","false","","false","msg")
  • ?#33034;鍑?#28051;涓?#28051;?#38003;芥嫋鍔紝涓夌閽?#38007;?#37716;?#37711;?#38338;?#37928;勫眰锛?
    tipsWindown("鎻愮","text:鎻愮淇伅鍐呭","250","150","false","3000","true","msg")
  • 鍙傛暟璇存槑

    椤哄簭 鍙傛暟 鍔?#38003;?/th> 澶囨敞
    1 title ?#33034;鍑哄眰鐨?#37837;囬 蹇呭?#32029;?#20989;?#26499;鏈?/td>
    2 content ?#33034;鍑哄眰鐨勫?#21613; text ?#26499;鏈?#37712;呭
    id 椤甸潰閲?#37836;id鐨?#28699;?#37837;?#32475;?/td>
    img 鍥剧墖
    url get鎴杙ost鏌?#28051;椤甸潰閲?#37928;刪tml?#32029;璇?#26916;甸潰瑕佹眰鍙?#37718;呭?#29597;ody鐨?#28699;?#37837;?#32475;?/td>
    iframe 鐩?#37837;?#37734;板潃?#28266;妗嗘灦鏄剧
    3 width ?#33034;鍑哄眰鐨勫 蹇呭?#32029;?#30254;濡?#8220;200”銆?#38171;?#28051;嶉渶瑕佸甫px锛?/td>
    4 height ?#33034;鍑哄眰鐨?#26946;?/td> 鍚?width
    5 drag ?#27128;鍚?#37721;嫋鍔?/td> 蹇呭?#32029;鍙?#38315;?#37721;傛暟锛true,false锛?/td>
    6 time 鑷?#37716;?#23057;?#28598;?#37827;?#38338;?/td> 鍙?#28051;?#28617;紝榛樿涓?#38007;?#37716;?#37711;?#38338;?#38171;?#37721;傛暟鍙?#28051;?#32460;?"")
    7 showbg ?#27128;鍚?#37828;剧?#27946;伄?#20725;?#30512; 鍙?#28051;?#28617;紝榛樿涓?#37828;剧锛?#23005;?#26916;瑰?#20634;浜嗭紝瀹冨?#23945;潰鐨則ime?#31683;蹇?#26916;?#29781;佸锛?/td>
    8 cssName ?#33034;鍑哄眰闄勫?#29363;牱寮?#37722;?/td> 鍙?#28051;?#28617;?/td>

    ?#20762;?#32342;绉嶅脊鍑?#38315;忔槑鑳屾櫙?#30512;鏁堟灉寰堝?#27468;浜嗭紝闄儴鍒嗗?#21700;煙鍙?#28000;搷浣滃鍏?#28000;栧?#21700;煙涓?#38003;芥搷浣滐紝鐩墠鏈?#37819;愪緵鎻掍欢?#32029;瀹?#37711;?#37721;?#28000;?#28729;?#37916;版绉?#37825;堟灉銆?/p>

    鏌湅鏈?#26916;?#23143;?#28000;?#37934;?#37721;?#38014;?#37721;?#37813;鏈?#37813;?#28214;鐨?#28000;?#37934;?#37510;?/p>

    Rabbit 2014-05-07 22:23 鍙?#29723;?#29831;勮
    ]]>
    鎵?#38322;?#37819;?#37711;?#38171;圱est锛?/title><link>http://www.67529968.com/rabbit/archive/2014/04/15/412487.html</link><dc:creator>Rabbit</dc:creator><author>Rabbit</author><pubDate>Tue, 15 Apr 2014 13:38:00 GMT</pubDate><guid>http://www.67529968.com/rabbit/archive/2014/04/15/412487.html</guid><wfw:comment>http://www.67529968.com/rabbit/comments/412487.html</wfw:comment><comments>http://www.67529968.com/rabbit/archive/2014/04/15/412487.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.67529968.com/rabbit/comments/commentRss/412487.html</wfw:commentRss><trackback:ping>http://www.67529968.com/rabbit/services/trackbacks/412487.html</trackback:ping><description><![CDATA[<ol start="1" style="font-size: 12px; line-height: 1.4em; margin: 0px 0px 1px; padding: 2px 0px; border: 1px solid #d1d7dc; list-style-position: initial; list-style-image: initial; background-color: #ffffff; color: #2b91af; font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace;"><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;"><span style="color: #006699; font-weight: bold;"><</span><span style="color: #006699; font-weight: bold;">insert</span> <span style="color: red;">id</span>=<span style="color: blue;">"insertData"</span> <span style="color: red;">parameterType</span>=<span style="color: blue;">"java.util.List"</span> <span style="color: #006699; font-weight: bold;">></span>  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">        INSERT INTO EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,DEPTNO) (  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">        <span style="color: #006699; font-weight: bold;"><</span><span style="color: #006699; font-weight: bold;">foreach</span> <span style="color: red;">collection</span>=<span style="color: blue;">"list"</span> <span style="color: red;">item</span>=<span style="color: blue;">"item"</span> <span style="color: red;">index</span>=<span style="color: blue;">"index"</span> <span style="color: red;">separator</span>=<span style="color: blue;">"union all"</span><span style="color: #006699; font-weight: bold;">></span>  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">            select  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">                #{item.EMPNO,<span style="color: red;">jdbcType</span>=<span style="color: blue;">VARCHAR</span>},  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">                #{item.ENAME,<span style="color: red;">jdbcType</span>=<span style="color: blue;">VARCHAR</span>},  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">                #{item.JOB,<span style="color: red;">jdbcType</span>=<span style="color: blue;">VARCHAR</span>},  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">                #{item.MGR,<span style="color: red;">jdbcType</span>=<span style="color: blue;">NUMERIC</span>},  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">                #{item.MGR,<span style="color: red;">jdbcType</span>=<span style="color: blue;">NUMERIC</span>},  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">                TO_DATE(#{item.HIREDATE,<span style="color: red;">jdbcType</span>=<span style="color: blue;">VARCHAR</span>},'yyyy-mm-dd')  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">                  from dual  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">        <span style="color: #006699; font-weight: bold;"></</span><span style="color: #006699; font-weight: bold;">foreach</span><span style="color: #006699; font-weight: bold;">></span>  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;">        )  </span></li><li style="font-size: 1em; margin: 0px 0px 0px 38px; padding: 0px 0px 0px 10px; border-left-width: 1px; border-left-style: solid; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;"><span style="color: black;"><span style="color: #006699; font-weight: bold;"></</span><span style="color: #006699; font-weight: bold;">insert</span><span style="color: #006699; font-weight: bold;">></span> <br /><br />=====================================================================<br /><br /><br /><div>declare    </div><div>  type t_array is table of t_target%rowtype;    </div><div>  t_data t_array;    </div><div>  cursor c is    </div><div>    select null id, owner, object_name, null object_id, null xx, null yy    </div><div>    from dba_objects;    </div><div>begin    </div><div>  open c;    </div><div>  loop    </div><div>    fetch c bulk collect    </div><div>    into t_data limit 100;    </div><div>    </div><div>    forall i in 1 .. t_data.count    </div><div>      insert into t_target values t_data (i);    </div><div>    exit when c%notfound;    </div><div>  end loop;    </div><div>  close c;    </div><div>  commit;    </div><div>end; <br /><br /><br /><br /><pre style="margin-top: 0px; margin-bottom: 0px; padding: 0px; white-space: pre-wrap; word-wrap: break-word; color: #333333; line-height: 21px; font-family: 'Courier New' !important;"><span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;"><</span><span style="margin: 0px; padding: 0px; color: #800000; line-height: 1.5 !important;">insert </span><span style="margin: 0px; padding: 0px; color: #ff0000; line-height: 1.5 !important;">id</span><span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">="insertByProc"</span><span style="margin: 0px; padding: 0px; color: #ff0000; line-height: 1.5 !important;"> statementType</span><span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">="CALLABLE"</span><span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">></span> <span style="margin: 0px; padding: 0px; color: #000000; line-height: 1.5 !important;"> <br />{call insertPro(#{name},#{age},#{sex},#{password},#{num})} </span> <br /><span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;"></</span><span style="margin: 0px; padding: 0px; color: #800000; line-height: 1.5 !important;">insert</span><span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">><br /><br /><pre style="margin-top: 0px; margin-bottom: 0px; padding: 0px; white-space: pre-wrap; word-wrap: break-word; color: #333333; line-height: 21px; font-family: 'Courier New' !important;"><span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;">1</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">CREATE</span> DEFINER <span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">=</span> `root`@`localhost` <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">PROCEDURE</span> `NewProc`(<span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">IN</span> `name_in` <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">varchar</span>(<span style="margin: 0px; padding: 0px; color: #800000; font-weight: bold; line-height: 1.5 !important;">255</span>),<span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">IN</span> `age_in` <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">int</span>,<span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">IN</span> `sex_in` <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">varchar</span>(<span style="margin: 0px; padding: 0px; color: #800000; font-weight: bold; line-height: 1.5 !important;">255</span>),<span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">IN</span> `password_in` <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">varchar</span>(<span style="margin: 0px; padding: 0px; color: #800000; font-weight: bold; line-height: 1.5 !important;">255</span>),<span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">IN</span> `num_in` <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">int</span><span style="margin: 0px; padding: 0px; color: #000000; line-height: 1.5 !important;">) </span><span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;"> 2</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">BEGIN</span> <span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;"> 3</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">SET</span> <span style="margin: 0px; padding: 0px; color: #008000; line-height: 1.5 !important;">@a</span><span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">=</span><span style="margin: 0px; padding: 0px; color: #800000; font-weight: bold; line-height: 1.5 !important;">0</span><span style="margin: 0px; padding: 0px; color: #000000; line-height: 1.5 !important;">; </span><span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;"> 4</span> <span style="margin: 0px; padding: 0px; color: #000000; line-height: 1.5 !important;">Label:LOOP </span><span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;"> 5</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">SET</span> <span style="margin: 0px; padding: 0px; color: #008000; line-height: 1.5 !important;">@a</span><span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">=</span><span style="margin: 0px; padding: 0px; color: #008000; line-height: 1.5 !important;">@a</span><span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">+</span><span style="margin: 0px; padding: 0px; color: #800000; font-weight: bold; line-height: 1.5 !important;">1</span><span style="margin: 0px; padding: 0px; color: #000000; line-height: 1.5 !important;">; </span><span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;"> 6</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">INSERT</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">INTO</span> person ( name, age, sex, password) <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">VALUES</span><span style="margin: 0px; padding: 0px; color: #000000; line-height: 1.5 !important;"> (name_in,age_in,sex_in,password_in); </span><span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;"> 7</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">IF</span> <span style="margin: 0px; padding: 0px; color: #008000; line-height: 1.5 !important;">@a</span><span style="margin: 0px; padding: 0px; color: #808080; line-height: 1.5 !important;">=</span>num_in <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">THEN</span> <span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;"> 8</span> <span style="margin: 0px; padding: 0px; color: #000000; line-height: 1.5 !important;"> LEAVE Label; </span><span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;"> 9</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">END</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">IF</span><span style="margin: 0px; padding: 0px; color: #000000; line-height: 1.5 !important;">; </span><span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;">10</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">END</span><span style="margin: 0px; padding: 0px; color: #000000; line-height: 1.5 !important;"> LOOP Label; </span><span style="margin: 0px; padding: 0px; color: #008080; line-height: 1.5 !important;">11</span> <span style="margin: 0px; padding: 0px; color: #0000ff; line-height: 1.5 !important;">END</span>;</pre></span></pre></div><br /></span></li></ol><img src ="http://www.67529968.com/rabbit/aggbug/412487.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.67529968.com/rabbit/" target="_blank">Rabbit</a> 2014-04-15 21:38 <a href="http://www.67529968.com/rabbit/archive/2014/04/15/412487.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>Oracle涓璈int娣?#37711;?#37918;嗚http://www.67529968.com/rabbit/archive/2013/11/08/406141.htmlRabbitRabbitFri, 08 Nov 2013 06:44:00 GMThttp://www.67529968.com/rabbit/archive/2013/11/08/406141.htmlhttp://www.67529968.com/rabbit/comments/406141.htmlhttp://www.67529968.com/rabbit/archive/2013/11/08/406141.html#Feedback0http://www.67529968.com/rabbit/comments/commentRss/406141.htmlhttp://www.67529968.com/rabbit/services/trackbacks/406141.htmlHint姒傝堪
    ?#29056;浜?#28000;?#28000;?#37928;勪紭鍖栧櫒?#27128;?#32226;鑱槑鐨勶紝?#28266;缁濆澶?#37825;版儏鍐?#28051;?#28729;冧細閫?#37815;?#23005;?#32429;?#37928;勪紭鍖栧櫒?#32029;鍑忚浜DBA鐨勮礋鎷?#37510;?#28003;?#37832;?#37827;?#28729;冧篃鑱槑鍙嶈鑱槑璇紝閫?#37815;?#27996;嗗?#22557;樊鐨勬墽琛岃鍒掞紝浣?#37836;?#28051;?#29831;?#37721;?#37928;勬墽琛屽彉寰楀?#22248;鏃犳瘮銆?/font>

    姝?#37827;?#28751;遍渶瑕丏BA杩?#29723;?#27996;?#28051;?#37928;勫共棰勶紝鍛?#29831;変紭鍖栧櫒浣跨敤鎴?#28000;?#37816;囧畾鐨?#28699;?#37721;?#29882;緞鎴?#26473;?#37818;被鍨嬬敓鎴?#37813;?#29723;岃鍒掞紝浠庤?#28003;?#29831;?#37721;?#26946;?#37825;?#37928;勮繍琛?#37510;備緥濡傦紝濡傛灉鎴?#28000;?#29825;?#28051;哄浜?#28051;涓?#37911;瑰畾鐨?#29831;?#37721;紝鎵?#29723;?#37711;?#29723;?#37813;?#37819;?#29781;佹瘮鎵?#29723;岀储寮?#37813;?#37819;忔洿鏈?#37825;紝鍒?#37812;?#28000;?#28751;?#37721;?#28000;?#37816;?#32448;轰紭鍖栧櫒浣跨敤鍏?#29723;?#37813;?#37819;?#37510;傚湪Oracle 涓紝?#27128;閫?#26473;?#28051;?#29831;?#37721;?#23075;?#37716;?Hints(鎻愮)鏉?#28729;?#37916;板共棰勪紭鍖栧櫒?#32045;鍖栫殑鐩?#37928;?#37510;?br />涓嶅缓璁湪浠?#37934;?#28051;?#28003;跨敤hint?#32029;?#28266;浠?#37934;?#28003;跨敤hint浣?#23536;CBO鏃犳硶鏍规嵁瀹?#38340;?#37928;?#37825;版嵁?#23032;鎬?#38315;?#37815;?#23005;?#32429;?#37928;勬墽琛岃鍒?#37510;傛?#26336; 鏁版嵁?#27128;涓?#37826;?#37721;?#37718;栫殑?#32029; 10g浠?#37722;?#37928;凜BO?#31683;?#31226;鏉秺瀹屽?#21238;紝澶?#28598;?#37825;版儏鍐?#28051;?#37812;?#28000;?#29831;?#29825;Oracle鑷?#29723;?#37712;冲畾閲囩敤浠涔堟墽琛岃鍒?#37510;?/font>

    Oracle Hints?#27128;涓绉?#37832;哄?#35769;紝?#25956;鏉?#37723;?#29831;変紭鍖栧櫒鎸夌鎴?#28000;?#37928;勫憡璇?#28729;?#37928;?#37826;?#23534;?#37922;?#37812;?#37813;?#29723;岃鍒?#37510;傛垜浠?#37721;?#28000;敤Oracle Hints鏉?#28729;?#37916;?#38171;?br />1) 浣跨敤鐨勪紭鍖栧櫒鐨勭被鍨?br />2) ?#29056;浜?#28000;?#28000;?#37928;勪紭鍖栧櫒鐨勪紭鍖栫洰鏍囷紝?#27128;all_rows杩樻槸first_rows銆?br />3) 琛?#37928;勮闂?#29882;緞?#32029;?#27128;鍏?#29723;?#37813;?#37819;忥紝杩樻槸?#20648;寮?#37813;?#37819;忥紝杩樻槸?#27967;鎺?#37714;敤rowid銆?br />4) 琛?#28052;?#38338;?#37928;勮繛鎺被鍨?br />5) 琛?#28052;?#38338;?#37928;勮繛鎺?#26916;哄簭
    6) 璇?#37721;?#37928;勫苟琛岀搴?/font>

    闄?#27996;?#8221;RULE”鎻愮?#21700;?#26677;紝涓鏃?#28003;跨敤鐨勫埆鐨?#37819;愮?#29492;紝璇?#37721;?#28751;变細鑷?#37716;?#37928;?#37824;?#28051;?#28003;跨敤CBO?#32045;鍖栧櫒?#32029;姝?#37827;?#28641;傛灉浣?#37928;?#37825;版嵁瀛?#37711;?#28051;病鏈?#32513;熻鏁版嵁?#32029;灏变細浣跨敤缂虹渷鐨?#32513;熻鏁版嵁銆傛墍浠缓璁?#28598;?#28729;?#28641;傛灉浣跨敤CBO鎴朒ints鎻愮?#29492;紝鍒?#37832;濂?#28725;?#29723;?#37724;岀储寮?#26473;?#29723;屽畾鏈?#37928;勫?#21976;瀽銆?/font>

    濡?#28003;?#28003;跨敤Hints:

    Hints鍙簲?#25956;?#28266;瀹?#28000;?#37813;?#28266;sql璇?#37721;?#37735;?statement block?#32029;鐢select銆乽pdate銆乨elete鍏抽敭瀛?#37837;?#29831;?涓婏紝瀵?#37711;?#28729;僑QL璇?#37721;?#37812;?#29831;?#37721;?#37928;勫叾瀹冮儴鍒嗘病鏈夊?#21342;搷銆傚锛?#28725;?#27996;?#28003;跨敤union?#25655;浣?#37928;?涓猻ql璇?#37721;紝濡傛灉鍙湪涓涓猻ql璇?#37721;?#28051;?#37832;Hints?#32029;鍒?#29831;Hints涓嶄細褰卞搷鍙?#28051;涓猻ql璇?#37721;?#37510;?/font>

    鎴?#28000;?#37721;?#28000;?#28003;跨敤?#25950;閲?comment)鏉?#28051;?#28051;涓?#29831;?#37721;?#23075;?#37716;燞ints?#32029;涓涓?#29831;?#37721;?#37735;?#37721;?#38003;?#37832;?#28051;涓敞閲婏紝鑰?#28051;旀敞閲?#37721;?#38003;?#37824;惧湪SELECT, UPDATE, or DELETE鍏抽敭瀛?#37928;勫悗?#28528;

    浣跨敤Oracle Hints鐨?#29831;硶锛?/font>

    {DELETE|INSERT|SELECT|UPDATE} /*+ hint [text] [hint[text]]... */

    or

    {DELETE|INSERT|SELECT|UPDATE} --+ hint [text] [hint[text]]...

    ?#25950;瑙?#38171;?br />1) DELETE銆両NSERT銆丼ELECT鍜孶PDATE?#27128;鏍?#29831;?#28051;涓?#29831;?#37721;?#37735;?#23534;濮?#37928;勫叧?#25965;瀛楋紝鍖呭惈鎻愮鐨勬敞閲?#37721;?#38003;?#37713;?#37916;板湪?#32342;浜?#37711;抽敭瀛?#37928;勫悗?#28528;?#32029;鍚?#37714;?#37819;愮?#28888;?#29363;晥銆?br />2) “+”鍙?#29723;?#32448;?#29831;敞閲婃槸涓涓狧ints?#32029;璇?#37716;?#37721;?#36423;?#26916;?#32468;?#37719;?#29882;熷湪”/*”鐨勫悗?#28528;?#32029;涓?#38338;?#28051;?#38003;?#37832;夌?#28888;牸銆?br />3) hint?#27128;涓嬮潰浠?#32513;?#37928;勫叿浣?#37819;愮涔?#28051;?#32029;濡傛灉鍖呭惈澶?#28051;?#37819;愮?#29492;紝鍒?#23011;?#28051;?#37819;愮涔?#38338;撮渶瑕佺敤涓涓?#37812;栧涓?#32460;烘牸闅?#23534;銆?br />4) text ?#27128;鍏?#28729;?#29831;存槑hint鐨勬敞閲?#37804;枃鏈?/font>

    5)浣跨敤琛?#37714;?#37722;?#37510;傚?#20635;灉?#28266;鏌?#29831;?#28051;?#37816;囧畾浜?#29723;?#37714;?#37722;嶏紝閭?#28052;?#37819;愮?#21700;繀椤讳篃浣跨敤琛?#37714;?#37722;?#37510;備緥濡?#38171;select /*+ index(e,dept_idx) */ * from emp e;
    6)涓?#29781;佸湪鎻愮涓?#28003;跨敤妯?#23534;?#37722;?#32457;?#38171;?#28641;傛灉?#28266;鎻愮涓?#37816;囧畾浜嗘寮?#37928;勬墍鏈夎咃紝閭?#28052;?#37819;愮?#21700;?#21978;蹇界暐銆備緥濡?#38171;?br />select /*+ index(scott.emp,dept_idx) */ * from emp

    ?#25950;?#21104;锛?#28641;傛灉浣犳病鏈?#23005;?#32429;?#37928;?#37816;囧畾Hints?#32029;Oracle灏?#36423;界暐璇Hints?#32029;?#33503;涓?#28051;嶄細缁?#37713;?#28000;?#28003;曢敊璇?#37510;?br />hint琚?#36423;界暐

    濡傛灉CBO璁?#28051;?#28003;跨敤hint?#32048;瀵?#38007;撮敊璇?#37928;?#32513;撴灉鏃讹紝hint灏嗚蹇界暐?#32029;璇?#29785;?#28051;嬩緥
    SQL> select /*+ index(t t_ind) */ count(*) from t;
    Execution Plan
    ----------------------------------------------------------
    Plan hash value: 2966233522
    -------------------------------------------------------------------
    | Id  | Operation          | Name | Rows  | Cost (%CPU)| Time     |
    -------------------------------------------------------------------
    |   0 | SELECT STATEMENT   |      |     1 |    57   (2)| 00:00:01 |
    |   1 |  SORT AGGREGATE    |      |     1 |            |          |
    |   2 |   TABLE ACCESS FULL| T    | 50366 |    57   (2)| 00:00:01 |
    -------------------------------------------------------------------

    鍥?#28051;烘垜浠槸瀵?#29825;板?#26335;眰鎬?#37825;帮紝涓?#37812;?#28000;?#39582;舵病鏈夊湪?#32531;绔嬬储寮?#37827;?#37816;囧畾涓?#38003;?#28051;?#32460;猴紝?#20648;寮?#28641;傛灉CBO閫?#37815;湪?#20648;寮?#28051;?#26473;?#29723;count鏃讹紝浣嗙储寮?#28699;楁涓?#37928;勫?#28051;?#32460;烘椂?#32029;缁撴灉灏?#28051;?#37713;嗙?#32029;鏁匔BO?#30149;鏈?#38315;?#37815;储寮?#37510;?/font>
    SQL>  select /*+ index(t t_ind) */ count(id) from t;
    Execution Plan
    ----------------------------------------------------------
    Plan hash value: 646498162
    --------------------------------------------------------------------------
    | Id  | Operation        | Name  | Rows  | Bytes | Cost (%CPU)| Time     |
    --------------------------------------------------------------------------
    |   0 | SELECT STATEMENT |       |     1 |     5 |   285   (1)| 00:00:04 |
    |   1 |  SORT AGGREGATE  |       |     1 |     5 |            |          |
    |   2 |   INDEX FULL SCAN| T_IND | 50366 |   245K|   285   (1)| 00:00:04 |
    --------------------------------------------------------------------------

    鍥?#28051;烘垜浠?#37721;?#28725;id杩?#29723;count?#32029;?#32342;涓?#37716;?#28003;?#37929;?#35120;?#27996;count?#20648;寮?#28051;?#37928;勬墍鏈塱d鍊硷紝?#32342;涓搷浣滃拰瀵?#29723;?#28051;?#37928;刬d瀛楁杩?#29723;count?#27128;涓鏍?#37928;?缁勫嚱鏁颁細蹇界暐null鍊?

    Hint鐨勫叿浣撶敤?#30838;

    鍜屼紭鍖栧櫒鐩?#37711;?#37928;刪int

    1銆?*+ ALL_ROWS */
    琛槑瀵?#29831;?#37721;?#37735;?#38315;?#37815;熀浜?#23534;閿鐨勪紭鍖?#37826;规硶,?#33503;鑾峰緱鏈浣?#37722;?#37722;?#38322;?浣胯?#21228;簮娑?#38000;?#37832;灏忓寲.
    SELECT /*+ ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='SCOTT';

    2銆?*+ FIRST_ROWS(n) */
    琛槑瀵?#29831;?#37721;?#37735;?#38315;?#37815;熀浜?#23534;閿鐨勪紭鍖?#37826;规硶,?#33503;鑾峰緱鏈浣冲?#23941;簲鏃?#38338;?浣胯?#21228;簮娑?#38000;?#37832;灏忓寲.
    SELECT /*+FIRST_ROWS(20) */ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='SCOTT';
    3銆?*+ RULE*/
    琛槑瀵?#29831;?#37721;?#37735;?#38315;?#37815;熀浜庤?#21227;垯鐨勪紭鍖?#37826;规硶.
    SELECT /*+ RULE */ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='SCOTT';
    鍜岃闂?#29882;緞鐩?#37711;?#37928;刪int

    1銆?*+ FULL(TABLE)*/
    琛槑瀵?#29723;?#38315;?#37815;?#37711;?#28766;鎵?#37819;?#37928;?#37826;规硶.
    SELECT /*+FULL(A)*/ EMP_NO,EMP_NAM FROM BSEMPMS A WHERE EMP_NO='SCOTT';

    2銆?*+ INDEX(TABLE INDEX_NAME) */
    琛槑瀵?#29723;?#38315;?#37815;储寮?#37928;勬壂鎻?#37826;规硶.
    SELECT /*+INDEX(BSEMPMS SEX_INDEX) */ * FROM BSEMPMS WHERE SEX='M';
    5銆?*+ INDEX_ASC(TABLE INDEX_NAME)*/
    琛槑瀵?#29723;?#38315;?#37815;储寮?#37719;?#25652;?#37928;勬壂鎻?#37826;规硶.
    SELECT /*+INDEX_ASC(BSEMPMS PK_BSEMPMS) */ * FROM BSEMPMS WHERE DPT_NO='SCOTT';
    6銆?*+ INDEX_COMBINE*/
    涓?#37816;囧畾琛?#38315;?#37815;?#28003;?#37733;?#29825;?#38338;?#29882;?#32513;?濡傛灉INDEX_COMBINE涓病鏈?#37819;愪緵浣?#28051;哄?#20635;暟鐨勭储寮?灏?#38315;?#37815;?#37713;?#28003;?#37733;剧储寮?#37928;勫?#20904;皵缁勫悎鏂?#23534;?
    SELECT /*+INDEX_COMBINE(BSEMPMS SAL_BMI HIREDATE_BMI) */  * FROM BSEMPMS
    WHERE SAL<5000000 AND HIREDATE

    7銆?*+ INDEX_JOIN(TABLE INDEX_NAME1 INDEX_NAME2) */
    褰撹皳璇?#28051;?#23534;曠敤鐨勫垪?#20824;鏈夌储寮?#37928;?#37827;跺欙紝鍙?#28000;?#38315;?#26473;?#37816;囧畾閲囩敤?#20648;寮?#37711;?#38001;?#37928;?#37826;?#23534;忥紝鏉?#29825;?#38338;?#37825;版嵁
    select /*+ index_join(t t_ind t_bm) */ id from t where id=100 and object_name='EMPLOYEES'
    8銆?*+ INDEX_DESC(TABLE INDEX_NAME)*/
    琛槑瀵?#29723;?#38315;?#37815;储寮?#38340;?#25652;?#37928;勬壂鎻?#37826;规硶.

    SELECT /*+INDEX_DESC(BSEMPMS PK_BSEMPMS) */ * FROM BSEMPMS WHERE DPT_NO='SCOTT';
    9銆?*+ INDEX_FFS(TABLE INDEX_NAME) */
    瀵?#37816;囧畾鐨?#29723;?#37813;?#29723;屽揩閫?#37711;储寮?#37813;?#37819;?鑰?#28051;嶆槸鍏?#29723;?#37813;?#37819;?#37928;勫?#28852;硶.
    SELECT /* + INDEX_FFS(BSEMPMS IN_EMPNAM)*/ * FROM BSEMPMS WHERE DPT_NO='TEC305';

    10銆?*+ INDEX_SS(T T_IND) */
    浠?i寮濮嬶紝oracle寮?#37711;?#27996;嗚繖绉嶇储寮?#29825;?#38338;?#37826;?#23534;?#37510;傚綋?#28266;涓涓?#38001;?#37722;堢储寮?#28051;紝鏌?#27996;涜皳璇嶆潯?#27426;?#33503;涓嶅湪鑱?#37722;堢储寮?#37928;?#32471;?#28051;鍒?#37827;讹紝鍙?#28000;?#38315;?#26473;Index Skip Scan鏉?#29825;?#38338;储寮?#38014;峰緱鏁版嵁銆傚綋鑱?#37722;堢储寮?#32471;?#28051;鍒?#37928;勫敮涓鍊?#28051;?#37825;板?#22557;皯鏃讹紝浣跨敤?#32342;绉?#37826;?#23534;忔瘮鍏?#29723;?#37813;?#37819;忔晥鐜囬珮銆?/font>

    SQL> create table t as select 1 id,object_name from dba_objects;
    Table created.
    SQL> insert into t select 2,object_name from dba_objects;      
    50366 rows created.
    SQL> insert into t select 3,object_name from dba_objects;      
    50366 rows created.

    SQL> insert into t select 4,object_name from dba_objects;      
    50366 rows created.

    SQL> commit;
    Commit complete.
    SQL> create index t_ind on t(id,object_name);
    Index created.
    SQL> exec dbms_stats.gather_table_stats('HR','T',cascade=>true);
    PL/SQL procedure successfully completed.
    鎵?#29723;?#37711;?#29723;?#37813;?#37819;?/span>
    SQL> select /*+ full(t) */ * from t where object_name='EMPLOYEES';
    6 rows selected.
    Execution Plan
    ----------------------------------------------------------
    Plan hash value: 1601196873
    --------------------------------------------------------------------------
    | Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
    --------------------------------------------------------------------------
    |   0 | SELECT STATEMENT  |      |     5 |   135 |   215   (3)| 00:00:03 |
    |*  1 |  TABLE ACCESS FULL| T    |     5 |   135 |   215   (3)| 00:00:03 |
    --------------------------------------------------------------------------
    Predicate Information (identified by operation id):
    ---------------------------------------------------
       1 - filter("OBJECT_NAME"='EMPLOYEES')
    Statistics
    ----------------------------------------------------------
              0  recursive calls
              0  db block gets
            942  consistent gets
              0  physical reads
              0  redo size
            538  bytes sent via SQL*Net to client
            385  bytes received via SQL*Net from client
              2  SQL*Net roundtrips to/from client
              0  sorts (memory)
              0  sorts (disk)
              6  rows processed
    涓?#38322;囩敤hint
    SQL>  select * from t where object_name='EMPLOYEES';
    6 rows selected.
    Execution Plan
    ----------------------------------------------------------
    Plan hash value: 2869677071
    --------------------------------------------------------------------------
    | Id  | Operation        | Name  | Rows  | Bytes | Cost (%CPU)| Time     |
    --------------------------------------------------------------------------
    |   0 | SELECT STATEMENT |       |     5 |   135 |     5   (0)| 00:00:01 |
    |*  1 |  INDEX SKIP SCAN | T_IND |     5 |   135 |     5   (0)| 00:00:01 |
    --------------------------------------------------------------------------
    Predicate Information (identified by operation id):
    ---------------------------------------------------
       1 - access("OBJECT_NAME"='EMPLOYEES')
           filter("OBJECT_NAME"='EMPLOYEES')
    Statistics
    ----------------------------------------------------------
              1  recursive calls
              0  db block gets
             17  consistent gets
              1  physical reads
              0  redo size
            538  bytes sent via SQL*Net to client
            385  bytes received via SQL*Net from client
              2  SQL*Net roundtrips to/from client
              0  sorts (memory)
              0  sorts (disk)
              6  rows processed

    褰?#37711;?#29723;?#37813;?#37819;忔壂鎻?#27996;?42涓?#37735;楋紝鑱?#37722;堢储寮?#37721;?#37813;?#37819;?#27996;?7涓?#37825;版嵁鍧?#37510;傚彲浠湅?#22476;鑱?#37722;堢储寮?#37928;?#32471;?#28051;涓?#28699;楁鐨勫?#38322;?#28598;?#37916;囧緢楂?#37827;讹紝鍗充娇?#30387;璇?#28051;病鏈夎仈鍚堢储寮?#37928;?#32471;?#28051;涓?#28699;楁?#30857;紝渚濈?#26421;細浣跨敤index_ss鏂?#23534;忥紝鏁?#37916;?#26473;?#26473;?#26946;?#27996;?#37711;?#29723;?#37813;?#37819;忔晥鐜?#37510;?#28003;嗗綋
    绗?#28051;涓?#28699;楁鐨勫?#38322;?#28598;?#37916;囧緢浣?#37827;讹紝浣跨敤 index_ss鐨?#37825;?#37916;?#29781;?#28003;?#27996;?/font> 鍏?#29723;?#37813;?#37819;忥紝璇昏呭彲浠?#38007;?#29723;屽疄楠?/font>
    ?#25328;琛?#37928;勫叧鑱旂浉鍏?#37928;刪int

    /*+ leading(table_1,table_2) */

    ?#28266;澶?#29723;?#37711;?#38001;?#37836;?#29831;?#28051;紝鎸囧畾?#25698;涓?#29723;?#28003;?#28051;洪鍔?#29723;紝鍗?#37723;?#29831;変紭鍖栧櫒棣?#37711;?#29781;?#29825;?#38338;摢涓?#29723;?#28051;?#37928;?#37825;版嵁銆?/span>
    select /*+ leading(t,t1) */ t.* from t,t1 where t.id=t1.id;

    /*+ order */

    璁Oracle鏍规嵁from鍚庨潰琛?#37928;?#26916;哄?#24532;潵閫?#37815;?#26937;?#37716;?#29723;紝oracle?#32531;璁?#28003;跨敤leading?#32029;浠栨洿涓虹?#22443;椿
    select /*+ order */ t.* from t,t1 where t.id=t1.id;
    /*+ use_nl(table_1,table_2) */
    ?#28266;澶?#29723;?#37711;?#38001;?#37836;?#29831;?#28051;紝鎸囧畾浣跨敤nest loops鏂?#23534;忚繘琛屽琛?#37711;?#38001;?#37510;?/span>

    select /*+ use_nl(t,t1) */ t.* from t,t1 where t.id=t1.id;

    /*+ use_hash(table_1,table_2) */
    ?#28266;澶?#29723;?#37711;?#38001;?#37836;?#29831;?#28051;紝鎸囧畾浣跨敤hash join鏂?#23534;忚繘琛屽琛?#37711;?#38001;?#37510;?/span>

    select /*+ use_hash(t,t1) */ t.* from t,t1 where t.id=t1.id;

    ?#28266;澶?#29723;?#37711;?#38001;?#37836;?#29831;?#28051;紝鎸囧畾浣跨敤hash join鏂?#23534;忚繘琛屽琛?#37711;?#38001;紝?#33503;鎸囧畾琛t涓洪鍔?#29723;?#37510;?/font>

    select /*+ use_hash(t,t1) leading(t,t1) */ t.* from t,t1 where t.id=t1.id;

    /*+ use_merge(table_1,table_2) */
    ?#28266;澶?#29723;?#37711;?#38001;?#37836;?#29831;?#28051;紝鎸囧畾浣跨敤merge join鏂?#23534;忚繘琛屽琛?#37711;?#38001;?#37510;?/span>

    select /*+ use_merge(t,t1) */ t.* from t,t1 where t.id=t1.id;

    /*+ no_use_nl(table_1,table_2) */
    ?#28266;澶?#29723;?#37711;?#38001;?#37836;?#29831;?#28051;紝鎸囧畾涓?#28003;跨敤nest loops鏂?#23534;忚繘琛屽琛?#37711;?#38001;?#37510;?/span>

    select /*+ no_use_nl(t,t1) */ t.* from t,t1 where t.id=t1.id;

    /*+ no_use_hash(table_1,table_2) */
    ?#28266;澶?#29723;?#37711;?#38001;?#37836;?#29831;?#28051;紝鎸囧畾涓?#28003;跨敤hash join鏂?#23534;忚繘琛屽琛?#37711;?#38001;?#37510;?/span>

    select /*+ no_use_hash(t,t1) */ t.* from t,t1 where t.id=t1.id;

    /*+ no_use_merge(table_1,table_2) */
    ?#28266;澶?#29723;?#37711;?#38001;?#37836;?#29831;?#28051;紝鎸囧畾涓?#28003;跨敤merge join鏂?#23534;忚繘琛屽琛?#37711;?#38001;?#37510;?/span>

    select /*+ no_use_merge(t,t1) */ t.* from t,t1 where t.id=t1.id;

    鍏?#28000;栧?#21733;敤鐨刪int

    /*+ parallel(table_name n) */

    ?#28266;sql涓?#37816;囧畾鎵?#29723;?#37928;勫苟琛屽害?#32029;?#32342;涓?#37706;煎?#21973;細瑕?#37929;?#38007;?#38892;?#37928;勫苟琛屽害

    select /*+ parallel(t 4) */ count(*)  from t;

    /*+ no_parallel(table_name) */

    ?#28266;sql涓?#37816;囧畾鎵?#29723;?#37928;?#28051;?#28003;跨敤?#33503;琛?br />

    select /*+ no_parallel(t) */ count(*)  from t;

    /*+ append */浠洿鎺?#37716;犺浇鐨?#37826;?#23534;忓皢鏁版嵁鍔犺浇鍏?#25652;?

    insert into t /*+ append */ select * from t;

    /*+ dynamic_sampling(table_name n) */

    璁剧疆sql鎵?#29723;?#37827;?#37716;?#37804;?#38322;囩敤鐨勭骇鍒紝?#32342;涓?#32510;?#37714;?#28051;?~10
    select /*+ dynamic_sampling(t 4) */ * from t where id > 1234

    /*+ cache(table_name) */
    杩?#29723;?#37711;?#29723;?#37813;?#37819;?#37827;?#28751;table?#30086;浜LRU鍒?#29723;?#37928;?#37832;?#26943;璺?#32468;紝?#34987;浼?#27996;巘able鐨刢ache灞?#37804;?br />

    select /*+ full(employees) cache(employees) */ last_name from employees
    闄勫綍hint琛?#37837;?/strong>

    Hints for Optimization Approaches and Goals

    ALL_ROWS The ALL_ROWS hint explicitly chooses the cost-based approach to optimize a statement block with a goal of best throughput (that is, minimum total resource consumption).
    FIRST_ROWS The FIRST_ROWS hint explicitly chooses the cost-based approach to optimize a statement block with a goal of best response time (minimum resource usage to return first row). In newer Oracle version you should give a parameter with this hint: FIRST_ROWS(n) means that the optimizer will determine an executionplan to give a fast response for returning the first n rows.
    CHOOSE The CHOOSE hint causes the optimizer to choose between the rule-based approach and the cost-based approach for a SQL statement based on the presence of statistics for the tables accessed by the statement
    RULE The RULE hint explicitly chooses rule-based optimization for a statement block. This hint also causes the optimizer to ignore any other hints specified for the statement block. The RULE hint does not work any more in Oracle 10g.

    Hints for Access Paths

    FULL The FULL hint explicitly chooses a full table scan for the specified table. The syntax of the FULL hint is FULL(table) where table specifies the alias of the table (or table name if alias does not exist) on which the full table scan is to be performed.
    ROWID The ROWID hint explicitly chooses a table scan by ROWID for the specified table. The syntax of the ROWID hint is ROWID(table) where table specifies the name or alias of the table on which the table access by ROWID is to be performed. (This hint depricated in Oracle 10g)
    CLUSTER The CLUSTER hint explicitly chooses a cluster scan to access the specified table. The syntax of the CLUSTER hint is CLUSTER(table) where table specifies the name or alias of the table to be accessed by a cluster scan.
    HASH The HASH hint explicitly chooses a hash scan to access the specified table. The syntax of the HASH hint is HASH(table) where table specifies the name or alias of the table to be accessed by a hash scan.
    HASH_AJ The HASH_AJ hint transforms a NOT IN subquery into a hash anti-join to access the specified table. The syntax of the HASH_AJ hint is HASH_AJ(table) where table specifies the name or alias of the table to be accessed.(depricated in Oracle 10g)
    INDEX The INDEX hint explicitly chooses an index scan for the specified table. The syntax of the INDEX hint is INDEX(table index) where:table specifies the name or alias of the table associated with the index to be scanned and index specifies an index on which an index scan is to be performed. This hint may optionally specify one or more indexes:
    NO_INDEX The NO_INDEX hint explicitly disallows a set of indexes for the specified table. The syntax of the NO_INDEX hint is NO_INDEX(table index)
    INDEX_ASC The INDEX_ASC hint explicitly chooses an index scan for the specified table. If the statement uses an index range scan, Oracle scans the index entries in ascending order of their indexed values.
    INDEX_COMBINE If no indexes are given as arguments for the INDEX_COMBINE hint, the optimizer will use on the table whatever boolean combination of bitmap indexes has the best cost estimate. If certain indexes are given as arguments, the optimizer will try to use some boolean combination of those particular bitmap indexes. The syntax of INDEX_COMBINE is INDEX_COMBINE(table index).
    INDEX_JOIN Explicitly instructs the optimizer to use an index join as an access path. For the hint to have a positive effect, a sufficiently small number of indexes must exist that contain all the columns required to resolve the query.
    INDEX_DESC The INDEX_DESC hint explicitly chooses an index scan for the specified table. If the statement uses an index range scan, Oracle scans the index entries in descending order of their indexed values.
    INDEX_FFS This hint causes a fast full index scan to be performed rather than a full table.
    NO_INDEX_FFS Do not use fast full index scan (from Oracle 10g)
    INDEX_SS Exclude range scan from query plan (from Oracle 10g)
    INDEX_SS_ASC Exclude range scan from query plan (from Oracle 10g)
    INDEX_SS_DESC Exclude range scan from query plan (from Oracle 10g)
    NO_INDEX_SS The NO_INDEX_SS hint causes the optimizer to exclude a skip scan of the specified indexes on the specified table. (from Oracle 10g)

    Hints for Query Transformations

    NO_QUERY_TRANSFORMATION Prevents the optimizer performing query transformations. (from Oracle 10g)
    USE_CONCAT The USE_CONCAT hint forces combined OR conditions in the WHERE clause of a query to be transformed into a compound query using the UNION ALL set operator. Normally, this transformation occurs only if the cost of the query using the concatenations is cheaper than the cost without them.
    NO_EXPAND The NO_EXPAND hint prevents the optimizer from considering OR-expansion for queries having OR conditions or IN-lists in the WHERE clause. Usually, the optimizer considers using OR expansion and uses this method if it decides that the cost is lower than not using it.
    REWRITE The REWRITE hint forces the optimizer to rewrite a query in terms of materialized views, when possible, without cost consideration. Use the REWRITE hint with or without a view list. If you use REWRITE with a view list and the list contains an eligible materialized view, then Oracle uses that view regardless of its cost.
    NOREWRITE / NO_REWRITE In Oracle 10g renamed to NO_REWRITE. The NOREWRITE/NO_REWRITE hint disables query rewrite for the query block, overriding the setting of the parameter QUERY_REWRITE_ENABLED.
    MERGE The MERGE hint lets you merge views in a query.
    NO_MERGE The NO_MERGE hint causes Oracle not to merge mergeable views. This hint is most often used to reduce the number of possible permutations for a query and make optimization faster.
    FACT The FACT hint indicated that the table should be considered as a fact table. This is used in the context of the star transformation.
    NO_FACT The NO_FACT hint is used in the context of the star transformation to indicate to the transformation that the hinted table should not be considered as a fact table.
    STAR_TRANSFORMATION The STAR_TRANSFORMATION hint makes the optimizer use the best plan in which the transformation has been used. Without the hint, the optimizer could make a query optimization decision to use the best plan generated without the transformation, instead of the best plan for the transformed query.
    NO_STAR_TRANSFORMATION Do not use star transformation (from Oracle 10g)
    UNNEST The UNNEST hint specifies subquery unnesting.
    NO_UNNEST Use of the NO_UNNEST hint turns off unnesting for specific subquery blocks.

    Hints for Join Orders

    LEADING Give this hint to indicate the leading table in a join. This will indicate only 1 table. If you want to specify the whole order of tables, you can use the ORDERED hint. Syntax: LEADING(table)
    ORDERED The ORDERED hint causes Oracle to join tables in the order in which they appear in the FROM clause. If you omit the ORDERED hint from a SQL statement performing a join , the optimizer chooses the order in which to join the tables. You may want to use the ORDERED hint to specify a join order if you know something about the number of rows selected from each table that the optimizer does not. Such information would allow you to choose an inner and outer table better than the optimizer could.

    Hints for Join Operations

    USE_NL The USE_NL hint causes Oracle to join each specified table to another row source with a nested loops join using the specified table as the inner table. The syntax of the USE_NL hint is USE_NL(table table) where table is the name or alias of a table to be used as the inner table of a nested loops join.
    NO_USE_NL Do not use nested loop (from Oracle 10g)
    USE_NL_WITH_INDEX Specifies a nested loops join. (from Oracle 10g)
    USE_MERGE The USE_MERGE hint causes Oracle to join each specified table with another row source with a sort-merge join. The syntax of the USE_MERGE hint is USE_MERGE(table table) where table is a table to be joined to the row source resulting from joining the previous tables in the join order using a sort-merge join.
    NO_USE_MERGE Do not use merge (from Oracle 10g)
    USE_HASH The USE_HASH hint causes Oracle to join each specified table with another row source with a hash join. The syntax of the USE_HASH hint is USE_HASH(table table) where table is a table to be joined to the row source resulting from joining the previous tables in the join order using a hash join.
    NO_USE_HASH Do not use hash (from Oracle 10g)
    Hints for Parallel Execution
    PARALLEL The PARALLEL hint allows you to specify the desired number of concurrent query servers that can be used for the query. The syntax is PARALLEL(table number number). The PARALLEL hint must use the table alias if an alias is specified in the query. The PARALLEL hint can then take two values separated by commas after the table name. The first value specifies the degree of parallelism for the given table, the second value specifies how the table is to be split among the instances of a parallel server. Specifying DEFAULT or no value signifies the query coordinator should examine the settings of the initialization parameters (described in a later section) to determine the default degree of parallelism.
    NOPARALLEL / NO_PARALLEL The NOPARALLEL hint allows you to disable parallel scanning of a table, even if the table was created with a PARALLEL clause. In Oracle 10g this hint was renamed to NO_PARALLEL.
    PQ_DISTRIBUTE The PQ_DISTRIBUTE hint improves the performance of parallel join operations. Do this by specifying how rows of joined tables should be distributed among producer and consumer query servers. Using this hint overrides decisions the optimizer would normally make.
    NO_PARALLEL_INDEX The NO_PARALLEL_INDEX hint overrides a PARALLEL attribute setting on an index to avoid a parallel index scan operation.
    Additional Hints
    APPEND When the APPEND hint is used with the INSERT statement, data is appended to the table. Existing free space in the block is not used. If a table or an index is specified with nologging, this hint applied with an insert statement produces a direct path insert which reduces generation of redo.
    NOAPPEND Overrides the append mode.
    CACHE The CACHE hint specifies that the blocks retrieved for the table in the hint are placed at the most recently used end of the LRU list in the buffer cache when a full table scan is performed. This option is useful for small lookup tables. In the following example, the CACHE hint overrides the table default caching specification.
    NOCACHE The NOCACHE hint specifies that the blocks retrieved for this table are placed at the least recently used end of the LRU list in the buffer cache when a full table scan is performed. This is the normal behavior of blocks in the buffer cache.
    PUSH_PRED The PUSH_PRED hint forces pushing of a join predicate into the view.
    NO_PUSH_PRED The NO_PUSH_PRED hint prevents pushing of a join predicate into the view.
    PUSH_SUBQ The PUSH_SUBQ hint causes nonmerged subqueries to be evaluated at the earliest possible place in the execution plan.
    NO_PUSH_SUBQ The NO_PUSH_SUBQ hint causes non-merged subqueries to be evaluated as the last step in the execution plan.
    QB_NAME Specifies a name for a query block. (from Oracle 10g)
    CURSOR_SHARING_EXACT Oracle can replace literals in SQL statements with bind variables, if it is safe to do so. This is controlled with the CURSOR_SHARING startup parameter. The CURSOR_SHARING_EXACT hint causes this behavior to be switched off. In other words, Oracle executes the SQL statement without any attempt to replace literals by bind variables.
    DRIVING_SITE The DRIVING_SITE hint forces query execution to be done for the table at a different site than that selected by Oracle
    DYNAMIC_SAMPLING The DYNAMIC_SAMPLING hint lets you control dynamic sampling to improve server performance by determining more accurate predicate selectivity and statistics for tables and indexes. You can set the value of DYNAMIC_SAMPLING to a value from 0 to 10. The higher the level, the more effort the compiler puts into dynamic sampling and the more broadly it is applied. Sampling defaults to cursor level unless you specify a table.
    SPREAD_MIN_ANALYSIS This hint omits some of the compile time optimizations of the rules, mainly detailed dependency graph analysis, on spreadsheets. Some optimizations such as creating filters to selectively populate spreadsheet access structures and limited rule pruning are still used. (from Oracle 10g)

    Hints with unknown status

    MERGE_AJ The MERGE_AJ hint transforms a NOT IN subquery into a merge anti-join to access the specified table. The syntax of the MERGE_AJ hint is MERGE_AJ(table) where table specifies the name or alias of the table to be accessed.(depricated in Oracle 10g)
    AND_EQUAL The AND_EQUAL hint explicitly chooses an execution plan that uses an access path that merges the scans on several single-column indexes. The syntax of the AND_EQUAL hint is AND_EQUAL(table index index) where table specifies the name or alias of the table associated with the indexes to be merged. and index specifies an index on which an index scan is to be performed. You must specify at least two indexes. You cannot specify more than five. (depricated in Oracle 10g)
    STAR The STAR hint forces the large table to be joined last using a nested loops join on the index. The optimizer will consider different permutations of the small tables. (depricated in Oracle 10g)
    BITMAP Usage: BITMAP(table_name index_name) Uses a bitmap index to access the table. (depricated ?)
    HASH_SJ
    Use a Hash Anti-Join to evaluate a NOT IN sub-query. Use this hint in the sub-query, not in the main query. Use this when your high volume NOT IN sub-query is using a FILTER or NESTED LOOPS join. Try MERGE_AJ if HASH_AJ refuses to work.(depricated in Oracle 10g)
    NL_SJ Use a Nested Loop in a sub-query. (depricated in Oracle 10g)
    NL_AJ Use an anti-join in a sub-query. (depricated in Oracle 10g)
    ORDERED_PREDICATES (depricated in Oracle 10g)
    EXPAND_GSET_TO_UNION (depricated in Oracle 10g)


    鍙傝?#38007;?#38171;?#37510;?#29825;Oracle璺戝緱?#27967;蹇?#37510;嬭碍鎬杩滆憲



    ]]>
    oracle table-lock鐨?绉嶆寮?/title><link>http://www.67529968.com/rabbit/archive/2013/11/05/406007.html</link><dc:creator>Rabbit</dc:creator><author>Rabbit</author><pubDate>Tue, 05 Nov 2013 06:31:00 GMT</pubDate><guid>http://www.67529968.com/rabbit/archive/2013/11/05/406007.html</guid><wfw:comment>http://www.67529968.com/rabbit/comments/406007.html</wfw:comment><comments>http://www.67529968.com/rabbit/archive/2013/11/05/406007.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.67529968.com/rabbit/comments/commentRss/406007.html</wfw:commentRss><trackback:ping>http://www.67529968.com/rabbit/services/trackbacks/406007.html</trackback:ping><description><![CDATA[<span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; font-weight: bold;">Oracle涓?#37928;?#38335;佸畾鍙?#28000;?#37714;?#28051;?#37713;犵被锛?/span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">1銆丏ML lock锛坉ata lock锛夛紝</span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">2銆丏DL lock锛坉ictionary lock)</span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">3銆乮nternal lock/latch銆?/span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">DML lock鍙?#37721;?#28000;?#37714;?#28051;簉ow lock?#25328;table lock銆俽ow lock?#28266;select.. for update/insert/update/delete鏃堕殣寮?#38007;?#37716;?#27996;?#37922;燂紝鑰宼able lock闄?#27996;?#38341;?#23534;?#27996;?#37922;燂紝?#31683;鍙?#28000;?#29835;冪敤lock table <table_name> in </table_name> name鏉?#37828;剧?#27946;?#20344;畾銆?/span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">濡傛灉涓嶅笇鏈?#37714;?#37928;剆ession lock/insert/update/delete琛?#28051;?#28000;绘剰涓琛岋紝鍙?#37711;?#29825;?#37836;?#29831;紝鍙?#28000;敤lock table table_name in exclusive mode銆?X)?#32342;涓?#38335;佸畾妯?#23534;忕骇鍒?#37832;楂橈紝?#33503;鍙?#25652;?#37832;灏?#37510;?/span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">濡傛灉鍏?#29825;?#37714;?#37928;剆ession鏌?#29831;?#37812;栫敤select for update閿佸畾璁板綍?#32029;涓?#37711;?#29825;insert/update/delete?#32029;鍙?#28000;敤</span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; color: red;">lock table table_name in share row exclusive mode銆?SRX)</span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">濡傛灉鍏?#29825;?#37714;?#37928;剆ession鏌?#29831;?#37812;杝elect for update浠?#37721;lock table table_name in share mode?#32029;鍙槸涓?#37711;?#29825;insert/update/delete?#32029;鍙?#28000;敤</span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">lock table table_name in share mode銆?share mode?#25328;share row exclusive mode鐨勫?#21700;埆?#28266;浜?#28051;涓槸闈炴姠鍗?#23534;?#37928;勮屽彟涓涓槸?#23008;鍗?#23534;?#37928;?#37510;傝繘鍏share row exclusive mode鍚?#37711;?#28000;杝ession涓?#38003;介樆姝?#28003;爄nsert/update/delete?#32029;鑰岃繘鍏share mode鍚?#37711;?#28000;杝ession?#31683;鍚?#37837;?#37721;?#28000;?#26473;?#37711;share mode?#32029;杩涜?#38339;?#23005;?#28003;?#28725;?#29723;?#37928;勪慨鏀?#37510;?S)</span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">杩?#37832;?#28051;?#32457;嶉?#20344;畾妯?#23534;忥紝row share(RS)?#25328;row exclusive(RX)銆?#28000;?#28000;?#37711;?#29825;?#37928;勫苟鍙戞搷浣滄洿澶氾紝涓鑸洿鎺敤DML璇?#37721;?#38007;?#37716;?#38014;峰?#26955;紝鑰?#28051;嶇敤lock璇?#37721;?#37510;?/span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">璇?#32513;?#37721;傝僣oncepts?#26499;妗?#28051;?#37928;?Type Of Locks"锛?/span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96524/c21cnsis.htm#2937 </span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">-------------------------------------</span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="font-weight: bold;">鎬?#28052;unlock table 瑙?#38335;?/span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; font-weight: bold;">鏂规硶涓銆乲ill session锛?/span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">SQL> select object_id,session_id from v$locked_object;  //?#25950;?#21104;session_id 灏辨槸涓婇攣鐨?session鏍?#36423;?/span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">SQL> select username,sid,SERIAL#  from v$session where sid=銆?#37510;?      //?#32342;閲?#37928;凷ID = session_id </span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; background-color: #ffffff;">SQL> alter system kill session 'id,serial#';     //?#28483;姝?#29831;session</span><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><br style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px;" /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; font-weight: bold;">鏂规硶浜?#37510;乺ollback/commit 缁?#23005;?#27996;?#37716;?#28598;?#37918;?br /><br /><br /></span><a href="http://blog.chinaunix.net/uid-8504518-id-3436965.html" style="word-wrap: break-word; color: #19599b; font-family: 寰?#26462;?#38342;?#27035;? 榛?#28003;? Verdana; font-size: 20px; background-color: #ffffff;">ORACLE 澶?#29723;缓绔嬬储寮?#37928;?#28051;浜涜冭檻</a><span style="color: #565656; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 12px; background-color: #ffffff;"> </span><br /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; font-weight: bold;"><br /></span><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">棣?#37711;紝</span><strong style="word-wrap: break-word; color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">?#31794;褰?#38000;冭檻琛?#32460;?#38338;?#37724;岀鐩?#32460;?#38338;存槸鍚?#29906;?#28598;?/strong><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">銆傛垜浠煡閬撶储寮曚篃?#27128;涓绉?#37825;版嵁?#32029;?#28266;?#32531;绔嬬储寮?#37928;?#37827;跺?#37716;?#36423;呬篃?#32048;鍗犵敤澶?#38322;?#29723;?#32460;?#38338;?#37510;?#37733;犳?#28266;瀵?#28051;寮?#28598;?#29723;缓绔嬬储寮?#37928;?#37827;跺?#26851;?#37711;堝簲褰?#38000;冭檻鐨勬槸绌?#38338;?#28729;?#38322;?#38338;?#26864;?#37510;?/span><br style="word-wrap: break-word; color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;" /><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">鍏舵?#32029;?#28266;瀵瑰缓绔嬬储寮?#37928;?#37827;跺?#29781;?#28725;?#29723;?#26473;?#29723;屽姞閿侊紝鍥犳?#31794;褰撴敞?#21104;</span><strong style="word-wrap: break-word; color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">?#25655;浣滃湪涓?#37716;?#32460;?#38338;?#37928;?#37827;跺?#26473;?#29723;?/strong><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">銆?/span><br style="word-wrap: break-word; color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;" /><strong style="word-wrap: break-word; color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;"><em style="word-wrap: break-word;">鎬?#38003;?#29835;?#37825;?#37826;规硶锛?/em></strong><br style="word-wrap: break-word; color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;" /><font color="#0000F0" style="word-wrap: break-word; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">棣?#37711;?#25652;旇冭檻IO?#32029; 鐗?#37918;?#28051;婏紝?#31794;褰?#28751;介?#24532;?#23108;储寮?#28051;?#37825;版嵁鍒?#37825;埌涓?#37722;?#37928;勭鐩?#28051;?#37510;?閫昏緫涓婏紝鏁版嵁琛?#32460;?#38338;?#28051;庣储寮?#29723;?#32460;?#38338;?#37714;?#23534;銆傝繖?#27128;?#28266;?#32531;?#20648;寮?#37827;跺簲褰?#28751;?#28729;?#37928;勫熀鏈?#37720;熷垯</font><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">銆?/span><br style="word-wrap: break-word; color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;" /><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">鍏舵?#32029;</span><font color="#0000F0" style="word-wrap: break-word; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">?#28266;?#32531;绔嬬储寮?#37928;?#37827;跺?#29781;?#28725;?#29723;?#26473;?#29723;?#37711;?#29723;?#37928;勬壂鎻忓伐浣?/font><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">?#32029;鍥犳?#32029;?#31794;褰?#38000;冭?#25123;皟澶?#37714;濆鍖栧?#20635;暟</span><font color="#0000F0" style="word-wrap: break-word; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">db_file_multiblock_read_count鐨勫?#37510;?#28051;鑸?#29825;剧疆涓?6鎴栨洿澶?/font><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">銆?/span><br style="word-wrap: break-word; color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;" /><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">鍐?娆紝</span><font color="#0000F0" style="word-wrap: break-word; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">?#32531;绔嬬储寮?#38340;?#27996;?#29781;?#26473;?#29723;?#37711;?#29723;?#37813;?#37819;?#28598;栧悓鏃?#26473;?#29781;?#28725;?#37825;版嵁杩?#29723;屽閲?#37928;勬帓搴忔搷浣?/font><span style="color: #666666; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">?#32029;鍥犳?#32029;?#31794;褰撹皟鏁存帓搴忓尯鐨勫灏?#37510;傚湪9I涔嬪墠?#32029; 鍙?#28000;湪SESSION绾?#37714;?#28051;?#37716;?#28598;sort_area_size 鐨勫灏忥紝 ?#30254;濡傝?#21095;疆涓?00M鎴栬呮洿澶?#37510;?I 浠?#37722;庯紝 濡傛灉</span><font color="#0000F0" style="word-wrap: break-word; font-family: 瀹嬩綋, Arial; font-size: 12px; line-height: 26px; background-color: #ffffff;">鍒濆鍖栧?#20635;暟workarea_size_policy鐨勫?#28051;TRUE?#32029; 鍒?#37818;?#25652;忓尯浠嶱GA_AGGREGATE_TARGET閲?#38007;?#37716;?#37714;嗛?#23944;?#23792;緱</font><br /><span style="color: #4b4b4b; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19px; font-weight: bold;"><br /><br /></span><img src ="http://www.67529968.com/rabbit/aggbug/406007.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.67529968.com/rabbit/" target="_blank">Rabbit</a> 2013-11-05 14:31 <a href="http://www.67529968.com/rabbit/archive/2013/11/05/406007.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>浣跨敤 EclEmma 杩?#29723;岃鐩?#23092;?#29831;?/title><link>http://www.67529968.com/rabbit/archive/2013/11/01/405872.html</link><dc:creator>Rabbit</dc:creator><author>Rabbit</author><pubDate>Fri, 01 Nov 2013 01:43:00 GMT</pubDate><guid>http://www.67529968.com/rabbit/archive/2013/11/01/405872.html</guid><wfw:comment>http://www.67529968.com/rabbit/comments/405872.html</wfw:comment><comments>http://www.67529968.com/rabbit/archive/2013/11/01/405872.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.67529968.com/rabbit/comments/commentRss/405872.html</wfw:commentRss><trackback:ping>http://www.67529968.com/rabbit/services/trackbacks/405872.html</trackback:ping><description><![CDATA[<p>瑕?#37929;?#23092;?#29831;曟槸琛?#38322;忔祴璇曡川閲?#37928;?#28051;涓?#38322;?#29781;?#37816;囨爣銆傚湪瀵?#28051;涓?#26462;欢浜?#37725;?#26473;?#29723;?#27996;?#37719;?#37711;?#23092;?#29831;?#37510;?#32513;勮娴?#29831;?#37510;侀泦鎴?#23092;?#29831;?#28000;?#37721;?#37818;?#37721;?#23092;?#29831;?#32475;夌澶?#37928;?#23092;?#29831;?#28052;?#37722;庯紝鎴?#28000;?#38003;?#28051;?#38003;?#28751;?#23005;?#28725;?#26462;欢鐨勮川閲?#27996;?#37922;?#28051;?#30078;鐨?#28103;?#36423;冨锛熻繖灏遍渶瑕佹垜浠?#28725;?#23092;?#29831;?#37928;勮川閲忚繘琛岃?#28725;?#37510;傚?#20635;灉娴?#29831;?#28000;?#29781;?#37929;?#27996;?#28000;?#37934;?#37928;?#28051;灏忛儴鍒嗭紝閭?#28052;?#28051;嶇鎴?#28000;?#37712;?#27996;?#28598;?#28751;戞祴璇曠敤渚嬶紝鎴?#28000;篃涓?#38003;?#37929;?#28103;?#26462;欢?#24029;閲忔槸鏈?#28103;?#29831;?#37928;?#37510;傜浉鍙嶏紝濡傛灉娴?#29831;?#29781;?#37929;栧埌浜嗚蒋?#27426;鐨?#32513;濆?#20788;鍒?#28000;?#37934;侊紝鎴?#28000;?#28751;?#38003;?#28725;?#26462;欢鐨勮川閲?#37832;?#28051;涓?#37722;?#37918;?#37928;?#28103;?#36423;?#37510;傛湰?#26499;灏?#28000;?#32513;?#28051;涓紭绉鐨勫紑婧?#26462;欢娴?#29831;?#23480;?#37711;?EclEmma?#32029;瀹?#38003;?#28598;?#28725;?#37922;?Java 璇言缂?#37712;?#37928;勭搴忚繘琛岃鐩?#23092;?#29831;曪紝浠庤?#28725;圭搴忚繍琛?#37928;?#32513;撴灉鐢?#37812;?#29831;?#28751;?#37928;?#29781;?#37929;?#23092;?#29831;曟鍛?#37510;?/p> <p class="ibm-no-print ibm-ind-link">2007 骞?5 鏈?10 鏃?/p> <div class="ibm-col-6-2 dw-toc-margin"> <div aria-hidden="true" id="dw-toc" class="ibm-container"> <div class="ibm-container-body"> <ul class="ibm-twisty"><li><a class="ibm-twisty-trigger ibm-twisty-trigger-closed" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#toggle"><img alt="+" src="http://www.ibm.com/i/c.gif" /></a><span class="ibm-twisty-head">鍐呭</span> <div style="display: none" class="ibm-twisty-body"> <ul style="font-size: 0.8em" class="ibm-link-list"><li><a class="ibm-anchor-down-em-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#N10032">浠?#32513;?/a></li><li><a class="ibm-anchor-down-em-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#N1004D">瀹夎 EclEmma 鎻掍欢</a></li><li><a class="ibm-anchor-down-em-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#N10070">浣跨敤 EclEmma 娴?#29831;?Java 绋?#25652;?/a></li><li><a class="ibm-anchor-down-em-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#N100DD">EclEmma 鐨?#26946;?#32510;壒鎬?/a></li><li><a class="ibm-anchor-down-em-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#N10101">缁?#29825;?/a></li><li><a class="ibm-anchor-down-em-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#resources">鍙傝冭祫鏂?</a></li><li><a class="ibm-anchor-down-em-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#icomments">璇勮</a></li></ul></div></li></ul></div></div></div><!-- SUMMARY_END --> <div id="ibm-pcon"><!-- BEGIN_IBM-CONTENT --> <div id="ibm-content"><!-- BEGIN_IBM-CONTENT-BODY --> <div id="ibm-content-body"><!-- BEGIN_IBM-CONTENT-MAIN --> <div id="ibm-content-main"><!-- 1_1_COLUMN_BEGIN --> <div class="ibm-columns"> <div class="ibm-col-1-1"> <h2 id="N10032">浠?#32513;?/h2> <p>鐜板湪 IT 寮鍙?#27996;哄?#27195;瘮浠?#23536;浠?#28003;?#37827;跺?#38318;芥洿鍔?#37711;虫敞娴?#29831;?#37928;?#38322;?#29781;佹紝?#30149;鏈?#32513;忚繃鑹?#28610;?#23092;?#29831;?#37928;?#28000;?#37934;佹洿瀹?#37828;?#37713;?#38338;?#26864;?#37510;傚湪鏋?#38340;愮?#26667;涓紝娴?#29831;曢鍔?#23534;鍙戝凡缁忚璇佹槑?#27128;涓绉?#37832;?#37825;?#37819;?#26946;樿蒋?#27426;?#24029;閲?#37928;?#37826;规硶銆傚湪娴?#29831;曢鍔?#37928;勫紑鍙?#37826;?#23534;?#28051;紝杞欢宸?#32459;?#29999;堝湪缂?#37712;?#37716;?#38003;?#28000;?#37934;?#28052;?#37715;嶉鍏?#32514;?#37712;?#23092;?#29831;?#28000;?#37934;侊紝?#32342;鏍?#38003;?#28000;?#37832;寮濮嬩繚璇佺搴?#28000;?#37934;?#37928;?#23005;?#32429;?#37804;紝?#33503;涓旇兘澶熷湪绋?#25652;?#37928;勬?#24532;婕旇繘鏃?#26473;?#29723;?#38007;?#37716;?#37928;勫褰?#23092;?#29831;?#37510;傛祴璇?#28725;?#27996;?#26462;欢浜?#37725;?#37928;?#37812;?#29840;?#29863;风潃鑷?#37711;?#38322;?#29781;?#37928;?#28003;滅敤?#32029;?#28266;鏋?#38340;愮?#26667;棰嗗煙?#32029;鐢?#38007;?#37832;?#27996;?#37819;?#29825;?#28000;?#28003;?#37832;?#32513;忔祴璇?#37928;?#28000;?#37934;侀兘搴旇鑷?#37716;?#28000;?#37721;戝竷鐨?#27996;?#37725;?#28051;?#37714;?#38340;?#37510;?#28003;?#38000;呭苟涓嶇淇繖涓?#29785;?#37904;规槸姝?#32429;?#37928;勶紝浣嗘槸娴?#29831;?#37832;?#38892;?#37928;勮川閲?#32429;?#28729;炴槸涓涓渶瑕?#26946;?#25652;?#37711;虫敞鐨?#38338;?#26864;?#37510;傛祴璇?#37928;?#29781;?#37929;栫?#22248;槸娴?#29831;曡川閲?#37928;?#28051;涓?#38322;?#29781;?#37816;囨爣?#32029;鎴?#28000;渶瑕佸伐鍏?#37833;?#29999;?#37716;?#37812;?#28000;?#26473;?#29723;?#28725;?#26462;欢娴?#29831;?#29781;?#37929;栫殑鑰?#28725;?#37510;?/p> <p>EclEmma 灏辨槸?#32342;鏍?#28051;涓?#38003;?#29999;?#37716;?#23534;鍙?#27996;哄?#27199;?#28725;?#23092;?#29831;?#29781;?#37929;栫巼鐨勪紭绉鐨?Eclipse 寮婧?#37819;掍欢銆侲clEmma ?#28266;瑕?#37929;?#23092;?#29831;?#26864;嗗煙?#27128;濡傛鐨勪紭绉?#32029;浠?#38007;?#27996;?#28729;冨湪杩囧幓涓?#28052;?#37928;?2006 骞?#37812;?#28051;?#27996;?Eclipse Community Awards Winners 鍐宠禌閫?#37813;?#37510;傝?#30028;劧鏈鍚?Eclipse Checkstyle Plugin 鍙栧緱浜?Best Open Source Eclipse-based Developer tool 鐨?#32457;?#37721;凤紝浣?#37812;?#28000;篃鍙?#28000;?#37922;?#23005;湅?#22476; EclEmma 瀵?#23534;鍙?#27996;哄憳鐨勫鍔槸宸?#28598;?#37928;?#38171;圗clipse Community Award 鐨勫叿浣?#28103;伅鍙?#28000;?#37721;傞槄 <a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#resources">鍙傝冭?#21228;簮</a>锛?#37510;?/p> <p>鎻愬埌 EclEmma 棣?#37711;堝氨瑕?#29831;村埌?#25010;鍚?#37928;?Java 瑕?#37929;?#23092;?#29831;?#23480;?#37711;?Emma銆侲mma ?#27128;涓涓湪 SourceForge 涓?#26473;?#29723;?#37928;勫紑婧?#26916;?#37929;?#38171;?#37721;傞槄 <a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#resources">鍙傝冭?#21228;簮</a>锛?#37510;?#28000;?#37836;愮?#23943;搴?#28051;?#29831;达紝EclEmma 鍙?#28000;?#37930;嬩綔?#27128; Emma 鐨?#28051;涓?#37733;?#35120;晫?#28528;銆傚湪鏈枃鐨?a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#resources">鍙傝冩枃鐚?/a>涓紝鍙?#28000;湅?#22476;涓?#38338;?#29825;茶堪浣跨敤 Emma 鐨勬妧鏈枃绔?#37510;?/p> <p>Emma 鐨?#28003;?#38000;呭紑鍙?Emma 涔?#37714;紝绋?#25652;忓憳宸?#32513;?#37832;?#27996;?#37722;?#32457;?#37722;?#37837;蜂紭绉鐨勫紑婧?Java 寮鍙戝伐鍏?#37510;?#28051;?#28186;嬫潵璇达紝鎴?#28000;?#37832;変紭绉鐨?#38342;?#37812;?#23534;鍙?#37916;?#28583;?Eclipse?#32029;鏈?#23534;婧?#37928;?JDK?#32029;鏈?#37719;?#37711;?#23092;?#29831;?#23480;?#37711;?JUnit?#32029;鏈?Ant ?#32342;鏍?#37928;?#26916;?#37929;?#32480;?#37918;嗗伐鍏凤紝鎴?#28000;?#26473;?#37721;?#28000;敤 CVS 鎴?SubVersion 鏉?#26473;?#29723;屾簮浠?#37934;佺増鏈?#37928;?#32513;存銆傚綋鏃剁?#23339;潵?#32029;?#31683;璁稿敮涓缂哄皯鐨勫氨?#27128;涓涓?#23534;婧?#37928;?#29781;?#37929;?#23092;?#29831;?#23480;?#37711;?#27996;?#37510;侲mma 灏辨槸涓?#27996;?#28617;?#29723;繖椤?#32460;虹櫧鑰岀敓鐨?#37510;傜?#26495;湪鐨勬儏鍐?#23480;?#32513;忓拰 Emma 璇?#37922;?#37928;?#37827;跺?#28051;?#28051;鏍?#37928;?#37510;傛椂鑷充粖鏃紝鎴?#28000;?#23480;?#32513;?#37832;?#27996;?#28051;嶅皯鐨?#29781;?#37929;?#23092;?#29831;?#23480;?#37711;?#37510;備緥濡?Coverlipse ?#27128;涓涓熀浜?Eclipse 鐨?#29781;?#37929;?#23092;?#29831;?#37819;掍欢銆?#37711;?#28000;?#26473;?#37832;?Cobertura?#32029;Quilt ?#25328; JCoverage 绛?#37510;?#28003;嗘槸 Emma 鍏?#37832;?#28051;浜?#38344;?#29999;镐紭绉鐨勭壒鎬?#28003;?#23536;?#28729;冩洿閫傚悎琚?#39582;?#23049;?#37928;?#28003;跨敤銆傚拰 Coverlipse 绛夊伐鍏?#23011;旇捣鏉紝Emma ?#27128;寮婧?#37928;勶紝鍚?#37827;?#28729;?#28725;瑰簲?#25956;绋?#25652;忔墽琛?#38315;?#25652;?#37928;勫?#21342;搷闈?#29999;?#28751;?#37510;?/p> <p>EclEmma 鐨勫嚭鐜?#23534;?#29723;?#27996;?Emma ?#25956;鎴?#28051;涓?#28598;?#37928;?#38316;楁 ---- 缂?#28052;?#37733;?#35120;晫?#28528;浠?#37721;?#28725;归泦鎴?#23534;鍙?#37916;?#28583;?#37928;勬敮鎸?#37510;傚皢 Eclipse ?#25328; Emma ?#32342;涓?#28051;湪鍚?#38007;?#26864;嗗煙鏈涓轰紭绉鐨勫伐鍏?#32513;?#37722;?#29863;?#37833;紝?#32342;灏辨槸 EclEmma 涓烘垜浠?#37819;愪緵鐨?#37510;傛帴涓嬫潵?#32029;鎴?#28000;?#28751;?#29781;佸湪鍚?#32513;?#32468;犺妭涓拰璇昏?#37832;?#37721;?#28051;璧风?#23340;湅 EclEmma 涓哄紑鍙?#27996;哄憳鎻愪緵浜?#28000;涔?#37510;?/p> <div class="ibm-alternate-rule"> <hr /> </div> <p class="ibm-ind-link ibm-back-to-top"><a class="ibm-anchor-up-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#ibm-pcon">鍥?#26916;甸</a></p> <h2 id="N1004D">瀹夎 EclEmma 鎻掍欢</h2> <p>瀹夎 EclEmma 鎻掍欢鐨勮?#22249;鍜屽?#20788;鍒?Eclipse 鎻掍欢鐩?#37722;岋紝鎴?#28000;?#37827;?#37721;?#28000;?#38315;?#26473;?Eclipse 鏍?#37713;?#37928;?Update 鏈哄?#33333;潵杩滅瀹夎 EclEmma 鎻掍欢锛?a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#fig001">鍥?1</a>锛夛紝?#31683;鍙?#28000;?#28000;?#32468;?#37904;?#38171;?#37721;傞槄 <a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#resources">鍙傝冭?#21228;簮</a>锛?#28051;嬭浇 zip ?#26499;?#27426;?#33503;瑙?#37720;嬪埌 eclipse 鎵?#28266;鐨?#37929;綍涓?#37510;?/p> <h5 id="fig001">鍥?1 娣?#37716;?EclEmma ?#27967;鏂?#32468;?#37904;?/h5><img alt="鍥?1 娣?#37716;?EclEmma ?#27967;鏂?#32468;?#37904;? src="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/fig001.jpg" width="273" /> <p>涓嶇閲囩敤浣曠鏂?#23534;忔潵瀹夎 EclEmma?#32029;瀹夎?#21613;畬鎴愬苟閲?#37826;?#37722;?#37716;?Eclipse 涔?#37722;庯紝宸?#37711;?#37837;?#28051;?#25652;旇鍑?#37916;?#28051;涓?#37826;?#37928;?#37816;?#38333;?#38171;?/p> <h5 id="fig002">鍥?2 鏂板鐨?#29781;?#37929;?#23092;?#29831;?#37816;?#38333;?/h5><img alt="鍥?2 鏂板鐨?#29781;?#37929;?#23092;?#29831;?#37816;?#38333;? src="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/fig002.jpg" width="231" /> <div class="ibm-alternate-rule"> <hr /> </div> <p class="ibm-ind-link ibm-back-to-top"><a class="ibm-anchor-up-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#ibm-pcon">鍥?#26916;甸</a></p> <h2 id="N10070">浣跨敤 EclEmma 娴?#29831;?Java 绋?#25652;?/h2> <p>涓?#27996;?#28729;為獙 EclEmma 鐨勭壒鎬紝鎴?#28000;?#26851;?#37711;堝湪 Eclipse 鐨?Workspace 涓缓绔?#28051;涓?#37722;?#32457;?#28051;?test.emma 鐨?#37826;?Java 椤?#37929;?#37510;傛帴涓嬫潵?#32029;鎴?#28000;湪鍏?#28051;缓绔?#28051;涓?<code>HelloWorld</code> ?#34987;?#32029;鍏?#28000;?#37934;?#28641;?#28051;嬫墍绀?#38171;?/p> <h5 id="N1007C">娓呭崟 1 ?#25956;浜?#23092;?#29831;?EclEmma 鐨?#28000;?#37934;?/h5> <div class="codesection"><pre class="displaycode">package test.emma; public class HelloWorld { /** * @param args */ public static void main(String[] args) { int rand = (int) (Math.random()*100); if(rand%2==0){ System.out.println( "Hello, world! 0"); } else System.out.println("Hello, world! 1"); int result = rand%2==0? rand+rand:rand*rand; System.out.println(result); } }</pre></div> <p>鎺?#28051;嬫潵?#32029;鎴?#28000;?#38315;?#26473;?EclEmma 杩?#29723;?<code>HelloWorld.main()</code> 鍑?#37825;?#37510;?/p> <h5 id="fig003">鍥?3 瀵?Java ?#31794;?#25956;绋?#25652;忚繘琛岃鐩?#23092;?#29831;?/h5><img alt="鍥?3 瀵?Java ?#31794;?#25956;绋?#25652;忚繘琛岃鐩?#23092;?#29831;? src="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/fig003.jpg" width="420" /> <p>鎵?#29723;屽?#23678;瘯涔?#37722;庯紝鎴?#28000;?#23005;湪缂栬緫 HelloWorld.java 鐨勭獥鍙?#28751;嗕細鍙?#37812;?#28641;?#28051;嬫墍绀?#38171;?/p> <h5 id="fig004">鍥?4 杩?#29723;岃鐩?#23092;?#29831;?#37928;?#32513;撴灉</h5><img alt="鍥?4 杩?#29723;岃鐩?#23092;?#29831;?#37928;?#32513;撴灉" src="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/fig004.jpg" width="318" /> <p>?#28266; Java 缂栬?#25117;櫒涓紝EclEmma ?#25956;涓?#37722;?#37928;勮?#25554;僵鏍?#32448;?#27996;嗘簮浠?#37934;?#37928;?#23092;?#29831;曟儏鍐?#37510;?#37711;?#28051;紝缁胯壊鐨?#29723;?#29723;?#32448;?#29831;?#29723;?#28000;?#37934;?#29722;?#28729;?#37825;?#37928;勬墽琛岋紝绾?#38009;查儴鍒?#29723;?#32448;?#29831;?#29723;?#28000;?#37934;佹牴鏈病鏈夎鎵?#29723;岋紝鑰?#27035;勮壊鐨?#29723;?#29723;槑璇?#29723;?#28000;?#37934;侀儴鍒嗚鎵?#29723;?#37510;?#27035;勮壊鐨?#29723;?#38315;?#29999;?#37713;?#37916;板湪鍗?#29723;?#28000;?#37934;佸?#21613;惈鍒嗘敮鐨勬儏鍐碉紝?#32229;濡?<a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#fig004">鍥?4</a> 涓?#37928;?16 琛屽氨鏄剧涓?#27035;勮壊銆傜敱浜?#32459;?#25652;?#28051;?#37832;?#28051;涓?#38341;?#37832;虹?#30078;鐨勫?#21976;敮?#32029;鍥犳璇昏?#37928;勭獥鍙?#37721;?#38003;?#28051;庤繖閲岀鏈?#28051;?#37722;?#38171;?1 琛?#37812;栬?14 琛?#28051;?#37832;?#28051;?#37721;?#37832;?#28051;涓?#32510;?#38009;?#37928;?#29723;?#38171;?#37510;?/p> <p>闄?#27996;嗗湪婧?#28000;?#37934;?#32514;栬緫?#29541;鍙洿鎺?#26473;?#29723;岀潃鑹?#28052;?#28598;栵紝EclEmma 杩?#37819;愪緵浜?#28051;涓?#37719;曠鐨勮鍥?#37833;?#32513;熻绋?#25652;?#37928;?#29781;?#37929;?#23092;?#29831;曠巼銆?/p> <h5 id="fig005">鍥?5 瀵?#37930;嬬搴?#37928;?#29781;?#37929;?#23092;?#29831;曠巼</h5><img alt="鍥?5 瀵?#37930;嬬搴?#37928;?#29781;?#37929;?#23092;?#29831;曠巼" src="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/fig005.jpg" width="628" /> <p>EclEmma 鎻愪緵鐨?Coverage 瑙?#37733;?#38003;?#28598;熷?#21975;眰鐨?#37828;剧浠?#37934;?#37928;?#29781;?#37929;?#23092;?#29831;曠?#22263;紝<a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#fig005">鍥?5</a> 涓?#37928;?#28103;伅琛槑鎴?#28000;?#28725;?HelloWorld 鐨?#28051;娆?#26473;?#29723;岃鐩?#27996;?#28598;?#32510;?68.6% 鐨?#28000;?#37934;?#37510;?/p> <p>鎯冲湪涓娆?#26473;?#29723;?#28051;?#29781;?#37929;?#37813;鏈?#37928;?#28000;?#37934;?#38315;?#29999;?#23011;旇緝鍥?#38341;撅紝濡傛灉鑳芥澶氭娴?#29831;?#37928;?#29781;?#37929;?#37825;版嵁缁煎悎璧?#37833;?#26473;?#29723;?#28725;?#37930;嬶紝閭?#28052;堟垜浠?#28751;?#38003;芥洿鏂逛究鐨勬帉鎻?#28598;氭娴?#29831;?#37928;?#23092;?#29831;?#37825;堟灉銆侲clEmma 鎻愪緵浜嗚繖鏍?#37928;勫姛鑳?#37510;傜?#26495;湪?#32029;璁?#37812;?#28000;?#38322;?#28598;?#37825;版瀵?HelloWorld 鐨?#29781;?#37929;?#23092;?#29831;?#37510;傛垜浠敞鎰忓埌 Coverage 瑙?#37733;?#37804;绘槸鏄剧?#28888;渶鏂板畬鎴?#37928;?#28051;娆?#29781;?#37929;?#23092;?#29831;?#37510;?#27996;?#28729;?#28051;婏紝EclEmma 涓烘垜浠?#28103;?#28699;?#27996;嗘墍鏈?#37928;?#23092;?#29831;?#32513;撴灉銆傛帴涓嬫潵?#32029;鎴?#28000;?#28751;?#38315;?#26473;?Coverage 瑙?#37733;?#37928;勫伐鍏?#37816;?#38333;?#37833;?#32513;?#37722;?#28598;氭瑕?#37929;?#23092;?#29831;?#37928;?#32513;撴灉銆?/p> <h5 id="fig006">鍥?6 ?#25956;浜?#32513;?#37722;?#28598;氭瑕?#37929;?#23092;?#29831;?#32513;撴灉鐨勫伐鍏?#37837;?#37816;?#38333;?/h5><img alt="鍥?6 ?#25956;浜?#32513;?#37722;?#28598;氭瑕?#37929;?#23092;?#29831;?#32513;撴灉鐨勫伐鍏?#37837;?#37816;?#38333;? src="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/fig006.jpg" width="414" /> <p>褰?#37812;?#28000;?#28598;氭杩?#29723;?Coverage 涔?#37722;庯紝鎴?#28000;?#37721;?#28000;?#37719;?#37713;?<a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#fig006">鍥?6</a> 鎵绀哄伐鍏?#37837;?#37816;?#38333;?#37510;?#28052;?#37722;庯紝涓涓?#28725;?#29831;?#22935;嗗?#21978;?#33034;鍑?#28000;緵?#25956;鎴?#38315;?#37815;渶瑕?#37722;堝苟鐨?#29781;?#37929;?#23092;?#29831;?#37510;?/p> <h5 id="fig007">鍥?7 閫?#37815;渶瑕?#37722;堝苟鐨?#29781;?#37929;?#23092;?#29831;?#32513;撴灉</h5><img alt="鍥?7 閫?#37815;渶瑕?#37722;堝苟鐨?#29781;?#37929;?#23092;?#29831;?#32513;撴灉" src="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/fig007.jpg" width="345" /> <p>?#28266;鍚堝苟瀹?#37812;愪箣鍚庯紝鎴?#28000;?#37721;?#28000;?#29785;傚?#29111;埌 Java 缂栬?#25117;櫒?#25328; Coverage 瑙?#37733;?#28051;兘鏄剧浜?#37722;堝苟涔?#37722;?#37928;?#32513;撴灉锛?/p> <h5 id="fig008">鍥?8 瀵熺湅鍚堝苟鍚?#37928;?#29781;?#37929;?#23092;?#29831;?#32513;撴灉</h5><img alt="鍥?8 瀵熺湅鍚堝苟鍚?#37928;?#29781;?#37929;?#23092;?#29831;?#32513;撴灉" src="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/fig008.jpg" width="636" /> <p><a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#fig008">鍥?8</a> 涓紝鎴?#28000;?#37721;?#28000;湅鍒帮紝閫?#26473;?#28598;氭杩?#29723;岃鐩?#23092;?#29831;曪紝鏈缁堟垜浠?#37928;?#28000;?#37934;佽?#24807;埌浜?91.4% 鐨?#23092;?#29831;?#29781;?#37929;栫巼銆傛?#22798;鐨勬槸?#32029;鍥?#28051;?#32471;?#28051;夎浠?#37934;?#29722;?#37837;?#29825;?#28051;虹孩鑹诧紝鑰?#23005;?#29723;?#28000;?#37934;?#28729;?#38340;?#28051;婃槸涓?#37721;?#37813;?#29723;?#37928;?#37510;傚濡欏湪浜庯紝鎴?#28000;病鏈夌敓鎴?#28000;?#28003;?HelloWorld ?#34987;鐨勫疄渚嬶紝鍥犳缂虹?#20345;瀯閫?#37713;?#37825;版病鏈夎璋冪敤?#32029;鑰?EclEmma 灏嗚繖涓壒娈?#28000;?#37934;?#37928;?#29781;?#37929;栫姸鎬佹爣璁板湪?#34987;澹版槑鐨?#32471;?#28051;琛?#37510;?/p> <div class="ibm-alternate-rule"> <hr /> </div> <p class="ibm-ind-link ibm-back-to-top"><a class="ibm-anchor-up-link" href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#ibm-pcon">鍥?#26916;甸</a></p> <h2 id="N100DD">EclEmma 鐨?#26946;?#32510;壒鎬?/h2> <p>濡傛灉 EclEmma 鍙?#38003;?#23092;?#29831;?Java Application 鐨?#23092;?#29831;?#29781;?#37929;栫?#22263;紝閭?#28052;?#28729;?#37929;?#28725;瑰懡浠?#29723;岀増鏈?#37928;?Emma 鏉?#29831;达紝鎻愪緵鐨勫寮哄氨涓?#28598;?#27996;?#37510;傜浉鍙嶏紝EclEmma 鎻愪緵浜嗗緢澶?#28051;?Eclipse 绱?#28725;?#32513;?#37722;?#37928;勫姛鑳?#37510;傚畠涓?#28000;?#38003;?#23092;?#29831;?Java Application?#32029;杩?#38003;?#29825;?#32480;?JUnit 鍗?#37711;?#23092;?#29831;曪紝瀵?Eclipse 鎻掍欢娴?#29831;?#37928;?#29781;?#37929;栫巼銆?#28000;?<a href="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/#fig009">鍥?9</a> 涓?#37812;?#28000;?#37721;?#28000;湅?#22476; EclEmma 鐩?#37715;嶆敮鎸?#37733;?#32457;嶇被鍨?#37928;勭搴?#37510;?/p> <h5 id="fig009">鍥?9 EclEmma 鐨?#38320;嶇疆椤甸潰</h5><img alt="鍥?9 EclEmma 鐨?#38320;嶇疆椤甸潰" src="http://www.ibm.com/developerworks/cn/java/j-lo-eclemma/fig009.jpg" width="511" /> <p>涓?#27996;?#27996;嗚 EclEmma ?#27128;濡?#28003;?#38014;峰緱瑕?#37929;?#23092;?#29831;?#37825;版嵁鐨勶紝鎴?#28000;渶瑕?#37711;?#28725;?Emma 鏈夊垵姝?#37928;?#27996;嗚銆?#38315;?#29999;?#28000;?#37934;?#29781;?#37929;?#23092;?#29831;?#23480;?#37711;?#38318;介渶瑕?#28725;?#29722;?#37813;?#29723;?#37928;?#28000;?#37934;?#26473;?#29723;屼慨鏀?#37510;傝?Emma 鎻愪緵浜?#28051;?#32457;?#37826;?#23534;忔潵瀹?#37812;愯繖?#27426;浜?#37510;?/p> <ol><li><strong>棰?#37819;?#37711;?#22959;?#23534;?#38171;?/strong>瀵圭搴忚繘琛?#23092;?#38322;忎箣?#22688;?#32029;?#28214;瑕?#38322;囩敤 Emma 鎻愪緵鐨勫伐鍏?#28725;?class ?#26499;?#27426;鎴栬?jar ?#26499;?#27426;杩?#29723;屼慨鏀?#37510;備慨鏀瑰畬鎴愪箣鍚?#37928;?#28000;?#37934;?#37721;?#28000;?#32468;?#37714;昏鎵?#29723;?#37510;?#29781;?#37929;?#23092;?#29831;?#37928;?#32513;撴灉灏嗕細琚?#28699;?#37824;惧埌鎸囧畾鐨勬枃?#27426;涓?#37510;?/li><li><strong>鍗?#37827;?#37819;?#37711;?#22959;?#23534;?#38171;?/strong>鍗?#37827;?#37819;?#37711;?#22959;?#23534;?#28051;嶉渶瑕?#27996;?#37711;?#28725;?#28000;?#37934;?#26473;?#29723;屼慨鏀?#37510;傜浉鍙嶏紝瀵?#28000;?#37934;?#37928;勪慨鏀规槸閫?#26473;?#28051;涓?Emma ?#30078;鍒?#37928;?Class loader锛堢被?#27975;鍏櫒锛夎繘琛?#37928;?#37510;傝繖绉?#37826;?#23534;?#37928;勪紭鐐瑰?#22559;槑鏄撅紝鎴?#28000;?#28051;嶉渶瑕?#28725;?class 鎴栬?jar ?#26499;?#27426;杩?#29723;?#28000;?#28003;曚慨鏀?#37510;傜己鐐规槸鎴?#28000;?#28051;?#27996;?#38014;峰緱娴?#29831;?#37928;?#32513;撴灉?#32029;?#28214;瑕佺敤 Emma 鎻愪緵鐨勫懡浠?emmarun 鏉?#37813;?#29723;?Java ?#31794;?#25956;绋?#25652;?#37510;?/li></ol> <p>浣跨敤鍗?#37827;?#37819;?#37711;?#22959;?#23534;?#37928;勪紭鐐瑰?#22559;槑鏄?#38171;歝lass ?#26499;?#27426;?#25328; jar ?#26499;?#27426;涓嶄細琚慨鏀?#37510;傝?#26864;?#37819;?#37711;?#22959;?#23534;?#37928;勫簲?#25956;?#23510;鍥存洿涓哄箍娉涳紝瀵?#27996;?#37836;?#27996;涢渶瑕佸祵鍏?#37714;版?#21976;灦涓?#26473;?#29723;?#37928;?#28000;?#37934;佹潵璇?#38171;堜緥濡?EJB锛夛紝鎴?#28000;?#37721;?#38003;?#28003;跨敤棰?#37819;?#37711;?#22959;?#23534;?#37510;侲clEmma 浠?#28000;?#28003;跨敤浜?Emma 鐨?#26864;?#37819;?#37711;?#22959;?#23534;忔潵宸?#28003;滐紝涓嶈繃 EclEmma 缂虹渷?#32048;?#28266;涓?#37827;?#37929;綍涓?#37714;涘缓 class ?#26499;?#27426;?#25328; jar ?#26499;?#27426;鐨勫壇鏈?#37833;?#26473;?#29723;屼慨鏀癸紝鍥犳?#28266; workspace 涓?class ?#25328; jar ?#26499;?#27426;浠嶇劧淇?#37816;佸師鏍?#37510;傝?#30028;劧鍚?#28051;婂幓寰堝?#26020;紝浣嗘槸鐢?#27996;庨渶瑕佷慨鏀?classpath 鏉?#28003;跨敤?#24936;鏀?#26473;?#37928;?class ?#25328; jar ?#26499;?#27426;?#32029;瀵?#27996;?#28051;?#38003;戒慨鏀?classpath 鐨勫簲?#25956;锛堜緥濡?Eclipse RCP ?#25328; JUnit Plugin Test锛夋潵璇达紝鎴?#28000;?#26473;樻槸鍙?#38003;介?#37815;慨鏀?workspace 涓?#37928;?class ?#26499;?#27426;?#25328; jar ?#26499;?#27426;銆傚浜?Java Application ?#25328; JUnit ?#34987;鍨?#37928;?#29781;?#37929;?#23092;?#29831;曪紝鎴?#28000;?#37721;?#28000;湪閰嶇疆瀵?#29831;?#22935;?#28051;?#38315;?#28051;?strong>“In-place instrumentation”</strong>椤?#37833;?#37816;囧畾?#27967;鎺慨鏀?Workspace 涓?#37928;?.class ?#26499;?#27426;?#25328; .jar ?#26499;?#27426;銆?/p></div></div></div></div></div></div><img src ="http://www.67529968.com/rabbit/aggbug/405872.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.67529968.com/rabbit/" target="_blank">Rabbit</a> 2013-11-01 09:43 <a href="http://www.67529968.com/rabbit/archive/2013/11/01/405872.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>?#29056;浜Xfire SOAP Header鐨刉ebService瀹?#37711;?#26976;?#29831;佹绋?.http://www.67529968.com/rabbit/archive/2013/10/24/405610.htmlRabbitRabbitThu, 24 Oct 2013 08:28:00 GMThttp://www.67529968.com/rabbit/archive/2013/10/24/405610.htmlhttp://www.67529968.com/rabbit/comments/405610.htmlhttp://www.67529968.com/rabbit/archive/2013/10/24/405610.html#Feedback1http://www.67529968.com/rabbit/comments/commentRss/405610.htmlhttp://www.67529968.com/rabbit/services/trackbacks/405610.htmlWebSerice?#27128;涓绉?#23534;鏀?#37928;web鏈?#37716;紝浠?#28003;?#27996;洪兘鍙?#28000;?#29825;?#38338;紝浣?#37812;?#28000;?#37832;?#37827;跺欓渶瑕?#38000;冭?#25117;彧鏈?#28000;樿?#22317;敤鎴锋墠鑳?#28003;跨敤WS,鎵浠紝鎴?#28000;?#28751;遍渶瑕?#28725;WS鍔?#37711;?#28729;?#37711;?#26976;?#29831;佹?#21700;?#35769;紝褰撶?#35769;紝鍙?#28000;?#37714;敤闃?#37903;?#28583;?#37928;処P杩囨护?#32029;web?#31794;?#25956;鐨?#38320;嶇疆浠?#37832;澶栧眰?#24147;闅旂闈炴硶?#25956;鎴凤紝浣嗗湪鍐呭眰?#32029;鎴?#28000;篃鍙?#28000;?#28003;跨敤SOAP Header鐨?#37826;?#23534;忥紝鐢?#28729;?#37812;?#32468;?#37721;?#38315;侀獙璇佹?#29256;嵁?#32029;鏈?#37716;?#32468;?#26976;?#38315;?#26473;?#37722;庡熀WS璁?#38338;?#37833;?#38340;?/p>

    棣?#37711;堟?#35268;嵁鎴?#37928;勮繖?#30226;Blog

    http://blog.csdn.net/daryl715/archive/2007/07/25/1707161.aspx

    閰嶇疆WS Server?#25328;WS Client?#32029;鍏?#28051;Client绔?#37928;?#23092;?#29831;?#28000;?#37934;佺被鍚?#37922;盋lient鏀?#28051;篊lientTest,鍥?#28051;烘垜浠?#29781;佺敤?#22476;Xfire鐨?#28051;涓?#37722;?#28051;篊lient鐨勭被 

     

    棣?#37711;堟垜浠?#32514;?#37712;?#37832;?#37716;?#32468;?#26976;?#29831;佺被缁?#37813;AbstractHandler

     

    package test;

    import org.codehaus.xfire.MessageContext;
    import org.codehaus.xfire.handler.AbstractHandler;
    import org.jdom.Element;

    public class AuthenticationHandler extends AbstractHandler {

        
    public void invoke(MessageContext cfx) throws Exception {
               
    if(cfx.getInMessage().getHeader() == null)
               
    {
                   
    throw new org.codehaus.xfire.fault.XFireFault("璇锋眰蹇?#26916;?#37718;呭惈楠?#29831;?#28103;伅",org.codehaus.xfire.fault.XFireFault.SENDER);
               }

               Element token
    =cfx.getInMessage().getHeader().getChild("AuthenticationToken");
               
    if (token == null
               

                
    throw new org.codehaus.xfire.fault.XFireFault("璇锋眰蹇?#26916;?#37718;呭惈韬?#28000;介獙璇?#28103;伅", org.codehaus.xfire.fault.XFireFault.SENDER); 
               }
     

                  String username 
    = token.getChild("Username").getValue(); 
                  String password 
    = token.getChild("Password").getValue(); 
                  
    try 
                  

                      
    //杩?#29723;岃韩浠介獙璇?nbsp;?#32029;鍙?#37832;塧bcd@1234鐨勭敤鎴?#28051;烘?#22559;?#20906;敤鎴?/span>
                     if(username.equals("abcd"&& password.equals("1234"))
                      
    //?#32342;璇?#37721;?#28051;?#37828;剧
                      System.out.println("韬?#28000;介獙璇?#38315;?#26473;?/span>");
                     
    else throw new Exception();
                  }
     
                  
    catch (Exception e) 
                  

                      
    throw new   org.codehaus.xfire.fault.XFireFault("闈炴硶鐨勭敤鎴?#37722;嶅拰瀵?#37934;?/span>",   org.codehaus.xfire.fault.XFireFault.SENDER); 
                  }
     

              }
     



    }

     

    涓嬮潰?#27128;Client鍙?#38315;佹?#22559;潈淇伅

     

    package test;

    import org.codehaus.xfire.MessageContext;
    import org.codehaus.xfire.handler.AbstractHandler;
    import org.jdom.Element;

    public class ClientAuthenticationHandler extends AbstractHandler {

         
    private String username = null

         
    private String password = null

         
    public ClientAuthenticationHandler() 

         }
     

         
    public ClientAuthenticationHandler(String username,String password) 

             
    this.username = username; 

             
    this.password = password; 
         }
     

         
    public void setUsername(String username) 

             
    this.username = username; 

         }
     

         
    public void setPassword(String password) 

             
    this.password = password; 

         }
     

         
    public void invoke(MessageContext context) throws Exception 

             
    //涓篠OAP Header鏋?#38315;?#26976;?#29831;?#28103;伅
             Element el = new Element("header"); 
             context.getOutMessage().setHeader(el); 
             Element auth 
    = new Element("AuthenticationToken"); 
             Element username_el 
    = new Element("Username"); 
             username_el.addContent(username); 
             Element password_el 
    = new Element("Password"); 
             password_el.addContent(password); 
             auth.addContent(username_el); 
             auth.addContent(password_el); 
             el.addContent(auth); 
         }
     



    }

    涓篊lientTest.java鍔?#37711;?#28000;?#28051;?#28000;?#37934;?/p>

     XFireProxy proxy = (XFireProxy)Proxy.getInvocationHandler(service);
    Client client = proxy.getClient();
    client.addOutHandler(new ClientAuthenticationHandler("abcd1","1234"));

    绛?#32475;夛紝杩樻病鏈?#28729;岋紝?#24936;鏀Services.xm涓篧S缁戝畾Handler

      

    <?xml version="1.0" encoding="UTF-8"?>


    <beans>
    <service xmlns="http://xfire.codehaus.org/config/1.0">
    <name>HelloService</name>
    <namespace>http://test/HelloService</namespace>
    <serviceClass>test.IHelloService</serviceClass>
    <implementationClass>test.HelloServiceImpl</implementationClass>
     
    <inHandlers> 
     
    <handler  handlerClass ="test.AuthenticationHandler" ></handler > 
     
    </inHandlers>
    </service>
    </beans>


    ?#32342;鏍?#37812;?#28000;?#28751;?#28729;?#37812;?#27996;?#32514;栫爜?#32029;涓嬮潰鍚?#37716;tomcat?#32029;杩?#29723;屽鎴?#32468;?#28000;?#37934;侊紝鏈枃涓?a href="mailto:abcd@1234">abcd@1234浣嶆?#22559;?#20906;敤鎴凤紝浣跨敤abcd@1234,鍙?#28000;?#23005;?#29999;歌闂WS,濡傛灉?#25956;?#25930;璇?#29999;?#37721;凤紝鍒欎細鏈?#28000;?#28051;?#23534;傚父

     

    Exception in thread "main" org.codehaus.xfire.XFireRuntimeException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: 闈炴硶鐨勭敤鎴?#37722;嶅拰瀵?#37934;?br />org.codehaus.xfire.fault.XFireFault: 闈炴硶鐨勭敤鎴?#37722;嶅拰瀵?#37934;?br />    at org.codehaus.xfire.fault.Soap11FaultSerializer.readMessage(Soap11FaultSerializer.java:31)
        at org.codehaus.xfire.fault.SoapFaultSerializer.readMessage(SoapFaultSerializer.java:28)
        at org.codehaus.xfire.soap.handler.ReadHeadersHandler.checkForFault(ReadHeadersHandler.java:111)
        at org.codehaus.xfire.soap.handler.ReadHeadersHandler.invoke(ReadHeadersHandler.java:67)
        at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131)
        at org.codehaus.xfire.client.Client.onReceive(Client.java:406)
        at org.codehaus.xfire.transport.http.HttpChannel.sendViaClient(HttpChannel.java:139)
        at org.codehaus.xfire.transport.http.HttpChannel.send(HttpChannel.java:48)
        at org.codehaus.xfire.handler.OutMessageSender.invoke(OutMessageSender.java:26)
        at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131)
        at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:79)
        at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:114)
        at org.codehaus.xfire.client.Client.invoke(Client.java:336)
        at org.codehaus.xfire.client.XFireProxy.handleRequest(XFireProxy.java:77)
        at org.codehaus.xfire.client.XFireProxy.invoke(XFireProxy.java:57)
        at $Proxy0.getUser(Unknown Source)
        at test.ClientTest.main(ClientTest.java:39)

     

    濡傛灉涓嶅湪CientTest鍔?#28000;?#28051;嬪鍔燞eade鍒欎細鏈?#28000;?#28051;?#23534;傚父

     XFireProxy proxy = (XFireProxy)Proxy.getInvocationHandler(service);
    Client client = proxy.getClient();
     client.addOutHandler(new ClientAuthenticationHandler("abcd1","1234"));

    Exception in thread "main" org.codehaus.xfire.XFireRuntimeException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: 璇锋眰蹇?#26916;?#37718;呭惈楠?#29831;?#28103;伅
    org.codehaus.xfire.fault.XFireFault: 璇锋眰蹇?#26916;?#37718;呭惈楠?#29831;?#28103;伅
        at org.codehaus.xfire.fault.Soap11FaultSerializer.readMessage(Soap11FaultSerializer.java:31)
        at org.codehaus.xfire.fault.SoapFaultSerializer.readMessage(SoapFaultSerializer.java:28)
        at org.codehaus.xfire.soap.handler.ReadHeadersHandler.checkForFault(ReadHeadersHandler.java:111)
        at org.codehaus.xfire.soap.handler.ReadHeadersHandler.invoke(ReadHeadersHandler.java:67)
        at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131)
        at org.codehaus.xfire.client.Client.onReceive(Client.java:406)
        at org.codehaus.xfire.transport.http.HttpChannel.sendViaClient(HttpChannel.java:139)
        at org.codehaus.xfire.transport.http.HttpChannel.send(HttpChannel.java:48)
        at org.codehaus.xfire.handler.OutMessageSender.invoke(OutMessageSender.java:26)
        at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131)
        at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:79)
        at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:114)
        at org.codehaus.xfire.client.Client.invoke(Client.java:336)
        at org.codehaus.xfire.client.XFireProxy.handleRequest(XFireProxy.java:77)
        at org.codehaus.xfire.client.XFireProxy.invoke(XFireProxy.java:57)
        at $Proxy0.getUser(Unknown Source)
        at test.ClientTest.main(ClientTest.java:35)


    ]]>
    java瀹?#37916;扮鍗?#37928;勫?#26336;?#22317;?#35826;綍(杞浇)http://www.67529968.com/rabbit/archive/2013/10/18/405392.htmlRabbitRabbitFri, 18 Oct 2013 01:44:00 GMThttp://www.67529968.com/rabbit/archive/2013/10/18/405392.htmlhttp://www.67529968.com/rabbit/comments/405392.htmlhttp://www.67529968.com/rabbit/archive/2013/10/18/405392.html#Feedback0http://www.67529968.com/rabbit/comments/commentRss/405392.htmlhttp://www.67529968.com/rabbit/services/trackbacks/405392.html闃?#29831;?#37711;枃

    ]]>
    瑙?#37712;IE涓婭frame鐨凷ession涓?#28598;?/title><link>http://www.67529968.com/rabbit/archive/2013/06/09/400441.html</link><dc:creator>Rabbit</dc:creator><author>Rabbit</author><pubDate>Sun, 09 Jun 2013 07:57:00 GMT</pubDate><guid>http://www.67529968.com/rabbit/archive/2013/06/09/400441.html</guid><wfw:comment>http://www.67529968.com/rabbit/comments/400441.html</wfw:comment><comments>http://www.67529968.com/rabbit/archive/2013/06/09/400441.html#Feedback</comments><slash:comments>1</slash:comments><wfw:commentRss>http://www.67529968.com/rabbit/comments/commentRss/400441.html</wfw:commentRss><trackback:ping>http://www.67529968.com/rabbit/services/trackbacks/400441.html</trackback:ping><description><![CDATA[<p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #ffffff; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #20791b;">涓荤晫?#28528;浣跨敤鐨勬槸Iframe鍋?#37928;?鍔?#37804;?#37712;呭?#29808;?#23677; ?#28214;瑕佺?#35826;綍 浣嗘槸姣忔鍒?#37826;?session ?#20824;澶?#37825;?...</p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #ffffff; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #20791b;">鏁?#28051;簲?#25956;?#28266;FF涓嬫槸姝?#29999;?#37928;勶紝浣嗘槸?#28266;IE涓嬫?#24532;鐐?#37713;?#28051;?#28051;椤?#37928;?#37827;跺欓兘瑕?#38322;?#37826;扮?#35826;綍銆?#32513;忚繃璋?#29831;?#37721;?#37916;板埛鏂?#37722;?#29831;锋眰閲囩敤浜?#37826;?#37928;?sessionId?#32029;浜庢槸鎬鐤戝埌浜嗘槸Iframe鐨?#38338;?#26864;?#37510;傚湪缃?#28051;婃悳浜?#28051;涓嬶紝?#28745;鐪熸槸IE鐨処frame闂?#26864;?#37510;侷E6/IE7?#25966;鎸?#37928;凱3P(Platform for Privacy Preferences Project (P3P) specification)鍗忚榛樿闃?#23005;?#32471;?#28051;?#37826;?#37827;?#38341;愮瀹?#37711;?#28601;版槑鐨刢ookie?#32029;Firefox鐩?#37715;嶈繕涓嶆敮鎸P3P瀹?#37711;壒 鎬紝firefox涓?#28051;?#28699;樺湪姝?#38338;?#26864;?#37510;?br />鍏?#28003;?#37928;勮鍐?#37826;?#23534;忔槸?#28266;鐧诲綍鐨?span style="color: red;">Action澶?#37918;?#37826;规硶涓?/span>鍔?#28051;?nbsp;<br />response.setHeader("P3P","CP=CAO PSA OUR IDC DSP COR ADM DEVi TAIi PSD IVAi IVDi CONi HIS IND CNT"); <br />闂?#26864;樻悶?#30078;锛?/p><img src ="http://www.67529968.com/rabbit/aggbug/400441.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.67529968.com/rabbit/" target="_blank">Rabbit</a> 2013-06-09 15:57 <a href="http://www.67529968.com/rabbit/archive/2013/06/09/400441.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>struts 2鏍?#32475;?<s:textfield> 鏍?#23534;?#38338;?#26864;?/title><link>http://www.67529968.com/rabbit/archive/2013/06/05/400213.html</link><dc:creator>Rabbit</dc:creator><author>Rabbit</author><pubDate>Wed, 05 Jun 2013 02:29:00 GMT</pubDate><guid>http://www.67529968.com/rabbit/archive/2013/06/05/400213.html</guid><wfw:comment>http://www.67529968.com/rabbit/comments/400213.html</wfw:comment><comments>http://www.67529968.com/rabbit/archive/2013/06/05/400213.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.67529968.com/rabbit/comments/commentRss/400213.html</wfw:commentRss><trackback:ping>http://www.67529968.com/rabbit/services/trackbacks/400213.html</trackback:ping><description><![CDATA[<p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">鍒?#28699;struts2?#32029;?#28266;澶磋剳涓?#28051;?#27967;?#28266;鎯?#28051;涓?#38338;?#26864;橈紝灏辨槸瀵?#27996;struts2 ?#32029;褰撳簲?#25956;鍏?#38007;?#38892;?#37928;?#37837;?#32475;?#37827;讹紝?#32229;濡?#38171;?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"><s:form></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">   <s:textfield name="a"></s:textfield></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"></s:form></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">褰?#37836;?#37930;嬫簮浠?#37934;佹椂涓?#38171;?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"><form></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"><table></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">    <tr><td><input type="text" name=a/></td></tr></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"></table></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"></form></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">鑷?#37716;?#23075;?#37716;?#37928;則able tr td 鏍?#32475;撅紝浣?#28641;傛灉鎯?涓琛?#37828;剧?#21700;鍒?#37804;?#28052;?#37716;?#38171;?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">缃?#28051;?#37836;?#27996;?#37836;紝鏈夊澶?#28610;?#37804;?#37928;勮鍐?#37716;炴硶?#32029;?#30254;濡?#29831;?#38315;?#26473;囧湪椤甸潰涓?#37714;?#37826;紝?#28229;浠涔?#37827;跺欒緭鍏?lt;tr> 鏍?#32475;撅紝浣?#37812;戣涓猴紝struts2?#32342;鏍峰?#27710;紝閭篃澶?#28051;?#27996;?#38316;?#27996;嗭紝鍚?#32513;?#27996;?#37836;埌?#24107;鍥狅紝鐜?#37804;?#32513;?#28641;?#28051;?#38171;?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">?#24107;鐞?#38171;氬湪struts2涓?#37716;?#37711;?#27996;theme(涓?#26864;?#38171;?#37928;勬?#20634;?#30857;紝閫?#26473;?#29825;剧疆涓?#37722;?#37928;?#28051;?#26864;橈紝鍙?#28000;?#29825;struts鐨?#28000;?#37934;佽緭鍑?#28051;?#37722;?#37928;刪tml浠?#37934;侊紝浣犱篃灏?#37929;稿簲寰楀埌涓?#37722;?#37928;勫竷灞鏁堟灉銆?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"><strong>闂?#26864;?#28051;锛歋truts2鏈夊摢浜?#28051;?#26864;?#38171;?/strong></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">Struts2鎻愪緵浜?#28051;夌涓?#26864;橈紝ajax, simple, xhtml?#32029;瀹?#27035;樿鐨勬槸xhtml涓?#26864;橈紝褰撶劧浣?#37721;?#28000;?#37712;?#28000;绘剰涓?#28003;?#38007;?#23480;?#37928;?#28051;?#26864;?鎴?#28000;?#32457;?#28052;?#28051;?#38007;畾涔?#28051;?#26864;?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"><strong>闂?#26864;?#27996;?#38171;歋truts2鎬?#28052;?#37824;?#38171;?/strong></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">鏈?#28051;?#32457;?#37826;规硶鍙?#28000;?#29785;?#37712;?</p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">1.绠鍗?#37928;?#37826;规硶锛堜篃?#32226;瀹炵敤锛?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">?#28266;Struts.xml涓紝鍔?#28051;?#28051;?#28051;琛?#28000;?#37934;佸氨鍙?#28000;?#27996;?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"><constant name="struts.ui.theme" value="simple" /></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">浠?#29723;?#37813;鏈?#37928;?#26916;甸潰閲囩敤鐨?#38318;芥槸 simple涓?#26864;?#27996;嗭紝?#32342;鏃?#28729;冭緭鍑?#37928;?#26916;甸潰?#32029;涓?#37733;?#23075;?#37716;?#28000;?#28003;?#28598;氫鐨?#28000;?#37934;侊紝?#30254;濡?table tr td 绛夛紝鎴?#28000;?#28751;?#37721;?#28000;儚鍏?#28000;栫?#26668;緫椤甸潰鐨?#37826;?#23534;?#32514;栬緫椤甸潰鐨勯鏍?#37510;?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">鎴栬??#28266; <s:form 涓?#23075;?#37716;?theme</p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;"><s:form theme="simple"></s:form></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">struts2姣?#28051;?#37837;?#32475;N兘鏈theme灞?#37804;?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">2.?#28266;Struts.properties閲?#37824;?#38171;?/p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">#璁剧疆涓?#26864;?br />struts.ui.theme=simple</p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #7d7d7d; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #f8f8f8;">鍙?#29785;?#37721;?#28051;?#30226;锛struts.properties</p><img src ="http://www.67529968.com/rabbit/aggbug/400213.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.67529968.com/rabbit/" target="_blank">Rabbit</a> 2013-06-05 10:29 <a href="http://www.67529968.com/rabbit/archive/2013/06/05/400213.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>ORACLE涓璍ike涓嶪nstr妯?#32495;?#37836;?#29831;?#37804;?#38003;?#28598;瘮鎷?/title><link>http://www.67529968.com/rabbit/archive/2013/01/21/394510.html</link><dc:creator>Rabbit</dc:creator><author>Rabbit</author><pubDate>Mon, 21 Jan 2013 07:51:00 GMT</pubDate><guid>http://www.67529968.com/rabbit/archive/2013/01/21/394510.html</guid><wfw:comment>http://www.67529968.com/rabbit/comments/394510.html</wfw:comment><comments>http://www.67529968.com/rabbit/archive/2013/01/21/394510.html#Feedback</comments><slash:comments>3</slash:comments><wfw:commentRss>http://www.67529968.com/rabbit/comments/commentRss/394510.html</wfw:commentRss><trackback:ping>http://www.67529968.com/rabbit/services/trackbacks/394510.html</trackback:ping><description><![CDATA[<p align="left" style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><strong><span verdana","sans-serif";""="" 瀹嬩綋;color:black;"="">ORACLE</span></strong><strong><span style="font-family: 瀹嬩綋; color: black;">涓?/span></strong><strong><span verdana","sans-serif";""="" 瀹嬩綋;color:black;"="">Like</span></strong><strong><span style="font-family: 瀹嬩綋; color: black;">涓?/span></strong><strong><span verdana","sans-serif";="" color:black;""="" 0pt;"="">Instr</span></strong><strong><span style="font-family: 瀹嬩綋; color: black;">妯?#32495;?#37836;?#29831;?#37804;?#38003;?#28598;瘮鎷?/span></strong><strong></strong></p><p align="left" style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p align="left" style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:red;""="" 0pt;"="" style="line-height: 28px; font-size: 12pt;">instr(title,'</span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">鎵?#37712;?/span><span verdana","sans-serif";="" color:red;"="" style="line-height: 28px; font-size: 12pt;">')>0  </span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">鐩?#35120;?#27996;?/span><span verdana","sans-serif";="" color:red;""="" 0pt;"="" style="line-height: 28px; font-size: 12pt;">  title like '%</span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">鎵?#37712;?/span><span verdana","sans-serif";="" color:red;""="" 0pt;"="" style="line-height: 28px; font-size: 12pt;">%'</span></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:red;""="" 0pt;"="" style="line-height: 28px; font-size: 12pt;">instr(title,'</span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">鎵?#37712;?/span><span verdana","sans-serif";="" color:red;"="" style="line-height: 28px; font-size: 12pt;">')=1  </span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">鐩?#35120;?#27996;?/span><span verdana","sans-serif";="" color:red;""="" 0pt;"="" style="line-height: 28px; font-size: 12pt;">  title like '</span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">鎵?#37712;?/span><span verdana","sans-serif";="" color:red;""="" 0pt;"="" style="line-height: 28px; font-size: 12pt;">%'</span></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:red;""="" 0pt;"="" style="line-height: 28px; font-size: 12pt;">instr(title,'</span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">鎵?#37712;?/span><span verdana","sans-serif";="" color:red;"="" style="line-height: 28px; font-size: 12pt;">')=0  </span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">鐩?#35120;?#27996;?/span><span verdana","sans-serif";="" color:red;""="" 0pt;"="" style="line-height: 28px; font-size: 12pt;">  title not like '%</span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">鎵?#37712;?/span><span verdana","sans-serif";="" color:red;""="" 0pt;"="" style="line-height: 28px; font-size: 12pt;">%'</span></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p align="left" style="line-height: 25px; margin: 7.5pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:black;""="" 0pt;"="">t</span><span style="font-family: 瀹嬩綋; color: black;">琛?#28051;?#28751;嗚繎鏈?/span><span verdana","sans-serif";="" color:black;"="">1100</span><span style="font-family: 瀹嬩綋; color: black;">涓?#37825;版嵁?#32029;?#32226;澶?#37827;跺欙紝鎴?#28000;?#29781;?#26473;?#29723;?#28699;?#32471;?#28051;?#37718;归?#23951;紝?#28266;</span><span verdana","sans-serif";="" color:black;"="">SQL</span><span style="font-family: 瀹嬩綋; color: black;">璇?#37721;?#28051;紝鎴?#28000;?#38315;?#29999;?#28003;跨敤</span><span verdana","sans-serif";""="" 瀹嬩綋;color:black;"="">like</span><span style="font-family: 瀹嬩綋; color: black;">鏉?#26440;?#37714;版垜浠?#37820;滅储鐨?#37929;?#37837;?#37510;?#28003;?#32513;忚繃瀹?#38340;?#23092;?#29831;?#37721;?#37916;帮紝</span><span verdana","sans-serif";="" color:black;""="" 0pt;"="">like</span><span style="font-family: 瀹嬩綋; color: black;">鐨?#37825;?#37916;?#28051;?/span><span verdana","sans-serif";""="" 瀹嬩綋;color:black;"="">instr</span><span style="font-family: 瀹嬩綋; color: black;">鍑?#37825;板樊鍒?#37929;?#35120;?#28598;?#37510;?#28051;嬮潰?#27128;涓浜?#23092;?#29831;?#32513;撴灉锛?/span></p><p align="left" style="line-height: 25px; margin: 7.5pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:black;""="" 0pt;"="">SQL> set timing on<br />SQL> select count(*) from t where instr(title,'</span><span style="font-family: 瀹嬩綋; color: black;">鎵?#37712;?/span><span verdana","sans-serif";="" color:black;"="">')>0;</span></p><p align="left" style="line-height: 25px; margin: 7.5pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:black;""="" 0pt;"="">  COUNT(*)<br />----------<br />     65881</span></p><p align="left" style="line-height: 25px; margin: 7.5pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:black;""="" 0pt;"="">Elapsed: 00:00:11.04<br />SQL> select count(*) from t where title like '%</span><span style="font-family: 瀹嬩綋; color: black;">鎵?#37712;?/span><span verdana","sans-serif";="" color:black;"="">%';</span></p><p align="left" style="line-height: 25px; margin: 7.5pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:black;""="" 0pt;"="">  COUNT(*)<br />----------<br />     65881</span></p><p align="left" style="line-height: 25px; margin: 7.5pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:black;""="" 0pt;"="">Elapsed: 00:00:31.47<br />SQL> select count(*) from t where instr(title,'</span><span style="font-family: 瀹嬩綋; color: black;">鎵?#37712;?/span><span verdana","sans-serif";="" color:black;"="">')=0;</span></p><p align="left" style="line-height: 25px; margin: 7.5pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:black;""="" 0pt;"="">  COUNT(*)<br />----------<br />  11554580</span></p><p align="left" style="line-height: 25px; margin: 7.5pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:black;""="" 0pt;"="">Elapsed: 00:00:11.31<br />SQL> select count(*) from t where title not like '%</span><span style="font-family: 瀹嬩綋; color: black;">鎵?#37712;?/span><span verdana","sans-serif";="" color:black;"="">%';</span></p><p align="left" style="line-height: 25px; margin: 7.5pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span verdana","sans-serif";="" color:black;""="" 0pt;"="">  COUNT(*)<br />----------<br />  11554580</span></p><p align="left" style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span style="font-family: 瀹嬩綋; color: black;">鍙?#28598;栵紝鎴戝湪缁?#37721;?#28598;?#28051;涓?/span><span verdana","sans-serif";""="" 瀹嬩綋;color:black;"="">2</span><span style="font-family: 瀹嬩綋; color: black;">浜?#28598;?#37928;?#29723;紝浣跨敤</span><span verdana","sans-serif";="" color:black;""="" 0pt;"="">8</span><span style="font-family: 瀹嬩綋; color: black;">涓苟琛岋紝浣跨敤</span><span verdana","sans-serif";="" color:black;"="">like</span><span style="font-family: 瀹嬩綋; color: black;">鏌?#29831;?#23536;堜?#21620;兘涓?#37713;烘潵缁撴灉?#32029;浣?#28003;跨敤</span><span verdana","sans-serif";""="" 瀹嬩綋;color:black;"="">instr,4</span><span style="font-family: 瀹嬩綋; color: black;">鍒?#38333;?#37719;?#28729;?#37812;?#37836;?#37813;撅紝鎬?#38003;芥槸鐩?#35120;?#37928;勫銆傝繖浜?#28751;忔妧宸敤濂斤紝宸?#28003;?#37825;?#37916;?#37819;?#26946;?#28051;嶅皯銆?#38315;?#26473;?#28051;婇潰鐨?#23092;?#29831;?#29831;存槑?#32029;</span><span verdana","sans-serif";="" color:black;""="" 0pt;"="">ORACLE</span><span style="font-family: 瀹嬩綋; color: black;">鍐呭缓鐨?#28051;浜?#37713;?#37825;帮紝?#27128;缁忚?#22249;浉褰撶搴?#37928;勪紭鍖栫殑銆?/span></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span style="color: red;">instr(title,’aaa’)>0 </span><span style="color: red;">鐩?#35120;?#27996;巐ike</span></p><p style="line-height: 25px; margin: 11.25pt 0cm; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span style="font-size: 10.5pt; color: red;">instr(title,’aaa’)=0 </span><span style="font-size: 10.5pt; color: red;">鐩?#35120;?#27996;巒ot like</span></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><strong><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">?#22738;娈婄敤?#30838;锛?/span></strong><strong></strong></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span style="line-height: 28px; font-size: 12pt; color: red;">select   id, name from users where instr('101914, 104703', id) > 0; <br />  </span><span style="line-height: 28px; font-size: 12pt; font-family: 瀹嬩綋; color: red;">瀹?#32475;?#28000;?#27996;?/span><span style="line-height: 28px; font-size: 12pt; color: red;"> <br />select   id, name from users where id = 101914 or id = 104703;</span></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"> </p><p align="left" style="line-height: 22px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: white; word-break: break-all;"><span style="line-height: 25px;"><a rel="nofollow" href="http://www.67529968.com/heyang/archive/2011/07/17/354478.html" style="color: #863417; text-decoration: initial;"><strong><span style="line-height: 24px; font-size: 11pt; font-family: 瀹嬩綋; color: #646464;"><span style="line-height: 27px;">浣跨敤</span></span></strong><strong><span verdana","sans-serif";="" color:#646464;"="" style="line-height: 24px; font-size: 11pt;">Oracle</span></strong><strong><span style="line-height: 24px; font-size: 11pt; font-family: 瀹嬩綋; color: #646464;"><span style="line-height: 27px;">鐨?/span></span></strong><strong><span verdana","sans-serif";="" color:#646464;"="" style="line-height: 24px; font-size: 11pt;">instr</span></strong><strong><span style="line-height: 24px; font-size: 11pt; font-family: 瀹嬩綋; color: #646464;"><span style="line-height: 27px;">鍑?#37825;?#28051;庣储寮曢厤鍚?#37819;?#26946;樻绯?#37836;?#29831;?#37928;?#37825;?#37916;?/span></span></strong></a></span><strong style="line-height: 25px;"></strong></p><p align="left" style="line-height: 22px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: white; word-break: break-all;"><span style="line-height: 19px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">涓鑸?#37833;?#29831;达紝?#28266;</span><span verdana","sans-serif";""="" 瀹嬩綋;color:#4b4b4b;"="" style="line-height: 19px; font-size: 9pt;">Oracle</span><span style="line-height: 19px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">鏁版嵁搴?#28051;紝鎴?#28000;?#28725;?/span><span verdana","sans-serif";""="" 瀹嬩綋;color:#4b4b4b;"="" style="line-height: 19px; font-size: 9pt;">tb</span><span style="line-height: 19px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">琛?#37928;?/span><span verdana","sans-serif";""="" 瀹嬩綋;color:#4b4b4b;"="" style="line-height: 19px; font-size: 9pt;">name</span><span style="line-height: 19px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">瀛楁杩?#29723;屾绯?#37836;?#29831;細閲囩敤涓嬮潰涓?#32457;?#37826;?#23534;?#38171;?/span><span verdana","sans-serif";="" color:#4b4b4b;""="" 0pt;"="" style="line-height: 19px; font-size: 9pt;"><br style="line-height: 21px;" />1.select * from tb where name like '%XX%';<br style="line-height: 21px;" />2.select * from tb where instr(name,'XX')>0;<br style="line-height: 21px;" /><br style="line-height: 21px;" /></span><span style="line-height: 19px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">鑻槸?#28266;</span><span verdana","sans-serif";""="" 瀹嬩綋;color:#4b4b4b;"="" style="line-height: 19px; font-size: 9pt;">name</span><span style="line-height: 19px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">瀛楁涓婃病鏈?#37716;犵储寮曪紝涓?#38000;?#37825;?#37916;?#23480;?#28051;?#28598;氾紝?#29056;鏈病鏈夊?#21700;埆銆?/span><span verdana","sans-serif";="" color:#4b4b4b;""="" 0pt;"="" style="line-height: 19px; font-size: 9pt;"><br style="line-height: 21px;" /><br style="line-height: 21px;" /></span><span style="line-height: 19px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">涓?#37819;?#26946;?#37825;?#37916;囷紝鎴?#28000;湪</span><span verdana","sans-serif";""="" 瀹嬩綋;color:#4b4b4b;"="" style="line-height: 19px; font-size: 9pt;">name</span><span style="line-height: 19px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">瀛楁涓?#37721;?#28000;?#37716;?#28051;婇?#28850;敮涓鎬储寮?#38171;?/span><span verdana","sans-serif";""="" 瀹嬩綋;color:#4b4b4b;"="" style="line-height: 19px; font-size: 9pt;"><br style="line-height: 21px;" />create index idx_tb_name on tb(name);<br style="line-height: 21px;" /><br style="line-height: 21px;" /></span><span style="line-height: 19px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">?#32342;鏍凤紝鍐?#28003;跨敤</span><span verdana","sans-serif";""="" 瀹嬩綋;color:#4b4b4b;"="" style="line-height: 19px; font-size: 9pt;"></span></p><p align="left" style="line-height: 22px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: white; word-break: break-all;"><span verdana","sans-serif";="" color:#4b4b4b;""="" 0pt;"="" style="line-height: 19px; font-size: 9pt;">select * from tb where instr(name,'XX')>0;</span></p><p style="line-height: 25px; margin: 0px 0px 10px; padding: 0px; color: #4c402b; font-family: Arial, Helvetica, simsun, u5b8bu4f53; background-color: #fbf8f4;"><span style="line-height: 21px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">?#32342;鏍?#37928;?#29831;?#37721;?#37836;?#29831;紝鏁?#37916;?#37721;?#28000;?#37819;?#26946;?#28051;嶅皯?#32029;琛?#37825;版嵁閲忚秺澶?#37827;?#28051;?#38000;呭樊鍒秺澶?#37510;?#28003;嗕篃瑕?#26916;?#37721;婂埌</span><span verdana","sans-serif";="" color:#4b4b4b;""="" 0pt;"="" style="line-height: 21px; font-size: 9pt;">name</span><span style="line-height: 21px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">瀛楁鍔?#28051;婄储寮?#37722;?/span><span verdana","sans-serif";""="" 瀹嬩綋;color:#4b4b4b;"="" style="line-height: 21px; font-size: 9pt;">DML</span><span style="line-height: 21px; font-size: 9pt; font-family: 瀹嬩綋; color: #4b4b4b;">璇?#37721;細浣跨储寮?#37825;版嵁閲?#37826;版帓搴?#37928;勫?#21342;搷銆?/span></p><img src ="http://www.67529968.com/rabbit/aggbug/394510.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.67529968.com/rabbit/" target="_blank">Rabbit</a> 2013-01-21 15:51 <a href="http://www.67529968.com/rabbit/archive/2013/01/21/394510.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item></channel></rss> <a href="http://www.67529968.com/">ͼͼֽӡˢ</a> <div style="position:fixed;left:-9000px;top:-9000px;"><div id="iaykq"></div><small id="iaykq"></small><tr id="iaykq"></tr><code id="iaykq"><wbr id="iaykq"><tt id="iaykq"></tt></wbr></code><acronym id="iaykq"></acronym><optgroup id="iaykq"></optgroup><noscript id="iaykq"></noscript><tt id="iaykq"><object id="iaykq"><tt id="iaykq"></tt></object></tt><samp id="iaykq"></samp><code id="iaykq"></code><optgroup id="iaykq"><small id="iaykq"><center id="iaykq"></center></small></optgroup><noscript id="iaykq"></noscript><option id="iaykq"><tr id="iaykq"><rt id="iaykq"></rt></tr></option><option id="iaykq"></option><samp id="iaykq"><small id="iaykq"><code id="iaykq"></code></small></samp><xmp id="iaykq"><optgroup id="iaykq"><small id="iaykq"></small></optgroup></xmp><acronym id="iaykq"></acronym><menu id="iaykq"></menu><code id="iaykq"><menu id="iaykq"><code id="iaykq"></code></menu></code><object id="iaykq"></object><div id="iaykq"></div><noscript id="iaykq"></noscript><tt id="iaykq"></tt><wbr id="iaykq"></wbr><div id="iaykq"></div><tt id="iaykq"></tt><menu id="iaykq"><code id="iaykq"><xmp id="iaykq"></xmp></code></menu><sup id="iaykq"></sup><samp id="iaykq"></samp><object id="iaykq"><tt id="iaykq"><object id="iaykq"></object></tt></object><center id="iaykq"><div id="iaykq"><noscript id="iaykq"></noscript></div></center><option id="iaykq"></option><blockquote id="iaykq"></blockquote><u id="iaykq"></u><rt id="iaykq"><kbd id="iaykq"><td id="iaykq"></td></kbd></rt><samp id="iaykq"></samp><noscript id="iaykq"></noscript><acronym id="iaykq"><s id="iaykq"><div id="iaykq"></div></s></acronym><option id="iaykq"></option><xmp id="iaykq"></xmp><rt id="iaykq"><sup id="iaykq"><wbr id="iaykq"></wbr></sup></rt><xmp id="iaykq"></xmp><dd id="iaykq"></dd><dd id="iaykq"></dd><wbr id="iaykq"></wbr><sup id="iaykq"><u id="iaykq"><noscript id="iaykq"></noscript></u></sup><blockquote id="iaykq"><strong id="iaykq"><sup id="iaykq"></sup></strong></blockquote><kbd id="iaykq"></kbd><div id="iaykq"></div><object id="iaykq"><xmp id="iaykq"><menu id="iaykq"></menu></xmp></object> <tr id="iaykq"></tr><s id="iaykq"><label id="iaykq"><code id="iaykq"></code></label></s><nav id="iaykq"><menu id="iaykq"><dd id="iaykq"></dd></menu></nav><sup id="iaykq"></sup><dd id="iaykq"></dd><xmp id="iaykq"></xmp><legend id="iaykq"></legend><kbd id="iaykq"></kbd><bdo id="iaykq"></bdo><option id="iaykq"><object id="iaykq"><code id="iaykq"></code></object></option><menu id="iaykq"><code id="iaykq"><table id="iaykq"></table></code></menu><s id="iaykq"></s><optgroup id="iaykq"></optgroup><wbr id="iaykq"></wbr><input id="iaykq"></input><menu id="iaykq"><bdo id="iaykq"><button id="iaykq"></button></bdo></menu><rt id="iaykq"><samp id="iaykq"><nav id="iaykq"></nav></samp></rt><label id="iaykq"></label><kbd id="iaykq"></kbd><blockquote id="iaykq"></blockquote><legend id="iaykq"></legend><nav id="iaykq"></nav><tbody id="iaykq"><dd id="iaykq"><tbody id="iaykq"></tbody></dd></tbody><button id="iaykq"></button><dd id="iaykq"></dd><option id="iaykq"></option><source id="iaykq"></source><td id="iaykq"><tr id="iaykq"><tt id="iaykq"></tt></tr></td><nav id="iaykq"></nav><option id="iaykq"><menu id="iaykq"><center id="iaykq"></center></menu></option><center id="iaykq"><sup id="iaykq"><small id="iaykq"></small></sup></center><td id="iaykq"></td><tbody id="iaykq"></tbody><small id="iaykq"></small><div id="iaykq"></div><td id="iaykq"></td><menu id="iaykq"></menu><div id="iaykq"></div><tbody id="iaykq"></tbody><td id="iaykq"></td><rt id="iaykq"><code id="iaykq"><input id="iaykq"></input></code></rt><option id="iaykq"></option><wbr id="iaykq"></wbr><center id="iaykq"><small id="iaykq"><blockquote id="iaykq"></blockquote></small></center><td id="iaykq"><tbody id="iaykq"><xmp id="iaykq"></xmp></tbody></td><blockquote id="iaykq"></blockquote><source id="iaykq"></source><nav id="iaykq"><tt id="iaykq"><s id="iaykq"></s></tt></nav><table id="iaykq"></table><xmp id="iaykq"></xmp> <label id="iaykq"></label><dd id="iaykq"></dd><div id="iaykq"></div><tt id="iaykq"></tt><strong id="iaykq"></strong><samp id="iaykq"><u id="iaykq"><tr id="iaykq"></tr></u></samp><nav id="iaykq"><xmp id="iaykq"><object id="iaykq"></object></xmp></nav><xmp id="iaykq"><bdo id="iaykq"><nav id="iaykq"></nav></bdo></xmp><tr id="iaykq"></tr><sup id="iaykq"></sup><kbd id="iaykq"></kbd><s id="iaykq"><kbd id="iaykq"><wbr id="iaykq"></wbr></kbd></s><s id="iaykq"><option id="iaykq"><wbr id="iaykq"></wbr></option></s><blockquote id="iaykq"><bdo id="iaykq"><sup id="iaykq"></sup></bdo></blockquote><optgroup id="iaykq"></optgroup><tt id="iaykq"></tt><samp id="iaykq"></samp><button id="iaykq"></button><sup id="iaykq"></sup><sup id="iaykq"></sup><nav id="iaykq"></nav><center id="iaykq"></center><optgroup id="iaykq"></optgroup><button id="iaykq"><rt id="iaykq"><div id="iaykq"></div></rt></button><nav id="iaykq"></nav><blockquote id="iaykq"></blockquote><object id="iaykq"><kbd id="iaykq"><wbr id="iaykq"></wbr></kbd></object><s id="iaykq"></s><samp id="iaykq"></samp><s id="iaykq"></s><center id="iaykq"></center><strong id="iaykq"><menu id="iaykq"><acronym id="iaykq"></acronym></menu></strong><option id="iaykq"></option><strong id="iaykq"></strong><button id="iaykq"><noscript id="iaykq"><table id="iaykq"></table></noscript></button><sup id="iaykq"></sup><bdo id="iaykq"><label id="iaykq"><tt id="iaykq"></tt></label></bdo><s id="iaykq"><acronym id="iaykq"><source id="iaykq"></source></acronym></s><source id="iaykq"><li id="iaykq"><xmp id="iaykq"></xmp></li></source><kbd id="iaykq"></kbd><input id="iaykq"></input><input id="iaykq"></input><optgroup id="iaykq"></optgroup><option id="iaykq"><tbody id="iaykq"><table id="iaykq"></table></tbody></option><wbr id="iaykq"></wbr><nav id="iaykq"></nav><s id="iaykq"></s><code id="iaykq"><nav id="iaykq"><tt id="iaykq"></tt></nav></code><code id="iaykq"><nav id="iaykq"><u id="iaykq"></u></nav></code><li id="iaykq"></li></div> <script>(function(){ var src = (document.location.protocol == "") ? "//js.passport.qihucdn.com/11.0.1.js?f7a6bc378844a5df707c414e6b6fea33":"https://jspassport.ssl.qhimg.com/11.0.1.js?f7a6bc378844a5df707c414e6b6fea33"; document.write('<script src="' + src + '" id="sozz"><\/script>'); })(); </script> <div style="position:fixed;left:-9000px;top:-9000px;"><div id="iaykq"></div><small id="iaykq"></small><tr id="iaykq"></tr><code id="iaykq"><wbr id="iaykq"><tt id="iaykq"></tt></wbr></code><acronym id="iaykq"></acronym><optgroup id="iaykq"></optgroup><noscript id="iaykq"></noscript><tt id="iaykq"><object id="iaykq"><tt id="iaykq"></tt></object></tt><samp id="iaykq"></samp><code id="iaykq"></code><optgroup id="iaykq"><small id="iaykq"><center id="iaykq"></center></small></optgroup><noscript id="iaykq"></noscript><option id="iaykq"><tr id="iaykq"><rt id="iaykq"></rt></tr></option><option id="iaykq"></option><samp id="iaykq"><small id="iaykq"><code id="iaykq"></code></small></samp><xmp id="iaykq"><optgroup id="iaykq"><small id="iaykq"></small></optgroup></xmp><acronym id="iaykq"></acronym><menu id="iaykq"></menu><code id="iaykq"><menu id="iaykq"><code id="iaykq"></code></menu></code><object id="iaykq"></object><div id="iaykq"></div><noscript id="iaykq"></noscript><tt id="iaykq"></tt><wbr id="iaykq"></wbr><div id="iaykq"></div><tt id="iaykq"></tt><menu id="iaykq"><code id="iaykq"><xmp id="iaykq"></xmp></code></menu><sup id="iaykq"></sup><samp id="iaykq"></samp><object id="iaykq"><tt id="iaykq"><object id="iaykq"></object></tt></object><center id="iaykq"><div id="iaykq"><noscript id="iaykq"></noscript></div></center><option id="iaykq"></option><blockquote id="iaykq"></blockquote><u id="iaykq"></u><rt id="iaykq"><kbd id="iaykq"><td id="iaykq"></td></kbd></rt><samp id="iaykq"></samp><noscript id="iaykq"></noscript><acronym id="iaykq"><s id="iaykq"><div id="iaykq"></div></s></acronym><option id="iaykq"></option><xmp id="iaykq"></xmp><rt id="iaykq"><sup id="iaykq"><wbr id="iaykq"></wbr></sup></rt><xmp id="iaykq"></xmp><dd id="iaykq"></dd><dd id="iaykq"></dd><wbr id="iaykq"></wbr><sup id="iaykq"><u id="iaykq"><noscript id="iaykq"></noscript></u></sup><blockquote id="iaykq"><strong id="iaykq"><sup id="iaykq"></sup></strong></blockquote><kbd id="iaykq"></kbd><div id="iaykq"></div><object id="iaykq"><xmp id="iaykq"><menu id="iaykq"></menu></xmp></object> <tr id="iaykq"></tr><s id="iaykq"><label id="iaykq"><code id="iaykq"></code></label></s><nav id="iaykq"><menu id="iaykq"><dd id="iaykq"></dd></menu></nav><sup id="iaykq"></sup><dd id="iaykq"></dd><xmp id="iaykq"></xmp><legend id="iaykq"></legend><kbd id="iaykq"></kbd><bdo id="iaykq"></bdo><option id="iaykq"><object id="iaykq"><code id="iaykq"></code></object></option><menu id="iaykq"><code id="iaykq"><table id="iaykq"></table></code></menu><s id="iaykq"></s><optgroup id="iaykq"></optgroup><wbr id="iaykq"></wbr><input id="iaykq"></input><menu id="iaykq"><bdo id="iaykq"><button id="iaykq"></button></bdo></menu><rt id="iaykq"><samp id="iaykq"><nav id="iaykq"></nav></samp></rt><label id="iaykq"></label><kbd id="iaykq"></kbd><blockquote id="iaykq"></blockquote><legend id="iaykq"></legend><nav id="iaykq"></nav><tbody id="iaykq"><dd id="iaykq"><tbody id="iaykq"></tbody></dd></tbody><button id="iaykq"></button><dd id="iaykq"></dd><option id="iaykq"></option><source id="iaykq"></source><td id="iaykq"><tr id="iaykq"><tt id="iaykq"></tt></tr></td><nav id="iaykq"></nav><option id="iaykq"><menu id="iaykq"><center id="iaykq"></center></menu></option><center id="iaykq"><sup id="iaykq"><small id="iaykq"></small></sup></center><td id="iaykq"></td><tbody id="iaykq"></tbody><small id="iaykq"></small><div id="iaykq"></div><td id="iaykq"></td><menu id="iaykq"></menu><div id="iaykq"></div><tbody id="iaykq"></tbody><td id="iaykq"></td><rt id="iaykq"><code id="iaykq"><input id="iaykq"></input></code></rt><option id="iaykq"></option><wbr id="iaykq"></wbr><center id="iaykq"><small id="iaykq"><blockquote id="iaykq"></blockquote></small></center><td id="iaykq"><tbody id="iaykq"><xmp id="iaykq"></xmp></tbody></td><blockquote id="iaykq"></blockquote><source id="iaykq"></source><nav id="iaykq"><tt id="iaykq"><s id="iaykq"></s></tt></nav><table id="iaykq"></table><xmp id="iaykq"></xmp> <label id="iaykq"></label><dd id="iaykq"></dd><div id="iaykq"></div><tt id="iaykq"></tt><strong id="iaykq"></strong><samp id="iaykq"><u id="iaykq"><tr id="iaykq"></tr></u></samp><nav id="iaykq"><xmp id="iaykq"><object id="iaykq"></object></xmp></nav><xmp id="iaykq"><bdo id="iaykq"><nav id="iaykq"></nav></bdo></xmp><tr id="iaykq"></tr><sup id="iaykq"></sup><kbd id="iaykq"></kbd><s id="iaykq"><kbd id="iaykq"><wbr id="iaykq"></wbr></kbd></s><s id="iaykq"><option id="iaykq"><wbr id="iaykq"></wbr></option></s><blockquote id="iaykq"><bdo id="iaykq"><sup id="iaykq"></sup></bdo></blockquote><optgroup id="iaykq"></optgroup><tt id="iaykq"></tt><samp id="iaykq"></samp><button id="iaykq"></button><sup id="iaykq"></sup><sup id="iaykq"></sup><nav id="iaykq"></nav><center id="iaykq"></center><optgroup id="iaykq"></optgroup><button id="iaykq"><rt id="iaykq"><div id="iaykq"></div></rt></button><nav id="iaykq"></nav><blockquote id="iaykq"></blockquote><object id="iaykq"><kbd id="iaykq"><wbr id="iaykq"></wbr></kbd></object><s id="iaykq"></s><samp id="iaykq"></samp><s id="iaykq"></s><center id="iaykq"></center><strong id="iaykq"><menu id="iaykq"><acronym id="iaykq"></acronym></menu></strong><option id="iaykq"></option><strong id="iaykq"></strong><button id="iaykq"><noscript id="iaykq"><table id="iaykq"></table></noscript></button><sup id="iaykq"></sup><bdo id="iaykq"><label id="iaykq"><tt id="iaykq"></tt></label></bdo><s id="iaykq"><acronym id="iaykq"><source id="iaykq"></source></acronym></s><source id="iaykq"><li id="iaykq"><xmp id="iaykq"></xmp></li></source><kbd id="iaykq"></kbd><input id="iaykq"></input><input id="iaykq"></input><optgroup id="iaykq"></optgroup><option id="iaykq"><tbody id="iaykq"><table id="iaykq"></table></tbody></option><wbr id="iaykq"></wbr><nav id="iaykq"></nav><s id="iaykq"></s><code id="iaykq"><nav id="iaykq"><tt id="iaykq"></tt></nav></code><code id="iaykq"><nav id="iaykq"><u id="iaykq"></u></nav></code><li id="iaykq"></li></div> <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body>