unit8.cpp

CBUILDER+SQL的实现

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

#include <vcl.h>
#pragma hdrstop

#include "Unit8.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm8 *Form8;
//---------------------------------------------------------------------------
__fastcall TForm8::TForm8(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------

void __fastcall TForm8::Button1Click(TObject *Sender)
{
 try
 {
   Table1->Close();
  Table1->IndexFieldNames="sname";

  Table1->Open();
  if(!Table1->FindKey(new TVarRec(LabeledEdit1->Text),0))
   ShowMessage("查无此学生！！……");
  else
   ShowMessage( "查询成功！");

 }
 catch(Exception &e)
 {MessageBox(Handle,"查询失败","信息提示",MB_OK);}
}
//---------------------------------------------------------------------------
void __fastcall TForm8::Button2Click(TObject *Sender)
{
Close();        
}
//---------------------------------------------------------------------------
void __fastcall TForm8::Button3Click(TObject *Sender)
{
if(Table1->Active==false)
Table1->Open();
Table1->Append();
}
//---------------------------------------------------------------------------