unit5.pas

简单的选课系统 采用delphi书写 包含简单的管理功能以及学生 教师 管理员登陆

unit Unit5;

interface

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

type
  TForm5 = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label3: TLabel;
    Label5: TLabel;
    Label7: TLabel;
    Label9: TLabel;
    Label11: TLabel;
    Label13: TLabel;
    Label15: TLabel;
    Label17: TLabel;
    Label19: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    ComboBox1: TComboBox;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Button2: TButton;
    Button1: TButton;
    Button3: TButton;
    Label2: TLabel;
    Edit10: TEdit;
    DBGrid1: TDBGrid;
    Button4: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form5: TForm5;
  count:smallint;
  pass:String;

implementation
Uses Unit2,Unit1,Unit6;
{$R *.dfm}


procedure TForm5.Button1Click(Sender: TObject);
begin
    with Unit6.Data.ADOQuery1 do
    begin
      close;
      sql.Clear;
      sql.Add('select * from 管理员');
      sql.Add('where 管理员账号 ='''+Edit1.Text+'''');
      open;
      Edit2.Text:=FieldByName('姓名').Text;
      ComboBox1.Text:=FieldByName('性别').AsString;
      Edit3.Text:=FieldByName('出生年月').AsString;
      Edit4.Text:=FieldByName('所在单位').AsString;
      Edit5.Text:=FieldByName('邮政编码').AsString;
      Edit6.Text:=FieldByName('联系地址').AsString;
      Edit7.Text:=FieldByName('电话1').AsString;
      Edit8.Text:=FieldByName('电话2').AsString;
      Edit9.Text:=FieldByName('备注').AsString;
      Edit10.Text:=FieldByName('密码').AsString;
      count:=1;
      with data.ADOQuery2 do
      begin
        close;
        sql.Clear;
        sql.Add('select * from 管理员');
        open;
      end
    end
end;

procedure TForm5.Button2Click(Sender: TObject);
begin
    if count=1 then
    begin
      Button2.Caption:='确认修改';
      Button1.Caption:='复位';
      count:=2;
    end
    else
    begin
      with Unit6.Data.ADOQuery1 do
      begin
        close;
        sql.Clear;
        sql.Add('update 管理员');
        sql.Add('set 姓名='''+Edit2.Text+''',性别='''+ComboBox1.Text+''',出生年月='''+Edit3.Text+''',所在单位='''+Edit4.Text+''',联系地址='''+Edit6.Text+''',邮政编码='''+Edit5.Text+''',电话1='''+Edit7.Text+''',电话2='''+Edit8.Text+''',备注='''+Edit9.Text+''',密码='''+Edit10.Text+'''');
        sql.Add('where 管理员账号='''+Edit1.Text+'''');
        EXECSQL;
        application.MessageBox('修改成功','修改信息',MB_OK+MB_ICONEXCLAMATION);
        edit1.Clear;
        edit2.Clear;
        Edit3.Clear;
        Edit4.Clear;
        edit5.Clear;
        edit6.Clear;
        edit7.Clear;
        Edit8.Clear;
        Edit9.Clear;
        edit10.Clear;
        count:=1;
        Button2.Caption:='修改';
        Button1.Caption:='查询';
        with data.ADOQuery2 do
      begin
        close;
        sql.Clear;
        sql.Add('select * from 管理员');
        open;
      end
      end
    end
end;
procedure TForm5.Button3Click(Sender: TObject);
begin
    with data.ADOQuery1 do
    begin
        close;
        sql.Clear;
        sql.Add('insert into 管理员');
        sql.Add('values ('''+Edit1.Text+''','''+Edit10.Text+''','''+Edit2.Text+''','''+Combobox1.Text+''','''+Edit3.Text+''','''+Edit4.Text+''','''+Edit6.Text+''','''+Edit5.Text+''','''+Edit7.Text+''','''+Edit8.Text+''','''+Edit9.Text+''')');
        execsql;
        application.MessageBox('添加成功','添加信息',MB_OK+MB_ICONEXCLAMATION);
        edit1.Clear;
        edit2.Clear;
        Edit3.Clear;
        Edit4.Clear;
        edit5.Clear;
        edit6.Clear;
        edit7.Clear;
        Edit8.Clear;
        Edit9.Clear;
        edit10.Clear;
        with data.ADOQuery2 do
        begin
          close;
          sql.Clear;
          sql.Add('select * from 管理员');
          open;
        end
    end
end;

procedure TForm5.Button4Click(Sender: TObject);
begin
    with data.ADOQuery1 do
    begin
        close;
        sql.Clear;
        sql.Add('delete from 管理员');
        sql.Add('where 管理员账号='''+Edit1.Text+'''');
        execsql;
        with data.ADOQuery2 do
        begin
          close;
          sql.Clear;
          sql.Add('select * from 管理员');
          open;
        end
    end
end;

end.