unit1.pas

sql server 2005书中11到16章的全部代码

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Edit2: TEdit;
    Button1: TButton;
    Label1: TLabel;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    Button7: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
adoquery1.Close ;
adoquery1.SQL.Clear ;
adoquery1.SQL.Add('select * from stu where  '+ edit2.Text ) ;
adoquery1.Open ;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
adoquery1.Insert ;
end;

procedure TForm1.Button3Click(Sender: TObject);
var i:integer ;
begin
 i:=messagedlg('确定要删除该记录吗？',mtconfirmation,[mbyes,mbno],1) ;
 if i=6 then                      //如果你单击"YES"按钮，则会删除记录
 begin
adoquery1.Delete ;
if adoquery1.Eof then
showmessage('没有数据要删除了!') ;
end ;
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
adoquery1.Prior ;                               //移动到上一条记录
if adoquery1.Bof then
 //如果移过第一条记录，则会显示提示对话框
showmessage('移过第一笔了!') ;
end;

procedure TForm1.Button5Click(Sender: TObject);
begin
adoquery1.Next ;       //移动到下一条记录
if adoquery1.Eof then               
//如果移过最后一条记录，则会显示提示对话框
showmessage('移过最后一笔了') ;
end;

procedure TForm1.Button6Click(Sender: TObject);
begin
adoquery1.First  ;
end;

procedure TForm1.Button7Click(Sender: TObject);
begin
adoquery1.Last ;
end;

end.