三种版本查找iapId的函数

来源：互联网发布：北京编程培训班推荐编辑：程序博客网时间：2024/06/05 04:48

三种版本查找iapId的函数，其中第1种和第3种类似

////////////////////////////////////////////////1/////////////////////////////////////////////////////////

TUint32 CRZHttpIAPManager::QueryAccessPointId(const TDesC& aApnName)
{
TBool aFind = EFalse;
CCommsDatabase* commsDB = CCommsDatabase::NewL(EDatabaseTypeIAP);

  CCommsDbTableView* tableView = commsDB->OpenTableLC(TPtrC(OUTGOING_GPRS));
  TInt err = tableView->GotoFirstRecord();
  TUint32 aIapId = 0; //需要返回的正确的ID

  while ( err == KErrNone )
  {
   TBuf16<50> unionName;
   unionName.Zero();

   TBuf<50> pointerName;
   pointerName.Zero();

   TUint32 iCmwapId = 0;

   tableView->ReadTextL(TPtrC(COMMDB_NAME), unionName);
   tableView->ReadTextL(TPtrC(GPRS_APN), pointerName);
   tableView->ReadUintL(TPtrC(COMMDB_ID), iCmwapId );

   TBuf<32> temp = OUTGOING_GPRS;
   TBuf8<32> outgoing_gprs;
   outgoing_gprs.Copy(temp);

   if(pointerName.CompareF(_L("cmwap")) == 0)
   {
    CCommsDbTableView* pIAPView = commsDB->OpenViewMatchingUintLC( TPtrC(IAP), TPtrC(IAP_SERVICE), iCmwapId );
    TInt ret = pIAPView->GotoFirstRecord();

    while( ret == KErrNone )
    {
     TBuf8<50> bufName;
     pIAPView->ReadTextL( TPtrC(IAP_SERVICE_TYPE), bufName );

     if( bufName.CompareF(outgoing_gprs) == 0 )
     {
      pIAPView->ReadUintL(TPtrC(COMMDB_ID), aIapId);
      aFind = ETrue;
      break;
     }

ret = pIAPView->GotoNextRecord();

    }
    CleanupStack::PopAndDestroy(pIAPView);
   }

   if (aFind)
   {
    break;
   }

err = tableView->GotoNextRecord();
}

CleanupStack::PopAndDestroy(tableView);
delete commsDB;

return aIapId;
}

///////////////////////////////////////////////////////////////2////////////////////////////////////////////////////////////////////

TUint32 CRZHttpIAPManager::QueryAccessPointId2(const TDesC& aApnName)
{
__UHEAP_MARK;
CCommsDatabase* db = CCommsDatabase::NewL(EDatabaseTypeIAP);
CleanupStack::PushL(db);

// 遍历OUTGOING_GPRS表，查找匹配的APN
TBuf<0x20> name;
TUint32 id = 0;
  {
  CCommsDbTableView* view = db->OpenTableLC(TPtrC(OUTGOING_GPRS));

  TInt err = view->GotoFirstRecord();

  while (err == KErrNone)
   {
   TBuf<32> apn;

   view->ReadUintL(TPtrC(COMMDB_ID), id); //接入点ID
   view->ReadTextL(TPtrC(COMMDB_NAME), name);//连接名称
   view->ReadTextL(TPtrC(GPRS_APN), apn); //接入点名称,可以通过这个字段判断接入点是CMWAP还是CMNET

   apn.LowerCase();
   if (apn.Compare(aApnName) == 0)
    {
    break; //找到匹配的APN
    }
   err = view->GotoNextRecord();
   }

  if (err != KErrNone)
   {
   CleanupStack::PopAndDestroy(view);
   CleanupStack::PopAndDestroy(db);
   User::Leave(KErrNotFound);
   }

  CleanupStack::PopAndDestroy(view);
  }

CCommsDbTableView* view = db->OpenTableLC(TPtrC(IAP));

TInt err = view->GotoFirstRecord();
while (err == KErrNone)
{
TBuf<32> name2;

view->ReadUintL(TPtrC(COMMDB_ID), id); //接入点ID
view->ReadTextL(TPtrC(COMMDB_NAME), name2);//连接名称

  if (!name.Compare(name2))
   {
   break; //找到匹配的APN
   }

err = view->GotoNextRecord();
}

CleanupStack::PopAndDestroy(view);

CleanupStack::PopAndDestroy(db);
__UHEAP_MARKEND;
return id;
}

///////////////////////////////////////////////////////////////3////////////////////////////////////////////////////////////////////

TUint32 CRZHttpIAPManager::QueryAccessPointId3(const TDesC& aApnName)
{
TUint32 iapId = 0;
TBuf<KCommsDbSvrMaxColumnNameLength> apnName;

TUint32 fakeIapId;

CCommsDatabase* commDb = CCommsDatabase::NewL(EDatabaseTypeIAP);
CleanupStack::PushL(commDb);

CCommsDbTableView* commView = commDb->OpenTableLC(TPtrC(OUTGOING_GPRS));

if (commView->GotoFirstRecord() == KErrNone)
  {

  do
   {
   commView->ReadTextL((TPtrC) GPRS_APN, apnName);
   commView->ReadUintL(TPtrC(COMMDB_ID), fakeIapId);

   if (apnName.Find(aApnName) >= 0) //不区分大小写
    {
    CCommsDbTableView* iapView = commDb->OpenViewMatchingUintLC(TPtrC(IAP), TPtrC(IAP_SERVICE), fakeIapId);
    TInt nErr = iapView->GotoFirstRecord();

    if (nErr == KErrNone)
     {
     iapView->ReadUintL(TPtrC(COMMDB_ID), fakeIapId);
     iapId = fakeIapId;
     CleanupStack::PopAndDestroy(); //iapView
     break;
     }

    CleanupStack::PopAndDestroy(); //iapView
    }
   }
  while (commView->GotoNextRecord() == KErrNone);

  }
CleanupStack::PopAndDestroy(2);

return iapId;
}