{"id":113,"date":"2012-03-25T10:12:07","date_gmt":"2012-03-25T10:12:07","guid":{"rendered":"http:\/\/www.nywzjs.com\/?p=113"},"modified":"2012-03-25T10:14:33","modified_gmt":"2012-03-25T10:14:33","slug":"%e7%a7%91%e8%ae%af8-0%e5%ae%9e%e7%8e%b0%e6%90%9c%e7%b4%a2%e5%85%b3%e9%94%ae%e5%ad%97%e6%90%9c%e7%b4%a2%e6%8f%90%e7%a4%ba%e5%8a%9f%e8%83%bd","status":"publish","type":"post","link":"http:\/\/www.nywzjs.com\/?p=113","title":{"rendered":"\u79d1\u8baf8.0\u5b9e\u73b0\u641c\u7d22\u5173\u952e\u5b57\u641c\u7d22\u63d0\u793a\u529f\u80fd"},"content":{"rendered":"<p>\u529f\u80fd\uff1a\u641c\u7d22\u5173\u952e\u8bcd\u50cf\u767e\u5ea6\u641c\u7d22\u63d0\u793a\u4e00\u6837\u663e\u793a\u4e00\u4e9b\u76f8\u5173\u7684\u5173\u952e\u8bcd\uff0c\u800c\u4e14\u63d0\u793a\u7684\u8bcd\u4ece\u6570\u636e\u5e93\u4e2d\u8c03\u7528\u70ed\u641c\u8bcd\u3002<\/p>\n<p>\u6548\u679c\u56fe\uff1a<a href=\"http:\/\/www.nywzjs.com\/wp-content\/uploads\/2012\/03\/20120325181018.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-116\" title=\"\u6548\u679c\u56fe\" src=\"http:\/\/www.nywzjs.com\/wp-content\/uploads\/2012\/03\/20120325181018-300x218.jpg\" alt=\"\u6548\u679c\u56fe\" width=\"300\" height=\"218\" srcset=\"http:\/\/www.nywzjs.com\/wp-content\/uploads\/2012\/03\/20120325181018-300x218.jpg 300w, http:\/\/www.nywzjs.com\/wp-content\/uploads\/2012\/03\/20120325181018.jpg 352w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><a href=\"http:\/\/www.nywzjs.com\/wp-content\/uploads\/2012\/03\/QQ\u622a\u56fe20120325181018.jpg\"><br \/>\n<\/a><\/p>\n<p>\u65b0\u5efaSQL\u6807\u7b7e\uff0cSQL\u8bed\u53e5\u4e3a\uff1a<\/p>\n<blockquote><p>select top 300 KeyText from KS_KeyWords where len(KeyText)&lt;10 ORDER BY hits DESC<\/p><\/blockquote>\n<p>\u5faa\u73af\u4f53\u4e3a\uff1a<\/p>\n<blockquote>\n<pre>&lt;script&gt;\r\nvar intIndex=0;arrList = new Array();\r\n[loop=300]arrList[intIndex++] = \"{$Field(KeyText,Text,0,...,1,)}\";\r\n[\/loop]\r\nfunction smanPromptList(arrList,objInputId){\r\nthis.style = \"background:#FFFFFF;border: 1px solid #CCCCCC;border-top:none;font-size:13px;cursor: default;line-height:22px;position:absolute;z-index:999999999;margin:0px;\"\r\nif (arrList.constructor!=Array){alert('smanPromptList\u521d\u59cb\u5316\u5931\u8d25:\u7b2c\u4e00\u4e2a\u53c2\u6570\u975e\u6570\u7ec4!');return ;}\r\nwindow.onload =function() {\r\narrList.sort(function(a,b){\r\nif(a.length&gt;b.length)return 1;\r\nelse if(a.length==b.length)return a.localeCompare(b);\r\nelse return -1;\r\n})\r\nvar objouter=document.getElementById(\"__smanDisp\") \/\/\u663e\u793a\u7684DIV\u5bf9\u8c61\r\nvar objInput = document.getElementById(objInputId); \/\/\u6587\u672c\u6846\u5bf9\u8c61\r\nvar selectedIndex=-1;\r\nvar intTmp; \/\/\u5faa\u73af\u7528\u7684:)\r\nif (objInput==null) {alert('smanPromptList\u521d\u59cb\u5316\u5931\u8d25:\u6ca1\u6709\u627e\u5230\"'+objInputId+'\"\u6587\u672c\u6846');return ;}\r\n\/\/\u6587\u672c\u6846\u5931\u53bb\u7126\u70b9\r\nobjInput.onblur=function(){\r\nobjouter.style.display='none';\r\n}\r\n\/\/\u6587\u672c\u6846\u6309\u952e\u62ac\u8d77\r\nobjInput.onkeyup=checkKeyCode;\r\n\/\/\u6587\u672c\u6846\u5f97\u5230\u7126\u70b9\r\nobjInput.onfocus=checkAndShow;\r\nfunction checkKeyCode(){\r\nvar ie = (document.all)? true:false\r\nif (ie){\r\nvar keyCode=event.keyCode\r\nif (keyCode==40||keyCode==38){ \/\/\u4e0b\u4e0a\r\nvar isUp=false\r\nif(keyCode==40) isUp=true ;\r\nchageSelection(isUp)\r\n}else if (keyCode==13){\/\/\u56de\u8f66\r\noutSelection(selectedIndex);\r\n}else{\r\ncheckAndShow()\r\n}\r\n}else{\r\ncheckAndShow()\r\n}\r\ndivPosition()\r\n}\r\nfunction checkAndShow(){\r\nvar strInput = objInput.value\r\nif (strInput!=\"\"){\r\ndivPosition();\r\nselectedIndex=-1;\r\nobjouter.innerHTML =\"\";\r\nfor (intTmp=0;intTmp&lt;arrList.length;intTmp++){\r\nfor(i=0;i&lt;arrList[intTmp].length;i++){\r\nif (arrList[intTmp].substr(i, strInput.length).toUpperCase()==strInput.toUpperCase()){\r\naddOption(arrList[intTmp],strInput);\r\n}\r\n}\r\n}\r\nobjouter.style.display='';\r\n}else{\r\nobjouter.style.display='none';\r\n}\r\nfunction addOption(value,keyw){\r\nvar v=value.replace(keyw,\"&lt;b&gt;&lt;font color=red&gt;\"+keyw+\"&lt;\/font&gt;&lt;\/b&gt;\");\r\nobjouter.innerHTML +=\"&lt;div onmouseover=\\\"this.className='sman_selectedStyle'\\\" onmouseout=\\\"this.className=''\\\" onmousedown=\\\"document.getElementById('\"+objInputId+\"').value='\" + value + \"'\\\"&gt;\" + v + \"&lt;\/div&gt;\"\r\n}\r\n}\r\nfunction chageSelection(isUp){\r\nif (objouter.style.display=='none'){\r\nobjouter.style.display='';\r\n}else{\r\nif (isUp)\r\nselectedIndex++\r\nelse\r\nselectedIndex--\r\n}\r\nvar maxIndex = objouter.children.length-1;\r\nif (selectedIndex&lt;0){selectedIndex=0}\r\nif (selectedIndex&gt;maxIndex) {selectedIndex=maxIndex}\r\nfor (intTmp=0;intTmp&lt;=maxIndex;intTmp++){\r\nif (intTmp==selectedIndex){\r\nobjouter.children[intTmp].className=\"sman_selectedStyle\";\r\n}else{\r\nobjouter.children[intTmp].className=\"\";\r\n} } }\r\nfunction outSelection(Index){\r\nobjInput.value = objouter.children[Index].innerText;\r\nobjouter.style.display='none';\r\n}\r\nfunction divPosition(){\r\nobjouter.style.top =getAbsoluteHeight(objInput)+getAbsoluteTop(objInput);\r\nobjouter.style.left =getAbsoluteLeft(objInput);\r\nobjouter.style.width=getAbsoluteWidth(objInput)\r\n}\r\n}\r\ndocument.write(\"&lt;div id='__smanDisp' style='position:absolute;display:none;z-index:999999;background-color:#FFFFFF;\" + this.style + \"' onbulr&gt; &lt;\/div&gt;\");\r\ndocument.write(\"&lt;style&gt;.sman_selectedStyle{background-Color:#dddddd;color:#333333;}&lt;\/style&gt;\");\r\nfunction getAbsoluteHeight(ob){\r\nreturn ob.offsetHeight\r\n}\r\nfunction getAbsoluteWidth(ob){\r\nreturn ob.offsetWidth\r\n}\r\nfunction getAbsoluteLeft(ob){\r\nvar s_el=0;el=ob;while(el){s_el=s_el+el.offsetLeft;el=el.offsetParent;}; return s_el\r\n}\r\nfunction getAbsoluteTop(ob){\r\nvar s_el=0;el=ob;while(el){s_el=s_el+el.offsetTop ;el=el.offsetParent;}; return s_el\r\n}\r\n}\r\nsmanPromptList(arrList,\"inputer\")\r\n&lt;\/script&gt;<\/pre>\n<\/blockquote>\n<p>\u6700\u540e\uff0c\u6253\u5f00KS_Cls\\Kesion.Label.SearchCls.asp\u3002\u5728\u7b2c50\u884c\u7684\u4ee3\u7801\u4e2d\u52a0\u5165<\/p>\n<blockquote><p>id=\"\"inputer\"\"<\/p><\/blockquote>\n<p>\u8fd9\u6837\u5c31OK\u4e86\uff0c\u524d\u53f0\u6700\u597d\u662f\u751f\u6210\u9759\u6001\u9875\u9762\uff0c\u5426\u5219\u6bcf\u6b21\u90fd\u4ece\u6570\u636e\u5e93\u8c03\u7528300\u4e2a\u5173\u952e\u8bcd\u4f1a\u5f71\u54cd\u5230\u7f51\u9875\u7684\u901f\u5ea6\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u529f\u80fd\uff1a\u641c\u7d22\u5173\u952e\u8bcd\u50cf\u767e\u5ea6\u641c\u7d22\u63d0\u793a\u4e00\u6837\u663e\u793a\u4e00\u4e9b\u76f8\u5173\u7684\u5173\u952e\u8bcd\uff0c\u800c\u4e14\u63d0\u793a\u7684\u8bcd\u4ece\u6570\u636e\u5e93\u4e2d\u8c03\u7528\u70ed\u641c\u8bcd\u3002 \u6548\u679c\u56fe\uff1a \u65b0\u5efaSQ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[43],"_links":{"self":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts\/113"}],"collection":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=113"}],"version-history":[{"count":0,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}