锘??xml version="1.0" encoding="utf-8" standalone="yes"?>BlogJava-鎮熷績http://www.8634070.com/Reg/鎴愬姛涓嶆槸灏嗘潵鎵嶆湁鐨?鑰屾槸浠庡喅瀹氬幓鍋?#37928;?#38317;?#28051;€鍒昏捣,鎸佺画绱?#32457;?#38000;?#37812;?#37510;? 涓婁汉鐢?#37928;?#37827;呴€旂舰銆傚墠閫斿緢杩?涔熷緢鏆?#37510;傜劧鑰?#28051;?#29781;佹€?#37510;?#28051;嶆€?#37928;勪汉鐨?#38344;?#37715;嶆?#23942;湁璺?#37510;?/description>zh-cnTue, 26 Mar 2019 20:14:55 GMTTue, 26 Mar 2019 20:14:55 GMT60MSDN鍛婅瘔浣犵綉鍧€http://www.8634070.com/Reg/archive/2013/04/19/398068.html鑹炬尝鑹炬尝Fri, 19 Apr 2013 01:53:00 GMThttp://www.8634070.com/Reg/archive/2013/04/19/398068.htmlhttp://www.8634070.com/Reg/comments/398068.htmlhttp://www.8634070.com/Reg/archive/2013/04/19/398068.html#Feedback0http://www.8634070.com/Reg/comments/commentRss/398068.htmlhttp://www.8634070.com/Reg/services/trackbacks/398068.htmlhttp://msdn.itellyou.cn/?lang=zh-cn

]]>
?#32137;?#31926;绮剧伒(IP鍦?#37735;€鍒囨崲鍣?v2.0.0.3 final <font color=red>闄凙U3婧愮爜</font>锛堟洿鏂?#38171;?/title><link>http://www.8634070.com/Reg/archive/2012/06/19/381088.html</link><dc:creator>鑹炬尝</dc:creator><author>鑹炬尝</author><pubDate>Tue, 19 Jun 2012 05:05:00 GMT</pubDate><guid>http://www.8634070.com/Reg/archive/2012/06/19/381088.html</guid><wfw:comment>http://www.8634070.com/Reg/comments/381088.html</wfw:comment><comments>http://www.8634070.com/Reg/archive/2012/06/19/381088.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/Reg/comments/commentRss/381088.html</wfw:commentRss><trackback:ping>http://www.8634070.com/Reg/services/trackbacks/381088.html</trackback:ping><description><![CDATA[ <div>?#32137;?#31926;绮剧伒 v2.0.0.3<br />杞?#28000;?#29831;存槑锛?#38315;傚悎澶氱綉?#31926;?#23001;鍏?#28003;?#37922;?#38171;?#32432;?#37714;版潃杞?#37819;愮¤º锛?#29831;?#37711;?#29825;?#38315;?#26473;?#38171;屽¦‚360<br />搴?#37922;?#39582;?#37721;?#38171;?a class="linkwin7" href="http://www.duote.com/win7"><font color="#0000ff">Win7</font></a>/Vista/WinXP/<br />杞?#28000;?#28598;?#28751;?#38171;?96 KB<br />缂栧啓璇­è¨€锛欰U3<br />浣?#38000;?#38317;?#32480;?#38171;?a href="mailto:1015208770@163.com">1015208770@163.com</a><br /><strike>涓?#26462;?#37734;?#37735;€1锛?/strike><a href="http://www.8634070.com/Files/Reg/NetworkSpirit.rar"><strike>http://www.8634070.com/Files/Reg/NetworkSpirit.rar</strike></a>(鍐呴儴鍑芥暟璋?#37922;¨æ湁鏃?#37706;?#37713;虹Ž°涓嶆­£?#29238;鐨勯棶棰?<br />涓?#26462;?#37734;?#37735;€2锛?a href="http://www.8634070.com/Files/Reg/NetworkSpirit.rar"></a><a href="http://www.8634070.com/Files/Reg/NetworkSpirit.zip">http://www.8634070.com/Files/Reg/NetworkSpirit.zip</a>(杩?#28051;ªæ槸2.0.0.4鐗堟湰锛屾洿鏂?#28051;€涓?#37911;堟湰鍙?#38171;屼慨澶?#28051;?#28051;?#37911;堟湰鍐呴儴鍑芥暟璋?#37922;¨é棶棰?<br />婧愮爜鍦?#37735;€1锛?a href="http://www.8634070.com/Files/Reg/NetworkSpirit(code).rar">http://www.8634070.com/Files/Reg/NetworkSpirit(code).rar(2.0.0.3</a>婧愮爜)<br /><br />MD5妫€娴?#38171;?br />鏂?#28000;?#37911;堟湰: 2.0.0.3<br />?#24936;?#25980;鏃堕棿: 2012-06-19, 12:34:44<br />MD5: 09CBAE1D6436C4EAE867AB802140E26F<br />SHA1: 4B2DA60F609948A46989C417E44C17515B8FAA9B<br />CRC32: D3A9D77E<br /><br />?#27967;鏂?#29831;存槑锛?br />1.婧?#28000;£ç爜閲嶆瀯<br />2.鍏?#37826;°UI<br />3.姝£å紡?#27967;?#24725;涓虹綉?#31926;绮剧伒(IP鍦?#37735;€鍒囨崲鍣?<br /><br />?#23003;?#20824;璇存槑锛?br />1.鏀?#37816;?#28598;氭¨¡?#32033;鍒囨崲<br />2.鑷?#37716;?#28766;忚斀VMware铏氭?#29114;綉?#23857;璁?#32515;?br />3.鑷?#37716;?#37714;?#37826;­ç綉?#22158;?#27128;?#24769;宸?#26473;?#37818;?br /><br />杞?#28000;?#37812;ªå浘锛?br /><br /><img border="0" alt="" src="http://www.8634070.com/images/blogjava_net/reg/?#32137;?#31926;绮剧伒v2.0.0.3.jpg" width="604" height="331" /><br /></div> <img src ="http://www.8634070.com/Reg/aggbug/381088.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/Reg/" target="_blank">鑹炬尝</a> 2012-06-19 13:05 <a href="http://www.8634070.com/Reg/archive/2012/06/19/381088.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣¡¨璇勮®º</a></div>]]></description></item><item><title><font color=red>advanced systemcare 5.2娉?#37712;岀爜</font>http://www.8634070.com/Reg/archive/2012/04/06/373431.html鑹炬尝鑹炬尝Fri, 06 Apr 2012 01:21:00 GMThttp://www.8634070.com/Reg/archive/2012/04/06/373431.htmlhttp://www.8634070.com/Reg/comments/373431.htmlhttp://www.8634070.com/Reg/archive/2012/04/06/373431.html#Feedback6http://www.8634070.com/Reg/comments/commentRss/373431.htmlhttp://www.8634070.com/Reg/services/trackbacks/373431.html
涓€娆捐兘鍒嗘?#24878;郴缁?#37804;§è兘鐡?#26864;?#37928;勪紭鍖?#26462;?#28000;?#37510;?#28729;?#38315;?#26473;?#28725;?#32495;?#32513;熷叏鏂?#28003;?#37928;?#29831;?#37826;?#38171;?#37813;?#37714;?#32495;?#32513;?#37804;§è兘鐨?#37921;?#26864;?#37813;€鍦?#38171;岀劧?#24727;?#28225;?#25313;瀵?#37804;?#37734;?#26473;涜?#23676;慨?#25980;銆佷紭鍖?#37510;?#23005;?#28598;?#28729;?#26473;?#37711;锋湁?#26879;璋?#26462;?#28000;跺?#23678;?#33333;剰杞?#28000;?#37813;«æ弿娓呴櫎?#23003;?#20824;锛?#28052;熻兘灏?#28003;?#37928;勯?#24878;§淇?#37805;?#28000;?#37922;?#38004;?#28051;?#37814;?#38340;?#37510;傞拡瀵?#28051;ªä汉鍏嶈´¹浣?#37922;?#37510;侫dvanced
WindowsCare Personal宸叉洿?#24725;涓ºAdvanced SystemCare銆?br />娉?#37712;岀爜:
79818-39C67-6AD87-1B8D4

]]>
Dom4jFactory(璇?#37721;栧Œ…鍚?#37723;藉悕绌洪棿鐨刋ML锛堟敮鎸佽?#20636;偣璇?#37721;?#28051;?#28729;屾暣锛?<font color=red>娣?#37716;?#28003;?#37922;?#28729;炰緥</font>http://www.8634070.com/Reg/archive/2011/12/14/366351.html鑹炬尝鑹炬尝Wed, 14 Dec 2011 08:39:00 GMThttp://www.8634070.com/Reg/archive/2011/12/14/366351.htmlhttp://www.8634070.com/Reg/comments/366351.htmlhttp://www.8634070.com/Reg/archive/2011/12/14/366351.html#Feedback2http://www.8634070.com/Reg/comments/commentRss/366351.htmlhttp://www.8634070.com/Reg/services/trackbacks/366351.htmlimport java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.XPath;
import org.dom4j.io.SAXReader;

/**
 * 璇?#37721;–æ湁鍛藉悕绌洪棿鐨刋ML锛堟敮鎸佽?#20636;偣璇?#37721;?#28051;?#28729;屾暣锛?br />  * 
@author Ai Bo
 * 
@version 1.3.1 Date 2011-12-14
 
*/

public class Dom4jFactory {
    
private SAXReader reader = new SAXReader();
    
private Document document;
    
private static Element root;
    
private static Map<String, String> xmlMap = new HashMap<String, String>();

    
public Dom4jFactory(String path) {
        
super();
        
try {
            document 
= reader.read(path);
            root 
= document.getRootElement();
            String defaultNamespace 
= root.getNamespaceURI();
            xmlMap.put(
"default", defaultNamespace);
        }
 catch (DocumentException e) {
            e.printStackTrace();
        }

    }


    
public static List<?> getSelectNodes(String arg0) {
        XPath selector 
= root.createXPath("//default:" + arg0);
        selector.setNamespaceURIs(xmlMap);
        
return selector.selectNodes(root);
    }

    
    @SuppressWarnings(
"unchecked")
    
public <T> T getSelectObject(String arg0){
        List
<?> selectNodes = getSelectNodes(arg0);
        
if(selectNodes.size()==1){
            
return (T) selectNodes.get(0);
        }
else{
            
return null;
        }

    }

}

 XML鏂?#28000;?

<?xml version="1.0" encoding="UTF-8"?>
<inputs xmlns="http://input.abio.com.cn" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation
="http://input.abio.com.cn http://www.abio.com.cn/sproinput.xsd">
   
<columns>2</columns>
   
<input id="id"  datatype="String" minlen="1" maxlen="32" casetype="U" width="40" name_zh="?#26271;鎹?#28000;£ç爜" inputtype="text" editable="2" gridwidth="3"></input>
   
<input id="organNo"  datatype="integer" nullable="false" minlen="1" maxlen="20" casetype="U" width="40" name_zh="鏈?#37835;?#32514;?#37721;? inputtype="text" editable="2"></input>
   
<input id="organName"  datatype="String" nullable="false" minlen="1" maxlen="20" casetype="U" width="40" name_zh="鏈?#37835;勫悕绉? inputtype="text" editable="2"></input>
   
<input id="pOrganNo"  datatype="String" nullable="false" minlen="1" maxlen="20" casetype="U" width="40" name_zh="鐖?#37832;?#37835;?#32514;?#37721;? inputtype="text" editable="2"></input>
   
<input id="effTime"  datatype="Date" validator="Date" nullable="false" format="yyyy-MM-dd" minlen="8" maxlen="8" casetype="U" width="40" name_zh="?#28225;鏁?#37827;?#37832;? inputtype="date" editable="2"></input>
   
<input id="createUser"  datatype="String" minlen="1" maxlen="20" casetype="U" width="40" name_zh="鍒涘缓?#27721;" inputtype="text" editable="2"></input>
   
<input id="createTime"  datatype="Date" minlen="10" maxlen="20" casetype="U" width="40" name_zh="鍒涘缓鏃?#37832;? editable="2" inputtype="text"></input>
   
<input id="updateUser"  datatype="String"  minlen="1" maxlen="20" casetype="U" width="40" name_zh="?#27967;鏂颁汉" inputtype="text" editable="2"></input>
   
<input id="updateTime"  datatype="Date" minlen="10" maxlen="20" casetype="U" width="40" name_zh="?#27967;鏂?#37827;?#37832;? editable="2" inputtype="text"></input>
</inputs>

璇?#37721;–XML鍗?#28051;?#38010;傜偣锛坕nputs涓?#37928;„columns鑺傜偣锛?

Dom4jFactory df = new Dom4jFactory("c:\\test.xml");
        DefaultElement columnsitem 
= df.getSelectObject("columns");

璇?#37721;–XML inputs鑺傜偣涓?#37813;€?#28225;鐨„input鑺傜偣锛?/p>

Dom4jFactory df = new Dom4jFactory("c:\\test.xml");
            List
<DefaultElement> inputNodes = df.getSelectNodes("input");




 



]]>
a different object with the same identifier value was already associated with the sessionhttp://www.8634070.com/Reg/archive/2011/04/05/347655.html鑹炬尝鑹炬尝Tue, 05 Apr 2011 14:26:00 GMThttp://www.8634070.com/Reg/archive/2011/04/05/347655.htmlhttp://www.8634070.com/Reg/comments/347655.htmlhttp://www.8634070.com/Reg/archive/2011/04/05/347655.html#Feedback0http://www.8634070.com/Reg/comments/commentRss/347655.htmlhttp://www.8634070.com/Reg/services/trackbacks/347655.html杩?#28051;?#38335;?#29831;?#37812;?#28051;€鍏遍亣鍒?#26473;?#28051;?#23046;?#38171;?#28051;€?#27967;?#30149;?#28225;鎵?#37714;板緢濂?#37928;勮§£?#21893;鏂规¡ˆ锛?#26473;?#28051;?#38335;?#29831;?#27996;?#37922;熷?#29111;?#29365;浉淇?#28598;?#28729;?#38318;界煡?#20158;锛屽洜涓?#37734;¨hibernate涓?#37722;?#28051;€涓猻ession閲?#38344;¢æ湁浜?#28051;?#28051;?#37929;?#37722;屾 ‡璇?#28003;嗘槸?#27128;涓?#37722;?#28729;?#28003;?
涓€寮€濮?#37816;夌綉涓婅¯´鐨?#37922;¨session.merge(Object)鎶?#27996;?#28051;€涓?#38335;?#38171;?#37721;?#38003;芥槸?#30149;?#28225;鐢?#28610;?#38171;屾敼鐢?nbsp;session.clear(); session.update(user);杩?#37837;?#28751;監K浜?
鏂?#23049;?#28051;?#38171;?br />
package org.springframework.orm.hibernate3.support;

    
public void modifyByMerge(User user) {
        Session session 
= getHibernateTemplate().getSessionFactory().
                          getCurrentSession();
        session.clear();
        session.update(user);
    }

椤圭洰鐢?#37928;勬槸spring 
+ hibernate鎵€浠¥å緱鐢¨getHibernateTemplate().getSessionFactory().getCurrentSession();?#32241;?#32139;?#22688;Session



]]>
?#26271;鎹?#25652;?#37832;?#37716;?#32480;?#37918;?#23480;?#37711;?V2.0.0.1(鍘熷垱锛屾湜澶?#28729;舵‹鐮?http://www.8634070.com/Reg/archive/2011/03/30/347285.html鑹炬尝鑹炬尝Wed, 30 Mar 2011 07:23:00 GMThttp://www.8634070.com/Reg/archive/2011/03/30/347285.htmlhttp://www.8634070.com/Reg/comments/347285.htmlhttp://www.8634070.com/Reg/archive/2011/03/30/347285.html#Feedback1http://www.8634070.com/Reg/comments/commentRss/347285.htmlhttp://www.8634070.com/Reg/services/trackbacks/347285.html?#26271;鎹?#25652;?#37832;?#37716;?#32480;?#37918;?#23480;?#37711;?nbsp;V2.0.0.1
鍒涘§‹涔?#37714;?鍦?#23534;€鍙?#26473;?#32459;?#28051;?#38171;岀儲浜庢瘡娆?#23534;€鏈哄悗閮?#29781;佺敤鍛?#28000;?#37813;?#23534;€servers.msc鍚?#37716;?#37832;?#37716;?#38171;?#37812;?#38000;?#37814;?#29781;?#37722;?#37716;?#37928;?#37832;?#37716;¡å啓鎴?#28051;€涓狟AT 鏂?#28000;?#26473;愯?#23678;湇鍔?#37510;?#37812;戞湁鐐?#28051;?#28598;?#37728;?#23046;?#27035;戝?#34249;拷鐨勭ª—鍙?#38171;?#37813;€浠?#27996;?#37922;¨AU3?#21843;浜?#28051;?#28751;?#32459;?#25652;?#37922;¨æ潵绠?#37918;?#26473;?#27996;?#37832;?#37716;?#37510;?br /> ?#23003;?#20824;锛?br /> 1.鏀?#37816;oracle,sqlserver,mysql?#26271;鎹?#25652;?#37832;?#37716;?br /> 2.鏀?#37816;?#29825;?#32515;?#37832;?#37716;?#37722;?#37716;?#22959;¡å紡
3.鏀?#37816;?#37813;归?#24531;惎鍔?#37832;?#37716;?br /> 4.鏀?#37816;Windows(XP,VISTA,2008,7),鍏?#28000;–Windows绯?#32513;?#37922;?#27996;?#37827;堕棿?#26870;棰˜æ病?#28533;?#32241;鎬?#23092;?#29831;?#37510;?br /> 娉¨æ剰:
1.oracle鐨勭?#25117;¬鍣?#36423;呴渶?#21412;缃?#23005;£ç¡®(涓?#37911;?#28751;嗘敼杩?#26473;?#28051;ªé棶棰?

鏈?#37734;?#28051;?#26462;?http://www.8634070.com/Files/Reg/?#26271;鎹?#25652;?#37832;?#37716;?#32480;?#37918;?#23480;?#37711;?rar
鍒嗘祦鍦?#37735;€:http://down.51cto.com/data/184705

]]>
鏄剧¤ºsql server鐨勬煡璇?#29831;?#37721;?#26473;愯?#23678;椂?#26879;锛?#37711;?#28003;?#37714;版¯«绉?/title><link>http://www.8634070.com/Reg/archive/2011/03/18/346546.html</link><dc:creator>鑹炬尝</dc:creator><author>鑹炬尝</author><pubDate>Fri, 18 Mar 2011 08:31:00 GMT</pubDate><guid>http://www.8634070.com/Reg/archive/2011/03/18/346546.html</guid><wfw:comment>http://www.8634070.com/Reg/comments/346546.html</wfw:comment><comments>http://www.8634070.com/Reg/archive/2011/03/18/346546.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/Reg/comments/commentRss/346546.html</wfw:commentRss><trackback:ping>http://www.8634070.com/Reg/services/trackbacks/346546.html</trackback:ping><description><![CDATA[<div style="border-bottom: #cccccc 1px solid; border-left: #cccccc 1px solid; padding-bottom: 4px; background-color: #eeeeee; padding-left: 4px; width: 98%; padding-right: 5px; font-size: 13px; word-break: break-all; border-top: #cccccc 1px solid; border-right: #cccccc 1px solid; padding-top: 4px"><span style="color: #0000ff">declare</span><span style="color: #000000">   </span><span style="color: #008000">@ct</span><span style="color: #000000">   </span><span style="color: #000000; font-weight: bold">datetime</span><span style="color: #000000">   <br />   </span><span style="color: #0000ff">set</span><span style="color: #000000">   </span><span style="color: #008000">@ct</span><span style="color: #000000">   </span><span style="color: #808080">=</span><span style="color: #000000">   </span><span style="color: #ff00ff">getdate</span><span style="color: #000000">()   <br />   </span><span style="color: #008080">--</span><span style="color: #008080">-   </span><span style="color: #008080"><br /> </span><span style="color: #000000">  </span><span style="color: #008080">--</span><span style="color: #008080">sql   璇?#37721;?nbsp;  </span><span style="color: #008080"><br /> </span><span style="color: #000000"><br />   </span><span style="color: #008080">--</span><span style="color: #008080">-   </span><span style="color: #008080"><br /> </span><span style="color: #000000">  </span><span style="color: #0000ff">select</span><span style="color: #000000">   </span><span style="color: #ff00ff">datediff</span><span style="color: #000000">(ms,   </span><span style="color: #008000">@ct</span><span style="color: #000000">   ,</span><span style="color: #ff00ff">getdate</span><span style="color: #000000">())   </span><span style="color: #0000ff">as</span><span style="color: #000000">   </span><span style="color: #ff0000">'</span><span style="color: #ff0000">?#29025;璇?#37827;堕棿锛堟¯«绉?#38171;?/span><span style="color: #ff0000">'</span><span style="color: #000000"> <br /> </span></div> <img src ="http://www.8634070.com/Reg/aggbug/346546.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/Reg/" target="_blank">鑹炬尝</a> 2011-03-18 16:31 <a href="http://www.8634070.com/Reg/archive/2011/03/18/346546.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣¡¨璇勮®º</a></div>]]></description></item><item><title>鏍?Oracle鐢¨Start with...Connect By瀛愬彞閫掑綊?#29025;璇?/title><link>http://www.8634070.com/Reg/archive/2011/03/16/346370.html</link><dc:creator>鑹炬尝</dc:creator><author>鑹炬尝</author><pubDate>Wed, 16 Mar 2011 03:30:00 GMT</pubDate><guid>http://www.8634070.com/Reg/archive/2011/03/16/346370.html</guid><wfw:comment>http://www.8634070.com/Reg/comments/346370.html</wfw:comment><comments>http://www.8634070.com/Reg/archive/2011/03/16/346370.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/Reg/comments/commentRss/346370.html</wfw:commentRss><trackback:ping>http://www.8634070.com/Reg/services/trackbacks/346370.html</trackback:ping><description><![CDATA[<div style="border-bottom: #cccccc 1px solid; border-left: #cccccc 1px solid; padding-bottom: 4px; background-color: #eeeeee; padding-left: 4px; width: 98%; padding-right: 5px; font-size: 13px; word-break: break-all; border-top: #cccccc 1px solid; border-right: #cccccc 1px solid; padding-top: 4px"><span style="color: #000000">Start </span><span style="color: #0000ff">with</span><span style="color: #000000"><img src="http://www.8634070.com/Images/dot.gif" alt="" />Connect By瀛愬彞閫掑綊?#29025;璇?#28051;€鑸?#37922;?#27996;?#28051;€涓?#29723;?#32513;存姢鏍戝舰缁?#37835;?#37928;?#25652;?#37922;?#37510;?br /> 鍒涘?#34425;?#36720;?#23341;¡¨锛?br /> </span><span style="color: #0000ff">CREATE</span><span style="color: #000000"> </span><span style="color: #0000ff">TABLE</span><span style="color: #000000"> TBL_TEST<br /> (<br />   ID    </span><span style="color: #000000; font-weight: bold">NUMBER</span><span style="color: #000000">,<br />   NAME  </span><span style="color: #000000; font-weight: bold">VARCHAR2</span><span style="color: #000000">(</span><span style="color: #800000; font-weight: bold">100</span><span style="color: #000000"> BYTE),<br />   PID   </span><span style="color: #000000; font-weight: bold">NUMBER</span><span style="color: #000000">                                  </span><span style="color: #0000ff">DEFAULT</span><span style="color: #000000"> </span><span style="color: #800000; font-weight: bold">0</span><span style="color: #000000"><br /> );<br />  <br /> 鎻?#37711;?#23092;?#29831;曟暟鎹?#38171;?br /> </span><span style="color: #0000ff">INSERT</span><span style="color: #000000"> </span><span style="color: #0000ff">INTO</span><span style="color: #000000"> TBL_TEST(ID,NAME,PID) </span><span style="color: #0000ff">VALUES</span><span style="color: #000000">(</span><span style="color: #ff0000">'</span><span style="color: #ff0000">1</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">10</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">0</span><span style="color: #ff0000">'</span><span style="color: #000000">);<br /> </span><span style="color: #0000ff">INSERT</span><span style="color: #000000"> </span><span style="color: #0000ff">INTO</span><span style="color: #000000"> TBL_TEST(ID,NAME,PID) </span><span style="color: #0000ff">VALUES</span><span style="color: #000000">(</span><span style="color: #ff0000">'</span><span style="color: #ff0000">2</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">11</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">1</span><span style="color: #ff0000">'</span><span style="color: #000000">);<br /> </span><span style="color: #0000ff">INSERT</span><span style="color: #000000"> </span><span style="color: #0000ff">INTO</span><span style="color: #000000"> TBL_TEST(ID,NAME,PID) </span><span style="color: #0000ff">VALUES</span><span style="color: #000000">(</span><span style="color: #ff0000">'</span><span style="color: #ff0000">3</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">20</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">0</span><span style="color: #ff0000">'</span><span style="color: #000000">);<br /> </span><span style="color: #0000ff">INSERT</span><span style="color: #000000"> </span><span style="color: #0000ff">INTO</span><span style="color: #000000"> TBL_TEST(ID,NAME,PID) </span><span style="color: #0000ff">VALUES</span><span style="color: #000000">(</span><span style="color: #ff0000">'</span><span style="color: #ff0000">4</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">12</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">1</span><span style="color: #ff0000">'</span><span style="color: #000000">);<br /> </span><span style="color: #0000ff">INSERT</span><span style="color: #000000"> </span><span style="color: #0000ff">INTO</span><span style="color: #000000"> TBL_TEST(ID,NAME,PID) </span><span style="color: #0000ff">VALUES</span><span style="color: #000000">(</span><span style="color: #ff0000">'</span><span style="color: #ff0000">5</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">121</span><span style="color: #ff0000">'</span><span style="color: #000000">,</span><span style="color: #ff0000">'</span><span style="color: #ff0000">2</span><span style="color: #ff0000">'</span><span style="color: #000000">);<br />  <br /> 浠嶳oot寰€鏍?#37832;?#22986;?#38315;掑綊<br /> </span><span style="color: #0000ff">select</span><span style="color: #000000"> </span><span style="color: #808080">*</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> TBL_TEST<br />  start </span><span style="color: #0000ff">with</span><span style="color: #000000"> id</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">1</span><span style="color: #000000"><br />  connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior id </span><span style="color: #808080">=</span><span style="color: #000000"> pid<br />  <br /> 浠?#37832;?#22986;?#23536;€鏍慠OOT閫掑綊<br /> </span><span style="color: #0000ff">select</span><span style="color: #000000"> </span><span style="color: #808080">*</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> TBL_TEST<br />  start </span><span style="color: #0000ff">with</span><span style="color: #000000"> id</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">5</span><span style="color: #000000"><br />  connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior pid </span><span style="color: #808080">=</span><span style="color: #000000"> id<br /> </span><span style="color: #808080">=====</span><span style="color: #000000"><br /> 瀵?#27996;Žoracle杩涜¡Œ绠€鍗?#37837;戞煡璇?閫掑綊?#29025;璇?<br /> <br /> DEPTID PAREDEPTID NAME <br /> </span><span style="color: #000000; font-weight: bold">NUMBER</span><span style="color: #000000"> </span><span style="color: #000000; font-weight: bold">NUMBER</span><span style="color: #000000"> </span><span style="color: #000000; font-weight: bold">CHAR</span><span style="color: #000000"> (</span><span style="color: #800000; font-weight: bold">40</span><span style="color: #000000"> Byte) <br /> ?#20788;闂¨id 鐖堕儴闂¨id(鎵€灞為儴闂¨id) ?#20788;闂¨å悕绉?nbsp;<br /> <br /> <br /> 閫?#26473;?#28699;?#38010;傜偣鍚?#37837;硅?#20636;偣杩芥œ”.<br /> <br /> Sql浠£ç爜 <br /> </span><span style="color: #800000; font-weight: bold">1</span><span style="color: #000000">.</span><span style="color: #0000ff">select</span><span style="color: #000000"> </span><span style="color: #808080">*</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept start </span><span style="color: #0000ff">with</span><span style="color: #000000"> deptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">76</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior paredeptid</span><span style="color: #808080">=</span><span style="color: #000000">deptid   <br /> Sql浠£ç爜  <br /> </span><span style="color: #800000; font-weight: bold">1</span><span style="color: #000000">.</span><span style="color: #0000ff">select</span><span style="color: #000000"> </span><span style="color: #808080">*</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept start </span><span style="color: #0000ff">with</span><span style="color: #000000"> deptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">76</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior paredeptid</span><span style="color: #808080">=</span><span style="color: #000000">deptid   <br />  </span><span style="color: #0000ff">select</span><span style="color: #000000"> </span><span style="color: #808080">*</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept start </span><span style="color: #0000ff">with</span><span style="color: #000000"> deptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">76</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior paredeptid</span><span style="color: #808080">=</span><span style="color: #000000">deptid  <br /> <br /> 閫?#26473;囨?#30789;?#20636;?#24402;亶鍘嗗瓙鑺傜偣. <br /> <br /> Sql浠£ç爜 <br /> </span><span style="color: #800000; font-weight: bold">1</span><span style="color: #000000">.</span><span style="color: #0000ff">select</span><span style="color: #000000"> </span><span style="color: #808080">*</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept start </span><span style="color: #0000ff">with</span><span style="color: #000000"> paredeptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">0</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior deptid</span><span style="color: #808080">=</span><span style="color: #000000">paredeptid   <br /> Sql浠£ç爜  <br /> </span><span style="color: #800000; font-weight: bold">1</span><span style="color: #000000">.</span><span style="color: #0000ff">select</span><span style="color: #000000"> </span><span style="color: #808080">*</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept start </span><span style="color: #0000ff">with</span><span style="color: #000000"> paredeptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">0</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior deptid</span><span style="color: #808080">=</span><span style="color: #000000">paredeptid   <br /> </span><span style="color: #0000ff">select</span><span style="color: #000000"> </span><span style="color: #808080">*</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept start </span><span style="color: #0000ff">with</span><span style="color: #000000"> paredeptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">0</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior deptid</span><span style="color: #808080">=</span><span style="color: #000000">paredeptid  <br /> <br /> 鍙?#38315;?#26473;‡level 鍏?#38335;?#28699;楁煡璇?#37813;€鍦?#28766;?#23046;? <br /> <br /> Sql浠£ç爜 <br /> </span><span style="color: #800000; font-weight: bold">1</span><span style="color: #000000">.</span><span style="color: #0000ff">select</span><span style="color: #000000"> a.</span><span style="color: #808080">*</span><span style="color: #000000">,</span><span style="color: #0000ff">level</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept a start </span><span style="color: #0000ff">with</span><span style="color: #000000"> paredeptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">0</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior deptid</span><span style="color: #808080">=</span><span style="color: #000000">paredeptid   <br /> Sql浠£ç爜  <br /> </span><span style="color: #800000; font-weight: bold">1</span><span style="color: #000000">.</span><span style="color: #0000ff">select</span><span style="color: #000000"> a.</span><span style="color: #808080">*</span><span style="color: #000000">,</span><span style="color: #0000ff">level</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept a start </span><span style="color: #0000ff">with</span><span style="color: #000000"> paredeptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">0</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior deptid</span><span style="color: #808080">=</span><span style="color: #000000">paredeptid   <br /> </span><span style="color: #0000ff">select</span><span style="color: #000000"> a.</span><span style="color: #808080">*</span><span style="color: #000000">,</span><span style="color: #0000ff">level</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept a start </span><span style="color: #0000ff">with</span><span style="color: #000000"> paredeptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">0</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior deptid</span><span style="color: #808080">=</span><span style="color: #000000">paredeptid  <br /> <br /> 鍐嶆¬¡澶?#28052;?#28051;€涓?start </span><span style="color: #0000ff">with</span><span style="color: #000000"> <img src="http://www.8634070.com/Images/dot.gif" alt="" />connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> 鐨?#37922;?#23049;?#38171;?nbsp;start </span><span style="color: #0000ff">with</span><span style="color: #000000"> ?#24727;闈?#37813;€璺?#37928;?#28751;辨槸灏辨槸閫掑綊鐨勭?#23941;瓙銆?nbsp;<br /> <br /> 閫掑綊鐨勭?#23941;瓙涔熷?#36776;槸閫掑綊寮€濮?#37928;?#37734;?#37826;?nbsp;connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> ?#24727;闈?#37928;?prior" 濡?#37835;?#32514;虹渷锛氬垯鍙?#38003;芥煡璇?#37714;扮¬¦鍚堟潯浠?#37928;勮捣濮嬭¡Œ锛屽ƈ涓?#26473;涜¡Œ閫掑綊?#29025;璇?#38171;?nbsp;<br /> <br /> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior ?#24727;闈?#37813;€鏀?#37928;?#28699;楁®µ?#27128;?#28225;鍏?#32495;?#37928;?#38171;?#28729;?#37816;囨槑浜嗘煡璇?#37928;?#37826;?#37722;?#37510;?nbsp;<br /> <br /> 缁?#28052;?#38171;?nbsp;閫?#26473;?#28699;?#38010;傜?#30789;?#23792;緱椤?#38010;傜偣 <br /> <br /> Sql浠£ç爜 <br /> </span><span style="color: #800000; font-weight: bold">1</span><span style="color: #000000">.</span><span style="color: #0000ff">select</span><span style="color: #000000"> FIRST_VALUE(deptid) </span><span style="color: #0000ff">OVER</span><span style="color: #000000"> (</span><span style="color: #0000ff">ORDER</span><span style="color: #000000"> </span><span style="color: #0000ff">BY</span><span style="color: #000000"> </span><span style="color: #0000ff">LEVEL</span><span style="color: #000000"> </span><span style="color: #0000ff">DESC</span><span style="color: #000000"> ROWS UNBOUNDED PRECEDING) </span><span style="color: #0000ff">AS</span><span style="color: #000000"> firstdeptid </span><span style="color: #0000ff">from</span><span style="color: #000000"> persons.dept start </span><span style="color: #0000ff">with</span><span style="color: #000000"> deptid</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">76</span><span style="color: #000000"> connect </span><span style="color: #0000ff">by</span><span style="color: #000000"> prior paredeptid</span><span style="color: #808080">=</span><span style="color: #000000">deptid  <br /> </span><span style="color: #808080">====</span><span style="color: #000000">杩?#32457;嶆柟娉?#37721;ªæ槸?#32139;琛?#38322;?#28751;辨湁涓€棰?#37837;?澶?#22955;?#37837;?#37804;?#28052;ˆå姙锛?br /> <br /> .澹版槑锛欽avaEye鏂囩?#29365;?#22559;潈灞?#27996;?#28003;?#38000;?#38171;?#37721;?#23049;•å緥淇?#37814;?#37510;傛病?#28225;浣?#38000;?#28052;?#38344;?#29825;?#37721;?#28051;嶅緱杞?#26462;?#37510;?nbsp;<br /> </span></div> <img src ="http://www.8634070.com/Reg/aggbug/346370.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/Reg/" target="_blank">鑹炬尝</a> 2011-03-16 11:30 <a href="http://www.8634070.com/Reg/archive/2011/03/16/346370.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣¡¨璇勮®º</a></div>]]></description></item><item><title>SQLSERVER 瀛楃¬¦鍑芥暟鏁寸悊http://www.8634070.com/Reg/archive/2011/03/16/346369.html鑹炬尝鑹炬尝Wed, 16 Mar 2011 03:17:00 GMThttp://www.8634070.com/Reg/archive/2011/03/16/346369.htmlhttp://www.8634070.com/Reg/comments/346369.htmlhttp://www.8634070.com/Reg/archive/2011/03/16/346369.html#Feedback0http://www.8634070.com/Reg/comments/commentRss/346369.htmlhttp://www.8634070.com/Reg/services/trackbacks/346369.html銆€銆€/* 瀛楃¬¦鍑芥暟 */
銆€銆€
/* 杩斿洖瀛楃¬¦琛?#26440;惧紡涓?#37832;€宸¦ä晶瀛楃¬¦鐨凙SCII浠£ç爜鍊?nbsp;*/
銆€銆€
select Ascii(‘a‘) --a:97,A:65
銆€銆€/* 灏嗘?#23384;暟ASCII浠£ç爜杞¬æ崲涓哄?#26947;¬¦ */
銆€銆€
select Char(97)--97:a,65:A
銆€銆€/* 杩斿洖琛?#26440;惧紡涓?#37816;?#28729;氬?#26947;¬¦鐨?#23534;€濮?#28003;?#32515;?nbsp;*/
銆€銆€
select Charindex(‘b‘,‘abcdefg‘,5)
銆€銆€
/* 浠?#37825;存暟杩斿洖涓?#28051;?#28699;楃¬¦琛?#26440;惧紡鐨凷OUNDEX鍊?#28052;?#23480;?nbsp;*/
銆€銆€
select Difference(‘bet‘,‘bit‘)--3
銆€銆€/* 杩斿洖瀛楃¬¦琛?#26440;惧紡鏈€宸¦ä晶鎸?#28729;氭暟鐩?#37928;?#28699;楃¬¦ */
銆€銆€
select Left(‘abcdefg‘,3)--abc
銆€銆€/* 杩斿洖缁?#28729;氬?#26947;¬¦涓茶¡¨?#25578;鐨?#28699;楃¬¦?#26271; */
銆€銆€
select Len(‘abcdefg‘)--7
銆€銆€/* 杩斿洖灏?#28598;§å啓瀛楃¬¦杞¬æ崲涓?#28751;忓?#26947;¬¦鐨?#28699;楃¬¦琛?#26440;惧紡 */
銆€銆€
select Lower(‘ABCDEFG‘)--abcdefg
銆€銆€/* 杩斿洖鍒?#38340;?#27996;嗗墠瀵?#32460;烘 ¼涔?#37722;庡?#26947;¬¦琛?#26440;惧紡 */
銆€銆€
select Ltrim(‘銆€銆€ abcdefg‘)--abcdefg
銆€銆€/* 杩斿洖鍏锋湁缁?#28729;?#37928;?#37825;存暟浠£ç爜鐨„UNICODE瀛楃¬¦ */
銆€銆€
select Nchar(65)--A
銆€銆€/* 杩斿洖鎸?#28729;氳¡¨杈惧紡涓?#22959;¡å紡绗?#28051;€娆?#37713;虹Ž°鐨?#23534;€濮?#28003;?#32515;?nbsp;*/
銆€銆€
select Patindex(‘%_cd%‘,‘abcdefg‘)--2
銆€銆€/* 杩斿洖涓?#37812;?#28051;烘湁鏁?#37928;凷QL SERVER鍒?#38341;?#37837;?#29831;?#32471;?#38000;屾坊鍔?#27996;?#37714;?#38341;旂¬¦鐨„UNICODE瀛楃¬¦涓?nbsp;*/
銆€銆€
select Quotename(‘create table‘)
銆€銆€
/* 鐢?#32471;?#28051;?#28051;?#29723;?#26440;惧紡鏇¿æ崲绗?#28051;€涓?#29723;?#26440;惧紡涓?#37713;虹Ž°鐨勭¬¬浜?#28051;?#29723;?#26440;惧紡 */
銆€銆€
select Replace(‘abcdefg‘,‘cd‘,‘xxx‘)--abxxxefg
銆€銆€/* 鎸?#37816;?#28729;氭¬¡?#26271;?#22136;澶嶈¡¨杈惧紡 */
銆€銆€
select Replicate(‘abc|‘,4)--abc|abc|abc|abc|
銆€銆€/* 杩斿洖瀛楃¬¦琛?#26440;惧紡鐨?#38315;?#37722;戣¡¨杈惧紡 */
銆€銆€
select Reverse(‘abc‘)--cba
銆€銆€/* 杩斿洖瀛楃¬¦琛?#26440;惧紡鍙³ä晶鎸?#28729;氭暟鐩?#37928;?#28699;楃¬¦ */
銆€銆€
select Right(‘abcd‘,3)--bcd
銆€銆€/* 杩斿洖鎴?#37826;?#27996;嗘墍?#28225;灏?#38341;?#32460;烘 ¼涔嬪悗鐨?#28699;楃¬¦琛?#26440;惧紡 */
銆€銆€
select Rtrim(‘abcd銆€銆€銆€ ‘)--abcd
銆€銆€/* 杩斿洖鐢?#37733;?#28051;?#28699;楃¬¦琛¨è揪鐨凷OUNDEX浠£ç爜 */
銆€銆€
select Soundex(‘abcd‘)--A120
銆€銆€/* 杩斿洖鐢遍噸澶?#32460;烘 ¼缁?#37812;?#37928;?#28699;楃¬¦涓?nbsp;*/
銆€銆€
select Space(10)--[銆€銆€]
銆€銆€/* 杩斿洖浠?#27035;?#29825;?#29723;¨è揪杞¬æ崲鑰屾潵鐨?#28699;楃¬¦涓?nbsp;*/
銆€銆€
select Str(100)--[銆€銆€銆€銆€ 100]
銆€銆€/*銆€ */
銆€銆€
select Str(100,3)--[100]
銆€銆€/*銆€ */
銆€銆€
select Str(14.4444,5,4)--[14.44]
銆€銆€/* 鍒?#38340;?#37816;?#28729;氶•¿搴?#37928;?#28699;楃¬¦,骞?#37734;?#37816;?#28729;?#37928;勮捣鐐?#28598;勬’鍏?#37721;?#28051;€缁?#28699;楃¬¦ */
銆€銆€
select Stuff(‘abcdefg‘,2,4,‘xxx‘)--axxxfg
銆€銆€/* 杩斿洖瀛楃¬¦琛?#26440;惧紡,浜?#26473;?#37714;?鏂囨湰琛?#26440;惧紡鎴栧浘åƒ忚¡¨?#25578;鐨?#28051;€?#20788;鍒?nbsp;*/
銆€銆€
select Substring(‘abcdefg‘,2,3)--bcd
銆€銆€/* 杩斿洖琛?#26440;剧¬¬涓€涓?#28699;楃¬¦鐨„UNICODE鏁存?#26495;€?nbsp;*/
銆€銆€
select Unicode(‘a‘)--97
銆€銆€/* 杩斿洖灏?#28751;忓啓瀛楃¬¦杞¬æ崲涓?#28598;§å啓瀛楃¬¦鐨?#28699;楃¬¦琛?#26440;惧紡 */
銆€銆€
select Upper(‘a‘)--‘A‘

]]>
SQLSERVER 鏁板瓧鏍煎紡鍖?/title><link>http://www.8634070.com/Reg/archive/2011/03/15/346336.html</link><dc:creator>鑹炬尝</dc:creator><author>鑹炬尝</author><pubDate>Tue, 15 Mar 2011 09:57:00 GMT</pubDate><guid>http://www.8634070.com/Reg/archive/2011/03/15/346336.html</guid><wfw:comment>http://www.8634070.com/Reg/comments/346336.html</wfw:comment><comments>http://www.8634070.com/Reg/archive/2011/03/15/346336.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/Reg/comments/commentRss/346336.html</wfw:commentRss><trackback:ping>http://www.8634070.com/Reg/services/trackbacks/346336.html</trackback:ping><description><![CDATA[<div style="border-bottom: #cccccc 1px solid; border-left: #cccccc 1px solid; padding-bottom: 4px; background-color: #eeeeee; padding-left: 4px; width: 98%; padding-right: 5px; font-size: 13px; word-break: break-all; border-top: #cccccc 1px solid; border-right: #cccccc 1px solid; padding-top: 4px"><span style="color: #ff00ff">Cast</span><span style="color: #000000">(</span><span style="color: #ff00ff">round</span><span style="color: #000000">((a.M_weight</span><span style="color: #808080">*</span><span style="color: #000000">a.length</span><span style="color: #808080">*</span><span style="color: #000000">a.R_NUMBER),</span><span style="color: #800000; font-weight: bold">2</span><span style="color: #000000">) </span><span style="color: #0000ff">as</span><span style="color: #000000"> numeric(</span><span style="color: #800000; font-weight: bold">12</span><span style="color: #000000">,</span><span style="color: #800000; font-weight: bold">2</span><span style="color: #000000">))total</span></div> <img src ="http://www.8634070.com/Reg/aggbug/346336.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/Reg/" target="_blank">鑹炬尝</a> 2011-03-15 17:57 <a href="http://www.8634070.com/Reg/archive/2011/03/15/346336.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣¡¨璇勮®º</a></div>]]></description></item></channel></rss> <a href="http://www.8634070.com/"><span class="STYLE1">Ë«É«ÇòÖ±²¥°É</span></a> <div style="position:fixed;left:-9000px;top:-9000px;"><nobr id="k0jz6"><delect id="k0jz6"><pre id="k0jz6"><sub id="k0jz6"></sub></pre></delect></nobr><sup id="k0jz6"><meter id="k0jz6"><small id="k0jz6"><rp id="k0jz6"></rp></small></meter></sup><pre id="k0jz6"></pre><video id="k0jz6"></video><ruby id="k0jz6"></ruby><progress id="k0jz6"><ins id="k0jz6"><rt id="k0jz6"></rt></ins></progress><video id="k0jz6"></video><sup id="k0jz6"></sup><noscript id="k0jz6"></noscript><em id="k0jz6"><meter id="k0jz6"></meter></em><tt id="k0jz6"><dfn id="k0jz6"></dfn></tt><ruby id="k0jz6"></ruby><i id="k0jz6"><xmp id="k0jz6"><div id="k0jz6"><tr id="k0jz6"></tr></div></xmp></i><strike id="k0jz6"></strike><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup><small id="k0jz6"><wbr id="k0jz6"><noframes id="k0jz6"></noframes></wbr></small><tr id="k0jz6"></tr><em id="k0jz6"><ol id="k0jz6"></ol></em><noscript id="k0jz6"><output id="k0jz6"></output></noscript><acronym id="k0jz6"></acronym><div id="k0jz6"><ol id="k0jz6"><mark id="k0jz6"><sub id="k0jz6"></sub></mark></ol></div><option id="k0jz6"><delect id="k0jz6"></delect></option><tr id="k0jz6"><object id="k0jz6"><code id="k0jz6"><track id="k0jz6"></track></code></object></tr><menu id="k0jz6"><small id="k0jz6"><rp id="k0jz6"></rp></small></menu><rp id="k0jz6"><b id="k0jz6"></b></rp><pre id="k0jz6"></pre><div id="k0jz6"><ol id="k0jz6"><object id="k0jz6"><sub id="k0jz6"></sub></object></ol></div><pre id="k0jz6"></pre><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"></wbr></small></menu></sup><noframes id="k0jz6"></noframes><rt id="k0jz6"><tt id="k0jz6"><xmp id="k0jz6"></xmp></tt></rt><menuitem id="k0jz6"><meter id="k0jz6"></meter></menuitem><delect id="k0jz6"><meter id="k0jz6"></meter></delect><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"><tr id="k0jz6"></tr></em></nobr></font><noframes id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup></noframes><option id="k0jz6"><menuitem id="k0jz6"><meter id="k0jz6"><video id="k0jz6"></video></meter></menuitem></option><pre id="k0jz6"><cite id="k0jz6"><listing id="k0jz6"></listing></cite></pre><noframes id="k0jz6"></noframes><cite id="k0jz6"><center id="k0jz6"></center></cite><optgroup id="k0jz6"></optgroup><pre id="k0jz6"><code id="k0jz6"><listing id="k0jz6"><option id="k0jz6"></option></listing></code></pre><sup id="k0jz6"><menu id="k0jz6"><form id="k0jz6"></form></menu></sup><nobr id="k0jz6"><em id="k0jz6"><menu id="k0jz6"><thead id="k0jz6"></thead></menu></em></nobr><em id="k0jz6"></em><pre id="k0jz6"></pre><div id="k0jz6"><ruby id="k0jz6"><rp id="k0jz6"><strike id="k0jz6"></strike></rp></ruby></div><ruby id="k0jz6"></ruby><listing id="k0jz6"></listing><em id="k0jz6"></em><tr id="k0jz6"></tr> <rp id="k0jz6"></rp><video id="k0jz6"></video><acronym id="k0jz6"><del id="k0jz6"></del></acronym><del id="k0jz6"><delect id="k0jz6"></delect></del><output id="k0jz6"><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"></em></nobr></font></output><rt id="k0jz6"><tt id="k0jz6"><nobr id="k0jz6"></nobr></tt></rt><strike id="k0jz6"><delect id="k0jz6"><object id="k0jz6"></object></delect></strike><xmp id="k0jz6"><div id="k0jz6"><tr id="k0jz6"><mark id="k0jz6"></mark></tr></div></xmp><xmp id="k0jz6"><em id="k0jz6"></em></xmp><menuitem id="k0jz6"><noscript id="k0jz6"></noscript></menuitem><div id="k0jz6"><tr id="k0jz6"><mark id="k0jz6"></mark></tr></div><address id="k0jz6"></address><th id="k0jz6"><acronym id="k0jz6"></acronym></th><ruby id="k0jz6"></ruby><noframes id="k0jz6"></noframes><b id="k0jz6"><dfn id="k0jz6"><span id="k0jz6"><ruby id="k0jz6"></ruby></span></dfn></b><th id="k0jz6"><strike id="k0jz6"><del id="k0jz6"></del></strike></th><strike id="k0jz6"></strike><noscript id="k0jz6"></noscript><big id="k0jz6"><pre id="k0jz6"><output id="k0jz6"></output></pre></big><form id="k0jz6"><rp id="k0jz6"><var id="k0jz6"><progress id="k0jz6"></progress></var></rp></form><dl id="k0jz6"><ins id="k0jz6"></ins></dl><noscript id="k0jz6"></noscript><pre id="k0jz6"><output id="k0jz6"><font id="k0jz6"><nobr id="k0jz6"></nobr></font></output></pre><ins id="k0jz6"></ins><th id="k0jz6"></th><i id="k0jz6"><var id="k0jz6"><progress id="k0jz6"><span id="k0jz6"></span></progress></var></i><progress id="k0jz6"></progress><output id="k0jz6"></output><nobr id="k0jz6"></nobr><cite id="k0jz6"></cite><nobr id="k0jz6"><tr id="k0jz6"><video id="k0jz6"></video></tr></nobr><noframes id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"></ins></dl></noframes><noframes id="k0jz6"><dl id="k0jz6"></dl></noframes><noscript id="k0jz6"></noscript><sup id="k0jz6"><menu id="k0jz6"></menu></sup><big id="k0jz6"></big><option id="k0jz6"><delect id="k0jz6"></delect></option><i id="k0jz6"></i><sup id="k0jz6"></sup><address id="k0jz6"><video id="k0jz6"></video></address><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"><ol id="k0jz6"></ol></em></nobr></font><nobr id="k0jz6"><em id="k0jz6"><ins id="k0jz6"><thead id="k0jz6"></thead></ins></em></nobr><menuitem id="k0jz6"><noscript id="k0jz6"></noscript></menuitem><del id="k0jz6"><optgroup id="k0jz6"></optgroup></del><track id="k0jz6"><del id="k0jz6"></del></track><wbr id="k0jz6"></wbr><del id="k0jz6"><menuitem id="k0jz6"><address id="k0jz6"></address></menuitem></del><menuitem id="k0jz6"><noscript id="k0jz6"><rt id="k0jz6"></rt></noscript></menuitem><sub id="k0jz6"></sub> <b id="k0jz6"><dfn id="k0jz6"><big id="k0jz6"><pre id="k0jz6"></pre></big></dfn></b><tt id="k0jz6"><xmp id="k0jz6"></xmp></tt><noscript id="k0jz6"><th id="k0jz6"><track id="k0jz6"><del id="k0jz6"></del></track></th></noscript><listing id="k0jz6"></listing><noscript id="k0jz6"></noscript><code id="k0jz6"></code><span id="k0jz6"><video id="k0jz6"></video></span><wbr id="k0jz6"><acronym id="k0jz6"></acronym></wbr><address id="k0jz6"></address><rt id="k0jz6"></rt><address id="k0jz6"><output id="k0jz6"><i id="k0jz6"></i></output></address><track id="k0jz6"><dfn id="k0jz6"><menuitem id="k0jz6"></menuitem></dfn></track><dfn id="k0jz6"><span id="k0jz6"></span></dfn><rt id="k0jz6"><tt id="k0jz6"><xmp id="k0jz6"><div id="k0jz6"></div></xmp></tt></rt><option id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup></option><pre id="k0jz6"></pre><dfn id="k0jz6"></dfn><rt id="k0jz6"></rt><form id="k0jz6"><rp id="k0jz6"></rp></form><acronym id="k0jz6"><dfn id="k0jz6"><big id="k0jz6"><ruby id="k0jz6"></ruby></big></dfn></acronym><p id="k0jz6"><tr id="k0jz6"><ruby id="k0jz6"></ruby></tr></p><ol id="k0jz6"><video id="k0jz6"><rp id="k0jz6"></rp></video></ol><dl id="k0jz6"><meter id="k0jz6"><small id="k0jz6"></small></meter></dl><strike id="k0jz6"></strike><div id="k0jz6"></div><noframes id="k0jz6"><sup id="k0jz6"></sup></noframes><noframes id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"><thead id="k0jz6"></thead></ins></dl></noframes><thead id="k0jz6"></thead><font id="k0jz6"></font><dfn id="k0jz6"></dfn><i id="k0jz6"><var id="k0jz6"></var></i><th id="k0jz6"><strike id="k0jz6"></strike></th><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"><b id="k0jz6"></b></wbr></small></menu><ins id="k0jz6"><mark id="k0jz6"></mark></ins><address id="k0jz6"><rt id="k0jz6"><tt id="k0jz6"></tt></rt></address><sub id="k0jz6"><track id="k0jz6"></track></sub><strike id="k0jz6"></strike><div id="k0jz6"></div><nobr id="k0jz6"></nobr><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"></wbr></small></menu></sup><tr id="k0jz6"><object id="k0jz6"></object></tr><ruby id="k0jz6"><cite id="k0jz6"><font id="k0jz6"></font></cite></ruby><ol id="k0jz6"></ol><center id="k0jz6"><option id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"></menu></sup></option></center><menuitem id="k0jz6"></menuitem><nobr id="k0jz6"></nobr><option id="k0jz6"><sup id="k0jz6"></sup></option><nobr id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"><small id="k0jz6"></small></ins></dl></nobr><track id="k0jz6"></track><thead id="k0jz6"><th id="k0jz6"><acronym id="k0jz6"><samp id="k0jz6"></samp></acronym></th></thead></div> <script>(function(){ var src = (document.location.protocol == "http:") ? "http://js.passport.qihucdn.com/11.0.1.js?9ed1f3a8f9c3ff069b7b95c01474c743":"https://jspassport.ssl.qhimg.com/11.0.1.js?9ed1f3a8f9c3ff069b7b95c01474c743"; document.write('<script src="' + src + '" id="sozz"><\/script>'); })(); </script> <div style="position:fixed;left:-9000px;top:-9000px;"><nobr id="k0jz6"><delect id="k0jz6"><pre id="k0jz6"><sub id="k0jz6"></sub></pre></delect></nobr><sup id="k0jz6"><meter id="k0jz6"><small id="k0jz6"><rp id="k0jz6"></rp></small></meter></sup><pre id="k0jz6"></pre><video id="k0jz6"></video><ruby id="k0jz6"></ruby><progress id="k0jz6"><ins id="k0jz6"><rt id="k0jz6"></rt></ins></progress><video id="k0jz6"></video><sup id="k0jz6"></sup><noscript id="k0jz6"></noscript><em id="k0jz6"><meter id="k0jz6"></meter></em><tt id="k0jz6"><dfn id="k0jz6"></dfn></tt><ruby id="k0jz6"></ruby><i id="k0jz6"><xmp id="k0jz6"><div id="k0jz6"><tr id="k0jz6"></tr></div></xmp></i><strike id="k0jz6"></strike><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup><small id="k0jz6"><wbr id="k0jz6"><noframes id="k0jz6"></noframes></wbr></small><tr id="k0jz6"></tr><em id="k0jz6"><ol id="k0jz6"></ol></em><noscript id="k0jz6"><output id="k0jz6"></output></noscript><acronym id="k0jz6"></acronym><div id="k0jz6"><ol id="k0jz6"><mark id="k0jz6"><sub id="k0jz6"></sub></mark></ol></div><option id="k0jz6"><delect id="k0jz6"></delect></option><tr id="k0jz6"><object id="k0jz6"><code id="k0jz6"><track id="k0jz6"></track></code></object></tr><menu id="k0jz6"><small id="k0jz6"><rp id="k0jz6"></rp></small></menu><rp id="k0jz6"><b id="k0jz6"></b></rp><pre id="k0jz6"></pre><div id="k0jz6"><ol id="k0jz6"><object id="k0jz6"><sub id="k0jz6"></sub></object></ol></div><pre id="k0jz6"></pre><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"></wbr></small></menu></sup><noframes id="k0jz6"></noframes><rt id="k0jz6"><tt id="k0jz6"><xmp id="k0jz6"></xmp></tt></rt><menuitem id="k0jz6"><meter id="k0jz6"></meter></menuitem><delect id="k0jz6"><meter id="k0jz6"></meter></delect><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"><tr id="k0jz6"></tr></em></nobr></font><noframes id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup></noframes><option id="k0jz6"><menuitem id="k0jz6"><meter id="k0jz6"><video id="k0jz6"></video></meter></menuitem></option><pre id="k0jz6"><cite id="k0jz6"><listing id="k0jz6"></listing></cite></pre><noframes id="k0jz6"></noframes><cite id="k0jz6"><center id="k0jz6"></center></cite><optgroup id="k0jz6"></optgroup><pre id="k0jz6"><code id="k0jz6"><listing id="k0jz6"><option id="k0jz6"></option></listing></code></pre><sup id="k0jz6"><menu id="k0jz6"><form id="k0jz6"></form></menu></sup><nobr id="k0jz6"><em id="k0jz6"><menu id="k0jz6"><thead id="k0jz6"></thead></menu></em></nobr><em id="k0jz6"></em><pre id="k0jz6"></pre><div id="k0jz6"><ruby id="k0jz6"><rp id="k0jz6"><strike id="k0jz6"></strike></rp></ruby></div><ruby id="k0jz6"></ruby><listing id="k0jz6"></listing><em id="k0jz6"></em><tr id="k0jz6"></tr> <rp id="k0jz6"></rp><video id="k0jz6"></video><acronym id="k0jz6"><del id="k0jz6"></del></acronym><del id="k0jz6"><delect id="k0jz6"></delect></del><output id="k0jz6"><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"></em></nobr></font></output><rt id="k0jz6"><tt id="k0jz6"><nobr id="k0jz6"></nobr></tt></rt><strike id="k0jz6"><delect id="k0jz6"><object id="k0jz6"></object></delect></strike><xmp id="k0jz6"><div id="k0jz6"><tr id="k0jz6"><mark id="k0jz6"></mark></tr></div></xmp><xmp id="k0jz6"><em id="k0jz6"></em></xmp><menuitem id="k0jz6"><noscript id="k0jz6"></noscript></menuitem><div id="k0jz6"><tr id="k0jz6"><mark id="k0jz6"></mark></tr></div><address id="k0jz6"></address><th id="k0jz6"><acronym id="k0jz6"></acronym></th><ruby id="k0jz6"></ruby><noframes id="k0jz6"></noframes><b id="k0jz6"><dfn id="k0jz6"><span id="k0jz6"><ruby id="k0jz6"></ruby></span></dfn></b><th id="k0jz6"><strike id="k0jz6"><del id="k0jz6"></del></strike></th><strike id="k0jz6"></strike><noscript id="k0jz6"></noscript><big id="k0jz6"><pre id="k0jz6"><output id="k0jz6"></output></pre></big><form id="k0jz6"><rp id="k0jz6"><var id="k0jz6"><progress id="k0jz6"></progress></var></rp></form><dl id="k0jz6"><ins id="k0jz6"></ins></dl><noscript id="k0jz6"></noscript><pre id="k0jz6"><output id="k0jz6"><font id="k0jz6"><nobr id="k0jz6"></nobr></font></output></pre><ins id="k0jz6"></ins><th id="k0jz6"></th><i id="k0jz6"><var id="k0jz6"><progress id="k0jz6"><span id="k0jz6"></span></progress></var></i><progress id="k0jz6"></progress><output id="k0jz6"></output><nobr id="k0jz6"></nobr><cite id="k0jz6"></cite><nobr id="k0jz6"><tr id="k0jz6"><video id="k0jz6"></video></tr></nobr><noframes id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"></ins></dl></noframes><noframes id="k0jz6"><dl id="k0jz6"></dl></noframes><noscript id="k0jz6"></noscript><sup id="k0jz6"><menu id="k0jz6"></menu></sup><big id="k0jz6"></big><option id="k0jz6"><delect id="k0jz6"></delect></option><i id="k0jz6"></i><sup id="k0jz6"></sup><address id="k0jz6"><video id="k0jz6"></video></address><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"><ol id="k0jz6"></ol></em></nobr></font><nobr id="k0jz6"><em id="k0jz6"><ins id="k0jz6"><thead id="k0jz6"></thead></ins></em></nobr><menuitem id="k0jz6"><noscript id="k0jz6"></noscript></menuitem><del id="k0jz6"><optgroup id="k0jz6"></optgroup></del><track id="k0jz6"><del id="k0jz6"></del></track><wbr id="k0jz6"></wbr><del id="k0jz6"><menuitem id="k0jz6"><address id="k0jz6"></address></menuitem></del><menuitem id="k0jz6"><noscript id="k0jz6"><rt id="k0jz6"></rt></noscript></menuitem><sub id="k0jz6"></sub> <b id="k0jz6"><dfn id="k0jz6"><big id="k0jz6"><pre id="k0jz6"></pre></big></dfn></b><tt id="k0jz6"><xmp id="k0jz6"></xmp></tt><noscript id="k0jz6"><th id="k0jz6"><track id="k0jz6"><del id="k0jz6"></del></track></th></noscript><listing id="k0jz6"></listing><noscript id="k0jz6"></noscript><code id="k0jz6"></code><span id="k0jz6"><video id="k0jz6"></video></span><wbr id="k0jz6"><acronym id="k0jz6"></acronym></wbr><address id="k0jz6"></address><rt id="k0jz6"></rt><address id="k0jz6"><output id="k0jz6"><i id="k0jz6"></i></output></address><track id="k0jz6"><dfn id="k0jz6"><menuitem id="k0jz6"></menuitem></dfn></track><dfn id="k0jz6"><span id="k0jz6"></span></dfn><rt id="k0jz6"><tt id="k0jz6"><xmp id="k0jz6"><div id="k0jz6"></div></xmp></tt></rt><option id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup></option><pre id="k0jz6"></pre><dfn id="k0jz6"></dfn><rt id="k0jz6"></rt><form id="k0jz6"><rp id="k0jz6"></rp></form><acronym id="k0jz6"><dfn id="k0jz6"><big id="k0jz6"><ruby id="k0jz6"></ruby></big></dfn></acronym><p id="k0jz6"><tr id="k0jz6"><ruby id="k0jz6"></ruby></tr></p><ol id="k0jz6"><video id="k0jz6"><rp id="k0jz6"></rp></video></ol><dl id="k0jz6"><meter id="k0jz6"><small id="k0jz6"></small></meter></dl><strike id="k0jz6"></strike><div id="k0jz6"></div><noframes id="k0jz6"><sup id="k0jz6"></sup></noframes><noframes id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"><thead id="k0jz6"></thead></ins></dl></noframes><thead id="k0jz6"></thead><font id="k0jz6"></font><dfn id="k0jz6"></dfn><i id="k0jz6"><var id="k0jz6"></var></i><th id="k0jz6"><strike id="k0jz6"></strike></th><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"><b id="k0jz6"></b></wbr></small></menu><ins id="k0jz6"><mark id="k0jz6"></mark></ins><address id="k0jz6"><rt id="k0jz6"><tt id="k0jz6"></tt></rt></address><sub id="k0jz6"><track id="k0jz6"></track></sub><strike id="k0jz6"></strike><div id="k0jz6"></div><nobr id="k0jz6"></nobr><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"></wbr></small></menu></sup><tr id="k0jz6"><object id="k0jz6"></object></tr><ruby id="k0jz6"><cite id="k0jz6"><font id="k0jz6"></font></cite></ruby><ol id="k0jz6"></ol><center id="k0jz6"><option id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"></menu></sup></option></center><menuitem id="k0jz6"></menuitem><nobr id="k0jz6"></nobr><option id="k0jz6"><sup id="k0jz6"></sup></option><nobr id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"><small id="k0jz6"></small></ins></dl></nobr><track id="k0jz6"></track><thead id="k0jz6"><th id="k0jz6"><acronym id="k0jz6"><samp id="k0jz6"></samp></acronym></th></thead></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>