Testcomplete Javascript -打印SQL查询的输出

// 创建数据库连接对象
var connection = ADO.CreateADOConnection();

// 设置数据库连接字符串
connection.ConnectionString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=MyDatabase;User ID=MyUser;Password=MyPassword";

// 连接数据库
connection.Open();

// 创建查询对象
var query = ADO.CreateADOQuery();

// 设置查询语句
query.SQL = "SELECT * FROM MyTable";

// 执行查询
query.ActiveConnection = connection;
query.Open();

// 遍历结果集并打印输出
while (!query.EOF) {
    Log.Message(query.FieldByName("ColumnName").Value);
    query.Next();
}

// 关闭查询
query.Close();

function printSQLQueryOutput(queryString) {
    var connection = ADO.CreateADOConnection();
    connection.ConnectionString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=MyDatabase;User ID=MyUser;Password=MyPassword";
    connection.Open();

    var query = ADO.CreateADOQuery();
    query.SQL = queryString;
    query.ActiveConnection = connection;
    query.Open();

    while (!query.EOF) {
        Log.Message(query.FieldByName("ColumnName").Value);
        query.Next();
    }

    query.Close();
}

printSQLQueryOutput("SELECT * FROM MyTable");