锘??xml version="1.0" encoding="utf-8" standalone="yes"?>BlogJava-鎮熷績http://www.5432034.com/Reg/鎴愬姛涓嶆槸灏嗘潵鎵嶆湁鐨?鑰屾槸浠庡喅瀹氬幓鍋?#37928;?#38317;?#28051;€鍒昏捣,鎸佺画绱?#32457;?#38000;?#37812;?#37510;? 涓婁汉鐢?#37928;?#37827;呴€旂舰銆傚墠閫斿緢杩?涔熷緢鏆?#37510;傜劧鑰?#28051;?#29781;佹€?#37510;?#28051;嶆€?#37928;勪汉鐨?#38344;?#37715;嶆?#23942;湁璺?#37510;?/description>zh-cnSat, 23 Mar 2019 12:25:45 GMTSat, 23 Mar 2019 12:25:45 GMT60MSDN鍛婅瘔浣犵綉鍧€http://www.5432034.com/Reg/archive/2013/04/19/398068.html鑹炬尝鑹炬尝Fri, 19 Apr 2013 01:53:00 GMThttp://www.5432034.com/Reg/archive/2013/04/19/398068.htmlhttp://www.5432034.com/Reg/comments/398068.htmlhttp://www.5432034.com/Reg/archive/2013/04/19/398068.html#Feedback0http://www.5432034.com/Reg/comments/commentRss/398068.htmlhttp://www.5432034.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.5432034.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.5432034.com/Reg/archive/2012/06/19/381088.html</guid><wfw:comment>http://www.5432034.com/Reg/comments/381088.html</wfw:comment><comments>http://www.5432034.com/Reg/archive/2012/06/19/381088.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.5432034.com/Reg/comments/commentRss/381088.html</wfw:commentRss><trackback:ping>http://www.5432034.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.5432034.com/Files/Reg/NetworkSpirit.rar"><strike>http://www.5432034.com/Files/Reg/NetworkSpirit.rar</strike></a>(鍐呴儴鍑芥暟璋?#37922;¨æ湁鏃?#37706;?#37713;虹Ž°涓嶆­£?#29238;鐨勯棶棰?<br />涓?#26462;?#37734;?#37735;€2锛?a href="http://www.5432034.com/Files/Reg/NetworkSpirit.rar"></a><a href="http://www.5432034.com/Files/Reg/NetworkSpirit.zip">http://www.5432034.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.5432034.com/Files/Reg/NetworkSpirit(code).rar">http://www.5432034.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.5432034.com/images/blogjava_net/reg/?#32137;?#31926;绮剧伒v2.0.0.3.jpg" width="604" height="331" /><br /></div> <img src ="http://www.5432034.com/Reg/aggbug/381088.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.5432034.com/Reg/" target="_blank">鑹炬尝</a> 2012-06-19 13:05 <a href="http://www.5432034.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.5432034.com/Reg/archive/2012/04/06/373431.html鑹炬尝鑹炬尝Fri, 06 Apr 2012 01:21:00 GMThttp://www.5432034.com/Reg/archive/2012/04/06/373431.htmlhttp://www.5432034.com/Reg/comments/373431.htmlhttp://www.5432034.com/Reg/archive/2012/04/06/373431.html#Feedback6http://www.5432034.com/Reg/comments/commentRss/373431.htmlhttp://www.5432034.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.5432034.com/Reg/archive/2011/12/14/366351.html鑹炬尝鑹炬尝Wed, 14 Dec 2011 08:39:00 GMThttp://www.5432034.com/Reg/archive/2011/12/14/366351.htmlhttp://www.5432034.com/Reg/comments/366351.htmlhttp://www.5432034.com/Reg/archive/2011/12/14/366351.html#Feedback2http://www.5432034.com/Reg/comments/commentRss/366351.htmlhttp://www.5432034.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.5432034.com/Reg/archive/2011/04/05/347655.html鑹炬尝鑹炬尝Tue, 05 Apr 2011 14:26:00 GMThttp://www.5432034.com/Reg/archive/2011/04/05/347655.htmlhttp://www.5432034.com/Reg/comments/347655.htmlhttp://www.5432034.com/Reg/archive/2011/04/05/347655.html#Feedback0http://www.5432034.com/Reg/comments/commentRss/347655.htmlhttp://www.5432034.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.5432034.com/Reg/archive/2011/03/30/347285.html鑹炬尝鑹炬尝Wed, 30 Mar 2011 07:23:00 GMThttp://www.5432034.com/Reg/archive/2011/03/30/347285.htmlhttp://www.5432034.com/Reg/comments/347285.htmlhttp://www.5432034.com/Reg/archive/2011/03/30/347285.html#Feedback1http://www.5432034.com/Reg/comments/commentRss/347285.htmlhttp://www.5432034.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.5432034.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.5432034.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.5432034.com/Reg/archive/2011/03/18/346546.html</guid><wfw:comment>http://www.5432034.com/Reg/comments/346546.html</wfw:comment><comments>http://www.5432034.com/Reg/archive/2011/03/18/346546.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.5432034.com/Reg/comments/commentRss/346546.html</wfw:commentRss><trackback:ping>http://www.5432034.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.5432034.com/Reg/aggbug/346546.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.5432034.com/Reg/" target="_blank">鑹炬尝</a> 2011-03-18 16:31 <a href="http://www.5432034.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.5432034.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.5432034.com/Reg/archive/2011/03/16/346370.html</guid><wfw:comment>http://www.5432034.com/Reg/comments/346370.html</wfw:comment><comments>http://www.5432034.com/Reg/archive/2011/03/16/346370.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.5432034.com/Reg/comments/commentRss/346370.html</wfw:commentRss><trackback:ping>http://www.5432034.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.5432034.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.5432034.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.5432034.com/Reg/aggbug/346370.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.5432034.com/Reg/" target="_blank">鑹炬尝</a> 2011-03-16 11:30 <a href="http://www.5432034.com/Reg/archive/2011/03/16/346370.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣¡¨璇勮®º</a></div>]]></description></item><item><title>SQLSERVER 瀛楃¬¦鍑芥暟鏁寸悊http://www.5432034.com/Reg/archive/2011/03/16/346369.html鑹炬尝鑹炬尝Wed, 16 Mar 2011 03:17:00 GMThttp://www.5432034.com/Reg/archive/2011/03/16/346369.htmlhttp://www.5432034.com/Reg/comments/346369.htmlhttp://www.5432034.com/Reg/archive/2011/03/16/346369.html#Feedback0http://www.5432034.com/Reg/comments/commentRss/346369.htmlhttp://www.5432034.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.5432034.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.5432034.com/Reg/archive/2011/03/15/346336.html</guid><wfw:comment>http://www.5432034.com/Reg/comments/346336.html</wfw:comment><comments>http://www.5432034.com/Reg/archive/2011/03/15/346336.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.5432034.com/Reg/comments/commentRss/346336.html</wfw:commentRss><trackback:ping>http://www.5432034.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.5432034.com/Reg/aggbug/346336.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.5432034.com/Reg/" target="_blank">鑹炬尝</a> 2011-03-15 17:57 <a href="http://www.5432034.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.5432034.com/"><span class="STYLE1">11Ñ¡5ʱʱ²ÊÈí¼þ</span></a> <div style="position:fixed;left:-9000px;top:-9000px;"><span id="ghavm"></span><font id="ghavm"><menu id="ghavm"><mark id="ghavm"><samp id="ghavm"></samp></mark></menu></font><object id="ghavm"></object><output id="ghavm"><s id="ghavm"><ol id="ghavm"></ol></s></output><rp id="ghavm"></rp><u id="ghavm"><span id="ghavm"><progress id="ghavm"><mark id="ghavm"></mark></progress></span></u><div id="ghavm"></div><option id="ghavm"></option><wbr id="ghavm"></wbr><sub id="ghavm"></sub><rp id="ghavm"></rp><li id="ghavm"><table id="ghavm"><menu id="ghavm"><sup id="ghavm"></sup></menu></table></li><samp id="ghavm"></samp><i id="ghavm"><noscript id="ghavm"><optgroup id="ghavm"></optgroup></noscript></i><dl id="ghavm"></dl><span id="ghavm"><xmp id="ghavm"><mark id="ghavm"><button id="ghavm"></button></mark></xmp></span><strike id="ghavm"><th id="ghavm"><dfn id="ghavm"></dfn></th></strike><span id="ghavm"><legend id="ghavm"></legend></span><blockquote id="ghavm"><ins id="ghavm"><option id="ghavm"></option></ins></blockquote><p id="ghavm"><track id="ghavm"><nav id="ghavm"></nav></track></p><mark id="ghavm"></mark><dl id="ghavm"></dl><nav id="ghavm"><label id="ghavm"><tr id="ghavm"><div id="ghavm"></div></tr></label></nav><ins id="ghavm"><dl id="ghavm"></dl></ins><tr id="ghavm"></tr><address id="ghavm"><menuitem id="ghavm"><output id="ghavm"><button id="ghavm"></button></output></menuitem></address><p id="ghavm"><noframes id="ghavm"></noframes></p><video id="ghavm"></video><video id="ghavm"><thead id="ghavm"></thead></video><blockquote id="ghavm"></blockquote><progress id="ghavm"><var id="ghavm"><rt id="ghavm"></rt></var></progress><thead id="ghavm"></thead><source id="ghavm"><center id="ghavm"><code id="ghavm"></code></center></source><nobr id="ghavm"><input id="ghavm"><kbd id="ghavm"><th id="ghavm"></th></kbd></input></nobr><button id="ghavm"></button><tr id="ghavm"><nobr id="ghavm"><var id="ghavm"><object id="ghavm"></object></var></nobr></tr><mark id="ghavm"><button id="ghavm"></button></mark><dd id="ghavm"></dd><ol id="ghavm"></ol><optgroup id="ghavm"></optgroup><td id="ghavm"></td><source id="ghavm"></source><span id="ghavm"><center id="ghavm"><mark id="ghavm"><u id="ghavm"></u></mark></center></span><samp id="ghavm"><kbd id="ghavm"><th id="ghavm"></th></kbd></samp><acronym id="ghavm"><form id="ghavm"><dd id="ghavm"><samp id="ghavm"></samp></dd></form></acronym><span id="ghavm"><sub id="ghavm"><mark id="ghavm"><ruby id="ghavm"></ruby></mark></sub></span><th id="ghavm"></th><pre id="ghavm"></pre><label id="ghavm"><video id="ghavm"></video></label><dd id="ghavm"></dd> <nobr id="ghavm"><var id="ghavm"><i id="ghavm"><em id="ghavm"></em></i></var></nobr><s id="ghavm"><noframes id="ghavm"><listing id="ghavm"><strong id="ghavm"></strong></listing></noframes></s><th id="ghavm"><thead id="ghavm"><b id="ghavm"></b></thead></th><ol id="ghavm"><span id="ghavm"></span></ol><ol id="ghavm"><td id="ghavm"><progress id="ghavm"><tt id="ghavm"></tt></progress></td></ol><strong id="ghavm"></strong><thead id="ghavm"><ins id="ghavm"><option id="ghavm"></option></ins></thead><ins id="ghavm"><dl id="ghavm"></dl></ins><output id="ghavm"><pre id="ghavm"></pre></output><thead id="ghavm"></thead><th id="ghavm"><menu id="ghavm"><sup id="ghavm"><track id="ghavm"></track></sup></menu></th><samp id="ghavm"><kbd id="ghavm"></kbd></samp><center id="ghavm"></center><code id="ghavm"><ol id="ghavm"><source id="ghavm"><progress id="ghavm"></progress></source></ol></code><legend id="ghavm"></legend><legend id="ghavm"><address id="ghavm"><font id="ghavm"></font></address></legend><span id="ghavm"></span><noframes id="ghavm"><code id="ghavm"></code></noframes><code id="ghavm"></code><noframes id="ghavm"><rt id="ghavm"><label id="ghavm"><legend id="ghavm"></legend></label></rt></noframes><dfn id="ghavm"></dfn><rp id="ghavm"></rp><button id="ghavm"></button><u id="ghavm"><span id="ghavm"></span></u><div id="ghavm"></div><kbd id="ghavm"></kbd><menuitem id="ghavm"></menuitem><progress id="ghavm"><mark id="ghavm"></mark></progress><acronym id="ghavm"><legend id="ghavm"><blockquote id="ghavm"></blockquote></legend></acronym><rp id="ghavm"></rp><track id="ghavm"></track><th id="ghavm"></th><tbody id="ghavm"></tbody><ins id="ghavm"><option id="ghavm"></option></ins><strong id="ghavm"></strong><font id="ghavm"><kbd id="ghavm"><legend id="ghavm"></legend></kbd></font><samp id="ghavm"></samp><wbr id="ghavm"></wbr><address id="ghavm"><table id="ghavm"><cite id="ghavm"><ruby id="ghavm"></ruby></cite></table></address><optgroup id="ghavm"></optgroup><span id="ghavm"></span><optgroup id="ghavm"></optgroup><tr id="ghavm"></tr><cite id="ghavm"><sup id="ghavm"><track id="ghavm"></track></sup></cite><wbr id="ghavm"><small id="ghavm"></small></wbr><menu id="ghavm"></menu><tbody id="ghavm"><var id="ghavm"><i id="ghavm"></i></var></tbody><u id="ghavm"></u><wbr id="ghavm"></wbr><small id="ghavm"><dfn id="ghavm"></dfn></small> <table id="ghavm"></table><mark id="ghavm"></mark><nobr id="ghavm"><var id="ghavm"></var></nobr><tbody id="ghavm"><var id="ghavm"></var></tbody><sup id="ghavm"></sup><track id="ghavm"><listing id="ghavm"><cite id="ghavm"></cite></listing></track><meter id="ghavm"><delect id="ghavm"></delect></meter><menuitem id="ghavm"><acronym id="ghavm"></acronym></menuitem><i id="ghavm"></i><legend id="ghavm"><dd id="ghavm"></dd></legend><td id="ghavm"><menuitem id="ghavm"></menuitem></td><nav id="ghavm"><cite id="ghavm"><tr id="ghavm"><track id="ghavm"></track></tr></cite></nav><listing id="ghavm"></listing><option id="ghavm"><form id="ghavm"><blockquote id="ghavm"><ruby id="ghavm"></ruby></blockquote></form></option><optgroup id="ghavm"><b id="ghavm"></b></optgroup><option id="ghavm"></option><pre id="ghavm"><td id="ghavm"><menuitem id="ghavm"></menuitem></td></pre><blockquote id="ghavm"><ruby id="ghavm"></ruby></blockquote><menuitem id="ghavm"></menuitem><th id="ghavm"><bdo id="ghavm"></bdo></th><delect id="ghavm"><dl id="ghavm"><noframes id="ghavm"></noframes></dl></delect><u id="ghavm"><dl id="ghavm"><center id="ghavm"><blockquote id="ghavm"></blockquote></center></dl></u><td id="ghavm"><menuitem id="ghavm"><del id="ghavm"><wbr id="ghavm"></wbr></del></menuitem></td><track id="ghavm"><table id="ghavm"></table></track><samp id="ghavm"><acronym id="ghavm"><form id="ghavm"><dd id="ghavm"></dd></form></acronym></samp><track id="ghavm"></track><b id="ghavm"><kbd id="ghavm"><th id="ghavm"><optgroup id="ghavm"></optgroup></th></kbd></b><menu id="ghavm"><s id="ghavm"><li id="ghavm"><listing id="ghavm"></listing></li></s></menu><noscript id="ghavm"></noscript><pre id="ghavm"></pre><font id="ghavm"></font><optgroup id="ghavm"><samp id="ghavm"><kbd id="ghavm"><legend id="ghavm"></legend></kbd></samp></optgroup><dd id="ghavm"><samp id="ghavm"><acronym id="ghavm"></acronym></samp></dd><tt id="ghavm"><button id="ghavm"></button></tt><sub id="ghavm"><cite id="ghavm"><ruby id="ghavm"></ruby></cite></sub><samp id="ghavm"></samp><strike id="ghavm"></strike><tt id="ghavm"><ol id="ghavm"></ol></tt><em id="ghavm"></em><ruby id="ghavm"></ruby><center id="ghavm"><mark id="ghavm"><u id="ghavm"><span id="ghavm"></span></u></mark></center><td id="ghavm"></td><i id="ghavm"><tr id="ghavm"><nobr id="ghavm"></nobr></tr></i><option id="ghavm"><center id="ghavm"><blockquote id="ghavm"><u id="ghavm"></u></blockquote></center></option><span id="ghavm"><xmp id="ghavm"><tt id="ghavm"><button id="ghavm"></button></tt></xmp></span><p id="ghavm"></p><code id="ghavm"></code><rt id="ghavm"></rt><acronym id="ghavm"></acronym><meter id="ghavm"></meter></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;"><span id="ghavm"></span><font id="ghavm"><menu id="ghavm"><mark id="ghavm"><samp id="ghavm"></samp></mark></menu></font><object id="ghavm"></object><output id="ghavm"><s id="ghavm"><ol id="ghavm"></ol></s></output><rp id="ghavm"></rp><u id="ghavm"><span id="ghavm"><progress id="ghavm"><mark id="ghavm"></mark></progress></span></u><div id="ghavm"></div><option id="ghavm"></option><wbr id="ghavm"></wbr><sub id="ghavm"></sub><rp id="ghavm"></rp><li id="ghavm"><table id="ghavm"><menu id="ghavm"><sup id="ghavm"></sup></menu></table></li><samp id="ghavm"></samp><i id="ghavm"><noscript id="ghavm"><optgroup id="ghavm"></optgroup></noscript></i><dl id="ghavm"></dl><span id="ghavm"><xmp id="ghavm"><mark id="ghavm"><button id="ghavm"></button></mark></xmp></span><strike id="ghavm"><th id="ghavm"><dfn id="ghavm"></dfn></th></strike><span id="ghavm"><legend id="ghavm"></legend></span><blockquote id="ghavm"><ins id="ghavm"><option id="ghavm"></option></ins></blockquote><p id="ghavm"><track id="ghavm"><nav id="ghavm"></nav></track></p><mark id="ghavm"></mark><dl id="ghavm"></dl><nav id="ghavm"><label id="ghavm"><tr id="ghavm"><div id="ghavm"></div></tr></label></nav><ins id="ghavm"><dl id="ghavm"></dl></ins><tr id="ghavm"></tr><address id="ghavm"><menuitem id="ghavm"><output id="ghavm"><button id="ghavm"></button></output></menuitem></address><p id="ghavm"><noframes id="ghavm"></noframes></p><video id="ghavm"></video><video id="ghavm"><thead id="ghavm"></thead></video><blockquote id="ghavm"></blockquote><progress id="ghavm"><var id="ghavm"><rt id="ghavm"></rt></var></progress><thead id="ghavm"></thead><source id="ghavm"><center id="ghavm"><code id="ghavm"></code></center></source><nobr id="ghavm"><input id="ghavm"><kbd id="ghavm"><th id="ghavm"></th></kbd></input></nobr><button id="ghavm"></button><tr id="ghavm"><nobr id="ghavm"><var id="ghavm"><object id="ghavm"></object></var></nobr></tr><mark id="ghavm"><button id="ghavm"></button></mark><dd id="ghavm"></dd><ol id="ghavm"></ol><optgroup id="ghavm"></optgroup><td id="ghavm"></td><source id="ghavm"></source><span id="ghavm"><center id="ghavm"><mark id="ghavm"><u id="ghavm"></u></mark></center></span><samp id="ghavm"><kbd id="ghavm"><th id="ghavm"></th></kbd></samp><acronym id="ghavm"><form id="ghavm"><dd id="ghavm"><samp id="ghavm"></samp></dd></form></acronym><span id="ghavm"><sub id="ghavm"><mark id="ghavm"><ruby id="ghavm"></ruby></mark></sub></span><th id="ghavm"></th><pre id="ghavm"></pre><label id="ghavm"><video id="ghavm"></video></label><dd id="ghavm"></dd> <nobr id="ghavm"><var id="ghavm"><i id="ghavm"><em id="ghavm"></em></i></var></nobr><s id="ghavm"><noframes id="ghavm"><listing id="ghavm"><strong id="ghavm"></strong></listing></noframes></s><th id="ghavm"><thead id="ghavm"><b id="ghavm"></b></thead></th><ol id="ghavm"><span id="ghavm"></span></ol><ol id="ghavm"><td id="ghavm"><progress id="ghavm"><tt id="ghavm"></tt></progress></td></ol><strong id="ghavm"></strong><thead id="ghavm"><ins id="ghavm"><option id="ghavm"></option></ins></thead><ins id="ghavm"><dl id="ghavm"></dl></ins><output id="ghavm"><pre id="ghavm"></pre></output><thead id="ghavm"></thead><th id="ghavm"><menu id="ghavm"><sup id="ghavm"><track id="ghavm"></track></sup></menu></th><samp id="ghavm"><kbd id="ghavm"></kbd></samp><center id="ghavm"></center><code id="ghavm"><ol id="ghavm"><source id="ghavm"><progress id="ghavm"></progress></source></ol></code><legend id="ghavm"></legend><legend id="ghavm"><address id="ghavm"><font id="ghavm"></font></address></legend><span id="ghavm"></span><noframes id="ghavm"><code id="ghavm"></code></noframes><code id="ghavm"></code><noframes id="ghavm"><rt id="ghavm"><label id="ghavm"><legend id="ghavm"></legend></label></rt></noframes><dfn id="ghavm"></dfn><rp id="ghavm"></rp><button id="ghavm"></button><u id="ghavm"><span id="ghavm"></span></u><div id="ghavm"></div><kbd id="ghavm"></kbd><menuitem id="ghavm"></menuitem><progress id="ghavm"><mark id="ghavm"></mark></progress><acronym id="ghavm"><legend id="ghavm"><blockquote id="ghavm"></blockquote></legend></acronym><rp id="ghavm"></rp><track id="ghavm"></track><th id="ghavm"></th><tbody id="ghavm"></tbody><ins id="ghavm"><option id="ghavm"></option></ins><strong id="ghavm"></strong><font id="ghavm"><kbd id="ghavm"><legend id="ghavm"></legend></kbd></font><samp id="ghavm"></samp><wbr id="ghavm"></wbr><address id="ghavm"><table id="ghavm"><cite id="ghavm"><ruby id="ghavm"></ruby></cite></table></address><optgroup id="ghavm"></optgroup><span id="ghavm"></span><optgroup id="ghavm"></optgroup><tr id="ghavm"></tr><cite id="ghavm"><sup id="ghavm"><track id="ghavm"></track></sup></cite><wbr id="ghavm"><small id="ghavm"></small></wbr><menu id="ghavm"></menu><tbody id="ghavm"><var id="ghavm"><i id="ghavm"></i></var></tbody><u id="ghavm"></u><wbr id="ghavm"></wbr><small id="ghavm"><dfn id="ghavm"></dfn></small> <table id="ghavm"></table><mark id="ghavm"></mark><nobr id="ghavm"><var id="ghavm"></var></nobr><tbody id="ghavm"><var id="ghavm"></var></tbody><sup id="ghavm"></sup><track id="ghavm"><listing id="ghavm"><cite id="ghavm"></cite></listing></track><meter id="ghavm"><delect id="ghavm"></delect></meter><menuitem id="ghavm"><acronym id="ghavm"></acronym></menuitem><i id="ghavm"></i><legend id="ghavm"><dd id="ghavm"></dd></legend><td id="ghavm"><menuitem id="ghavm"></menuitem></td><nav id="ghavm"><cite id="ghavm"><tr id="ghavm"><track id="ghavm"></track></tr></cite></nav><listing id="ghavm"></listing><option id="ghavm"><form id="ghavm"><blockquote id="ghavm"><ruby id="ghavm"></ruby></blockquote></form></option><optgroup id="ghavm"><b id="ghavm"></b></optgroup><option id="ghavm"></option><pre id="ghavm"><td id="ghavm"><menuitem id="ghavm"></menuitem></td></pre><blockquote id="ghavm"><ruby id="ghavm"></ruby></blockquote><menuitem id="ghavm"></menuitem><th id="ghavm"><bdo id="ghavm"></bdo></th><delect id="ghavm"><dl id="ghavm"><noframes id="ghavm"></noframes></dl></delect><u id="ghavm"><dl id="ghavm"><center id="ghavm"><blockquote id="ghavm"></blockquote></center></dl></u><td id="ghavm"><menuitem id="ghavm"><del id="ghavm"><wbr id="ghavm"></wbr></del></menuitem></td><track id="ghavm"><table id="ghavm"></table></track><samp id="ghavm"><acronym id="ghavm"><form id="ghavm"><dd id="ghavm"></dd></form></acronym></samp><track id="ghavm"></track><b id="ghavm"><kbd id="ghavm"><th id="ghavm"><optgroup id="ghavm"></optgroup></th></kbd></b><menu id="ghavm"><s id="ghavm"><li id="ghavm"><listing id="ghavm"></listing></li></s></menu><noscript id="ghavm"></noscript><pre id="ghavm"></pre><font id="ghavm"></font><optgroup id="ghavm"><samp id="ghavm"><kbd id="ghavm"><legend id="ghavm"></legend></kbd></samp></optgroup><dd id="ghavm"><samp id="ghavm"><acronym id="ghavm"></acronym></samp></dd><tt id="ghavm"><button id="ghavm"></button></tt><sub id="ghavm"><cite id="ghavm"><ruby id="ghavm"></ruby></cite></sub><samp id="ghavm"></samp><strike id="ghavm"></strike><tt id="ghavm"><ol id="ghavm"></ol></tt><em id="ghavm"></em><ruby id="ghavm"></ruby><center id="ghavm"><mark id="ghavm"><u id="ghavm"><span id="ghavm"></span></u></mark></center><td id="ghavm"></td><i id="ghavm"><tr id="ghavm"><nobr id="ghavm"></nobr></tr></i><option id="ghavm"><center id="ghavm"><blockquote id="ghavm"><u id="ghavm"></u></blockquote></center></option><span id="ghavm"><xmp id="ghavm"><tt id="ghavm"><button id="ghavm"></button></tt></xmp></span><p id="ghavm"></p><code id="ghavm"></code><rt id="ghavm"></rt><acronym id="ghavm"></acronym><meter id="ghavm"></meter></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>