unit1.pas

来自「这是delphi 的入门代码是我们为了一次考试而准备的」· PAS 代码 · 共 106 行

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    CoolBar1: TCoolBar;
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton6: TToolButton;
    ToolButton7: TToolButton;
    ToolButton8: TToolButton;
    ToolButton9: TToolButton;
    DBGrid1: TDBGrid;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    ADOConnection1: TADOConnection;
    ADOCommand1: TADOCommand;
    ADOTable1: TADOTable;
    DataSource1: TDataSource;
    procedure ToolButton7Click(Sender: TObject);
    procedure ToolButton6Click(Sender: TObject);
    procedure ToolButton5Click(Sender: TObject);
    procedure ToolButton4Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.ToolButton1Click(Sender: TObject);
begin
  self.ADOTable1.First;
end;

procedure TForm1.ToolButton2Click(Sender: TObject);
begin
  self.ADOTable1.Prior;
end;

procedure TForm1.ToolButton3Click(Sender: TObject);
begin
  self.ADOTable1.Next;
end;

procedure TForm1.ToolButton4Click(Sender: TObject);
begin
  self.ADOTable1.Last;
end;

procedure TForm1.ToolButton5Click(Sender: TObject);
begin
  self.ADOCommand1.CommandText:='exec add_record @sno=:p1,@sna=:p2,@sdept=:p3';
  self.ADOCommand1.Parameters.ParamValues['p1']:=self.DBEdit1.Text;
  self.ADOCommand1.Parameters.ParamValues['p2']:=self.DBEdit2.Text;
  self.ADOCommand1.Parameters.ParamValues['p3']:=self.DBEdit3.Text;
  self.ADOCommand1.Execute;
  showmessage('添加成功!');
  self.ADOTable1.Refresh;

end;

procedure TForm1.ToolButton6Click(Sender: TObject);
begin
  self.ADOCommand1.CommandText:='exec del_record @sno=:p1';
  self.ADOCommand1.Parameters.ParamValues['p1']:=self.DBEdit1.Text;
  self.ADOCommand1.Execute;
  showmessage('删除成功!');
  self.ADOTable1.Refresh;
end;

procedure TForm1.ToolButton7Click(Sender: TObject);
begin
  self.ADOCommand1.CommandText:='exec update_record @sno=:p1,@sna=:p2,@sdept=:p3';
  self.ADOCommand1.Parameters.ParamValues['p1']:=self.DBEdit1.Text;
  self.ADOCommand1.Parameters.ParamValues['p2']:=self.DBEdit2.Text;
  self.ADOCommand1.Parameters.ParamValues['p3']:=self.DBEdit3.Text;
  self.ADOCommand1.Execute;
  showmessage('更新成功!');
  self.ADOTable1.Refresh;   
end;

end.