⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 a4-1.cfm.htm

📁 最全的asp.net教程,对现在正在学.net的学生有很好的辅助效果
💻 HTM
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Command对象</title>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
</head>

<body>
<font FACE="宋体" LANG="ZH-CN" SIZE="4"><b>

<p ALIGN="JUSTIFY">Command对象</p>
</b></font><font FACE="宋体" LANG="ZH-CN" SIZE="3">

<p ALIGN="JUSTIFY">使用Command对象，你可以执行带参数的存储过程，SQL查询，SQL语句。你可以使用Command对象接收Recordset对象。</p>

<p ALIGN="JUSTIFY">&lt;% Set MagicCMD = Server.CreateObject(</font><font SIZE="3">“</font><font
FACE="宋体" LANG="ZH-CN" SIZE="3">ADODB.Command</font><font SIZE="3">”</font><font
FACE="宋体" LANG="ZH-CN" SIZE="3">) %&gt;</p>
</font><b><font FACE="宋体" LANG="ZH-CN" SIZE="4">

<p ALIGN="JUSTIFY">集合</p>
</font><font FACE="宋体" LANG="ZH-CN">

<p ALIGN="JUSTIFY">Parameters</p>
</font></b><font FACE="宋体" LANG="ZH-CN" SIZE="3">

<p ALIGN="JUSTIFY">Parameters集合是Parameter对象的集合（参看后面的“Parameter对象”）。Parameter对象用于执行带参数的SQL查询或向一SQL存储过程传递或接收参数。</p>
</font><font FACE="宋体" LANG="ZH-CN"><b>

<p ALIGN="JUSTIFY">Properties</p>
</b></font><font FACE="宋体" LANG="ZH-CN" SIZE="3">

<p ALIGN="JUSTIFY">Properties集合是Property对象的集合（参看后面的“Preperty对象”）。不同的数据提供者比如Microsoft 
SQL Server和Microsoft Access在Command对象的Properties集合里具有不同的属性。这些属性影响Command对象的执行方式。</p>
</font><b><font FACE="宋体" LANG="ZH-CN" SIZE="4">

<p ALIGN="JUSTIFY">属性</p>
</font><font FACE="宋体" LANG="ZH-CN">

<p ALIGN="JUSTIFY">CreateParameter([Name] , [type] , [Direction] , [Size] , [Value] )</p>
</font></b><font FACE="宋体" LANG="ZH-CN" SIZE="3">

<p ALIGN="JUSTIFY">创建Command对象要使用的新参数。Name是新参数的名称。Type是该参数的数据类型。你可以使用下表所示的任何数据类型：</p>
</font><div align="center"><center>

<table BORDER="1" CELLSPACING="2" BORDERCOLOR="#008000" CELLPADDING="7" WIDTH="453">
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">常数</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">值</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">描述</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adBigInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">20</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">8字节有符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adBinary</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">128</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">二进制值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adBoolean</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">11</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">布尔值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adBSTR</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">8</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">Null-中断字符串(Unicode)</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adChar</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">129</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">字符串值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adCurrency</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">6</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">货币值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDate</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">7</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">日期值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDBDate</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">133</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">日期值（yyyymmdd）</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDBTime</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">134</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">时间值(hhmmss)</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDBTimeStamp</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">135</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">日期时间值（yyyymmddhhmmss）</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDecimal</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">14</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">具有固定的精度和范围的扩展数字型。</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDouble</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">5</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">双精度浮点数值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adEmpty</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">0</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">空值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adError</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">10</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">32位错误码</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adGUID</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">72</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">全球唯一的标志码</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adIDispatch</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">9</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">指向一个OLE对象Idispatch的指针</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adInteger</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">3</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">4字节有符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adIUnknown</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">13</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">指向一个OLE对象Iunkown的指针</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adLongVarBinary</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">205</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">长二进制值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adLongVarChar</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">201</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">长字符串值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adLongVarWChar</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">203</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">长NULL－中断字符串值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adNumeric</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">131</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">具有固定的精度和范围的扩展数字型。</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adSingle</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">4</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">单精度浮点值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adSmallInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">2</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">2字节有符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adTinyInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">16</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">1字节有符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUnsignedBigInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">21</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">8字节无符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUnsignedInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">19</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">4字节无符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUnsignedSmallInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">18</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">2字节无符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUnsignedTinyInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">17</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">1字节无符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUserDefined</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">132</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">未定义变量</font></td>
  </tr>
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -