{"id":208,"date":"2007-03-11T17:34:02","date_gmt":"2007-03-11T09:34:02","guid":{"rendered":"http:\/\/www.xujiwei.com\/blog\/?p=208"},"modified":"2010-01-29T21:13:10","modified_gmt":"2010-01-29T13:13:10","slug":"use-getrows-of-recordset-in-jscript","status":"publish","type":"post","link":"https:\/\/xujiwei.com\/blog\/2007\/03\/use-getrows-of-recordset-in-jscript\/","title":{"rendered":"[ASP] \u5728JScript\u4e2d\u4f7f\u7528RecordSet\u5bf9\u8c61\u7684GetRows\u65b9\u6cd5"},"content":{"rendered":"<p>\u5199ASP\u7a0b\u5e8f\u65f6\uff0c\u4e00\u822c\u60c5\u51b5\u603b\u662f\u4f7f\u7528\u7684VBScript\uff0c\u4e0d\u8fc7\u4e5f\u4e0d\u53ea\u662f\u8fd9\u4e00\u79cd\u9009\u62e9\uff0c\u4e5f\u53ef\u4ee5\u7528JScript\u3002\u4f46\u5728\u7528JScript\u4f5c\u4e3aASP\u7684\u8bed\u8a00\u65f6\uff0c\u6bd4\u7528VBScript\u6709\u4e00\u4e9b\u5c0f\u5c0f\u7684\u4e0d\u65b9\u4fbf\uff0c\u6bd4\u5982RecordSet\u7684GetRows\u65b9\u6cd5\u3002<\/p>\n<p>\u5728ASP\u4e2d\u64cd\u4f5c\u6570\u636e\u5e93\uff0c\u4e00\u822c\u90fd\u8981\u7528\u5230RecordSet\u5bf9\u8c61\uff0c\u5982\u679c\u6ce8\u91cd\u7a0b\u5e8f\u6548\u7387\u7684\u8bdd\uff0c\u53ef\u80fd\u5c31\u4f1a\u7528\u5230RecordSet\u5bf9\u8c61\u7684GetRows\u65b9\u6cd5\uff0c\u628a\u8bb0\u5f55\u96c6\u5bf9\u8c61\u8f6c\u6362\u6210\u6570\u7ec4\uff0c\u800c\u64cd\u4f5c\u6570\u7ec4\u5728\u901f\u5ea6\u4e0a\u5c06\u6bd4\u7528RecordSet\u5bf9\u8c61\u7684MoveNext\u65b9\u6cd5\u5feb\u5f88\u591a\uff0c\u800c\u4e14\u53ef\u4ee5\u5728\u53d6\u51fa\u6570\u7ec4\u540e\u5c3d\u65e9\u91ca\u653eRecordSet\u5bf9\u8c61\uff0c\u4ece\u800c\u51cf\u5c11\u8d44\u6e90\u7684\u5360\u7528\uff0c\u8fd9\u4e5f\u662f\u4f18\u5316ASP\u6027\u80fd\u7684\u4e00\u4e2a\u65b9\u6cd5\u3002<\/p>\n<p>\u5728VBScript\u91cc\uff0c\u7528RecordSet.GetRows\u65b9\u6cd5\u53d6\u5230\u7684\u662f\u4e00\u4e2a\u4e8c\u7ef4\u6570\u7ec4\uff0c\u91cc\u9762\u7684\u6570\u636e\u53ef\u4ee5\u901a\u8fc7\u904d\u5386\u6570\u7ec4\u7684\u65b9\u5f0f\u6765\u53d6\u5f97\u3002<\/p>\n<p>\u5047\u8bbe\u73b0\u5728\u6709\u4e00\u4e2a\u6570\u636e\u5e93\uff0c\u5176\u4e2d\u6709\u4e00\u4e2a\u8868\u540d\u4e3amytable\uff0c\u67093\u4e2a\u5b57\u6bb5\uff0c\u540d\u79f0\u5206\u522b\u4e3aid,first,second\u3002<\/p>\n<div class=\"codeHead\">\u7a0b\u5e8f\u4ee3\u7801\uff1a<a href=\"javascript:CopyText($('CODE_5441'));\">[ \u590d\u5236\u4ee3\u7801\u5230\u526a\u8d34\u677f ]<\/a><\/div>\n<div id=\"CODE_5441\" class=\"codeMain\">\n<ul>\n<li>'\u00a0code\u00a0by\u00a0xujiwei<\/li>\n<li>'\u00a0<a rel=\"external\" href=\"http:\/\/www.xujiwei.cn\/\">http:\/\/www.xujiwei.cn\/<\/a><\/li>\n<li>'\u00a0\u5b9a\u4e49\u53d8\u91cf<\/li>\n<li>Dim\u00a0conn,rs,data,recN,i<\/li>\n<li>'\u00a0\u8fde\u63a5\u6570\u636e\u5e93<\/li>\n<li>Set\u00a0conn=Server.CreateObject(\"ADODB.Connection\")<\/li>\n<li>conn.Open\u00a0\"Provider=Microsoft.Jet.OLEDB.4.0;Data\u00a0Source=\"\u00a0&amp;_<\/li>\n<li> Server.MapPath(\"data.mdb\")<\/li>\n<li>'\u00a0\u83b7\u53d6\u8bb0\u5f55\u96c6<\/li>\n<li>Set\u00a0rs=conn.Execute(\"SELECT\u00a0id,first,second\u00a0FROM\u00a0mytable\")<\/li>\n<li>'\u00a0\u83b7\u53d6\u6570\u636e\u6570\u7ec4<\/li>\n<li>data=rs.GetRows()<\/li>\n<li>'\u00a0\u5173\u95ed\u8bb0\u5f55\u96c6\uff0c\u91ca\u653e\u5bf9\u8c61<\/li>\n<li>rs.Close()<\/li>\n<li>Set\u00a0rs=Nothing<\/li>\n<li>'\u00a0\u83b7\u53d6\u8bb0\u5f55\u6570<\/li>\n<li>recN=UBound(data,2)<\/li>\n<li>'\u00a0\u5faa\u73af\u8f93\u51fa\u6570\u636e<\/li>\n<li>For\u00a0i=0\u00a0To\u00a0recN<\/li>\n<li> '\u00a0\u6ce8\u610f\uff0c\u6570\u7ec4\u4e0b\u6807\u4ece0\u5f00\u59cb<\/li>\n<li> '\u00a0\u663e\u793a\u6570\u636e\u5e93\u4e2d\u6570\u636e<\/li>\n<li> Response.Write(\"ID:\u00a0\"&amp;data(0,i)&amp;\",\u00a0First:\u00a0\"&amp;data(1,i)&amp;_<\/li>\n<li> \",\u00a0Second:\u00a0\"&amp;data(2,i)&amp;\"&lt;br\u00a0\/&gt;\")<\/li>\n<li>Next<\/li>\n<li>'\u00a0\u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u91ca\u653e\u5bf9\u8c61<\/li>\n<li>conn.Close()<\/li>\n<li>Set\u00a0conn=Nothing<\/li>\n<li>%&gt;<\/li>\n<\/ul>\n<\/div>\n<p>\u4f46\u662f\u5728JScript\u4f7f\u7528\u65f6\uff0c\u5c31\u4f1a\u6709\u4e00\u4e2a\u95ee\u9898\uff0c\u90a3\u5c31\u662fJScript\u5e76\u6ca1\u6709\u4e8c\u7ef4\u6570\u7ec4\uff0c\u5982\u679c\u8981\u7528GetRows\u6240\u83b7\u53d6\u7684\u6570\u636e\uff0c\u5fc5\u8981\u5c06\u8fd9\u4e2aVBScript\u4e2d\u7684\u4e8c\u7ef4\u6570\u7ec4\u8f6c\u6362\u6210JScript\u80fd\u8bc6\u522b\u7684\u6570\u7ec4\uff0c\u5373\u5143\u7d20\u4e3a\u6570\u7ec4\u7684\u4e00\u4e2a\u4e00\u7ef4\u6570\u7ec4\u3002<\/p>\n<p>\u5728JScript\u91cc\uff0c\u7528GetRows\u65b9\u6cd5\u83b7\u53d6\u7684\u6570\u7ec4\u6709\u4e00\u4e2atoArray\u65b9\u6cd5\uff0c\u53ef\u4ee5\u8f6c\u6362\u6210JScript\u4e2d\u80fd\u7528\u7684\u6570\u7ec4\uff0c\u4f46\u662f\u8fd9\u4e2a\u6570\u7ec4\u662f\u4e00\u7ef4\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u5982\u679c\u8981\u50cf\u5728VBScript\u4e00\u6837\u4f7f\u7528\u7684\u8bdd\uff0c\u8fd8\u9700\u8981\u6211\u4eec\u81ea\u5df1\u6765\u505a\u8f6c\u6362\u3002<\/p>\n<p>\u67e5\u9605\u4e86MSDN\u53ca\u5728\u7f51\u4e0a\u641c\u7d22\u4e86\u76f8\u5173\u7684\u6587\u7ae0\u4e4b\u540e\uff0c\u6211\u5199\u4e86\u4e00\u4e2a\u6570\u7ec4\u8f6c\u6362\u7684\u51fd\u6570\u7528\u4e8e\u5728JScript\u4e2d\u4f7f\u7528GetRows\u65b9\u6cd5\u3002<\/p>\n<div class=\"codeHead\">\u7a0b\u5e8f\u4ee3\u7801\uff1a<a href=\"javascript:CopyText($('CODE_7422'));\">[ \u590d\u5236\u4ee3\u7801\u5230\u526a\u8d34\u677f ]<\/a><\/div>\n<div id=\"CODE_7422\" class=\"codeMain\">\n<ul>\n<li>&lt;script\u00a0language=\"JScript\"\u00a0runat=\"server\"&gt;<\/li>\n<li>\/\/\u00a0code\u00a0by\u00a0xujiwei<\/li>\n<li>\/\/\u00a0<a rel=\"external\" href=\"http:\/\/www.xujiwei.cn\/\">http:\/\/www.xujiwei.cn\/<\/a><\/li>\n<li>\/\/\u00a0\u5b9a\u4e49\u53d8\u91cf<\/li>\n<li>var\u00a0conn,rs,vdata,data,recN,i;<\/li>\n<li>\/\/\u00a0\u8fde\u63a5\u6570\u636e\u5e93<\/li>\n<li>conn=Server.CreateObject(\"ADODB.Connection\");<\/li>\n<li>conn.Open(\"Provider=Microsoft.Jet.OLEDB.4.0;Data\u00a0Source=\"+<\/li>\n<li> Server.MapPath(\"data.mdb\"));<\/li>\n<li>\/\/\u00a0\u83b7\u53d6\u8bb0\u5f55\u96c6<\/li>\n<li>rs=conn.Execute(\"SELECT\u00a0id,first,second\u00a0FROM\u00a0test\");<\/li>\n<li>\/\/\u00a0\u83b7\u53d6\u6570\u636e\u6570\u7ec4\uff0c\u5e76\u8f6c\u6362\u6210\u4e3aJScript\u4e2d\u53ef\u7528\u7684\u6570\u7ec4\u7c7b\u578b<\/li>\n<li>vdata=rs.GetRows().toArray();<\/li>\n<li>\/\/\u00a0\u83b7\u53d6\u6570\u636e\u8868\u7684\u5b57\u6bb5\u6570<\/li>\n<li>i=rs.Fields.Count;<\/li>\n<li>\/\/\u00a0\u5173\u95ed\u8bb0\u5f55\u96c6\uff0c\u91ca\u653e\u5bf9\u8c61<\/li>\n<li>rs.Close();<\/li>\n<li>rs=null;<\/li>\n<li>\/\/\u00a0\u8f6c\u6362\u6570\u7ec4<\/li>\n<li>data=transArray(vdata,i);<\/li>\n<li>\/\/\u00a0\u83b7\u53d6\u8bb0\u5f55\u6570<\/li>\n<li>recN=data.length;<\/li>\n<li>\/\/\u00a0\u5faa\u73af\u8f93\u51fa\u6570\u636e<\/li>\n<li>for(i=0;i&lt;recN;i++)\u00a0{<\/li>\n<li> \/\/\u00a0\u6ce8\u610f\uff0c\u6570\u7ec4\u4e0b\u6807\u4ece0\u5f00\u59cb<\/li>\n<li> \/\/\u00a0\u663e\u793a\u6570\u636e\u5e93\u4e2d\u6570\u636e<\/li>\n<li> Response.Write(\"ID:\u00a0\"+data[i][0]+\",\u00a0First:\u00a0\"+data[i][1]+<\/li>\n<li> \",\u00a0Second:\u00a0\"+data[i][2]+\"&lt;br\u00a0\/&gt;\");<\/li>\n<li>}<\/li>\n<li>\/\/\u00a0\u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u91ca\u653e\u5bf9\u8c61<\/li>\n<li>conn.Close();<\/li>\n<li>conn=null;<\/li>\n<li>\/\/\u00a0\u6570\u7ec4\u8f6c\u6362\u51fd\u6570<\/li>\n<li>\/\/\u00a0by\u00a0xujiwei<\/li>\n<li>\/\/\u00a0\u53c2\u6570\uff1aarr\u00a0-\u00a0GetRows\u65b9\u6cd5\u5f97\u5230\u7684\u5bf9\u8c61\u7528toArray\u65b9\u6cd5\u5f97\u5230\u7684\u6570\u7ec4<\/li>\n<li>\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0fieldslen\u00a0-\u00a0\u6570\u636e\u8868\u5b57\u6bb5\u6570<\/li>\n<li>function\u00a0transArray(arr,fieldslen)\u00a0{<\/li>\n<li> var\u00a0len=arr.length\/fieldslen,data=[],sp;<\/li>\n<li> for(var\u00a0i=0;i&lt;len;i++)\u00a0{<\/li>\n<li> data[i]=new\u00a0Array();<\/li>\n<li> sp=i*fieldslen;<\/li>\n<li> for(var\u00a0j=0;j&lt;fieldslen;j++)<\/li>\n<li> data[i][j]=arr[sp+j];<\/li>\n<li> }<\/li>\n<li> return\u00a0data;<\/li>\n<li>}<\/li>\n<li>&lt;\/script&gt;<\/li>\n<\/ul>\n<\/div>\n<p>\u5bf9\u4e8e\u4e00\u4e9b\u66f4\u65b0\u9891\u7387\u4e0d\u9ad8\uff0c\u800c\u4f7f\u7528\u6b21\u6570\u6bd4\u8f83\u591a\u7684\u6570\u636e\uff0c\u53ef\u4ee5\u5728\u6210\u529f\u83b7\u53d6\u6570\u636e\u6570\u7ec4\u4e4b\u540e\uff0c\u7528Application\u5bf9\u8c61\u6765\u7f13\u5b58\u8d77\u6765\uff0c\u4ece\u800c\u51cf\u5c11\u5bf9\u6570\u636e\u5e93\u7684\u67e5\u8be2\u6b21\u6570\uff0c\u4e00\u5b9a\u7a0b\u5e8f\u7a0b\u5ea6\u4e0a\u4f18\u5316ASP\u7684\u6027\u80fd\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5199ASP\u7a0b\u5e8f\u65f6\uff0c\u4e00\u822c\u60c5\u51b5\u603b\u662f\u4f7f\u7528\u7684VBScript\uff0c\u4e0d\u8fc7\u4e5f\u4e0d\u53ea\u662f\u8fd9\u4e00\u79cd\u9009\u62e9\uff0c\u4e5f\u53ef &hellip;<\/p>\n<p class=\"read-more\"><a href=\"https:\/\/xujiwei.com\/blog\/2007\/03\/use-getrows-of-recordset-in-jscript\/\">\u7ee7\u7eed\u9605\u8bfb &raquo;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[18,116,109,52],"_links":{"self":[{"href":"https:\/\/xujiwei.com\/blog\/wp-json\/wp\/v2\/posts\/208"}],"collection":[{"href":"https:\/\/xujiwei.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xujiwei.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xujiwei.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/xujiwei.com\/blog\/wp-json\/wp\/v2\/comments?post=208"}],"version-history":[{"count":0,"href":"https:\/\/xujiwei.com\/blog\/wp-json\/wp\/v2\/posts\/208\/revisions"}],"wp:attachment":[{"href":"https:\/\/xujiwei.com\/blog\/wp-json\/wp\/v2\/media?parent=208"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xujiwei.com\/blog\/wp-json\/wp\/v2\/categories?post=208"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xujiwei.com\/blog\/wp-json\/wp\/v2\/tags?post=208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}