📄 db包装类.htm
字号:
<html>
<head>
<title>Ado包装类</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
</head>
<basefont face="宋体">
<body alink="#ff0000" vlink="#551a8b" link="#0000ee" text="#000000" bgcolor="#FFEEDD">
<h1 align="center"><font color="#FF8080"><strong><a name="页头">ADO包装类文档</a></strong></font></h1>
<p align="center">(名称:DBApi)</p>
<table border="0" cellpadding="4" width="100%">
<tr>
<td width="25%" align="center"><a href="#_property1">属性</a></td>
<td width="25%" align="center"><a href="#_method1">方法和过程</a></td>
<td width="25%" align="center"><a href="#_event1">事件</a></td>
<td width="25%" align="center"><a href="#_rule1">调用规则</a></td>
</tr>
</table>
<h3><font color="#8000FF"><strong><a name="_property1">属性</a></strong></font></h3>
<table border="1" width="100%" cellpadding="4" cellspacing="0">
<tr>
<td width="18%" align="center" bgcolor="#000000"><font color="#FFFFFF">名称</font></td>
<td width="16%" align="center" bgcolor="#000000"><font color="#FFFFFF">类型</font></td>
<td width="14%" align="center" bgcolor="#000000"><font color="#FFFFFF">读写属性</font></td>
<td width="52%" align="center" bgcolor="#000000"><font color="#FFFFFF">描述</font></td>
</tr>
<tr>
<td width="18%" valign="top">ErrDescription</td>
<td width="16%" valign="top">String</td>
<td width="14%" valign="top">R</td>
<td width="52%" valign="top">错误描述</td>
</tr>
<tr>
<td width="18%" valign="top">ErrNo</td>
<td width="16%" valign="top">Long</td>
<td width="14%" valign="top">R</td>
<td width="52%" valign="top">错误号</td>
</tr>
</table>
<h3><strong><font color="#8000FF"><a name="_method1">方法和过程</a></font></strong></h3>
<table border="1" width="100%" cellpadding="4" cellspacing="0" height="93">
<tr>
<td width="11%" align="center" bgcolor="#000000" height="16"><font color="#FFFFFF">名称</font></td>
<td width="10%" align="center" bgcolor="#000000" height="16"><font color="#FFFFFF">类型</font></td>
<td width="53%" align="center" bgcolor="#000000" height="16"><font color="#FFFFFF">参数</font></td>
<td width="26%" align="center" bgcolor="#000000" height="16"><font color="#FFFFFF">描述</font></td>
</tr>
<tr>
<td width="11%" valign="top" height="94">ExecuteSQL</td>
<td width="10%" valign="top" height="94">(Variant数组方法)</td>
<td width="53%" valign="top" height="94">strSQL-SQL语句<br>
lngReturn-返回值类型<br>
0:返回执行情况(True-成功，False-失败)<br>
1:返回集合(效率低)<br>
2:返回数组
</td>
<td width="26%" valign="top" height="94">若需要返回，在执行一个SQL后得到的结果集不为空，则根据需要返回,否则，返回把属性ErrNo返回。<br>
返回值的排列情况见<a href="#_ExecuteSQL">附表</a>
<p> </p>
</td>
</tr>
<tr>
<td width="11%" valign="top" height="1">BeginTrans</td>
<td width="10%" valign="top" height="1">Boolean</td>
<td width="53%" valign="top" height="1" nowrap>开始一个事务，成功返回True,否则为False</td>
<td width="26%" valign="top" height="1">不允许多事务</td>
</tr>
<tr>
<td width="11%" valign="top" height="1">RollBackTrans</td>
<td width="10%" valign="top" height="1">Boolean</td>
<td width="53%" valign="top" height="1" nowrap>事务回滚</td>
<td width="26%" valign="top" height="1"></td>
</tr>
<tr>
<td width="11%" valign="top" height="1">CommitTrans</td>
<td width="10%" valign="top" height="1">Boolean</td>
<td width="53%" valign="top" height="1" nowrap>事务提交</td>
<td width="26%" valign="top" height="1"></td>
</tr>
<tr>
<td width="11%" valign="top" height="1">Save</td>
<td width="10%" valign="top" height="1">BOOLEAN</td>
<td width="53%" valign="top" height="1" nowrap> varData-保存的数组(一维代表相应的FIELD，第二维代表记录数目，<br>
同ExecuteSQL的返回格式)。<br>
默认varData(0,i)作为每条记录的Key。<br>
varData(0,i)=0 ------Addnew<br>
varData(0,i)=-1------Delete<br>
varData(0,i)>0 ------Update<br>
注意：若指定了KeyField，则第一维起始一个或<br>
几个字将作为KeyField。<br>
如:指定KeyField为三，则varData(0,i),<br>
varData(1,i),varData(2,i)将作为Key.<br>
<br>
varField-保存的字段集合(一维数组)<br>
对应varData的所有字段集合,第一维的数目和varData一致，<br>
且顺序对应varData。<br>
lngKeyCount:关键字字段数目，在Update的时候，按关键字数目进行搜索。<br>
缺省默认为1。<br>
sTableName-需要更新的表名。<br>
</td>
<td width="26%" valign="top" height="1">保存操作，若失败返回FALSE，可通过Err等属性查看错误原因。
<p>使用细节请参阅<a href="My%20Webs/Sample.bas">Sample</a></p>
</td>
</tr>
</table>
<h3><font color="#8000FF"><strong><a name="_event1">事件</a></strong></font></h3>
<table border="1" width="100%" cellpadding="4" cellspacing="0">
<tr>
<td width="18%" align="center" bgcolor="#000000"><font color="#FFFFFF">名称</font></td>
<td width="20%" align="center" bgcolor="#000000"><font color="#FFFFFF">参数</font></td>
<td width="46%" align="center" bgcolor="#000000"><font color="#FFFFFF">描述</font></td>
</tr>
<tr>
<td width="18%" valign="top">无</td>
<td width="20%" valign="top"> </td>
<td width="46%" valign="top"> </td>
</tr>
</table>
<table>
</table>
<p><a name="_ExecuteSQL"><font color="#0000FF">ExecuteSQL返回值<br>
</font></a><font color="#0000FF">返回二维数组(第一维对应字段数目，第二维对应结果集记录数目)</font></p>
<table border="1" width="100%" height="81">
<tr>
<td width="16%" height="31"></td>
<td width="23%" height="31">Field(0)</td>
<td width="36%" height="31">Field(1)</td>
<td width="36%" height="31">... ...</td>
<td width="36%" height="31">Field(i-1)</td>
<td width="25%" height="31">Field(i)</td>
</tr>
<tr>
<td width="16%" height="16">Record(0)</td>
<td width="23%" height="16">Array(0,0)</td>
<td width="36%" height="16">Array(1,0)</td>
<td width="36%" height="16">... ...</td>
<td width="36%" height="16">Array(i-1,0)</td>
<td width="25%" height="16">Array(i,0)</td>
</tr>
<tr>
<td width="16%" height="16">Record(1)</td>
<td width="23%" height="16">Array(0,1)</td>
<td width="36%" height="16">Array(1,1)</td>
<td width="36%" height="16">... ...</td>
<td width="36%" height="16">Array(i-1,1)</td>
<td width="25%" height="16">Array(i,1)</td>
</tr>
<tr>
<td width="16%" height="16">... ...</td>
<td width="23%" height="16">... ...</td>
<td width="36%" height="16">... ...</td>
<td width="36%" height="16">... ...</td>
<td width="36%" height="16">... ...</td>
<td width="25%" height="16">... ...</td>
</tr>
<tr>
<td width="16%" height="16">Record(j-1)</td>
<td width="23%" height="16">Array(0,j-1)</td>
<td width="36%" height="16">Array(1,j-1)</td>
<td width="36%" height="16">... ...</td>
<td width="36%" height="16">Array(i-1,j-1)</td>
<td width="25%" height="16">Array(i,j-1)</td>
</tr>
<tr>
<td width="16%" height="16">Record(j)</td>
<td width="23%" height="16">Array(0,j)</td>
<td width="36%" height="16">Array(1,j)</td>
<td width="36%" height="16">... ...</td>
<td width="36%" height="16">Array(i-1,j)</td>
<td width="25%" height="16">Array(i,j)</td>
</tr>
</table>
<p><font color="#0000FF">返回COLLECTION (Item可用对应的字段名称访问,也可按次序号)</font></p>
<table border="1" width="100%" height="81">
<tr>
<td width="31%" height="31">Collection(j)(Item)</td>
<td width="29%" height="31">Field(0)</td>
<td width="31%" height="31">Field(1)</td>
<td width="15%" height="31">... ...</td>
<td width="34%" height="31">Field(i-1)</td>
<td width="32%" height="31">Field(i)</td>
</tr>
<tr>
<td width="31%" height="16">Record(0)</td>
<td width="29%" height="16">Collection(0)(0)</td>
<td width="31%" height="16">Collection(0)(1)</td>
<td width="15%" height="16">... ...</td>
<td width="34%" height="16">Collection(0)(i-1)</td>
<td width="32%" height="16">Collection(0)(i)</td>
</tr>
<tr>
<td width="31%" height="16">Record(1)</td>
<td width="29%" height="16">Collection(1)(0)</td>
<td width="31%" height="16">Collection(1)(1)</td>
<td width="15%" height="16">... ...</td>
<td width="34%" height="16">Collection(1)(i-1)</td>
<td width="32%" height="16">Collection(1)(i)</td>
</tr>
<tr>
<td width="31%" height="16">... ...</td>
<td width="29%" height="16">... ...</td>
<td width="31%" height="16">... ...</td>
<td width="15%" height="16">... ...</td>
<td width="34%" height="16">... ...</td>
<td width="32%" height="16">... ...</td>
</tr>
<tr>
<td width="31%" height="16">Record(j-1)</td>
<td width="29%" height="16">Collection(j-1)(0)</td>
<td width="31%" height="16">Collection(j-1)(1)</td>
<td width="15%" height="16">... ...</td>
<td width="34%" height="16">Collection(j-1)(i-1)</td>
<td width="32%" height="16">Collection(j-1)(i)</td>
</tr>
<tr>
<td width="31%" height="16">Record(j)</td>
<td width="29%" height="16">Collection(j)(0)</td>
<td width="31%" height="16">Collection(j)(1)</td>
<td width="15%" height="16">... ...</td>
<td width="34%" height="16">Collection(j)(i-1)</td>
<td width="32%" height="16">Collection(j)(i)</td>
</tr>
</table>
<p> </p>
<p>注：为了保证今后基于不同的数据库平台和技术的通用性，可能提供的方法比较有限，使用必然不如ADO ，RDO之类灵活，方便。
若有需要，可根据实际情况填加方法或属性，但需要保证通用性和效率。</p>
<p><em>Best viewed with Internet Explorer V4.01.<br>
Maintained by CHIGO<br>
Last update: <script language="VBScript">
<!--
document.write formatdatetime(document.lastmodified,vblongdate)
-->
</script> </em></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -