unit Unit20;

interface

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

type
  Tbjxg = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Image1: TImage;
    DBGrid1: TDBGrid;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    Splitter1: TSplitter;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure ADOQuery1AfterScroll(DataSet: TDataSet);
    procedure FormActivate(Sender: TObject);
    
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  bjxg: Tbjxg;

implementation
   uses unit1;
{$R *.dfm}

procedure Tbjxg.SpeedButton3Click(Sender: TObject);
begin
close;
end;

procedure Tbjxg.SpeedButton2Click(Sender: TObject);
var
 i:integer;
begin
i:=application.MessageBox('你確定要刪除嗎？','刪除提示',mb_YesNO);
 if i=7 then   //不刪除
 exit;
 ADOquery1.Delete;

end;

procedure Tbjxg.SpeedButton1Click(Sender: TObject);
begin
 if(edit1.Text='')or(edit2.Text='')or(edit3.Text='')or(edit4.Text='')or(edit5.Text='')then
 begin
 application.MessageBox('請輸入內容','提示',0+64);
 exit;
 end
 else
  ADOquery1.Edit;
  ADOquery1.fieldvalues['班級號']:=edit1.Text;
  ADOquery1.fieldvalues['所在年級']:=edit2.Text;
  ADOquery1.fieldvalues['所學專業']:=edit3.Text;
  ADOquery1.fieldvalues['班主任姓名']:=edit4.Text;
  ADOquery1.fieldvalues['教室號']:=edit5.Text;
  ADoquery1.Post;
  application.MessageBox('信息已經修改完成！','修改提示',mb_ok);
end;

procedure Tbjxg.ADOQuery1AfterScroll(DataSet: TDataSet);
begin
edit1.Text:=ADOquery1.fieldvalues['班級號'];
edit2.Text:=ADOquery1.fieldvalues['所在年級'];
edit3.Text:=ADOquery1.fieldvalues['所學專業'];
edit4.Text:=ADOquery1.fieldvalues['班主任姓名'];
edit5.Text:=ADOquery1.fieldvalues['教室號'];
end;

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



end.