
ant; ">
void CXIANGXIDLG::OnOK()

{

CoInitialize(NULL);
//初始化COM环境 
_ConnectionPtr m_pConnection;
//连接对象 
HRESULT hr;
try 
{

hr = m_pConnection.CreateInstance(
"ADODB.Connection");
//创建Connection对象
if(SU
CCEEDED(hr))

{

hr=m_pConnection->Open(
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=shouji.mdb",
"","",adModeUnknown);
//连库 
}

}
catch(_com_error e)

{

AfxMessageBox(
"数据库连接失败,确认数据库连接字符串是否正确");

}
//操纵表 
_RecordsetPtr m_pRecordset;
//记录集对象 
UpdateData(TRUE);

CString str
SQL;
if (m_name=="")
//路径1 
{

MessageBox(
"用户名不能为空!");
//函数A 
}
else {UpdateData(TRUE);
//函数B
int lenth=0;

lenth=m_name.GetLength();
if (lenth>12 || length<2)
//路径2 
{MessageBox(
"输入的用户名不正确或没有该用户!请重新输入!");
//函数C 
}

Else

{
if(m_pipei)
//路径3 
{

strSQL=
"SELECT * FROM sj_T_ShouJiKa where 用户姓名 = '"+m_name+
"'";
//函数D 
}

Else

{

strSQL=
"SELECT * FROM sj_T_ShouJiKa where 用户姓名 like '%"+m_name+
"%'";
//函数E 
}
try 
{

hr=m_pRecordset.CreateInstance(
"ADODB.Recordset");
if(SUCCEEDED(hr))

{
//从数据库中打开表 
m_pRecordset->Open(_bstr_t(strSQL),m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);

}
else 
{

AfxMessageBox(
"查询不成功!");

}

}
catch (_com_error e)

{

CString strError;

strError.Format(
"警告:打开数据表时发生异常。 错误信息: %s",e.ErrorMessage());

AfxMessageBox(strError);
return;

}
while(!m_pRecordset->adoEOF)
//路径4 
{
//函数F 
_bstr_t name="";

_bstr_t shoujikahao="";

_bstr_t tongxinzhishi="";

_bstr_t fuwushang="";
int i=0;

m_list5.DeleteAllItems();
while(!m_pRecordset->adoEOF)

{

name=(_bstr_t)m_pRecordset->GetCollect(
"用户姓名");

shoujikahao=(_bstr_t)m_pRecordset->GetCollect(
"手机卡号");

tongxinzhishi=(_bstr_t)m_pRecordset->GetCollect(
"通信制式");

fuwushang=(_bstr_t)m_pRecordset->GetCollect(
"服务商");

m_list5.InsertItem(i,name);

m_list5.SetItemText(i,1,shoujikahao);
//设置该行的不同列的显示字符 
m_list5.SetItemText(i,2,tongxinzhishi);

m_list5.SetItemText(i,3,fuwushang);

m_pRecordset->MoveNext();

i=i+1;

}

}
//关闭连接、释放com资源m_pRecordset->Close(); //路径5 
m_pRecordset.Release();

m_pConnection->Close();

m_pConnection.Release();

CoUninitialize();

}

}

}