unit10.pas

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

unit Unit10;

interface

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

type
  TForm10 = class(TForm)
    Panel1: TPanel;
    Label11: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton3: TSpeedButton;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    SpeedButton2: TSpeedButton;
    DBGrid1: TDBGrid;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit4: TEdit;
    Edit3: TEdit;
    Edit5: TEdit;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure ADOQuery1AfterScroll(DataSet: TDataSet);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form10: TForm10;

implementation

{$R *.dfm}

procedure TForm10.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
begin
 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('修改完毕','提示',0+64);
 end;
 end;
procedure TForm10.SpeedButton2Click(Sender: TObject);
var
i:integer;
begin
 i:=application.MessageBox('你确定要删除吗？','删除提示',mb_YesNO);
 if i=7 then
 exit;
 ADOquery1.Delete;
end;

procedure TForm10.SpeedButton3Click(Sender: TObject);
begin
self.Close;
end;

procedure TForm10.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 TForm10.FormActivate(Sender: TObject);
var
sqlstr:string;
begin
sqlstr:='select * from 成绩表';
ADOquery1.Close;
ADOquery1.SQL.Clear;
ADOquery1.SQL.Add(sqlstr);
ADOquery1.Open;
end;

end.