Question

急求一篇英文ASP技术问行翻译成中文

Database Connectivity with ASP and ADO

ASP uses a technology called ActiveX Data Objects (ADO) to work with databases. ADO is ActiveX technology which is built into the Internet Information Server (IIS). It is comprised of a number of objects which you can use. I will begin by explaining the "major players" briefly.

There are 3 major objects which you should be aware of in ADO: the Command Object, the Connection Object, and the Recordset object. Most of the time, you will only have to work with the RecordSet object (arguably), but in certain cases, you may want to set properties in (or use) one or both of the other 2 objects. Whenever you perform a database operation, these 3 objects are present, but it isn't necessary often to explicitly create all 3, as when one is used, the other 2 are implicitly created, even though you may not assign a variable to access them. The syntax for creating a variable to access these objects is (in VBScript) "[variable name] = Server.CreateObject("ADODB.[object name]")"

The RecordSet Object

The RecordSet object is basically a cursor (a temporary table which exists in memory) with some built-in functions and properties for working with the records contained in it. You can create a RecordSet object explicitly, or by executing a command through the Command Object.

Some of the properties which you may use frequently are:

BOF - Beginning of file

EOF - End of file

MaxRecords - Maximum number of records returned in a query

RecordCount - The number of records in the RecordSet

CursorType - Forward-only, static,dynamic, and keyset

Some of the methods (functions) of the RecordSet object which you may be most likely to use are:

Open - Open the Recordset

Close - Close the RecordSet

Move - Move to a specific record

MoveFirst - Move to the first record

MoveNext - Move forward one record

Move Previous - Move backwards one record

MoveLast - Move to the last record

AddNew - Add a new record to the RecordSet

Answer 1

数据库连通性以ASP 和骚扰 ASP 使用技术叫做ActiveX Data 对象(骚扰) 运作以数据库。骚扰是被建立入互联网信息服务器的ActiveX 技术(IIS) 。它您能使用的包括一定数量的对象。我开始将由解释"major players" 简要地。 有您应该意识到在骚扰的3 个主要对象: 命令对象、连接对象, 和Recordset 对象。多半时间, 您只将必须工作以RecordSet 对象(可争论), 但是在某些案件, 您可以想要设置物产在(或用途) 一个或两个其它2 个对象。每当您进行数据库操作,这些3 个对象经常是存在, 但它isn't 必要明确地创造所有3, 和当你被使用, 其它2 含蓄地被创造, 即使您不可以分配可变物访问他们。句法为创造可变物访问这些对象是(在VBScript) "[variable 名字] = Server.CreateObject("ADODB.[object name]")" RecordSet 对象 RecordSet 对象基本上是一个游标(存在在记忆) 的一个临时表以一些内部函数和物产为工作以纪录包含在它。您能明确地创造RecordSet 对象, 或由执行命令通过命令对象。 您可以频繁地使用的一些物产是: BOF - 文件起点 EOF - 文件结束 MaxRecords - 纪录的最大数字返回在询问 RecordCount - 纪录的数量在RecordSet CursorType - 向前只, 静态, 动态, 和keyset 一些方法(作用您可以是很可能对用途的) RecordSet 对象是: 开放- 打开Recordset 关闭- 接近RecordSet 移动- 行动向一个具体纪录 MoveFirst - 行动向第一纪录 MoveNext - 移动今后一个纪录 移动早先- 移动落后一个纪录 MoveLast - 行动向最后纪录 AddNew - 增加一个新纪录来RecordSet.