renewindex.pas

一个不错的信息管理系统

unit renewindex;

interface

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

type
  TForm11 = class(TForm)
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    Bevel1: TBevel;
    Memo1: TMemo;
    Bevel2: TBevel;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    DataSource1: TDataSource;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Button7: TButton;
    Label1: TLabel;
    Label2: TLabel;
    procedure Button2Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form11: TForm11;

implementation

{$R *.dfm}

procedure TForm11.Button2Click(Sender: TObject);
begin
adoquery1.Prior;
end;

procedure TForm11.Button7Click(Sender: TObject);
begin
button1.Enabled:=false;
button2.Enabled :=false;
button3.Enabled:=false;
button4.Enabled :=false;
memo1.Text:='';
memo1.SetFocus;
adoquery1.Active:=false;
end;

procedure TForm11.Button1Click(Sender: TObject);
begin
adoquery1.First;
end;

procedure TForm11.Button3Click(Sender: TObject);
begin
adoquery1.Next;
end;

procedure TForm11.Button4Click(Sender: TObject);
begin
adoquery1.Last;
end;

procedure TForm11.Button6Click(Sender: TObject);
begin
button1.Enabled:=false;
button2.Enabled :=false;
button3.Enabled:=false;
button4.Enabled :=false;
memo1.Text:='';
form11.Close;
end;

procedure TForm11.Button5Click(Sender: TObject);
begin
if memo1.Text='' then
begin
application.MessageBox('请输入SQL查询的语句例如：selete* from 表名 where 条件','提示',32);
memo1.SetFocus;
end
else
begin
adoquery1.Active:=false;
adoquery1.SQL.Clear;
adoquery1.SQL.Add(memo1.Text);
adoquery1.SQL:=memo1.Lines ;
adoquery1.Open;
memo1.SetFocus;
adoquery1.Active:=true;
button1.Enabled:=true;
button2.Enabled :=true;
button3.Enabled:=true;
button4.Enabled :=true;
end;
end;

procedure TForm11.FormActivate(Sender: TObject);
begin
memo1.SetFocus;
end;

end.