QTP访问数据库一、先给一个访问数据库的vbs脚本：使用的时候只需要调用下面标记为红色的三个函数基本就可以了Descriptio
获取检索到数据集Docume
tatio
查询语句PublicFu
ctio
FillDataTableByRefselectComma
dTextDimco

Setco
getOleDbCo
ectio
Dimcmd
SetcmdgetOleDbComma
dI
sta
ce
cmdComma
dTextselectComma
dTextcmdCo
ectio
co
DimadapterSetadaptergetOleDbDataAdapterI
sta
ce
adapterSelectComma
dcmdDimdataSetdatagetDataTableI
sta
ceadapterFilldataco
CloseSetFillDataTabledataE
dFu
ctio
Descriptio
执行一条无返回结果集的Sql语句例如Update、I
sert、delete语句Docume
tatio
查询语句PublicFu
ctio
ExecuteNoQueryByRefselectComma
dText
Dimco

fSetco
getOleDbCo
ectio
Dimcmd
SetcmdgetOleDbComma
dI
sta
ce
cmdComma
dTextselectComma
dTextcmdCo
ectio
co
返回影响的行数DimresultCou
tresultCou
tcmdExecuteNo
Query
co
CloseSetExecuteNoQueryresultCou
t
E
dFu
ctio
Descriptio
执行查询，并返回查询所返回的结果集中第一行的第一列。忽略额外的列或行例如Selectcou
tfromstude
tDocume
tatio
查询语句PublicFu
ctio
ExecuteScalarByRefselectComma
dTextDimco
Setco
getOleDbCo
ectio
DimcmdSetcmdgetOleDbComma
dI
sta
ce
cmdComma
dTextselectComma
dTextcmdCo
ectio
co
DimresualtObjectresualtObjectcmdExecuteScalarco
CloseExecuteScalarresualtObject
fE
dFu
ctio
Descriptio
获取OleDbCo
ectio
对象PrivateFu
ctio
getOleDbCo
ectio
Setco
DotNetFactoryCreateI
sta
ce