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.
PHP+Mysql简单实现了图书购物车 本文主要讲述如何通过PHP+HTML简单实现图书购物...
匹配中文字符的正则表达式:[\u4e00-\u9fa5] 评注:匹配中文还真是个头疼的事,...
一、安装Python、Pycharm、Anaconda PyCharm是一款好用且流行的Python编辑器。分...
深入理解Js中的this JavaScript 作用域为静态作用域 static scope ,但是在 Js ...
序、什么是MySQL? MySQL 是一种关系型数据库,在Java企业级开发中非常常用,因为...
前言 git和 svn不同,仅仅跟踪文件的变动,不跟踪目录。所以,一个空目录,如果...
1:readonly是要锁定这个控件,通过在界面上无法修改他(但是通过javascript可以...
这里万万用的是CentOS 7.6的系统推荐使用7以上的系统centos 6.X可能内核老旧安装...
今天,微软发布了Windows 10 Build 21301预览版本更新。该版本中并没有引入太多...
5月21日,被誉为数据库领域世界杯的数据库基准测试TPC-C官网更新了最新结果,支...