JScript 模拟 ADO.NET 基本对象

最新推荐文章于 2026-07-13 15:12:15 发布

原创最新推荐文章于 2026-07-13 15:12:15 发布 · 1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

脚本技术

此博客主要围绕ASP中ADO.NET模块展开，定义了OLEDBConnection和OLEDBCommand两个类。OLEDBConnection类用于处理数据库连接的打开与关闭，OLEDBCommand类用于执行数据库命令，包含执行查询和非查询操作，还涉及参数设置等功能，同时有错误调试函数。

<%@ Language="JScript" CODEPAGE = "936" %>

<%
/*
ADO.NET Module For ASP

Error:
err.name
err.message
err.description

*/
// OLEDBConnection Class
function OLEDBConnection(strConnection)
{

this.ConnectionString = strConnection;
this.Connection = Server.CreateObject("ADODB.Connection");
this.Connection.ConnectionString = this.ConnectionString;

this.Open = function()
{
    try {
      this.Connection.ConnectionString = this.ConnectionString;
      this.Connection.Open();
    }   catch(err) {
      err.name = "Connection Open Error"
      Debug(err);
    }
}

this.Close = function()
{
    try {
      this.Connection.Close;
    } catch(err) {
      err.name = "Connection Close Error"
      Debug(err);
    }
}

// return this.Connection;
}

// OLEDBCommand Class
function OLEDBCommand(strCommandText, objConnection)
{
this.CommandText = strCommandText;
this.Connection = objConnection;
this.Command = Server.CreateObject("ADODB.Command");
this.Command.CommandType = 8; // adCmdUnknown
this.Command.CommandText = this.CommandText;

this.ExecuteReader = function()
{
    try {
      this.Command.CommandText = this.CommandText;
      this.Command.ActiveConnection = this.Connection.Connection;
      return this.Command.Execute;
    } catch(err) {
      err.name = "ExecuteReader Error"
      Debug(err);
    }
}

this.ExecuteNonQuery = function()
{
    try {
      this.Command.ActiveConnection = this.Connection;
      this.Command.Execute;
    } catch(err) {
      err.name = "ExecuteNonQuery Error"
      Debug(err);
    }
}
// prototype: Parameters
this.Parameters = function(strParametersName,strParametersValue)
{

    this.Parameters.Name = strParametersName;
    this.Parameters.Value = strParametersValue;
    if ((this.Parameters.Name) && (this.Parameters.Value)) {
      this.Command.Parameters(this.Parameters.Name) = this.Parameters.Value;
    }
}
// prototype: AddParameters
this.CreateParameters = function(strParametersName, intParametersType, intParametersDirection, intParametersSize, strParametersValue)
{
    this.Parameters.Name = strParametersName;
    this.Parameters.Type = intParametersType;
    this.Parameters.Direction = intParametersDirection;
    this.Parameters.Size = intParametersSize;
    this.Parameters.Value = strParametersValue;
    this.Command.Parameters.Append(this.Command.CreateParameter(this.Parameters.Name, this.Parameters.Type, this.Parameters.Direction, this.Parameters.Size, this.Parameters.Value));
}

function Debug(err)
{
    Response.Write (err.name);
    Response.Write ("<br>")
    Response.Write (err.description);
    Response.End
}
// return this.Command
}
%>