繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > javascript asp教程Recordset记录
- ASP
- 一种比较方便的ASP分页程序
- 用一套论坛程序架设多个论坛
- ASP与ASP.NET在COOKIE方面的区别
- 较长数据无法在Asp页面中取出的三种解决方法
- 初试WAP之wml＋ASP查询
- 动态网站首页的静态生成方法
- 使用正则表达式实现模式图片新闻.ASP
- 让你的WAP网站有更好的兼容性
- WAP版的手机号码所在地查询
- asp模仿 Lotus Notes 的界面程序
- ORACLE920与ASP的连接问题的解决办法
- 利用SQLSERVER存储过程实现ASP用户身份验证
- 在ASP中自动创建多级文件夹的函数(使用FSO)
- 利用instr()函数防止SQL注入攻击
- 利用XSL和ASP实现XML文档在线编辑
- 表单对象textarea内容的格式控制（回车、换行、空格）
- 针对select写了一个通用的option输出函数
- ASP无组件BMP汉字生成类+汉字点阵库
- 时间、空间性能极优的asp无组件上传类
- 无组件生成BMP验证码
ASP 中的 javascript asp教程Recordset记录
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 178 ::
收藏到网摘: n/a
Recordset is another created/instanciated Object. It is a collection of data taken from a database. Recordset has 26 properties, 25 methods, 11 events, and two (2) collections. The vast majority of Recordset is beyond the scope of this web site.
Quick Aside:
The database we are using for lesson 16 and lesson 17 is an MS Access 2000 file (not the best database for large sites). The file is called htmlColor.mdb and it has a single Table called colorChart. The database Table has three columns and they are called ID, colorName, and hexValue.
The illustration below shows how we will cycle through these records.
|
|
|
In this example we cycle through the records row by row. We will use the MoveNext() Method to go from record #1 to #2, etc. Then, we will access specific data in each row by using the column name.
Get Started:
Below is the script for Lesson 17. It's exactly the same as the script for lesson 16. The difference is that we will focus on those lines of code that deal with Recordsets.
<%@LANGUAGE="JavaScript"%>
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
<HTML>
<BODY>
<%
var myConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";
myConnect += Server.MapPath("\\");
myConnect += "\\GlobalScripts\\htmlColor.mdb;";
var ConnectObj = Server.CreateObject("ADODB.Connection");
var RS = Server.CreateObject("ADODB.Recordset");
var sql="SELECT ID, colorName, hexValue FROM colorChart;";
ConnectObj.Open (myConnect);
RS.Open(sql,ConnectObj,adOpenForwardOnly,adLockReadOnly,adCmdText);
Response.Write("<TABLE BORDER=\"1\" CELLSPACING=\"0\">\r");
Response.Write("<TR><TH>ID</TH><TH>colorName</TH>");
Response.Write("<TH>hexValue</TH></TR>\r");
while (!RS.EOF) { Response.Write("<TR><TD>" +RS("ID")+ "</TD><TD BGCOLOR=\"#"); Response.Write( RS("hexValue")+ "\">" + RS("colorName") ); Response.Write("</TD><TD>" +RS("hexValue")+ "</TD></TR>\r"); RS.MoveNext(); }
Response.Write("</TABLE>\r");
RS.Close();
ConnectObj.Close();
RS = null;
ConnectObj = null;
%>
</BODY>
</HTML>
Click Here to run the script in a new window.
The DLL:
We'll dissect the Recordset statements from top to bottom. In this case that means starting with the Dynamic Link Library.
<!-- METADATA TYPE="typelib" FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
What in the world is a DLL? A Dynamic Link Library holds values without tying up memory. Here's how it works. If you try to use a variable that is undefined, ASP will first look it up in the DLL. You'll notice in the
Managing the Recordset:
First we must instanciate a Recordset, which we do in the little snippet below.
var RS = Server.CreateObject("ADODB.Recordset");
Next we create a Text Command. The text in question comes in the form of S.Q.L. (Structured Query Language). SQL is beyond the scope of this web site, but the command below means select ID, colorName and hexValue from the colorChart Table.
var sql="SELECT ID, colorName, hexValue FROM colorChart;";
Then we open the Recordset. The five arguments in order are: source, connection, cursor type, lock type, and options .
RS.Open(sql,ConnectObj,adOpenForwardOnly,adLockReadOnly,adCmdText);
Using a loop, we tell ASP to do certain things for as long as we haven't hit EOF, which means End of File.
while (!RS.EOF)
Next, we access specific collums in the Recordset by name.
Response.Write( RS("hexValue") + "\">" + RS("colorName") );
Then we move down from one row of records to the next.
RS.MoveNext();
Finally, when we reach EOF, the loop relinquishes control and we can close the Recordset Object.
RS.Close();
The Rest of The Story:
This is by no means a complete lesson on Recordsets; it wasn't meant to be. The rest of the story on Recordsets is out there, on the internet, and in books. There is one other thing we have to talk about with Recordsets. We do that in lesson 18.
评论 (0) All
