query2_0.cpp

校园刷卡系统

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

#include <vcl.h>
#pragma hdrstop

#include "Query2_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);

TQueryForm2_0 *QueryForm2_0;
//---------------------------------------------------------------------------
__fastcall TQueryForm2_0::TQueryForm2_0(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------

void __fastcall TQueryForm2_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 Record where cardID='"+s+"'";
HISQuery(Query1,sql,true);
if(Query1->IsEmpty())
{ShowMessage("此学号不存在！");Query1->Close();}
}
else
{ShowMessage("学号非法，必须是整型数！");}
}
else{ShowMessage("学号不能为空！");}
}
}
//---------------------------------------------------------------------------