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