unit1.pas

SQL server 2000 + Delphi 7 做的学生管理及综合积分测评系统。

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    StaticText1: TStaticText;
    StaticText2: TStaticText;
    StaticText3: TStaticText;
    Edit1: TEdit;
    Edit2: TEdit;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    ADOQuery1: TADOQuery;
    ComboBox1: TComboBox;
    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
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Text:='select 密码 from 用户管理 where 类型='''+ComboBox1.Text+''' and 用户名='''+Edit1.Text+''' and 密码='''+Edit2.Text+'''  ';
  ADOQuery1.Close;
  ADOQuery1.Open;

if(ADOQuery1.FieldByName('密码').AsString<>'') then
  begin
  form2.show;
  form1.Hide;
  end
else
  begin
      ShowMessage('用户名或密码错误！');
  end
end;

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

end.