login.pas

中学考试管理系统 采用智能管理 具有统计分析的能力

unit login;

interface

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

type
  TForm1 = class(TForm)
    Label1: TLabel;
    Panel1: TPanel;
    Label2: TLabel;
    userName: TEdit;
    Label3: TLabel;
    password: TEdit;
    Button1: TButton;
    Button2: TButton;
    ADOConnection1: TADOConnection;
    logonQry: TADOQuery;
    Label4: TLabel;
    uType: TComboBox;
    Button3: TButton;
    Button4: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses main, logout, regist;

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
    with logonqry do
        begin
           Close;
           SQL.clear;
           SQL.add('select * from login ');
           SQL.add('where  用户名='''+userName.text +''' and  密码 = '''+password.text+'''and 角色 ='''+uType.text+'''');
           open;
           if not eof then
             begin
               form1.Hide;
               form2.Show;
              end
            else
              begin
                ShowMessage('用户名或密码错误');
                userName.Clear;
                password.Clear;
              end;
            Close;
          end  ;

end;

procedure TForm1.Button3Click(Sender: TObject);
begin
  Form1.Hide;
  Form14.show;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  userName.Clear;
  password.Clear;
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
  Form1.Hide;
  Form15.show;
end;

end.