mainform.cpp

本程序为C++Builder程序

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

#include <vcl.h>
#pragma hdrstop

#include "MainForm.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm1 *Form1;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TForm1::BitBtn1Click(TObject *Sender)
{ //查询固定范围的数据库记录
  try
  {
    this->Query1->Close();
    this->Query1->SQL->Clear();
    AnsiString StrSQL="SELECT * FROM country.db WHERE Area>";
    StrSQL+=this->Edit1->Text+"  AND  Area<";
    StrSQL+=this->Edit2->Text;
    this->Query1->SQL->Text=StrSQL;
    this->Query1->Open();
    MessageBox(Handle,"查询固定范围的数据库记录操作成功！","信息提示",MB_OK);
  }
  catch(...)
  {
    MessageBox(Handle,"查询固定范围的数据库记录操作失败！","信息提示",MB_OK);
  }
}
//---------------------------------------------------------------------------