unit1.pas

教学管理系统源码

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    Label1: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Label2: TLabel;
    Bevel1: TBevel;
    Label3: TLabel;
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    Image1: TImage;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    ADOQuery1: TADOQuery;
    MaskEdit1: TMaskEdit;
    Edit1: TEdit;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation
uses Unit2;
{$R *.dfm}

procedure TForm1.BitBtn1Click(Sender: TObject);
begin

if Edit1.Text='' then   //若用户框中未输入任何内容
begin
Application.MessageBox('请输入用户名','错误！',MB_OK);
Edit1.SetFocus          //则焦点仍设在该框中
end
else
if
((RadioButton1.Checked=false) and (RadioButton2.Checked=false)) then
begin
Application.MessageBox('请选择权限','错误！',MB_OK);
Edit1.SetFocus          //则焦点仍设在该框中
end
else
begin                   //判断用户合法性及权限
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('SELECT 人员代号,密码,权限 from password Where 人员代号='''+Edit1.Text+''' and 密码='''+MaskEdit1.Text+'''');
//构造新的SQL语句
//ADOQuery1.SQL.Add('Where 人员代号=''');
//ADOQuery1.SQL.Add('And 密码='+MaskEdit1.Text+'');
ADOQuery1.Open;

if (ADOQuery1.RecordCount = 0)//or
//(MaskEdit1.Text<>ADOQuery1.FieldValues['密码'])
then
begin
Application.MessageBox('密码错误，请查询！','错误！',MB_OK);
Edit1.SetFocus;  //将焦点设置在当前位置

{if MaskEdit1.Text='' then
begin
Application.MessageBox('请输入用户名','错误！',MB_OK);
MaskEdit1.SetFocus          //则焦点仍设在该框中
end;}
end
else begin
Form1.Hide;
Form2.Show;
end;
end;
end;

procedure TForm1.BitBtn2Click(Sender: TObject);
begin
MaskEdit1.SetFocus
end;

end.