<?xml version="1.0" encoding="UTF-8"?>
  <feed xmlns="http://www.w3.org/2005/Atom">
  <title type="html"><![CDATA[〓荣耀±一生〓---X14071Z1's BLOG]]></title>
  <subtitle type="html"><![CDATA[沉迷的黑色岁月~~孤寂,永远的孤寂..落寞...然后一直沉沦..]]></subtitle>
  <id>http://www.Fuckadmin.com/Blog/</id>
  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/" /> 
  <link rel="self" type="application/atom+xml" href="http://www.Fuckadmin.com/Blog/atom.asp" /> 
  <generator uri="http://www.pjhome.net/" version="2.8">PJBlog3</generator> 
  <updated>2010-03-11T23:33:09+08:00</updated>

  <entry>
	  <title type="html"><![CDATA[fuck santai.com fuck szbank!]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=9" label="随笔日记" /> 
	  <updated>2010-03-11T23:33:09+08:00</updated>
	  <published>2010-03-11T23:33:09+08:00</published>
		  <summary type="html"><![CDATA[fuck you,santai!<br/><br/>fuck santai~<br/><br/>操他妈的三泰]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=719" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=719</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[[Delphi] 用API函数得到操作系统类型]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=2" label="计算机技术" /> 
	  <updated>2010-03-05T13:08:00+08:00</updated>
	  <published>2010-03-05T13:08:00+08:00</published>
		  <summary type="html"><![CDATA[最近一个东西想要升级前判断本级操作系统：<br/><br/><div class="UBBPanel codePanel"><div class="UBBTitle"><img src="http://www.Fuckadmin.com/Blog/images/code.gif" style="margin:0px 2px -3px 0px" alt="程序代码"/> 程序代码</div><div class="UBBContent">unit Unit1; <br/><br/>interface <br/><br/>uses<br/>Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,<br/>StdCtrls, CommDlg; <br/><br/>type<br/>TForm1 = class(TForm)<br/>Button1: TButton;<br/>procedure Button1Click(Sender: TObject);<br/>private<br/>{ Private declarations }<br/>public<br/>{ Public declarations }<br/>end; <br/>type<br/>TOSVersion = (osUnknown, os95, os95OSR2, os98, os98SE, osNT3, osNT4, os2K, osME, osXP); <br/><br/>var<br/>Form1: TForm1; <br/><br/>implementation <br/><br/>{$R *.DFM} <br/><br/>function GetOS :TOSVersion; <br/>var<br/>OS :TOSVersionInfo; <br/>begin<br/>&nbsp;&nbsp;ZeroMemory(@OS,SizeOf(OS));<br/>&nbsp;&nbsp;OS.dwOSVersionInfoSize:=SizeOf(OS);<br/>&nbsp;&nbsp;GetVersionEx(OS);<br/>&nbsp;&nbsp;Result:=osUnknown;<br/>&nbsp;&nbsp;if OS.dwPlatformId=VER_PLATFORM_WIN32_NT then begin<br/>&nbsp;&nbsp;&nbsp;&nbsp;case OS.dwMajorVersion of<br/>&nbsp;&nbsp;&nbsp;&nbsp;3: Result:=osNT3;<br/>&nbsp;&nbsp;&nbsp;&nbsp;4: Result:=osNT4;<br/>&nbsp;&nbsp;&nbsp;&nbsp;5: Result:=os2K;<br/>&nbsp;&nbsp;end;<br/>&nbsp;&nbsp;if (OS.dwMajorVersion=5) and (OS.dwMinorVersion=1) then<br/>&nbsp;&nbsp;Result:=osXP;<br/>end else begin<br/>&nbsp;&nbsp;if (OS.dwMajorVersion=4) and (OS.dwMinorVersion=0) then begin<br/>&nbsp;&nbsp;&nbsp;&nbsp;Result:=os95;<br/>&nbsp;&nbsp;&nbsp;&nbsp;if (Trim(OS.szCSDVersion)=&#39;B&#39;) then<br/>&nbsp;&nbsp;&nbsp;&nbsp;Result:=os95OSR2;<br/>&nbsp;&nbsp;end else<br/>&nbsp;&nbsp;if (OS.dwMajorVersion=4) and (OS.dwMinorVersion=10) then begin<br/>&nbsp;&nbsp;&nbsp;&nbsp;Result:=os98;<br/>&nbsp;&nbsp;&nbsp;&nbsp;if (Trim(OS.szCSDVersion)=&#39;A&#39;) then<br/>&nbsp;&nbsp;&nbsp;&nbsp;Result:=os98SE;<br/>&nbsp;&nbsp;end else<br/>&nbsp;&nbsp;if (OS.dwMajorVersion=4) and (OS.dwMinorVersion=90) then<br/>&nbsp;&nbsp;Result:=osME;<br/>end; <br/>end; <br/>procedure TForm1.Button1Click(Sender: TObject); <br/>var <br/>os:TosVersion; <br/>osVersion:string; <br/>begin<br/>&nbsp;&nbsp;os:=Getos;<br/>&nbsp;&nbsp;case OS of<br/>&nbsp;&nbsp;os95, os95OSR2: OSVersion:=&#39;Windows 95&#39;;<br/>&nbsp;&nbsp;os98: OSVersion:=&#39;Windows 98&#39;;<br/>&nbsp;&nbsp;os98SE: OSVersion:=&#39;Windows 98 第二版&#39;;<br/>&nbsp;&nbsp;osME: OSVersion:=&#39;Windows Millenium Edition&#39;;<br/>&nbsp;&nbsp;osNT3, osNT4: OSVersion:=&#39;Windows NT&#39;;<br/>&nbsp;&nbsp;os2K: OSVersion:=&#39;Windows 2000&#39;;<br/>&nbsp;&nbsp;osXP: OSVersion:=&#39;Windows XP&#39;;<br/>end;<br/>showmessage(osversion); <br/>end; <br/><br/>end. </div></div>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=718" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=718</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[[QQ] 7岁女孩成QQ盗号者：仅为100Q币]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=1" label="业界资讯" /> 
	  <updated>2010-03-02T13:45:09+08:00</updated>
	  <published>2010-03-02T13:45:09+08:00</published>
		  <summary type="html"><![CDATA[　　QQ被盗？不新鲜。向被盗者索要Q币作为归还条件？好像也不新鲜。可如果做出这两件事的，是一个年仅7岁的女孩，你会作何感想？假若这个小女孩因自己的行为遭到被公布照片、家庭信息、修改QQ空间等报复，你又会对报复者持怎样的态度？近日，网上一个名为《现在的小孩太无敌了，7岁就盗号》的帖子将上述事件公之于众，网友们的争论更是沸沸扬扬。<br/><br/>　　小盗号者仅为100Q币<br/>　　日前，网友“倚井盼归”称，前几日上QQ时和妹妹聊天，可没想到他妹妹的QQ号被盗了，当时在线的竟然是盗号者。“倚井盼归”想以自己妹妹年纪尚小为由，劝盗号者归还账号，可对方竟辩称自己刚满7岁，令楼主大吃一惊，却也将信将疑。盗号者随即说明了盗号意图，因正在玩的某个QQ游戏急需Q币为继，她要求楼主为自己的一个QQ主号充上100元Q币，作为交还号码的条件。其稚嫩的话语和略带商量的口吻，让楼主逐渐相信对方还是个孩子。<br/>　　楼主假装答应了对方的要求，又以为她充值为理由伺机套出了该女孩QQ主号的密码。情势由此发生逆转，楼主登录女孩的QQ，翻看和修改了她的QQ空间，并删除了女孩的部分QQ好友，以此威胁小女孩交还所盗QQ号的密码。可楼主的一番交涉并不成功，还被上来帮腔的女孩哥哥痛骂了一顿。于是，他在盛怒之下便将和女孩的聊天纪录、女孩和家人的照片、家庭电话等通通公布到论坛之上，称希望网友们共同声援、为他撑腰。<br/><br/>　　报复行为引发热议<br/>　　该帖一经发出便引发网友极大关注，一位年仅7岁的孩子竟然懂得如何盗号，并要求以100Q币作为交换条件，有网友为此惊呼“连小朋友都会盗号了，这个世界怎么了？！”不过，虽然网友们大多认为孩子的行为确实应该“受点教训”，可将7岁孩子的家庭信息和资料照片公布，“倚井盼归”的这一行为同样遭遇网友们的围攻。<br/>　　网友“bxbx90556”表示支持楼主教训小女孩：“这么小就盗号骗Q币，的确该给她个深刻的教训。”网友“工口的小猫”也觉得“就该下重药，犯了错误就要承受，既然这孩子已经成人化，那就让她深刻认识成人的世界”，而“铁斩”更是激烈地表示，“今天盗号要Q币，明天就敢偷银行卡要RMB，害人也有被害的一天，出来混迟早要还的。”<br/>　　相比之下，多数网友对楼主此举不甚赞同，“对方年纪这么小，你就把人家照片全发网上了，考虑过她今后的生活么？教育可以，但你的处理方式很不妥当”，网友“青松涧”则认为楼主太过分，“7岁大的孩子，你也来报复？为什么不打电话跟她爸妈直接交流？为了一个QQ号就曝光(对方信息)到网上，让大家帮你痛骂一顿就解气了？万一出事怎么办？什么叫做网络暴民，你就是。”<br/>　　记者试图用站内信联系“倚井盼归”，始终没有回音。截至发稿时，记者发现“倚井盼归”已经删除了小女孩及其家人的照片，留下了聊天记录的截图和对方电话等信息。<br/><br/>　　[律师说法]<br/>　　发帖者情节更为恶劣<br/>　　在这场网友争论中，有人提到，由于目前我国在虚拟账户和虚拟货币领域尚存在司法空白，QQ号码不属于财产保护对象，所以盗号行为才会如此猖獗。带着些许疑问，记者咨询了上海联业律师事务所王展律师。他表示，目前我国对于虚拟财产保护尚无强制性规范。QQ号码作为虚拟财产，持有人对其享有占有、使用等民事权益，但是尚未上升到刑法保护的财产范围，因此7岁女孩盗号、索要Q币的行为虽属盗窃、敲诈勒索的范畴，但只是一种侵权行为。<br/>　　而发帖者的所作所为不仅属于敲诈勒索，更因其篡改了女孩的个人空间等，带有黑客行为的性质，且明知故犯，可能对未成年人造成较大伤害，是情节更为恶劣的违法行为。不过，由于女孩照片出自QQ空间，普通网友可以公开访问，不再是个人隐私，因此发帖人公布其照片的行为只能定性为转载。<br/><br/>　　[内行揭秘]<br/>　　盗号成风背后的利益链<br/>　　自从QQ风靡全国，盗号便成为令人头痛又难以根除的顽疾，有人不明白，盗号者可以从中得到什么好处，以至于这般乐此不疲。记者辗转采访到一位了解内情的“业内人士”小吴，了解到了盗号背后的一些利益关联。<br/>　　为了多赚些生活费，小吴曾在大学时期接触过盗号行业，“一开始只是觉得那些软件挺有趣的，后来才知道还有钱赚”，“主要是通过一些专门的盗号工具，这些软件网上甚至能够下载，可以针对QQ账户进行盗取。”他还告诉记者，从理论上说，只要是连接到互联网上的电脑都有可能被侵入，只不过公共场所和个人家庭电脑因为安全意识薄弱等原因“比较容易下手”。而且盗号工具极易上手，不需要多少知识。<br/>　　据他透露，盗取Q号后会将5、6、7位的靓号、有Q币的号码等较有价值的号码筛选出来，再将剩余的打包卖给其他人。最多时一天经手的号码有五六百个，按照不同价格出售，“一天三四千块钱很容易，体力好的话可以更多，即便是后来卖号的人多了，价钱便宜了，一天1000块钱也不成问题，来钱太快，简直欲罢不能”。<br/>　　小吴还称，这个圈子的每个环节，都有人能够获利。“有人就专门盗号，有人是写盗号程序的，还有专事出售的，环节很多，基本上各干各的，都有钱赚。”<br/><br/>　　[链接]<br/>　　防盗号窍门<br/>　　此外，小吴还以自己的经验，告诉了记者一些防盗号的小窍门，与读者分享。<br/>　　1、用键盘输入一部分，再用软键盘输入一部分。<br/>　　2、改变密码的输入顺序，如密码为123456时，先输入1256，再将光标移到5前，输入34。<br/>　　3、号码被盗时不要马上申诉，先进行系统杀毒，以避免邮箱密码也被黑客拿到。]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=717" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=717</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[[SQL] Sql2000连接Sql2005]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=2" label="计算机技术" /> 
	  <updated>2010-02-22T15:03:55+08:00</updated>
	  <published>2010-02-22T15:03:55+08:00</published>
		  <summary type="html"><![CDATA[使用sql2000企业管理器直接注册链接sql2005是连不上的，但是查询分析器可以连接，但是有使用限制，使用下面方法可以实现此目的:<br/><br/>在工作过程中遇到这个问题，我们机器上安装了SQL 2000的数据库，但在实际使用过程中由于某个项目的需要连接SQL 2005的数据库，用SQL 2000的企业管理器连接SQL 2005是连接不上的，但是通过SQL　2000的查询分析器仍然可以连接SQL 2005的数据库，但是修改表结构等不方便，需要用SQL语言来写～～<br/><br/>根据SQL 2000连接SQL 2005的提示，可以到<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>的网站上免费下载一个软件：<br/><a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> Microsoft</a> SQL Server Management Studio Express(SSMSE) ：<br/>是一种免费、易用的图形管理工具，用于管理 SQL Server 2005 Express Edition 和具有高级服务的 SQL Server 2005 Express Edition。<br/><br/>下载地址是：<br/><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796" target="_blank" rel="external">http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796</a>&amp;displaylang=zh-cn<br/><br/>选择SQLServer2005_SSMSEE.msi这个下载就是了～～<br/><br/>在下载完毕安装的时候又提示: setup is missing prerequisites - msxlm6，解决也很简单，需要安装2007年8月14日的<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> Microsoft</a> XML Core Services 6.0 和 <a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> Microsoft</a> XML Core Services 6.0 Service Pack 1 安全更新程序 (KB933579)，其下载地址：<a href="http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn" target="_blank" rel="external">http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn</a>&amp;FamilyID=70c92e77-9e5a-41b1-a9d2-64443913c976。<br/><br/>然后先安装这个补丁，然后再安装SSMSE<br/><br/>将远程数据库备份到本地的方法,只要能连上远程数据库使用查询分析器sel&#101;ct 表中内容然后在结果区全选-右键-另存-文本之类的,然后本地导入,当然这需要对数据库表结构有较详细的认识才行!<br/>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=716" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=716</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[Cr&#101;ateParameter 参数类型对应表]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=2" label="计算机技术" /> 
	  <updated>2010-02-22T15:03:05+08:00</updated>
	  <published>2010-02-22T15:03:05+08:00</published>
		  <summary type="html"><![CDATA[&lt;%<br/>&#39;--------------------------------------------------------------------<br/>&#39; <a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> Microsoft</a> ADO<br/>&#39;<br/>&#39; Copyright (c) 1996-1998 <a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> Microsoft</a> Corporation.<br/>&#39;<br/>&#39;<br/>&#39;<br/>&#39; ADO constants include file for VBScript<br/>&#39;<br/>&#39;--------------------------------------------------------------------<br/><br/>&#39;---- CursorTypeEnum Values ----<br/>Const adOpenForwardOnly = 0<br/>Const adOpenKeyset = 1<br/>Const adOpenDynamic = 2<br/>Const adOpenStatic = 3<br/><br/>&#39;---- CursorOptionEnum Values ----<br/>Const adHoldRecords = &amp;H00000100<br/>Const adMovePrevious = &amp;H00000200<br/>Const adAddNew = &amp;H01000400<br/>Const adDel&#101;te = &amp;H01000800<br/>Const adUp&#100;ate = &amp;H01008000<br/>Const adBookmark = &amp;H00002000<br/>Const adApproxPosition = &amp;H00004000<br/>Const adUp&#100;ateBatch = &amp;H00010000<br/>Const adResync = &amp;H00020000<br/>Const adNotify = &amp;H00040000<br/>Const adFind = &amp;H00080000<br/>Const adSeek = &amp;H00400000<br/>Const adIndex = &amp;H00800000<br/><br/>&#39;---- LockTypeEnum Values ----<br/>Const adLockReadOnly = 1<br/>Const adLockPessimistic = 2<br/>Const adLockOptimistic = 3<br/>Const adLockBatchOptimistic = 4<br/><br/>&#39;---- ExecuteOptionEnum Values ----<br/>Const adAsyncExecute = &amp;H00000010<br/>Const adAsyncFetch = &amp;H00000020<br/>Const adAsyncFetchNonBlocking = &amp;H00000040<br/>Const adExecuteNoRecords = &amp;H00000080<br/>Const adExecuteStream = &amp;H00000400<br/><br/>&#39;---- ConnectOptionEnum Values ----<br/>Const adAsyncConnect = &amp;H00000010<br/><br/>&#39;---- ObjectStateEnum Values ----<br/>Const adStateClosed = &amp;H00000000<br/>Const adStateOpen = &amp;H00000001<br/>Const adStateConnecting = &amp;H00000002<br/>Const adStateExecuting = &amp;H00000004<br/>Const adStateFetching = &amp;H00000008<br/><br/>&#39;---- CursorLocationEnum Values ----<br/>Const adUseServer = 2<br/>Const adUseClient = 3<br/><br/>&#39;---- DataTypeEnum Values ----<br/>Const adEmpty = 0<br/>Const adTinyInt = 16<br/>Const adSmallInt = 2<br/>Const adInteger = 3<br/>Const adBigInt = 20<br/>Const adUnsignedTinyInt = 17<br/>Const adUnsignedSmallInt = 18<br/>Const adUnsignedInt = 19<br/>Const adUnsignedBigInt = 21<br/>Const adSingle = 4<br/>Const adDouble = 5<br/>Const adCurrency = 6<br/>Const adDecimal = 14<br/>Const adNumeric = 131<br/>Const adBoolean = 11<br/>Const adError = 10<br/>Const adUserDefined = 132<br/>Const adVariant = 12<br/>Const adIDispatch = 9<br/>Const adIUnknown = 13<br/>Const adGUID = 72<br/>Const adDate = 7<br/>Const adDBDate = 133<br/>Const adDBTime = 134<br/>Const adDBTimeStamp = 135<br/>Const adBSTR = 8<br/>Const adChar = 129<br/>Const adVarChar = 200<br/>Const adLongVarChar = 201<br/>Const adWChar = 130<br/>Const adVarWChar = 202<br/>Const adLongVarWChar = 203<br/>Const adBinary = 128<br/>Const adVarBinary = 204<br/>Const adLongVarBinary = 205<br/>Const adChapter = 136<br/>Const adFileTime = 64<br/>Const adPropVariant = 138<br/>Const adVarNumeric = 139<br/>Const adArray = &amp;H2000<br/><br/>&#39;---- FieldAttributeEnum Values ----<br/>Const adFldMayDefer = &amp;H00000002<br/>Const adFldUpdatable = &amp;H00000004<br/>Const adFldUnknownUpdatable = &amp;H00000008<br/>Const adFldFixed = &amp;H00000010<br/>Const adFldIsNullable = &amp;H00000020<br/>Const adFldMayBeNull = &amp;H00000040<br/>Const adFldLong = &amp;H00000080<br/>Const adFldRowID = &amp;H00000100<br/>Const adFldRowVersion = &amp;H00000200<br/>Const adFldCacheDeferred = &amp;H00001000<br/>Const adFldIsChapter = &amp;H00002000<br/>Const adFldNegativeScale = &amp;H00004000<br/>Const adFldKeyColumn = &amp;H00008000<br/>Const adFldIsRowURL = &amp;H00010000<br/>Const adFldIsDefaultStream = &amp;H00020000<br/>Const adFldIsCollection = &amp;H00040000<br/><br/>&#39;---- EditModeEnum Values ----<br/>Const adEditNone = &amp;H0000<br/>Const adEditInProgress = &amp;H0001<br/>Const adEditAdd = &amp;H0002<br/>Const adEditDel&#101;te = &amp;H0004<br/><br/>&#39;---- RecordStatusEnum Values ----<br/>Const adRecOK = &amp;H0000000<br/>Const adRecNew = &amp;H0000001<br/>Const adRecModified = &amp;H0000002<br/>Const adRecDel&#101;ted = &amp;H0000004<br/>Const adRecUnmodified = &amp;H0000008<br/>Const adRecInvalid = &amp;H0000010<br/>Const adRecMultipleChanges = &amp;H0000040<br/>Const adRecPendingChanges = &amp;H0000080<br/>Const adRecCanceled = &amp;H0000100<br/>Const adRecCantRelease = &amp;H0000400<br/>Const adRecConcurrencyViolation = &amp;H0000800<br/>Const adRecIntegrityViolation = &amp;H0001000<br/>Const adRecMaxChangesExceeded = &amp;H0002000<br/>Const adRecObjectOpen = &amp;H0004000<br/>Const adRecOutOfMemory = &amp;H0008000<br/>Const adRecPermissionDenied = &amp;H0010000<br/>Const adRecSchemaViolation = &amp;H0020000<br/>Const adRecDBDel&#101;ted = &amp;H0040000<br/><br/>&#39;---- GetRowsOptionEnum Values ----<br/>Const adGetRowsRest = -1<br/><br/>&#39;---- PositionEnum Values ----<br/>Const adPosUnknown = -1<br/>Const adPosBOF = -2<br/>Const adPosEOF = -3<br/><br/>&#39;---- BookmarkEnum Values ----<br/>Const adBookmarkCurrent = 0<br/>Const adBookmarkFirst = 1<br/>Const adBookmarkLast = 2<br/><br/>&#39;---- MarshalOptionsEnum Values ----<br/>Const adMarshalAll = 0<br/>Const adMarshalModifiedOnly = 1<br/><br/>&#39;---- AffectEnum Values ----<br/>Const adAffectCurrent = 1<br/>Const adAffectGroup = 2<br/>Const adAffectAllChapters = 4<br/><br/>&#39;---- ResyncEnum Values ----<br/>Const adResyncUnderlyingValues = 1<br/>Const adResyncAllValues = 2<br/><br/>&#39;---- CompareEnum Values ----<br/>Const adCompareLessThan = 0<br/>Const adCompareEqual = 1<br/>Const adCompareGreaterThan = 2<br/>Const adCompareNotEqual = 3<br/>Const adCompareNotComparable = 4<br/><br/>&#39;---- FilterGroupEnum Values ----<br/>Const adFilterNone = 0<br/>Const adFilterPendingRecords = 1<br/>Const adFilterAffectedRecords = 2<br/>Const adFilterFetchedRecords = 3<br/>Const adFilterConflictingRecords = 5<br/><br/>&#39;---- SearchDirectionEnum Values ----<br/>Const adSearchForward = 1<br/>Const adSearchBackward = -1<br/><br/>&#39;---- PersistFormatEnum Values ----<br/>Const adPersistADTG = 0<br/>Const adPersistXML = 1<br/><br/>&#39;---- StringFormatEnum Values ----<br/>Const adClipString = 2<br/><br/>&#39;---- ConnectPromptEnum Values ----<br/>Const adPromptAlways = 1<br/>Const adPromptComplete = 2<br/>Const adPromptCompleteRequired = 3<br/>Const adPromptNever = 4<br/><br/>&#39;---- ConnectModeEnum Values ----<br/>Const adModeUnknown = 0<br/>Const adModeRead = 1<br/>Const adModeWrite = 2<br/>Const adModeReadWrite = 3<br/>Const adModeShareDenyRead = 4<br/>Const adModeShareDenyWrite = 8<br/>Const adModeShareExclusive = &amp;Hc<br/>Const adModeShareDenyNone = &amp;H10<br/>Const adModeRecursive = &amp;H400000<br/><br/>&#39;---- RecordCr&#101;ateOptionsEnum Values ----<br/>Const adCr&#101;ateCollection = &amp;H00002000<br/>Const adCr&#101;ateStructDoc = &amp;H80000000<br/>Const adCr&#101;ateNonCollection = &amp;H00000000<br/>Const adOpenIfExists = &amp;H02000000<br/>Const adCr&#101;ateOverwrite = &amp;H04000000<br/>Const adFailIfNotExists = -1<br/><br/>&#39;---- RecordOpenOptionsEnum Values ----<br/>Const adOpenRecordUnspecified = -1<br/>Const adOpenOutput = &amp;H00800000<br/>Const adOpenAsync = &amp;H00001000<br/>Const adDelayFetchStream = &amp;H00004000<br/>Const adDelayFetchFields = &amp;H00008000<br/>Const adOpenExecuteCommand = &amp;H00010000<br/><br/>&#39;---- IsolationLevelEnum Values ----<br/>Const adXactUnspecified = &amp;Hffffffff<br/>Const adXactChaos = &amp;H00000010<br/>Const adXactReadUncommitted = &amp;H00000100<br/>Const adXactBrowse = &amp;H00000100<br/>Const adXactCursorStability = &amp;H00001000<br/>Const adXactReadCommitted = &amp;H00001000<br/>Const adXactRepeatableRead = &amp;H00010000<br/>Const adXactSerializable = &amp;H00100000<br/>Const adXactIsolated = &amp;H00100000<br/><br/>&#39;---- XactAttributeEnum Values ----<br/>Const adXactCommitRetaining = &amp;H00020000<br/>Const adXactAbortRetaining = &amp;H00040000<br/><br/>&#39;---- PropertyAttributesEnum Values ----<br/>Const adPropNotSupported = &amp;H0000<br/>Const adPropRequired = &amp;H0001<br/>Const adPropOptional = &amp;H0002<br/>Const adPropRead = &amp;H0200<br/>Const adPropWrite = &amp;H0400<br/><br/>&#39;---- ErrorValueEnum Values ----<br/>Const adErrProviderFailed = &amp;Hbb8<br/>Const adErrInvalidArgument = &amp;Hbb9<br/>Const adErrOpeningFile = &amp;Hbba<br/>Const adErrReadFile = &amp;Hbbb<br/>Const adErrWriteFile = &amp;Hbbc<br/>Const adErrNoCurrentRecord = &amp;Hbcd<br/>Const adErrIllegalOperation = &amp;Hc93<br/>Const adErrCantChangeProvider = &amp;Hc94<br/>Const adErrInTransaction = &amp;Hcae<br/>Const adErrFeatureNotAvailable = &amp;Hcb3<br/>Const adErrItemNotFound = &amp;Hcc1<br/>Const adErrObjectInCollection = &amp;Hd27<br/>Const adErrObjectNotSet = &amp;Hd5c<br/>Const adErrDataConversion = &amp;Hd5d<br/>Const adErrObjectClosed = &amp;He78<br/>Const adErrObjectOpen = &amp;He79<br/>Const adErrProviderNotFound = &amp;He7a<br/>Const adErrBoundToCommand = &amp;He7b<br/>Const adErrInvalidParamInfo = &amp;He7c<br/>Const adErrInvalidConnection = &amp;He7d<br/>Const adErrNotReentrant = &amp;He7e<br/>Const adErrStillExecuting = &amp;He7f<br/>Const adErrOperationCancelled = &amp;He80<br/>Const adErrStillConnecting = &amp;He81<br/>Const adErrInvalidTransaction = &amp;He82<br/>Const adErrUnsafeOperation = &amp;He84<br/>Const adwrnSecurityDialog = &amp;He85<br/>Const adwrnSecurityDialogHeader = &amp;He86<br/>Const adErrIntegrityViolation = &amp;He87<br/>Const adErrPermissionDenied = &amp;He88<br/>Const adErrDataOverflow = &amp;He89<br/>Const adErrSchemaViolation = &amp;He8a<br/>Const adErrSignMismatch = &amp;He8b<br/>Const adErrCantConvertvalue = &amp;He8c<br/>Const adErrCantCr&#101;ate = &amp;He8d<br/>Const adErrColumnNotOnThisRow = &amp;He8e<br/>Const adErrURLIntegrViolSetColumns = &amp;He8f<br/>Const adErrURLDoesNotExist = &amp;He8f<br/>Const adErrTreePermissionDenied = &amp;He90<br/>Const adErrInvalidURL = &amp;He91<br/>Const adErrResourceLocked = &amp;He92<br/>Const adErrResourceExists = &amp;He93<br/>Const adErrCannotComplete = &amp;He94<br/>Const adErrVolumeNotFound = &amp;He95<br/>Const adErrOutOfSpace = &amp;He96<br/>Const adErrResourceOutOfScope = &amp;He97<br/>Const adErrUnavailable = &amp;He98<br/>Const adErrURLNamedRowDoesNotExist = &amp;He99<br/>Const adErrDelResOutOfScope = &amp;He9a<br/>Const adErrPropInvalidColumn = &amp;He9b<br/>Const adErrPropInvalidOption = &amp;He9c<br/>Const adErrPropInvalidValue = &amp;He9d<br/>Const adErrPropConflicting = &amp;He9e<br/>Const adErrPropNotAllSettable = &amp;He9f<br/>Const adErrPropNotSet = &amp;Hea0<br/>Const adErrPropNotSettable = &amp;Hea1<br/>Const adErrPropNotSupported = &amp;Hea2<br/>Const adErrCatalogNotSet = &amp;Hea3<br/>Const adErrCantChangeConnection = &amp;Hea4<br/>Const adErrFieldsUp&#100;ateFailed = &amp;Hea5<br/>Const adErrDenyNotSupported = &amp;Hea6<br/>Const adErrDenyTypeNotSupported = &amp;Hea7<br/><br/>&#39;---- ParameterAttributesEnum Values ----<br/>Const adParamSigned = &amp;H0010<br/>Const adParamNullable = &amp;H0040<br/>Const adParamLong = &amp;H0080<br/><br/>&#39;---- ParameterDirectionEnum Values ----<br/>Const adParamUnknown = &amp;H0000<br/>Const adParamInput = &amp;H0001<br/>Const adParamOutput = &amp;H0002<br/>Const adParamInputOutput = &amp;H0003<br/>Const adParamReturnValue = &amp;H0004<br/><br/>&#39;---- CommandTypeEnum Values ----<br/>Const adCmdUnknown = &amp;H0008<br/>Const adCmdText = &amp;H0001<br/>Const adCmdTable = &amp;H0002<br/>Const adCmdStoredProc = &amp;H0004<br/>Const adCmdFile = &amp;H0100<br/>Const adCmdTableDirect = &amp;H0200<br/><br/>&#39;---- EventStatusEnum Values ----<br/>Const adStatusOK = &amp;H0000001<br/>Const adStatusErrorsOccurred = &amp;H0000002<br/>Const adStatusCantDeny = &amp;H0000003<br/>Const adStatusCancel = &amp;H0000004<br/>Const adStatusUnwantedEvent = &amp;H0000005<br/><br/>&#39;---- EventReasonEnum Values ----<br/>Const adRsnAddNew = 1<br/>Const adRsnDel&#101;te = 2<br/>Const adRsnUp&#100;ate = 3<br/>Const adRsnUndoUp&#100;ate = 4<br/>Const adRsnUndoAddNew = 5<br/>Const adRsnUndoDel&#101;te = 6<br/>Const adRsnRequery = 7<br/>Const adRsnResynch = 8<br/>Const adRsnClose = 9<br/>Const adRsnMove = 10<br/>Const adRsnFirstChange = 11<br/>Const adRsnMoveFirst = 12<br/>Const adRsnMoveNext = 13<br/>Const adRsnMovePrevious = 14<br/>Const adRsnMoveLast = 15<br/><br/>&#39;---- SchemaEnum Values ----<br/>Const adSchemaProviderSpecific = -1<br/>Const adSchemaAsserts = 0<br/>Const adSchemaCatalogs = 1<br/>Const adSchemaCharacterSets = 2<br/>Const adSchemaCollations = 3<br/>Const adSchemaColumns = 4<br/>Const adSchemaCheckConstraints = 5<br/>Const adSchemaConstraintColumnUsage = 6<br/>Const adSchemaConstraintTableUsage = 7<br/>Const adSchemaKeyColumnUsage = 8<br/>Const adSchemaReferentialConstraints = 9<br/>Const adSchemaTableConstraints = 10<br/>Const adSchemaColumnsDomainUsage = 11<br/>Const adSchemaIndexes = 12<br/>Const adSchemaColumnPrivileges = 13<br/>Const adSchemaTablePrivileges = 14<br/>Const adSchemaUsagePrivileges = 15<br/>Const adSchemaProcedures = 16<br/>Const adSchemaSchemata = 17<br/>Const adSchemaSQLLanguages = 18<br/>Const adSchemaStatistics = 19<br/>Const adSchemaTables = 20<br/>Const adSchemaTranslations = 21<br/>Const adSchemaProviderTypes = 22<br/>Const adSchemaViews = 23<br/>Const adSchemaViewColumnUsage = 24<br/>Const adSchemaViewTableUsage = 25<br/>Const adSchemaProcedureParameters = 26<br/>Const adSchemaForeignKeys = 27<br/>Const adSchemaPrimaryKeys = 28<br/>Const adSchemaProcedureColumns = 29<br/>Const adSchemaDBInfoKeywords = 30<br/>Const adSchemaDBInfoLiterals = 31<br/>Const adSchemaCubes = 32<br/>Const adSchemaDimensions = 33<br/>Const adSchemaHierarchies = 34<br/>Const adSchemaLevels = 35<br/>Const adSchemaMeasures = 36<br/>Const adSchemaProperties = 37<br/>Const adSchemaMembers = 38<br/>Const adSchemaTrustees = 39<br/>Const adSchemaFunctions = 40<br/>Const adSchemaActions = 41<br/>Const adSchemaCommands = 42<br/>Const adSchemaSets = 43<br/><br/>&#39;---- FieldStatusEnum Values ----<br/>Const adFieldOK = 0<br/>Const adFieldCantConvertValue = 2<br/>Const adFieldIsNull = 3<br/>Const adFieldTruncated = 4<br/>Const adFieldSignMismatch = 5<br/>Const adFieldDataOverflow = 6<br/>Const adFieldCantCr&#101;ate = 7<br/>Const adFieldUnavailable = 8<br/>Const adFieldPermissionDenied = 9<br/>Const adFieldIntegrityViolation = 10<br/>Const adFieldSchemaViolation = 11<br/>Const adFieldBadStatus = 12<br/>Const adFieldDefault = 13<br/>Const adFieldIgnore = 15<br/>Const adFieldDoesNotExist = 16<br/>Const adFieldInvalidURL = 17<br/>Const adFieldResourceLocked = 18<br/>Const adFieldResourceExists = 19<br/>Const adFieldCannotComplete = 20<br/>Const adFieldVolumeNotFound = 21<br/>Const adFieldOutOfSpace = 22<br/>Const adFieldCannotDel&#101;teSource = 23<br/>Const adFieldReadOnly = 24<br/>Const adFieldResourceOutOfScope = 25<br/>Const adFieldAlreadyExists = 26<br/>Const adFieldPendingIns&#101;rt = &amp;H10000<br/>Const adFieldPendingDel&#101;te = &amp;H20000<br/>Const adFieldPendingChange = &amp;H40000<br/>Const adFieldPendingUnknown = &amp;H80000<br/>Const adFieldPendingUnknownDel&#101;te = &amp;H100000<br/><br/>&#39;---- SeekEnum Values ----<br/>Const adSeekFirstEQ = &amp;H1<br/>Const adSeekLastEQ = &amp;H2<br/>Const adSeekAfterEQ = &amp;H4<br/>Const adSeekAfter = &amp;H8<br/>Const adSeekBeforeEQ = &amp;H10<br/>Const adSeekBefore = &amp;H20<br/><br/>&#39;---- ADCPROP_Up&#100;ateCRITERIA_ENUM Values ----<br/>Const adCriteriaKey = 0<br/>Const adCriteriaAllCols = 1<br/>Const adCriteriaUpdCols = 2<br/>Const adCriteriaTimeStamp = 3<br/><br/>&#39;---- ADCPROP_ASYNCTHREADPRIORITY_ENUM Values ----<br/>Const adPriorityLowest = 1<br/>Const adPriorityBelowNormal = 2<br/>Const adPriorityNormal = 3<br/>Const adPriorityAboveNormal = 4<br/>Const adPriorityHighest = 5<br/><br/>&#39;---- ADCPROP_AUTORECALC_ENUM Values ----<br/>Const adRecalcUpFront = 0<br/>Const adRecalcAlways = 1<br/><br/>&#39;---- ADCPROP_Up&#100;ateRESYNC_ENUM Values ----<br/><br/>&#39;---- ADCPROP_Up&#100;ateRESYNC_ENUM Values ----<br/><br/>&#39;---- MoveRecordOptionsEnum Values ----<br/>Const adMoveUnspecified = -1<br/>Const adMoveOverWrite = 1<br/>Const adMoveDontUp&#100;ateLinks = 2<br/>Const adMoveAllowEmulation = 4<br/><br/>&#39;---- CopyRecordOptionsEnum Values ----<br/>Const adCopyUnspecified = -1<br/>Const adCopyOverWrite = 1<br/>Const adCopyAllowEmulation = 4<br/>Const adCopyNonRecursive = 2<br/><br/>&#39;---- StreamTypeEnum Values ----<br/>Const adTypeBinary = 1<br/>Const adTypeText = 2<br/><br/>&#39;---- LineSeparatorEnum Values ----<br/>Const adLF = 10<br/>Const adCR = 13<br/>Const adCRLF = -1<br/><br/>&#39;---- StreamOpenOptionsEnum Values ----<br/>Const adOpenStreamUnspecified = -1<br/>Const adOpenStreamAsync = 1<br/>Const adOpenStreamFromRecord = 4<br/><br/>&#39;---- StreamWriteEnum Values ----<br/>Const adWriteChar = 0<br/>Const adWriteLine = 1<br/><br/>&#39;---- SaveOptionsEnum Values ----<br/>Const adSaveCr&#101;ateNotExist = 1<br/>Const adSaveCr&#101;ateOverWrite = 2<br/><br/>&#39;---- FieldEnum Values ----<br/>Const adDefaultStream = -1<br/>Const adRecordURL = -2<br/><br/>&#39;---- StreamReadEnum Values ----<br/>Const adReadAll = -1<br/>Const adReadLine = -2<br/><br/>&#39;---- RecordTypeEnum Values ----<br/>Const adSimpleRecord = 0<br/>Const adCollectionRecord = 1<br/>Const adStructDoc = 2<br/>%&gt;<br/>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=715" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=715</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[[原]SQL存储过程解决数据转换．．．ｊｕｓｔ　ｆｏｒｂａｎｋ]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=2" label="计算机技术" /> 
	  <updated>2010-02-22T14:59:13+08:00</updated>
	  <published>2010-02-22T14:59:13+08:00</published>
		  <summary type="html"><![CDATA[存储过程　@Last_balance_per_B Varchar(100)<br/><br/>sel&#101;ct @Last_balance_per_B = cast(sum(last_balance) as varchar) from acc_data_table wh&#101;re years=@YEAR and monthe=＠month*3 and zhlx&lt;&gt;0 and acc_type=&#39;B&#39; and substring(account,16,3)=&#39;001&#39;<br/><br/>页面：<br/><br/>CmdSP.Parameters.Append CmdSP.Cr&#101;ateParameter(&#34;@Last_balance_per_B&#34;, adVarchar, adParamOutput,100)<br/><br/><br/>即可获得没被截断或者四舍五入的余额数据．．．吧？<br/><br/>just test<br/> <br/>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=714" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=714</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[[XML] asp读取xml文件并分页]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=2" label="计算机技术" /> 
	  <updated>2010-02-22T14:30:36+08:00</updated>
	  <published>2010-02-22T14:30:36+08:00</published>
		  <summary type="html"><![CDATA[asp读取xml文件并分页<br/>xml文件ly.xml<br/><br/>&lt;a&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;1&lt;/id&gt;<br/>&lt;name&gt;赵&lt;/name&gt;<br/>&lt;add&gt;浙江&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;2&lt;/id&gt;<br/>&lt;name&gt;钱&lt;/name&gt;<br/>&lt;add&gt;江苏&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;3&lt;/id&gt;<br/>&lt;name&gt;孙&lt;/name&gt;<br/>&lt;add&gt;安徽&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;4&lt;/id&gt;<br/>&lt;name&gt;李&lt;/name&gt;<br/>&lt;add&gt;福建&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;5&lt;/id&gt;<br/>&lt;name&gt;周&lt;/name&gt;<br/>&lt;add&gt;江西&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;6&lt;/id&gt;<br/>&lt;name&gt;吴&lt;/name&gt;<br/>&lt;add&gt;广东&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;7&lt;/id&gt;<br/>&lt;name&gt;郑&lt;/name&gt;<br/>&lt;add&gt;广西&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;8&lt;/id&gt;<br/>&lt;name&gt;王&lt;/name&gt;<br/>&lt;add&gt;云南&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;9&lt;/id&gt;<br/>&lt;name&gt;冯&lt;/name&gt;<br/>&lt;add&gt;贵州&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;10&lt;/id&gt;<br/>&lt;name&gt;陈&lt;/name&gt;<br/>&lt;add&gt;四川&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;11&lt;/id&gt;<br/>&lt;name&gt;储&lt;/name&gt;<br/>&lt;add&gt;湖南&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/><br/>&lt;b&gt;<br/>&lt;id&gt;12&lt;/id&gt;<br/>&lt;name&gt;卫&lt;/name&gt;<br/>&lt;add&gt;湖北&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;b&gt;<br/>&lt;id&gt;13&lt;/id&gt;<br/>&lt;name&gt;蒋&lt;/name&gt;<br/>&lt;add&gt;陕西&lt;/add&gt;<br/>&lt;/b&gt;<br/><br/>&lt;/a&gt;<br/><br/><br/><br/>asp文件index.asp<br/><br/>&lt;%<br/>xmlfilename=&#34;ly.xml&#34;<br/>Set objxml=Server.Cr&#101;ateObject(&#34;<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> Microsoft</a>.XMLDOM&#34;) <br/>objxml.load(Server.MapPath(xmlFileName))<br/>Set rootNode=objxml.documentElement<br/><br/>yu=rootNode.childNodes.length mod 5&nbsp;&nbsp;&nbsp;&nbsp; &#39;最后一页的留言数<br/><br/>PageSize =5&#39;假设每页显示5条留言<br/><br/>AllNodesNum =rootNode.childNodes.length-1 &#39;获取子节点数据（因为是从节点数从0开始的所最大子节点数要减1）<br/><br/>PageNum=AllNodesNum\PageSize+1 &#39;算出总页数<br/><br/>PageNo=request.querystring(&#34;PageNo&#34;) <br/>if PageNo=&#34;&#34; then &#39;如果是每一次获得页面则定位到每一页显示最新的留言 <br/>PageNo=1<br/><br/>end if<br/><br/>StarNodes=(PageNum-PageNo)*PageSize-1+yu &#39;获得起始节点<br/><br/>if yu=0 then<br/>StarNodes=(PageNum-PageNo+1)*PageSize-1+yu &#39;获得起始节点<br/>end if<br/>EndNodes=StarNodes-4 &#39;获得结束节点 <br/>if StarNodes=yu-1 then <br/>EndNodes=0 <br/>end if<br/><br/><br/>for i=StarNodes to EndNodes step -1&nbsp;&nbsp;&nbsp;&nbsp;&#39;从结束节点到超始节点之间读取节点数据 <br/>id = rootNode.childNodes.item(i).childNodes.item(0).text &#39;获序号 <br/>name =rootNode.childNodes.item(i).childNodes.item(1).text &#39;获得名字 <br/>add = rootNode.childNodes.item(i).childNodes.item(2).text &#39;获得地址<br/>%&gt; <br/>&lt;table border=&#34;1&#34; width=&#34;50%&#34;&gt;<br/>&lt;tr bgcolor=&#34;#F0F0F0&#34; height=&#34;20&#34;&gt; <br/>&lt;td&gt;&lt;%=id%&gt;&lt;/td&gt;<br/>&lt;td&gt;&lt;%=name%&gt;&lt;/td&gt;<br/>&lt;td&gt;&lt;%=add%&gt;&lt;/td&gt;<br/>&lt;/tr&gt; <br/>&lt;/table&gt;<br/>&lt;% <br/>Response.Write &#34;&lt;br&gt;&lt;br&gt;&#34;<br/>next<br/>set objXML=nothing <br/>Response.Write &#34;&lt;br&gt;&lt;br&gt;&#34;<br/>%&gt; <br/>&lt;table width=&#34;509&#34; border=&#34;1&#34;&gt;<br/>&lt;tr bgcolor=&#34;#FFFFFF&#34; align=&#34;right&#34;&gt; <br/>&lt;td&gt;&lt;%=pageno%&gt;/&lt;%=PageNum%&gt;页 &lt;/td&gt;<br/>&lt;td width=&#34;106&#34;&gt;&lt;%if pageno=1 then%&gt;首页&lt;%else%&gt;&lt;a href=&#34;index.asp?pageno=1&#34;&gt;首页&lt;/a&gt;&lt;%end if%&gt;&lt;/td&gt;<br/>&lt;td width=&#34;95&#34; &gt;&lt;%if pageno=1 then%&gt;上页&lt;%else%&gt;&lt;a href=&#34;index.asp?pageno=&lt;%=pageno-1%&gt;&#34;&gt; 上页&lt;/a&gt;&lt;%end if%&gt;&lt;/td&gt;&nbsp;&nbsp; <br/>&lt;td width=&#34;106&#34; &gt;&lt;%if cint(PageNo)=pagenum then%&gt;下页&lt;%else%&gt;&lt;a href=&#34;index.asp?pageno=&lt;%=pageno+1%&gt;&#34;&gt;下页&lt;/a&gt;&lt;%end if%&gt;&lt;/td&gt;<br/>&lt;td width=&#34;112&#34;&gt;&lt;%if cint(PageNo)=pagenum then%&gt;末页&lt;%else%&gt;&lt;a href=&#34;index.asp?pageno=&lt;%=pagenum%&gt;&#34;&gt; 末页&lt;/a&gt;&lt;%end if%&gt;&lt;/td&gt;<br/>&lt;/tr&gt;<br/>&lt;/table&gt;<br/><br/>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=713" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=713</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[[XML] asp+sql分页xml绑定]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=2" label="计算机技术" /> 
	  <updated>2010-02-22T14:27:12+08:00</updated>
	  <published>2010-02-22T14:27:12+08:00</published>
		  <summary type="html"><![CDATA[sql 表结构<br/><br/>复制代码<br/>if exists (sel&#101;ct * from dbo.sysobjects wh&#101;re id = object_id(N&#39;[dbo].[Products]&#39;) and OBJECTPROPERTY(id, N&#39;IsUserTable&#39;) = 1)<br/>dro&#112; table [dbo].[Products]<br/>GO<br/><br/>Cr&#101;ate TABLE [dbo].[Products] (<br/>&nbsp;&nbsp;&nbsp;&nbsp; [ID] [int] IDENTITY (1, 1) NOT NULL ,<br/>&nbsp;&nbsp;&nbsp;&nbsp; [ProductName] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,<br/>&nbsp;&nbsp;&nbsp;&nbsp; [SupplierID] [int] NULL ,<br/>&nbsp;&nbsp;&nbsp;&nbsp; [CategoryID] [int] NULL ,<br/>&nbsp;&nbsp;&nbsp;&nbsp; [QuantityPerUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,<br/>&nbsp;&nbsp;&nbsp;&nbsp; [UnitPrice] [money] NULL ,<br/>&nbsp;&nbsp;&nbsp;&nbsp; [UnitsInStock] [smallint] NULL ,<br/>&nbsp;&nbsp;&nbsp;&nbsp; [UnitsOnOrder] [smallint] NULL ,<br/>&nbsp;&nbsp;&nbsp;&nbsp; [ReorderLevel] [smallint] NULL ,<br/>&nbsp;&nbsp;&nbsp;&nbsp; [Discontinued] [bit] NOT NULL <br/>) ON [PRIMARY]<br/>GO<br/><br/><br/>代码如下：<br/><br/>复制代码<br/><br/>&lt;%<br/>&#39;可能通用性不怎么好<br/>&#39;注意查询出来的信息与HTML绑定的列，是一致的<br/><br/><br/><br/>dim T1,T2<br/><br/>T1=timer()<br/><br/><br/>const Default_psize=18<br/><br/>Class Cls_ForXml_Page<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp; Private mmax&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;ID最大值<br/>&nbsp;&nbsp;&nbsp;&nbsp; Private size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;总元素<br/>&nbsp;&nbsp;&nbsp;&nbsp; Private curp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;当前页<br/>&nbsp;&nbsp;&nbsp;&nbsp; Private coup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;总页数<br/>&nbsp;&nbsp;&nbsp;&nbsp; Private psize&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;页长<br/>&nbsp;&nbsp;&nbsp;&nbsp; <br/>&nbsp;&nbsp;&nbsp;&nbsp; Private list&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;列表<br/>&nbsp;&nbsp;&nbsp;&nbsp; Private temp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;临时<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp; &#39;析构<br/>&nbsp;&nbsp;&nbsp;&nbsp; Private Sub Class_Terminate()<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br/>&nbsp;&nbsp;&nbsp;&nbsp; End Sub<br/>&nbsp;&nbsp;&nbsp;&nbsp; &#39;构造<br/>&nbsp;&nbsp;&nbsp;&nbsp; Private Sub Class_Initialize()<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br/>&nbsp;&nbsp;&nbsp;&nbsp; End Sub<br/>&nbsp;&nbsp;&nbsp;&nbsp; <br/>&nbsp;&nbsp;&nbsp;&nbsp; &#39;处理数字<br/>&nbsp;&nbsp;&nbsp;&nbsp; Private Function nfilter(ByVal Param)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Param=trim(Param)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If IsNumeric(Param) Then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nfilter=Fix(Param)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nfilter=0<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If<br/>&nbsp;&nbsp;&nbsp;&nbsp; End Function<br/>&nbsp;&nbsp;&nbsp;&nbsp; <br/>&nbsp;&nbsp;&nbsp;&nbsp; Public Function getxml(ByVal con,ByVal sql,ByVal name)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; list=Trim(Left(sql,InStr(sql,&#34; from &#34;)-1))<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; list=Trim(Right(list,len(list)-len(&#34;sel&#101;ct &#34;)))<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; temp=split(list,&#34;,&#34;)<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; size=con.execute(&#34;sel&#101;ct count(ID) from (&#34; &amp; sql &amp; &#34;) as b&#34;).fields(0)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; psize=nfilter(request.QueryString(&#34;psize&#34;))<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If psize=0 Then psize=Default_psize<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If Not size Mod psize=0 Then coup=size\psize+1 Else coup=size\psize<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; curp=nfilter(request.QueryString(&#34;curp&#34;))<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If curp&lt;=0 Then curp=1<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If curp&gt;coup Then curp=coup<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sql&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=Right(sql,Len(sql)-InStr(sql,&#34; from &#34;)+1)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim rs<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set rs=con.execute(&#34;sel&#101;ct Max(ID) from (Sel&#101;ct Top &#34;&amp;(curp-1)*psize&amp;&#34; ID &#34;&amp;sql&amp;&#34; o&#114;der by ID) as a&#34;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If not rs.eof Then mmax=rs.fields(0)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If mmax=&#34;&#34; o&#114; isNull(mmax) Then mmax=0<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set rs=nothing<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If InStr(sql,&#34; wh&#101;re &#34;)&lt;&gt;0 Then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sql=replace(sql,&#34; wh&#101;re &#34;,&#34; wh&#101;re ID&gt;&#34;&amp;mmax&amp;&#34; and &#34;,1)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sql=&#34;Sel&#101;ct Top &#34;&amp;psize&amp;&#34; &#34;&amp;list&amp;&#34; &#34;&amp;sql<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sql=sql&amp;&#34; for xml auto,elements&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim ms,cm,msxml<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set ms=server.Cr&#101;ateObject(&#34;ADODB.Stream&#34;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set cm=server.Cr&#101;ateObject(&#34;ADODB.Command&#34;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ms.open<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set cm.ActiveConnection=con<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cm.properties(&#34;output stream&#34;).value=ms<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cm.commandtext=sql<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cm.execute ,,1024<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ms.position = 0<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msxml = &#34;&lt;xml id=&#34;&#34;&#34;&amp;name&amp;&#34;&#34;&#34; name=&#34;&#34;&#34;&amp;name&amp;&#34;&#34;&#34;&gt;&lt;root&gt;&#34;&amp;ms.readtext&amp;&#34;&lt;/root&gt;&lt;/xml&gt;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ms.close<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set ms = nothing<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getxml=msxml<br/>&nbsp;&nbsp;&nbsp;&nbsp; End Function<br/>&nbsp;&nbsp;&nbsp;&nbsp; <br/>&nbsp;&nbsp;&nbsp;&nbsp; &#39;过滤不需要的GET串<br/>&nbsp;&nbsp;&nbsp;&nbsp; Private Function filterGET(ByVal filters)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim url,i,obj,newGet,flag<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set url=request.QueryString()<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filters=Split(filters,&#34;,&#34;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newGet=&#34;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; For Each obj In url<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; flag=False<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; For i=0 To UBound(filters)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If Trim(LCase(CStr(obj)))=Trim(LCase(CStr(filters(i)))) Then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; flag=True<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Exit For<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Next<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If Not flag Then newGet&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;newGet&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;obj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#34;=&#34;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;url(obj)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#34;&amp;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Next<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If Not newGet=&#34;&#34; Then newGet=Trim(Left(newGet,Len(newGet)-1))<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filterGET=newGet<br/>&nbsp;&nbsp;&nbsp;&nbsp; End Function<br/>&nbsp;&nbsp;&nbsp;&nbsp; &#39;显示上下页（当前页,总页数,前后加起来的页数,除去cp参数的GET串）<br/>&nbsp;&nbsp;&nbsp;&nbsp; public function page(ByVal showPageC)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dim i,l,starF,endF,reStr,getStr,queryStr<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; queryStr=filterGET(&#34;curp,mmax&#34;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;*****************************************************<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if queryStr=&#34;&#34; then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=&#34;curp=1&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=queryStr &amp; &#34;&amp;curp=1&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if curp&gt;1 then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;a href=&#34;&#34;?&#34; &amp; getStr &amp; &#34;&#34;&#34; target=_self class=page&gt;首页&lt;/a&gt; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;font color=#CCCCCC&gt;首页&lt;/font&gt; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;*****************************************************<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if queryStr=&#34;&#34; then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=&#34;curp=&#34; &amp; (curp-1)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=queryStr &amp; &#34;&amp;curp=&#34; &amp; (curp-1)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if curp&gt;1 then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;a href=&#34;&#34;?&#34; &amp; getStr &amp; &#34;&#34;&#34; target=_self class=page&gt;上页&lt;/a&gt; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;font color=#CCCCCC&gt;上页&lt;/font&gt; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;*****************************************************<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if queryStr=&#34;&#34; then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=&#34;curp=&#34; &amp; (curp+1)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=queryStr &amp; &#34;&amp;curp=&#34; &amp; (curp+1)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if curp&lt;coup then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;a href=&#34;&#34;?&#34; &amp; getStr &amp; &#34;&#34;&#34; target=_self class=page&gt;下页&lt;/a&gt; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;font color=#CCCCCC&gt;下页&lt;/font&gt; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;*****************************************************<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if queryStr=&#34;&#34; then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=&#34;curp=&#34; &amp; coup<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=queryStr &amp; &#34;&amp;curp=&#34; &amp; coup<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if curp&lt;coup then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;a href=&#34;&#34;?&#34; &amp; getStr &amp; &#34;&#34;&#34; target=_self class=page&gt;末页&lt;/a&gt; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;font color=#CCCCCC&gt;末页&lt;/font&gt; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;*****************************************************<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if queryStr=&#34;&#34; then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=&#34;curp=&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=queryStr &amp; &#34;&amp;curp=&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;跳转：&lt;input type=text value=&#34; &amp; curp &amp; &#34; size=4 onkeyup=&#34;&#34;this.value=this.value.replace(/[^\d]/ig,&#39;&#39;);if(this.value&gt;&#34; &amp; coup &amp; &#34;)this.value=&#34; &amp; coup &amp;&#34;;&#34;&#34; onblur=&#34;&#34;this.onkeyup();&#34;&#34; onchange=&#34;&#34;this.onkeyup();&#34;&#34; onkeydown=&#34;&#34;if(event.keyCode==13)location.href=&#39;?&#34; &amp; getStr &amp; &#34;&#39;+this.value;&#34;&#34;&gt; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;span class=green&gt;　&#34; &amp; curp &amp; &#34;/&#34; &amp; coup &amp; &#34;　&#34; &amp; psize &amp; &#34;/页&lt;/span&gt; 合计:&#34; &amp; size &amp; &#34; &#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=filterGET(&#34;psize&#34;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if getStr=&#34;&#34; then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=&#34;psize=&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getStr=getStr &amp; &#34;&amp;psize=&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;页长：&lt;input type=text value=&#34; &amp; psize &amp; &#34; size=4 onkeyup=&#34;&#34;this.value=this.value.replace(/[^\d]/ig,&#39;&#39;);&#34;&#34; onblur=&#34;&#34;this.onkeyup();&#34;&#34; onchange=&#34;&#34;this.onkeyup();&#34;&#34; onkeydown=&#34;&#34;if(event.keyCode==13)location.href=&#39;?&#34; &amp; getStr &amp; &#34;&#39;+this.value;&#34;&#34;&gt;&#34; &amp; &#34;&lt;br&gt;&lt;br&gt;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;*****************************************************<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; const DOT=&#34;&lt;span style=cursor:hand;&gt;..&lt;/span&gt;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if showPageC=0 then showPageC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l=showPageC\2<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if curp-l&lt;=1 then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; starF=1<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; starF=curp-l<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; DOT<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; endF=starF+showPageC<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;script language=javascript&gt;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;var getStr;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;for(var i=&#34;&amp;starF&amp;&#34;;i&lt;=&#34;&amp;endF&amp;&#34; &amp;&amp; i&lt;=&#34;&amp;coup&amp;&#34;;i++) {&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&#39;&#34;&amp;queryStr&amp;&#34;&#39;==&#39;&#39;) getStr=&#39;curp=&#39;+i;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else getStr=&#39;&#34;&amp;queryStr&amp;&#34;&#39;+&#39;&amp;curp=&#39;+i;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(i!=&#34;&amp;curp&amp;&#34;) document.write(&#39;&lt;a href=&#34;&#34;?&#39;+getStr+&#39;&#34;&#34; target=_self class=page&gt;[&#39;+i+&#39;]&lt;/a&gt; &#39;);&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else document.write(&#39;&lt;b&gt;&lt;font color=#CC9933&gt;[&#39;+i+&#39;]&lt;/a&gt;&lt;/b&gt; &#39;);&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;}&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reStr=reStr &amp; &#34;&lt;/script&gt;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if endF&lt;coup then reStr=reStr &amp; DOT<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;*****************************************************<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; page=reStr<br/>&nbsp;&nbsp;&nbsp;&nbsp; end function<br/>End Class<br/><br/><br/><br/>dim con<br/>set con=server.cr&#101;ateobject(&#34;adodb.connection&#34;)<br/>con.open &#34;Provider=SQLOLEDB.1;Password=****;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=(local)&#34;<br/><br/>dim forxml<br/>set forxml=new Cls_ForXml_Page<br/>response.write(forxml.getXml(con,&#34;sel&#101;ct ID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued from Products wh&#101;re 1=1&#34;,&#34;xml1&#34;))<br/>%&gt;<br/>&lt;div id=&#34;top_page&#34;&gt;&lt;%=forxml.page(10)%&gt;&lt;/div&gt;<br/>&lt;%<br/>set forxml=nothing<br/>set con=nothing<br/>%&gt;<br/><br/><br/>&lt;table width=&#34;100%&#34;&nbsp;&nbsp;border=&#34;0&#34; align=&#34;center&#34; cellpadding=&#34;0&#34; cellspacing=&#34;0&#34;&gt;<br/>&nbsp;&nbsp;&lt;tr&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&lt;td bgcolor=&#34;#CCCCCC&#34;&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp; &lt;table width=&#34;100%&#34; datasrc=&#34;#xml1&#34; border=&#34;0&#34; cellspacing=&#34;1&#34; cellpadding=&#34;3&#34;&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;thead&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;6%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;编号&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;29%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;名称&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;6%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;编号1&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;6%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;编号2&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;23%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;单元1&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;8%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;价格&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;5%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;单元2&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;5%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;单元3&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;7%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;记录等级&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;th width=&#34;4%&#34; bgcolor=&#34;#FF9933&#34;&gt;&lt;span style=&#34;color: #FFFFFF&#34;&gt;未知&lt;/span&gt;&lt;/th&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/thead&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr bgcolor=&#34;#FFFFFF&#34;&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;ID&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;ProductName&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;SupplierID&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;CategoryID&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;QuantityPerUnit&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;UnitPrice&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;UnitsInStock&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;UnitsOnOrder&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;ReorderLevel&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;div datafld=&#34;Discontinued&#34; /&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&lt;/table&gt;&lt;/td&gt;<br/>&nbsp;&nbsp;&lt;/tr&gt;<br/>&lt;/table&gt;<br/>&lt;div id=&#34;bot_page&#34;&gt;&lt;/div&gt;<br/>&lt;script&gt;document.getElementById(&#34;bot_page&#34;).innerHTML=document.getElementById(&#34;top_page&#34;).innerHTML;&lt;/script&gt;<br/>&lt;style type=&#34;text/css&#34;&gt;<br/>&lt;!--<br/>body,table,td {<br/>&nbsp;&nbsp;&nbsp;&nbsp; font-size:9pt;<br/>}<br/>#top_page,#bot_page {<br/>&nbsp;&nbsp;&nbsp;&nbsp; background-color: #F0F0F0;<br/>&nbsp;&nbsp;&nbsp;&nbsp; border: 1px dashed #FF9933;<br/>}<br/>--&gt;<br/>&lt;/style&gt;<br/>&lt;%t2=timer()%&gt;<br/>&lt;br&gt;<br/>&lt;div align=&#34;center&#34;&gt;&lt;%=round((t2-t1)*1000,3)%&gt;&lt;/div&gt;]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=712" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=712</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[微软绝密COFEE泄露，可绕过所有Windows安全措施]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=2" label="计算机技术" /> 
	  <updated>2010-01-23T13:39:07+08:00</updated>
	  <published>2010-01-23T13:39:07+08:00</published>
		  <summary type="html"><![CDATA[<br/>据CrunchGear报道，<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>的一款名为COFEE的工具近日已经泄漏到网上，对于很多人来说这是一款非常陌生的<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>产品，这是<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>向国际刑警组织免费提供的证据提取工具，并不面向普通用户推广。<br/><br/>COFEE全称为“计算机在线法庭科学证据提取器（Computer Online Forensic Evidence Extractor）”，<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>是这样描述的COFEE的：“有了COFEE，没有合适的计算机取证能力的执法机构也可以轻松、可靠而且高效地收集现场证据。一个只有最基础的计算机知识的人也可以在不超过10分钟的时间里学会如何使用配置好的COFEE设备，执法人员可以像专家一样收集重要的犯罪证据，其复杂程度就像将USB插入计算机那样。”<br/><br/>简单地说，COFEE就是一种是形似U盘的提取工具，COFEE包含了超过150个信息收集、密码破解、网络嗅探等工具，可以快速绕过所有Windows的安全措施，并破解系统密码、显示网络浏览的历史，对电脑系统进行深入地搜索来获取证据。<br/><br/>对于普通用户来说COFEE并没有太大用处而且也不适合使用，考虑诸多因素<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>并没有公开发布COFEE，然而近日它却泄露到了网上，大小约为15MB。<br/>引用:<br/><br/>COFEE全称为“计算机在线法庭科学证据提取器（Computer Online Forensic EvidenceExtractor）”，<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>是这样描述的COFEE的：“有了COFEE，没有合适的计算机取证能力的执法机构可以轻松、可靠而且高效地收集现场证据。一个只有最基础的计算机知识的人也可以在不超过10分钟的时间里学会如何使用配置好的COFEE设备，执法人员可以像专家一样收集重要的犯罪证据，其复杂程度就像将USB插入计算机那样。”<br/><br/>简单地说，COFEE就是一种是形似U盘的提取工具，COFEE包含了超过150个信息收集、密码破解、网络嗅探等工具，可以快速绕过所有Windows的安全措施，并破解系统密码、显示网络浏览的历史，对电脑系统进行深入地搜索来获取证据。<br/><br/>　　计算机在线法证提取工具（Computer Online Forensic Evidence Extractor，缩写为COFEE）是<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>基于与国际刑警组织所签订的许可协议，为国际刑警组织所免费开发的一款在线Windows计算机系统犯罪证据提取工具。该工具包括英文、法文、德文、中文、俄罗斯文五个语言版本，于2008年交付给国际刑警组织，允许国际刑警组织187个成员国的政府相关执法人员使用（包括中国）。<br/><br/>　　近日，该工具被泄露到互联网上，部分中文站点在翻译转载说明时，过分夸大事实，例如以下新闻内容：<br/><br/>　　“据CrunchGear报道，<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>的一款名为COFEE的工具近日已经泄漏到网上，对于很多人来说这是一款非常陌生的<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>产品，这是<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>向国际刑警组织免费提供的证据提取工具，并不面向普通用户推广。COFEE全称为”计算机在线法庭科学证据提取器（Computer Online Forensic Evidence Extractor）“，<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>是这样描述的COFEE的：<br/><br/>　　”有了COFEE，没有合适的计算机取证能力的执法机构可以轻松、可靠而且高效地收集现场证据。一个只有最基础的计算机知识的人也可以在不超过10分钟的时间里学会如何使用配置好的COFEE设备，执法人员可以像专家一样收集重要的犯罪证据，其复杂程度就像将USB插入计算机那样。“<br/><br/>　　简单地说，COFEE就是一种是形似U盘的提取工具，COFEE包含了超过150个信息收集、密码破解、网络嗅探等工具，可以快速绕过所有Windows的安全措施，并破解系统密码、显示网络浏览的历史，对电脑系统进行深入地搜索来获取证据。<br/><br/>　　对于普通用户来说COFEE并没有太大用处而且也不适合使用，考虑诸多因素<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>并没有公开发布COFEE，然而近日它却泄露到了网上，大小约为15MB。”<br/><br/>　　导致多个用户/同事致电询问此事，认为<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> 微软</a>在 Windows 系统中留有后门/漏洞，对 Windows 系统的安全性提出质疑。<br/><br/>　　为了避免潜在的对于 Windows 系统后门/漏洞/安全性的质疑，在此进行COFEE的澄清说明：<br/><br/>　　1、 COFEE仅搜集计算机法证所用的相关信息，例如系统信息、用户信息、网络通讯信息等，本身力求保证原系统的完整性与数据精确性，不会对操作系统进行任何的破坏；<br/><br/>　　2、 COFEE本身为一系列Windows resource kit/<a href="http://www.microsoft.com/china/homepage/ms.htm" target="_blank"><img src="http://www.Fuckadmin.com/Blog/images/keywords/microsoft.gif" border="0" alt=""/> Microsoft</a> sysinternal tools工具的集合，所调用的工具，均可以从Internet上公开下载；<br/><br/>　　3、 COFEE在执行取证操作时，同样严格遵守操作系统的访问控制与进程操作，并非基于系统的漏洞或后门；<br/><br/>　　4、 COFEE不能破解Bitlock/EFS加密的数据信息；<br/><br/>　　5、 目前COFEE官方支持的操作系统为 Windows XP，但是同样可以在其他 Windows 操作系统上运行。<br/><br/>　　6、 关于 COFEE 搜集的信息，可以参考附件中的完整的样本输出报告。<br/><br/>　　7、 其他信息，可以参考附件中的。<br/><br/><br/><br/><br/>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=711" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=711</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[[下载]  清华大学计算机网络课程（11G）]]></title>
	  <author>
		 <name>hkylin</name>
		 <uri>http://www.Fuckadmin.com/Blog/</uri>
		 <email>x14071z1@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.Fuckadmin.com/Blog/default.asp?cateID=2" label="计算机技术" /> 
	  <updated>2010-01-23T13:16:27+08:00</updated>
	  <published>2010-01-23T13:16:27+08:00</published>
		  <summary type="html"><![CDATA[<p><strong>清华大学计算机系网络课程列表</strong> <br />
序号　 课程名称　 <br />
GD_jsj_001b　微型计算机技术　 <br />
GD_jsj_002b　数据结构　 <br />
GD_jsj_003b　人工智能导论　 <br />
GD_jsj_004b　信号处理原理　 <br />
GD_jsj_005b　多媒体计算机技术基础及应用 <br />
GD_jsj_006b　软件工程 <br />
GD_jsj_007b　计算机组成与结构 <br />
GD_jsj_008b　JAVA编程语言 <br />
GD_jsj_009b　编译原理 <br />
GD_jsj_010b　数据库系统及应用 <br />
GD_jsj_011b　虚拟现实与系统仿真 <br />
GD_jsj_012b　离散数学 <br />
GD_jsj_013b　数据库系统概论 <br />
GD_jsj_014b　MPI并行程序设计 <br />
GD_jsj_015b　计算机原理 <br />
GD_jsj_016b　模式识别 <br />
GD_jsj_017b　数字系统设计自动化 <br />
GD_jsj_018b　计算机系统结构 <br />
GD_jsj_019b　汇编语言程序设计 <br />
GD_jsj_020b　C++语言程序设计 <br />
GD_jsj_021y　计算机系统结构 <br />
GD_jsj_022y　计算机网络体系结构 <br />
GD_jsj_023y　数值分析 <br />
GD_jsj_024y　软件工程 <br />
GD_jsj_025y　组合数学 <br />
GD_jsj_026y　人工智能原理 <br />
GD_jsj_027y　计算机图形学 <br />
GD_jsj_028y　人工智能原理 <br />
GD_jsj_029y　工程数据库设计与应用 <br />
GD_jsj_030y　宽带网络交换技术 <br />
GD_jsj_031y　并行计算<br />
<span id="att_985109"><br />
<img title="Click Here To EnLarge" onclick=" window.open('http://bbs.crsky.com/1236983883/Mon_0908/123_166760_268f798025a83f8.jpg');" border="0" src="http://bbs.crsky.com/1236983883/thumb/Mon_0908/123_166760_268f798025a83f8.jpg" onload="if(this.width&gt;'700')this.width='700';" alt="" /></span><br />
<span id="att_985110"><br />
<img title="Click Here To EnLarge" onclick=" window.open('http://bbs.crsky.com/1236983883/Mon_0908/123_166760_4426d1f08da05bb.jpg');" border="0" src="http://bbs.crsky.com/1236983883/thumb/Mon_0908/123_166760_4426d1f08da05bb.jpg" onload="if(this.width&gt;'700')this.width='700';" alt="" /></span><br />
<span id="att_985111"><br />
<img title="Click Here To EnLarge" onclick=" window.open('http://bbs.crsky.com/1236983883/Mon_0908/123_166760_9c98693d1af82d4.jpg');" border="0" src="http://bbs.crsky.com/1236983883/thumb/Mon_0908/123_166760_9c98693d1af82d4.jpg" onload="if(this.width&gt;'700')this.width='700';" alt="" /></span><br />
<span id="att_985112"><br />
<img title="Click Here To EnLarge" onclick=" window.open('http://bbs.crsky.com/1236983883/Mon_0908/123_166760_28a39ca8bf9ea44.jpg');" border="0" src="http://bbs.crsky.com/1236983883/thumb/Mon_0908/123_166760_28a39ca8bf9ea44.jpg" onload="if(this.width&gt;'700')this.width='700';" alt="" /></span></p>
<p><span>下载种子:</span></p>
<p><span><a href="http://fuckadmin.com/blog/attachments/month_1001/s2010123131625.torrent"><img border="0" alt="" style="margin: 0px 2px -4px 0px" src="http://www.Fuckadmin.com/Blog/../../images/download.gif" />点击下载此文件</a></span></p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.Fuckadmin.com/Blog/article.asp?id=710" /> 
	  <id>http://www.Fuckadmin.com/Blog/default.asp?id=710</id>
  </entry>	
		
</feed>
