繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > javascript asp教程Recordset记录
- ASP
- 在Vista IIS 7 中用 vs2005 调试 Web 项目的注意事项
- ASP保存远程图片到本地 同时取得第一张图片并创建缩略图的代码
- ASP运行在IIS6 500错误解决办法
- ASP 精华源码收集（五年总结）
- ASP分页类(支持多风格变换)
- 动网论坛验证码改进 加法验证码(ASPJpeg版)
- asp 存储过程分页代码
- asp select下拉菜单选择图标并实时显示
- aspjpeg组件通用加水印函数代码
- aspjpeg 添加水印教程及生成缩略图教程
- ASP 根据用户权限判断显示的列标题
- asp 批量删除选中的多条记录
- asp 隐藏并修改文件的最后修改时间
- Discuz!NT 论坛整合ASP程序论坛教程
- ajax+asp无限级分类树型结构(带数据库)
- asp 由动态网页转变为静态网页的实现代码
- 通过表单的做为二进制文件上传request.totalbytes提取出上传的二级制数据
- ASP 使用三层架构 asp中使用类
- ASP GetRef 函数指针试探
- ASP 三层架构 Error处理类
ASP 中的 javascript asp教程Recordset记录
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 235 ::
收藏到网摘: 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
