繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > javascript asp教程More About Recordsets
- ASP
- ASP实例:读取xml文件的程序
- asp实现rar压缩和解压缩源代码
- 关于ASP中脚本执行顺序的讲解
- 用asp程序读取网站的alexa世界排名
- 初学ASP编程易犯的一个错误要注意
- ASP实现SQL语句日期格式的加减运算
- 通过启动脚本来感受ASP的力量
- ASP SCRIPT: 计数器(使用GrapShot组件)
- 学以致用 驳“ASP低能论”
- ASP分页显示Recordset数据
- ASP编程代码：隐藏图片的真实地址
- ASP网站Server object error的解决办法
- 用ASP对网页进行限制性的访问
- 把网页中的电话号码生成图片的ASP程序
- ASP实现文件直接下载
- 用ASP显示ACCESS数据库的的GIF图象
- ASP分页和日期格式化为RFC822格式的办法
- 实例：ASP与ACCESS链接
- ASP程序直接连接MYSQL数据库
- ASP连接MSSQL的错误: 拒绝访问
ASP 中的 javascript asp教程More About Recordsets
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 102 ::
收藏到网摘: n/a
Below we will attempt to access data from a database without knowing the column names. Clearly the best way to utilize data in your database is to keep track of your schema. Schema is the layout of data in your database. The concept is well beyond the scope of this web site, but it is worth mentioning. Most good resources on SQL will also be good resources on database management. Better database schema leads to better ASP code.
Get Started:
Below is the script for Lesson 18.
<%@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 * FROM colorChart;";
ConnectObj.Open (myConnect);
RS.Open(sql,ConnectObj,adOpenForwardOnly,adLockReadOnly,adCmdText);
var recordCount = RS.Fields.Count;
var x = 0;
var getFieldNames = false;
Response.Write("<TABLE BORDER=\"1\" CELLSPACING=\"0\">\r");
while (!RS.EOF) { if (x >= recordCount) { x = 0 } Response.Write("<TR>"); if (!getFieldNames) { while (x <= recordCount-1) { Response.Write("<TH>" + RS.Fields(x).Name + "</TH>"); x++; } getFieldNames = true; x = 0; Response.Write("</TR>\r<TR>") } while (x <= recordCount-1) { Response.Write("<TD>" + RS.Fields(x).Value + "</TD>"); x++; } Response.Write("</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.
I don't think this needs much explaining. The
Another Way:
A potentially more elegant way to accomplish this same goal is to use the ADO Method GetRows. It returns a multi-dimensional array containing the Recordset data. WAIT! Aren't JavaScript Arrays lexical (and flat)? Yes. We can emulate multi-dimensional arrays, but in reality they are flat. So it's a no-go on the GetRows... unless we do something really creative.
<%@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 * FROM colorChart;";
ConnectObj.Open (myConnect);
RS.Open(sql,ConnectObj,adOpenForwardOnly,adLockReadOnly,adCmdText);
var myArray = RS.GetRows().toArray();
Response.Write("Let's see the results of myArray as JavaScript");
Response.Write(" sees them (which is flat).<BR>\r");
Response.Write(myArray + "<BR><BR>\r")
RS.MoveFirst();
var myVBArray = new VBArray(RS.GetRows())
Response.Write("We can use the <I>new VBArray</I> constructor and the ")
Response.Write("<I>getItem( )</I> method. For example: myVBArray.getItem(1,1) ")
Response.Write("returns " + myVBArray.getItem(1,1) + "<BR><BR>\r")
Response.Write("Now lets make something useful.<BR>\r")
Response.Write("<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0>")
Response.Write("\r<TR>")
for (var x=0; x<=myArray.length-1; x++) { Response.Write("<TD>" + myArray[x] + "</TD>") if ((x+1)%RS.Fields.Count==0) { Response.Write("</TR>\r<TR>") } }
Response.Write("</TR>\r")
Response.Write("</TABLE>")
RS.Close();
RS = null;
ConnectObj.Close();
ConnectObj = null;
%>
</BODY>
</HTML>
Click Here to run the script in a new window.
Notice when we use getRows( ) we don't get the column names (but that would be really easy to fix). The problem with myArray is that it's not very useful in its raw state. So we use a modulo operator and thanks to a little thing called RS.Fields.Count we can tell how many times we write data to the table before staring a new table row.
If you like the new VBArray constructor you should know that you have the following methods: dimensions() getItem() lbound() toArray() and ubound().
评论 (0) All
