unit5.~pas

学生管理系统(delphi7.0+sql2000) 对学生基本信息,学生成绩,课程进行插,删,改功能

unit Unit5;

interface

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

type
  Tform5 = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label8: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Edit1: TEdit;
    Panel1: TPanel;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Label3: TLabel;
    Edit3: TEdit;
    Button4: TButton;
    DBGrid1: TDBGrid;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    Edit2: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Button1Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure Button2Click(Sender: TObject);


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

var
  form5: Tform5;

implementation
uses Unit1;
{$R *.dfm}
procedure Tform5.Button3Click(Sender: TObject);
begin

DBGrid1.Refresh;
DBgrid1.Font.Color:=clgreen;
end;

procedure Tform5.Button4Click(Sender: TObject);
begin
self.Close;
end;
procedure Tform5.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
if not (key in['0'..'9',#8])then
begin
key:=#0;
application.MessageBox('学号只能填写数字','提示',0+64);
end;
end;
procedure Tform5.Button1Click(Sender: TObject);
begin
if (edit1.Text='')or(edit3.Text='')then
begin
application.MessageBox('下面内容不能为空','提示',0+64);
exit;
end;
with ADOquery1 do
begin
 append;
 fieldvalues['学号']:=edit1.Text;
 fieldvalues['课程名称']:=edit2.text;
 fieldvalues['学期']:=edit5.Text;
 fieldvalues['授课教师']:=edit4.Text;
 fieldvalues['成绩']:=edit3.Text;
 try
 post;
 edit3.Clear;
 edit1.SetFocus;
 Edit1.SelectAll;
 except
 application.MessageBox('学号重复请重新输入','提示',0+64);
 delete;
 edit1.SetFocus;
 Edit1.SelectAll;
 exit;
 end;
 end;
end;

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





procedure Tform5.Button2Click(Sender: TObject);
begin
edit3.Clear;
edit1.SetFocus;
edit1.SelectAll;
end;


end.