三种版本查找iapId的函数

三种版本查找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;
 }