unit1.pas

学生学籍管理 delphi+sql2000 合力制作

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls, DB, ADODB, jpeg;

type
  TForm1 = class(TForm)
    Panel1: TPanel;
    Edit1: TEdit;
    Edit2: TEdit;
    Button1: TButton;
    Button2: TButton;
    ADOQuery1: TADOQuery;
    Image1: TImage;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}
uses unit2;

procedure TForm1.Button1Click(Sender: TObject);

begin
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('select * from controller where 编号 =:name and 密码 =:pw');
  ADOQuery1.Parameters.ParamByName('name').Value := edit1.Text;
  ADOQuery1.Parameters.ParamByName('pw').Value := edit2.Text;
  ADOQuery1.Open;

  if ADOQuery1.RecordCount = 0 then
  begin
    showmessage('你输入的用户名或密码不正确，请重试！') ;
    edit1.Clear;
    edit2.Clear;
    exit;
  end;
    self.Hide;
    Form2.ShowModal;


end;
procedure TForm1.Button2Click(Sender: TObject);
begin
  self.Close;
end;

procedure TForm1.Edit2KeyPress(Sender: TObject; var Key: Char);
begin
if Key = #13 then
  begin
     Button1.SetFocus;
     Button1click(self);
  end;
end;

procedure TForm1.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
  if Key = #13 then
  edit2.SetFocus;
end;

end.