query1_0.cpp

校园刷卡系统

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

#include <vcl.h>
#pragma hdrstop

#include "Query1_0.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"

extern void HISQuery(TQuery*qPtr,String&s,bool b);
extern bool isInteger(AnsiString str,bool minus);

//---------------------------------------------------------------------------
__fastcall TQueryForm1_0::TQueryForm1_0(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TQueryForm1_0::LabeledEdit1KeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
if(Key==13)
{
  if(LabeledEdit1->Text!="")
  {
    if(isInteger(LabeledEdit1->Text,false))
    {
    String s=LabeledEdit1->Text;
    String sql="select * from Student where schoolID='"+s+"'";
    HISQuery(Query1,sql,true);
      if(Query1->IsEmpty())
      {ShowMessage("此学号不存在！");Query1->Close();}
    }
    else
    {ShowMessage("学号非法，必须是整型数！");}
  }
  else{ShowMessage("学号不能为空！");}
}
}
//---------------------------------------------------------------------------