mainform.cpp

来自「C++ BUILDER精彩编程实例集锦(源码)3 第五部分 系统编程 第六部」· C++ 代码 · 共 49 行

//---------------------------------------------------------------------------

#include <vcl.h>
#pragma hdrstop

#include "MainForm.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm1 *Form1;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
        : TForm(Owner)
{
   this->Memo1->Text="SELECT * FROM Country WHERE Area>8000000";
}
//---------------------------------------------------------------------------

void __fastcall TForm1::BitBtn1Click(TObject *Sender)
{
   this->Query1->DatabaseName="BCDEMOS";
   this->Query1->Close();
   this->Query1->SQL->Clear();
   this->Query1->SQL->Add("SELECT * FROM country.db");
   this->Query1->SQL->Add("WHERE Continent='South America'");
   this->Query1->Open();
}
//---------------------------------------------------------------------------

void __fastcall TForm1::BitBtn2Click(TObject *Sender)
{
   this->Query1->DatabaseName="BCDEMOS";
   this->Query1->Close();
   this->Query1->SQL->LoadFromFile("SQL.txt");
   this->Query1->Open();
}
//---------------------------------------------------------------------------


void __fastcall TForm1::BitBtn3Click(TObject *Sender)
{
   this->Query1->DatabaseName="BCDEMOS";
   this->Query1->Close();
   this->Query1->SQL->Assign(Memo1->Lines);
   this->Query1->Open();
}
//---------------------------------------------------------------------------