c++ builder 连ado(自己的代码）

来源：互联网发布：ubuntu 浏览器下载慢编辑：程序博客网时间：2024/05/19 02:04

ADOConnection1->Connected=true;

        ADOQuery1->SQL->Clear();
        ADOQuery1->SQL->Add("select * from bus");
        ADOQuery1->Open();
        int bus_id=ADOQuery1->FieldByName("bus_id")->AsInteger;
        ShowMessage(IntToStr(bus_id));
        ADOQuery1->Close();
        ADOConnection1->Connected=false;

、、、、、、、、、、、、、、、、

下面的根改过

//取出platform的id 存于vector platform_id中
platform_id.erase(platform_id.begin(),platform_id.end());

        ADOConnection1->Connected=true;
        ADOQuery1->Close();
        ADOQuery1->SQL->Clear();
        ADOQuery1->SQL->Add("select * from platform");
        ADOQuery1->Open();

        while( ! ADOQuery1->Eof)
        {
                platform_id.push_back(ADOQuery1->FieldByName("platform_id")->AsInteger);
                //ShowMessage(IntToStr(bus_id));
                ADOQuery1->Next();
        }
        //ShowMessage(IntToStr(platform_id.size()));
        ADOConnection1->Connected=false;