asp の RecordSet オブジェクトを使用した JScript での GetRows

' code by xujiwei
' http://www.xujiwei.cn/
' Define variables
Dim conn,rs,data,recN,i
' Connect to the database
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &_
    Server.MapPath("data.mdb")
' Get the recordset
Set rs=conn.Execute("SELECT id,first,second FROM mytable")
' Get an array of data
data=rs.GetRows()
' Close the recordset and free the object
rs.Close()
Set rs=Nothing
' Get the number of records
recN=UBound(data,2)
' Loop through the output data
For i=0 To recN
    ' Note that the array subscript starts at 0
    ' Display the data in the database
    Response.Write("ID: "&data(0,i)&", First: "&data(1,i)&_
        ", Second: "&data(2,i)&"<br />")
Next
' Close the database connection and release the object
conn.Close()
Set conn=Nothing
%>

<script language="JScript" runat="server">
// code by xujiwei
// http://www.xujiwei.cn/
// Define variables
var conn,rs,vdata,data,recN,i;
// Connect to the database
conn=Server.CreateObject("ADODB.Connection");
conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+
    Server.MapPath("data.mdb"));
// Get the recordset
rs=conn.Execute("SELECT id,first,second FROM test");
// Get an array of data and convert it to an array type available in JScript
vdata=rs.GetRows().toArray();
// Get the number of fields in the data table
i=rs.Fields.Count;
// Close the recordset and free the object
rs.Close();
rs=null;
// Convert the array
data=transArray(vdata,i);
// Get the number of records
recN=data.length;
// Loop through the output data
for(i=0;i<recN;i++) {
    // Note that the array subscript starts at 0
    // Display the data in the database
    Response.Write("ID: "+data[i][0]+", First: "+data[i][1]+
        ", Second: "+data[i][2]+"<br />");
}
// Close the database connection and release the object
conn.Close();
conn=null;
// Array conversion functions
// by xujiwei
// Parameters: arr - the array of objects obtained by the GetRows method using the toArray method
// fieldslen - the number of fields in the data table
function transArray(arr,fieldslen) {
    var len=arr.length/fieldslen,data=[],sp;
    for(var i=0;i<len;i++) {
        data[i]=new Array();
        sp=i*fieldslen;
        for(var j=0;j<fieldslen;j++)
            data[i][j]=arr[sp+j];
    }
    return data;
}
</script>