c++连接sqlserver的两种方式

最新推荐文章于 2023-07-31 23:25:31 发布

范泛

最新推荐文章于 2023-07-31 23:25:31 发布

阅读量3.1w

点赞数 6

本文链接：https://blog.csdn.net/fnjnxn/article/details/78738250

版权

c++ 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

#include "stdafx.h"
#include "MFCApplicationSqlServer.h"
#include "MFCApplicationSqlServerDlg.h"
#include "afxdialogex.h"
#include <icrsint.h>
#include <windows.h>
#include <sqltypes.h>
#include <sql.h>
#include <sqlext.h>
//方式一
#pragma comment(lib,"odbc32.lib")
//方式二

//#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF", "adoEOF")

//方式一:ODBC华丽的分割线/
SQLHENV env; //environment handle
SQLHDBC dbc; //connection handle
SQLHSTMT stmt; //state handle
SQLRETURN ret; //result return

//查询的结果返回到这些变量里
SQLCHAR sno[64];
SQLINTEGER grade;
SQLINTEGER cbSno , cbGrade ;

//环境句柄
ret = SQLAllocHandle(SQL_HANDLE_ENV, NULL, &env);
ret = SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION,(SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER);
ret = SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);
char c[512];
sprintf_s(c,"DRIVER={SQL Server};SERVER=192.168.1.29;DATABASE=baoshang;UID=sa;PWD=ebank@123;");

SQLCHAR outstr[1024];
SQLSMALLINT outstrlen;
ret = SQLDriverConnect(dbc, NULL, (SQLCHAR *)c, SQL_NTS, outstr, sizeof(outstr), &outstrlen, SQL_DRIVER_NOPROMPT);

int intTemp = SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt);
if (SQL_SUCCESS != SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt))
{
AfxMessageBox("Failed to connect");
}
else
{
// 基本上每个SQLExecDirect()都要初始化句柄
ret = SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt);
ret = SQLSetStmtAttr(stmt, SQL_ATTR_ROW_BIND_TYPE, (SQLPOINTER)SQL_BIND_BY_COLUMN, SQL_IS_INTEGER);

//查询
ret = SQLExecDirect(stmt, (SQLCHAR *)("SELECT * FROM dbo.TB_DICT_CONTTYPE"), SQL_NTS);
if (ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO)
{
/* 句柄、列、变量类型、接收缓冲、缓冲长度、返回的长度 */
ret = SQLBindCol(stmt, 1, SQL_C_LONG, &grade, 0, &cbGrade);
//ret = SQLBindCol(stmt, 2, SQL_C_CHAR, cno, CNO_LEN, &cbCno);
ret = SQLBindCol(stmt, 3, SQL_C_CHAR, sno, 64, &cbSno);
}
//遍历数据
while ((ret = SQLFetch(stmt)) != SQL_NO_DATA_FOUND)
{
if (ret == SQL_ERROR) printf("fetch error\n");
else
{
char szS[128];
sprintf_s(szS,"%d:%s",grade,sno);
AfxMessageBox(szS);
}
}
SQLFreeHandle(SQL_HANDLE_STMT, stmt);
SQLDisconnect(dbc);
SQLFreeHandle(SQL_HANDLE_DBC, dbc);
SQLFreeHandle(SQL_HANDLE_ENV, env);
}

//方式二:ADO/华丽的分割线///
_ConnectionPtr sqlSp;
HRESULT hr=sqlSp.CreateInstance(_uuidof(Connection));

if(FAILED(hr))
{
AfxMessageBox("_ConnectionPtr对象指针实例化失败！！！");
return ;
}
else {
try {
_bstr_t strConnect="Driver={sql server};server=192.168.1.29;uid=sa;pwd=ebank@123;database=baoshang;";
sqlSp->Open(strConnect,"","",adModeUnknown);
}
catch(_com_error &e)
{
AfxMessageBox(e.Description());
return;
}
_RecordsetPtr m_pRecordset;
if(FAILED(m_pRecordset.CreateInstance( _uuidof( Recordset ))))
{
AfxMessageBox("记录集对象指针实例化失败！");
return;
}
try {
m_pRecordset->Open("select * from dbo.TB_DICT_CONTTYPE",(IDispatch*)sqlSp,adOpenDynamic,adLockOptimistic, adCmdText);
}
catch (_com_error &e)
{
AfxMessageBox(e.Description());
return;
}
try {
m_pRecordset->MoveFirst();
while(!m_pRecordset->adoEOF)
{
CString insertTime=(char*)(_bstr_t)(m_pRecordset->Fields->GetItem(_variant_t("F_TYPE_ID"))->Value);
AfxMessageBox(insertTime);
m_pRecordset->MoveNext();
}
}
catch (_com_error &e)
{
AfxMessageBox(e.Description());
return;
}
}