unit6.pas

来自「学生档案管理系统,有登录模块」· PAS 代码 · 共 62 行

unit Unit6;

interface

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

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

var
  Form6: TForm6;

implementation

uses unit1;

{$R *.dfm}

procedure TForm6.Button1Click(Sender: TObject);
begin
   dm.ADOQuery2.Close;
   dm.ADOQuery2.SQL.Clear;
   dm.ADOQuery2.SQL.Add('select * from dangan');
   dm.ADOQuery2.SQL.Add('where 姓名 like''%'+edit1.text+'%''');
   dm.ADOQuery2.Open;
   panel1.Caption:='总共找到'+inttostr(dm.ADOQuery2.RecordCount)+'条记录';
   
end;

procedure TForm6.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    action:=cafree;
end;

procedure TForm6.FormCreate(Sender: TObject);
begin
    dm.ADOConnection1.Close;
    try
       dm.ADOConnection1.Open;
       except
           application.MessageBox('找不到数据库，引起该问题的原因是数据库文件可能被人为删除或改名','无法打开数据库',0);
           application.Terminate;
       end;
end;

end.