unit11.pas

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

unit Unit11;

interface

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

type
  TForm11 = class(TForm)
    GroupBox1: TGroupBox;
    Edit1: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    ComboBox1: TComboBox;
    Label5: TLabel;
    Edit4: TEdit;
    Label6: TLabel;
    Edit5: TEdit;
    Label7: TLabel;
    Edit6: TEdit;
    Label8: TLabel;
    Edit7: TEdit;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    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
  Form11: TForm11;
  pass:string;
implementation
uses unit6;
{$R *.dfm}

procedure TForm11.Button1Click(Sender: TObject);
begin
    with data.ADOQuery1 do
    begin
        close;
        sql.Clear;
        sql.Add('select * from 学生');
        sql.Add('where 学生学号='''+Edit1.Text+'''');
        open;
        edit2.Text:=fieldbyname('学生姓名').AsString;
        combobox1.Text:=fieldbyname('性别').AsString;
        edit3.Text:=fieldbyname('密码').AsString;
        edit4.Text:=fieldbyname('出生年月').AsString;
        edit5.Text:=fieldbyname('所在学院').AsString;
        edit6.Text:=fieldbyname('联系电话').AsString;
        edit7.Text:=fieldbyname('备注').AsString;
    end
end;

procedure TForm11.Button2Click(Sender: TObject);
begin
    with data.ADOQuery1 do
    begin
        close;
        sql.Clear;
        sql.Add('update 学生');
        sql.Add('set 学生姓名='''+Edit2.Text+''',密码='''+Edit3.Text+''',性别='''+Combobox1.Text+''',出生年月='''+Edit4.Text+''',所在学院='''+Edit5.Text+''',联系电话='''+Edit6.Text+''',备注='''+Edit7.Text+'''');
        sql.Add('where 学生学号='''+Edit1.Text+'''');
        execsql;
        application.MessageBox('修改成功','修改信息',MB_OK+MB_ICONEXCLAMATION);
        with data.ADOQuery2 do
        begin
          close;
          sql.Clear;
          sql.Add('select * from 学生');
          open;
          edit1.Clear;
          edit2.Clear;
          edit3.Clear;
          edit4.Clear;
          edit5.Clear;
          edit6.Clear;
          edit7.Clear;
        end
    end
end;

procedure TForm11.Button3Click(Sender: TObject);
begin
    with data.ADOQuery1 do
    begin
        close;
        sql.Clear;
        sql.Add('insert into 学生');
        sql.Add('values('''+Edit1.Text+''','''+Edit2.Text+''','''+Edit3.Text+''','''+Combobox1.Text+''','''+Edit4.Text+''','''+Edit5.Text+''','''+Edit6.Text+''','''+Edit7.Text+''')');
        execsql;
        application.MessageBox('添加成功','添加信息',MB_OK+MB_ICONEXCLAMATION);
        with data.ADOQuery2 do
        begin
          close;
          sql.Clear;
          sql.Add('select * from 学生');
          open;
          edit1.Clear;
          edit2.Clear;
          edit3.Clear;
          edit4.Clear;
          edit5.Clear;
          edit6.Clear;
          edit7.Clear;
        end
    end
end;

procedure TForm11.Button4Click(Sender: TObject);
begin
    with data.ADOQuery1 do
    begin
        close;
        sql.Clear;
        sql.Add('delete from 学生');
        sql.Add('where 学生学号='''+Edit1.Text+'''');
        execsql;
        application.MessageBox('删除成功','删除信息',MB_OK+MB_ICONEXCLAMATION);
        with data.ADOQuery2 do
        begin
            close;
            sql.Clear;
            sql.Add('select * from 学生');
            open;
            edit1.Clear;
            edit2.Clear;
            edit3.Clear;
            edit4.Clear;
            edit5.Clear;
            edit6.Clear;
            edit7.Clear;
        end
    end
end;

end.