unit Unit12;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, StdCtrls, Grids, DBGrids, ComCtrls, DB, ADODB;

type
  Tbyxxcx = class(TForm)
    Panel1: TPanel;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    DBGrid1: TDBGrid;
    StatusBar1: TStatusBar;
    Image1: TImage;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure FormActivate(Sender: TObject);
   

  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  byxxcx: Tbyxxcx;

implementation
 uses unit1;
{$R *.dfm}




procedure Tbyxxcx.Button2Click(Sender: TObject);
begin
self.Close;
end;

procedure Tbyxxcx.Button1Click(Sender: TObject);
begin
if(edit1.Text='')then
begin
application.MessageBox('請(qǐng)輸入學(xué)號(hào)','提示',0+64);
end;
 ADOquery1.SQL.Clear;
    ADOquery1.Close;
    ADOquery1.SQL.Add('select *from t_biye where 學(xué)號(hào)='''+edit1.text+'''');
     //MessageBox(handle,'查詢完畢!','提示',MB_OK or MB_ICONINFORMATION);
    dbgrid1.Font.Color:=clgreen;
    ADOquery1.Open;
    edit1.SetFocus;
    edit1.SelectAll;
if ADOquery1.RecordCount=0 then
    begin
    application.MessageBox('你輸入的數(shù)據(jù)不存在','提示',0+64);
    exit;
    end;
end;

procedure Tbyxxcx.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
 if not (key in['0'..'9',#8])then
   begin
   key:=#0;
   Application.MessageBox('學(xué)號(hào)只能填寫(xiě)數(shù)字','警告',0+64);
   end;
end;

procedure Tbyxxcx.FormActivate(Sender: TObject);
  var
 sqlstr:string;
begin
 sqlstr:='select *from t_biye';
  Adoquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add(sqlstr);
  ADOquery1.Open;
end;

end.