glyh.pas

来自「学生管理系统小鸟做了」· PAS 代码 · 共 65 行

unit glyh;

interface

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

type
  Tfmglyh = class(TForm)
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fmglyh: Tfmglyh;

implementation

uses dm;

{$R *.dfm}

procedure Tfmglyh.Button1Click(Sender: TObject);
begin
if edit1.Text='' then
  begin
    messagedlg('请输入要删除用户的编号！',mtInformation,[mbYes],0);
    exit;
  end;
 fmdm.qryglyh.Close;
 fmdm.qryglyh.SQL.Clear;
 fmdm.qryglyh.SQL.Add('delete from tab_stu where stu_id=:A');
 fmdm.qryglyh.Parameters.ParamByName('A').Value:=edit1.Text;
 try
      fmdm.qryglyh.ExecSQL;
      MessageDlg('删除记录成功！', mtInformation, [mbYes],0);
    except
      MessageDlg('操作失败！', mtInformation, [mbYes],0);
    end;

  fmdm.qryglyh.SQL.Clear;
  fmdm.qryglyh.SQL.Add('select * from tab_stu');
  fmdm.qryglyh.Open;
end;

procedure Tfmglyh.FormCreate(Sender: TObject);
begin
fmdm.qryglyh.Close;
fmdm.qryglyh.SQL.Clear;
fmdm.qryglyh.SQL.Add('select * from tab_stu');
fmdm.qryglyh.Open;
end;

end.