unit7.pas

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

unit Unit7;

interface

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

type
  TForm7 = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label3: TLabel;
    Label5: TLabel;
    Label7: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    ComboBox1: TComboBox;
    Edit3: TEdit;
    Button2: TButton;
    Button1: TButton;
    Label2: TLabel;
    Edit4: TEdit;
    Label4: TLabel;
    Edit5: TEdit;
    Label6: TLabel;
    Edit6: TEdit;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form7: TForm7;
  count:smallint;
  pass:String;

implementation
uses Unit6;
{$R *.dfm}

procedure TForm7.Button1Click(Sender: TObject);
begin
    with Unit6.Data.ADOQuery1 do
    begin
      close;
      sql.Clear;
      sql.Add('select * from 学生');
      sql.Add('where 学生学号 ='''+pass+'''');
      open;
      Edit1.Text:=FieldByName('学生学号').AsString;
      Edit2.Text:=FieldByName('学生姓名').AsString;
      Edit3.Text:=FieldByName('出生年月').AsString;
      Edit4.Text:=FieldByName('所在学院').AsString;
      Edit5.Text:=FieldByName('联系电话').AsString;
      Edit6.Text:=FieldByName('备注').AsString;
      ComboBox1.Text:=FieldByName('性别').AsString;
      count:=1;
    end
end;

procedure TForm7.Button2Click(Sender: TObject);
begin
  if count=1 then
    begin
      Button2.Caption:='确认修改';
      Button1.Caption:='复位';
      ComboBox1.Enabled:=True;
      Edit2.Enabled:=True;
      Edit3.Enabled:=True;
      Edit4.Enabled:=True;
      Edit5.Enabled:=True;
      Edit6.Enabled:=True;
      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+''',联系电话='''+Edit5.Text+''',备注='''+Edit6.Text+'''');
        sql.Add('where 学生学号='''+pass+'''');
        EXECSQL;
        ComboBox1.Enabled:=False;
        Edit2.Enabled:=False;
        Edit3.Enabled:=False;
        Edit4.Enabled:=False;
        Edit5.Enabled:=False;
        Edit6.Enabled:=False;
        count:=1;
        Button2.Caption:='修改';
        Button1.Caption:='查询';
      end
    end
end;

end.