unit Unit4;

interface

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

type
  Tjbxxcx = class(TForm)
    GroupBox1: TGroupBox;
    StatusBar1: TStatusBar;
    DBGrid1: TDBGrid;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    GroupBox3: TGroupBox;
    Button2: TButton;
    SpeedButton1: TSpeedButton;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    Label5: TLabel;
    Edit5: TEdit;
    procedure Button2Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  jbxxcx: Tjbxxcx;

implementation
uses unit1;

  {$R *.dfm}

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

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

procedure Tjbxxcx.Button1Click(Sender: TObject);
begin

 if edit1.Text='' then
    begin
    application.MessageBox('下面內容不能為空','提示',0+64);
    exit;
    end;
    ADOquery1.SQL.Clear;
    ADOquery1.Close;
    ADOquery1.SQL.Add('select *from t_information where 學號='''+edit1.text+'''');
     //MessageBox(handle,'查詢完畢!','提示',MB_OK or MB_ICONINFORMATION);
    dbgrid1.Font.Color:=clteal;
    ADOquery1.Open;
    edit1.SetFocus;
    edit1.SelectAll;

   if ADOquery1.RecordCount=0 then
    begin
    application.MessageBox('你輸入的數據不存在','提示',0+64);
    exit;
    end;
end;

procedure Tjbxxcx.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
 if not(key in['0'..'9',#8])then
 begin
 key:=#0;
 application.MessageBox('學號只能填寫數字','提示',0+64);
 exit;
 end;
end;
procedure Tjbxxcx.SpeedButton1Click(Sender: TObject);
 var
 sql:string;
begin
{   if(edit2.Text<>'')or(edit3.Text<>'')or(edit4.Text<>'')or(edit5.Text<>'')then
     sql:='where(學號 like '''+'%'+edit2.Text+'%'')or(姓名 like '''+'%'+edit3.Text+'%'')or(所在班級 like '''+'%'+edit4.Text+'%'')or(所學專業 like '''+'%'+edit5.Text+'%'')'
  else
   begin
    application.MessageBox('請輸入查詢內容','提示',mb_ok);
    exit;
    end;
 }
 sql:='where(學號 like '''+'%'+edit2.Text+'%'') and (姓名 like '''+'%'+edit3.Text+'%'') and (所在班級 like '''+'%'+edit4.Text+'%'') and(所學專業 like '''+'%'+edit5.Text+'%'')';

 ADOquery1.SQL.Clear;
 ADOquery1.Close;
 ADOquery1.SQL.Add('select * from t_information');
 ADOquery1.SQL.Add(sql);
 ADoquery1.Open;

 end;
end.