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

  try
  {
hr = m_pConnection.CreateInstance("ADODB.Connection");//创建Connection对象
if(SUCCEEDED(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 strSQL;
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();
  }
  }
}