ADOTestMSSQL

1. // ADOTest.cpp : 定义控制台应用程序的入口点。
2. //
4. #include "stdafx.h"
5. using namespace std;
7. int _tmain(int argc, _TCHAR* argv[])
8. {
9.     ::CoInitialize(NULL);                                                 //初始化COM组件,MFC用AfxOleInit()
10.     _ConnectionPtr pConn;                                                 //定义智能指针
11.     _CommandPtr pCmd;                                                     //定义智能指针
12.     _RecordsetPtr pRecord;                                                //定义智能指针
13.     _ParameterPtr pParam;                                                 //定义智能指针
15.     _bstr_t strCnn("Provider=sqloledb.1;Data Source=(local);"             //连接MSSQL字符串
16.             "Initial Catalog=RTU;User Id=sa;Password=5197313;");
17.     
18.     if (FAILED(pConn.CreateInstance("ADODB.Connection")))                 //初始ADODB连接
19.     {
20.         cout<<"Create Instance failed!"<<endl;
21.     }
23.     try 
24.     {
25.         pConn->Open(strCnn,"","",adConnectUnspecified);                   //连接数据库,ADO操作中建议语句中要常用try...catch()来捕获错误信息
26.     } 
27.     catch(_com_error e) 
28.     {
29.         cout<<"数据库连接失败!"<<endl;
30.         return 0;
31.     } 
33.     pCmd.CreateInstance(__uuidof(Command));                             //初始_CommandPtr智能指针
34.     pCmd->ActiveConnection = pConn;                                     //智能指针定位到连接指针.
36.     //******************************普通sql语句操作****************************************************//
37.     
38.     /*pCmd->CommandText = "SELECT * FROM T_WMETER";                       //给CommandText赋SQL语句
39.     pRecord.CreateInstance(__uuidof(Recordset));                        //初始_RecordsetPtr智能指针
40.     pRecord = pCmd->Execute(NULL, NULL,adCmdText);                      //执行SQL语句
41.     
42.     if(!pRecord->BOF) 
43.         pRecord->MoveFirst();                                           //设置指针初始位置
45.     _variant_t var;
46.     long Wmeter = 0;
48.     var = pRecord->GetCollect("WMeterID");
49.     if(var.vt != VT_NULL) 
50.         Wmeter = var.lVal;
51.     
52.     pRecord->MoveNext();                                              //移动ADO指针显示下一条数据
54.     var = pRecord->GetCollect("WMeterID");
55.     if(var.vt != VT_NULL) 
56.         Wmeter = var.lVal;
58.     cout<<Wmeter<<endl;*/
60.     //**********************************************************************************//
61.    //*******************************测试用存储过程sp_1调用***************************************************//
62.     _variant_t var;                               //定义传参变量
63.     var.intVal = 555;                             //定义参数值
65.     pCmd->CommandText = "sp_1";                   //指定存储过程
66.     pParam.CreateInstance(__uuidof(Parameter));   //初始参数指针
67.     pCmd->Parameters->Refresh();                  //刷新参数
69.     pParam = pCmd->CreateParameter(_bstr_t("@pin"),adInteger,adParamInput,sizeof(int),var.intVal); //创建参数@pin
71.     pCmd->Parameters->Append(pParam);                                                              //添加参数到指针
73.     pParam = pCmd->CreateParameter(_bstr_t("@pout"),adInteger,adParamOutput,sizeof(int));          //创建参数@pout
75.     pCmd->Parameters->Append(pParam);                                                              //添加参数到指针
77.     try
78.     {
79.         pCmd->Execute(NULL,NULL,adCmdStoredProc);                                                  //执行存储过程
80.     }
81.     catch(_com_error e)
82.     {
83.         cout<<e.Description()<<endl;
84.         cin.get();
85.     }
87.     try
88.     {
89.         cout<<pCmd->Parameters->GetItem("@pout")->GetValue().intVal<<endl;                         //获取OutPut参数的值
90.     }
91.     catch(_com_error e)
92.     {
93.         cout<<e.Description()<<endl;
94.         cin.get();
95.     }
97.     cin.get();
98.     return 0;
99. }