unit Unit17;

interface

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

type
  Tkczj = class(TForm)
    GroupBox1: TGroupBox;
    Label11: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    StatusBar1: TStatusBar;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit4: TEdit;
    Edit3: TEdit;
    ADOQuery1: TADOQuery;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
   
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  kczj: Tkczj;

implementation
 uses unit1;
{$R *.dfm}

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

procedure Tkczj.SpeedButton2Click(Sender: TObject);
begin
edit1.Text:='';
edit2.Text:='';
edit3.Text:='';
edit4.Text:='';
end;

procedure Tkczj.SpeedButton1Click(Sender: TObject);
begin
if(edit1.Text='')or(edit2.Text='')or(edit3.Text='')
   or(edit4.Text='')then
  begin
   application.MessageBox('請(qǐng)輸入以下內(nèi)容','提示',0+64);
   exit;
  end;
 with ADOquery1 do
begin
 append;
   fieldvalues['courseID']:=edit1.text;
   fieldvalues['courseName']:=edit2.Text;
   fieldvalues['courseType']:=edit3.Text;
   fieldvalues['teacher']:=edit4.Text;
  try
  post;
  except
      Application.MessageBox('課程號(hào)重復(fù),請(qǐng)重輸','警告',0+64);
      delete;
      edit1.SetFocus;
      edit1.SelectAll;
  exit;
 end;
 end;
end;
procedure Tkczj.FormActivate(Sender: TObject);
var
sqlstr:string;
begin
  sqlstr:='select *from t_course';
  ADOquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add(sqlstr);
  ADOquery1.Open;
  dbgrid1.Font.Color:=clgreen;
end;


end.