4,011
社区成员
发帖
与我相关
我的任务
分享
//全局
_RecordsetPtr g_Rs;
_ConnectionPtr g_Conn;
CADOTest::CADOTest()
{
AfxOleInit();
g_Rs = NULL;
try
{
g_Conn.CreateInstance(__uuidof(Connection));
g_Conn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ADOTest.mdb; Persist Security Info=TRUE;","","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}
}
CADOTest::~CADOTest()
{
if (NULL != g_Rs)
{
if(adStateClosed != g_Rs->State)
g_Rs->Close();
g_Rs = NULL;
}
if (NULL != g_Conn)
{
if (adStateClosed != g_Conn->State)
g_Conn->Close();
g_Conn = NULL;
}
}
void CADOTest::InsertData()
{
if(NULL != g_Conn && adStateOpen == g_Conn->State)
{
g_Rs.CreateInstance(__uuidof(Recordset));
_variant_t strSQL;
strSQL.SetString("SELECT TOP 1 * FROM ADOTable");
g_Rs->Open(strSQL,
g_Conn.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText);
for(int i = 1;i <= 1000;i++)
{
g_Rs->AddNew();
_variant_t var;
var.SetString("Data");
g_Rs->PutCollect(long(0),&var);
g_Rs->Update();
}
g_Rs.Close();
g_Rs = NULL;
}
}
// Clear the _variant_t
//
inline void _variant_t::Clear()
{
_com_util::CheckError(::VariantClear(this));
}
//////////////////////////////////////////////////////////////////////////////////////////
//
// Destructor
//
//////////////////////////////////////////////////////////////////////////////////////////
inline _variant_t::~_variant_t() throw()
{
::VariantClear(this);
}
for(int i = 1;i <= 1000;i++)
{
g_Rs->AddNew();
_variant_t var;
var.SetString("Data");
g_Rs->PutCollect(long(0),&var);
g_Rs->Update();
}
g_Rs.Close();
g_Rs = NULL;