addstudent.pas

来自「所有delphi的入门例子」· PAS 代码 · 共 50 行

unit addStudent;

interface

uses Windows, SysUtils, Classes, Graphics, Forms, Controls, StdCtrls,
  Buttons, ExtCtrls, ADODB;

type
  TOKRightDlg1 = class(TForm)
    OKBtn: TButton;
    CancelBtn: TButton;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    ADOCommand1: TADOCommand;
    procedure OKBtnClick(Sender: TObject);
    procedure CancelBtnClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  OKRightDlg1: TOKRightDlg1;

implementation

{$R *.dfm}

procedure TOKRightDlg1.OKBtnClick(Sender: TObject);
var
  sql : string;
begin
  sql := 'insert into student(classroomid,name,email) values ('''+edit1.text+''','''+edit2.text+''','''+edit3.text+''')';
  ADOCommand1.CommandText := sql;
  ADOCommand1.Execute ;
  close;
end;

procedure TOKRightDlg1.CancelBtnClick(Sender: TObject);
begin
  close;
end;

end.