unit4.~pas

本例是用delphi开发的学生与课程信息管理系统

unit Unit4;

interface

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

type
  TFormstu_del = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Editsno: TEdit;
    Editsname: TEdit;
    Label3: TLabel;
    Querystu_del: TQuery;
    DataSourcestu_del: TDataSource;
    DBGridstu_del: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    Button7: TButton;
    procedure Button1Click(Sender: TObject);
    procedure DBGridstu_delCellClick(Column: TColumn);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Formstu_del: TFormstu_del;

implementation

{$R *.dfm}

procedure TFormstu_del.Button1Click(Sender: TObject);
var
 sno,sname:string;flag:integer;
begin
  sno:=editsno.text;
  sname:=editsname.text;
  flag:=messagedlg('确实要注销吗？',mtconfirmation,[mbyes,mbno],0);
  if flag=mryes then
    begin
      with querystu_del do
        begin
          close;
          sql.clear;
          sql.add('delete from student where sno=:snoname');
          parambyname('snoname').asstring:=sno;
          prepare;
          execsql;
        end;
      with querystu_del do
        begin
          close;
          sql.clear;
          sql.add('select * from student');
          sql.add('order by sno');
          prepare;
          open;
        end;
    end;
    editsno.text:='';
    editsname.text:='';
end;

procedure TFormstu_del.DBGridstu_delCellClick(Column: TColumn);
begin
  editsno.text:=dbgridstu_del.fields[0].asstring;
  editsname.text:=dbgridstu_del.fields[1].asstring;
end;

procedure TFormstu_del.Button2Click(Sender: TObject);
begin
  close;
end;

end.