unit19.~pas

学生信息管理系统 学生信息管理系统 学生信息管理系统

unit Unit19;

interface

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

type
  Tbjsr = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    DBGrid1: TDBGrid;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton4: TSpeedButton;
    Image1: TImage;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);


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

var
  bjsr: Tbjsr;

implementation
 uses unit1;
{$R *.dfm}

procedure Tbjsr.SpeedButton4Click(Sender: TObject);
begin
self.Close;
end;

procedure Tbjsr.SpeedButton2Click(Sender: TObject);
begin
edit1.Clear;
edit2.Clear;
edit3.Clear;
edit4.Clear;
edit5.Clear;
end;

procedure Tbjsr.FormActivate(Sender: TObject);
 var
 sqlstr:string;
begin

  sqlstr:='select *from t_banji';
  Adoquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add(sqlstr);
  ADOquery1.Open;

end;

procedure Tbjsr.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;

 with ADOquery1 do
 begin
 append;
 fieldvalues['班级号']:=edit1.Text;
 fieldvalues['所在年级']:=edit2.Text;
 fieldvalues['所学专业']:=edit3.Text;
 fieldvalues['班主任姓名']:=edit4.Text;
 fieldvalues['教室号']:=edit5.Text;
 try
 post;
 except
 Application.MessageBox('班级号重复，请重新输入！','警告',0+64);
      delete;
      edit1.SetFocus;
      edit1.SelectAll;
      exit;
 end;
end;
end;



end.