unit2.pas

本系统是基于现代大学校园的课程选择和管理而设计的。该操作说明是给第一次使用本系统的人来使用的。本操作说明讲述了怎样一步步对数据库进行操作

unit Unit2;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls, Grids, DBGrids, ComCtrls, DBCtrls, Mask,
  jpeg;

type
  TForm2 = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    ComboBox1: TComboBox;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Panel2: TPanel;
    Label2: TLabel;
    Label3: TLabel;
    ComboBox2: TComboBox;
    Button4: TButton;
    Button5: TButton;
    Edit1: TEdit;
    Panel3: TPanel;
    Panel5: TPanel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Button7: TButton;
    Button8: TButton;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    Label26: TLabel;
    Button11: TButton;
    Button12: TButton;
    Edit14: TEdit;
    Edit15: TEdit;
    Edit16: TEdit;
    Edit17: TEdit;
    Edit18: TEdit;
    Edit19: TEdit;
    Edit20: TEdit;
    Edit21: TEdit;
    DBGrid2: TDBGrid;
    StatusBar1: TStatusBar;
    Panel6: TPanel;
    Label10: TLabel;
    DBGrid3: TDBGrid;
    Button9: TButton;
    Label11: TLabel;
    Label12: TLabel;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label27: TLabel;
    Edit10: TEdit;
    Edit11: TEdit;
    Label28: TLabel;
    Button13: TButton;
    Button14: TButton;
    Button15: TButton;
    DateTimePicker1: TDateTimePicker;
    Button16: TButton;
    Button6: TButton;
    Button17: TButton;
    Button18: TButton;
    Button10: TButton;
    Panel4: TPanel;
    Button19: TButton;
    Button20: TButton;
    Button21: TButton;
    Button22: TButton;
    Button23: TButton;
    Button24: TButton;
    Label9: TLabel;
    Label29: TLabel;
    Label30: TLabel;
    Label31: TLabel;
    Label32: TLabel;
    Edit12: TEdit;
    Edit13: TEdit;
    Edit22: TEdit;
    Edit23: TEdit;
    Edit24: TEdit;
    DBGrid1: TDBGrid;
    Label33: TLabel;
    Button25: TButton;
    Panel7: TPanel;
    Label34: TLabel;
    Label35: TLabel;
    Label36: TLabel;
    Label37: TLabel;
    Label38: TLabel;
    Label39: TLabel;
    Label40: TLabel;
    Edit25: TEdit;
    Edit26: TEdit;
    Edit27: TEdit;
    Edit28: TEdit;
    Edit29: TEdit;
    Edit30: TEdit;
    Edit31: TEdit;
    Button26: TButton;
    Button27: TButton;
    Button28: TButton;
    DBGrid4: TDBGrid;
    Label41: TLabel;
    Image1: TImage;
    Image2: TImage;
    Image3: TImage;
    Image4: TImage;
    Image5: TImage;
    Image6: TImage;
    Image7: TImage;
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
    procedure Button12Click(Sender: TObject);
    procedure Button11Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure DBGrid3CellClick(Column: TColumn);
    procedure Button13Click(Sender: TObject);
    procedure Button14Click(Sender: TObject);
    procedure Button15Click(Sender: TObject);
    procedure Button16Click(Sender: TObject);
    procedure DBGrid2CellClick(Column: TColumn);
    procedure Button17Click(Sender: TObject);
    procedure Button18Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure Button19Click(Sender: TObject);
    procedure Button20Click(Sender: TObject);
    procedure Button21Click(Sender: TObject);
    procedure Button22Click(Sender: TObject);
    procedure Button23Click(Sender: TObject);
    procedure Button24Click(Sender: TObject);
    procedure Button25Click(Sender: TObject);
    procedure DBGrid4CellClick(Column: TColumn);
    procedure Button26Click(Sender: TObject);
    procedure Button27Click(Sender: TObject);
    procedure Button28Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form2: TForm2;

implementation

uses Unit1;

{$R *.dfm}

procedure TForm2.Button1Click(Sender: TObject);
begin
if combobox1.Text='课程' then
begin
panel1.Visible:=false;
panel2.Visible:=true;
end
else
if combobox1.Text='学生信息' then
begin
panel1.Visible:=false;
panel6.Visible:=true;
Label10.Caption:='学生信息查询修改界面';
Form1.AdoQuery1.Close;
Form1.AdoQuery1.SQL.Clear;
Form1.AdoQuery1.SQL.Add('select * from 学生   ');
Form1.AdoQuery1.Open;
end
else
if combobox1.Text='老师信息' then
begin
panel1.Visible:=false;
panel4.Visible:=true;
//Label10.Caption:='老师信息查询修改界面';
Form1.AdoQuery1.Close;
Form1.AdoQuery1.SQL.Clear;
Form1.AdoQuery1.SQL.Add('select * from 老师  ');
Form1.AdoQuery1.Open;
end
else
if combobox1.Text='课程申请处理' then
begin
panel1.Visible:=false;
panel7.Visible:=true;
Form1.AdoQuery1.Close;
Form1.AdoQuery1.SQL.Clear;
Form1.AdoQuery1.SQL.Add('select * from 课程申请表');
Form1.AdoQuery1.Open;
end
else
begin
showmessage('请输入要查询的相关项目！');
end;
end;

procedure TForm2.Button4Click(Sender: TObject);
begin
if (combobox2.Text<>'')and (Edit1.Text<>'') then
begin
Form1.AdoQuery1.Close;
Form1.AdoQuery1.SQL.Clear;
Form1.AdoQuery1.SQL.Add('select * from 课程 where "'+combobox2.Text+'"='''+Edit1.Text+'''  ');
Form1.AdoQuery1.Open;
if Form1.ADOQuery1.RecordCount=1 then
begin
Edit1.Text:='';
//Dbgrid1.Visible:=true;
panel2.Visible:=false;
panel5.Visible:=true;
end
else
begin
showmessage('没有找到相关课程！请核实后重新查询！');
end;
end
else
begin
Form1.AdoQuery1.Close;
Form1.AdoQuery1.SQL.Clear;
Form1.AdoQuery1.SQL.Add('select * from 课程   ');
Form1.AdoQuery1.Open;
Edit1.Text:='';
//Dbgrid1.Visible:=true;
panel2.Visible:=false;
panel5.Visible:=true;
end;
end;

procedure TForm2.Button2Click(Sender: TObject);
begin
Form1.Timer1.Enabled:=false;
showmessage(''+Form2.StatusBar1.Panels[1].Text+''+#13+'上线时间为：'+Form2.StatusBar1.Panels[4].Text+'秒');
Form2.StatusBar1.Panels[1].Text:='管理者：';
close;
end;

procedure TForm2.Button3Click(Sender: TObject);
begin
panel1.Visible:=false;
panel3.Visible:=true;
end;

procedure TForm2.Button7Click(Sender: TObject);
begin
Form1.ADOQuery1.Close;
Form1.ADOQuery1.SQL.Clear;
Form1.ADOQuery1.SQL.Add('select * from 管理员 where 用户名='''+Edit2.Text+''' and 密码='''+Edit3.Text+'''');
Form1.ADOQuery1.Open;
if Form1.ADOQuery1.RecordCount=1 then
begin
if Edit4.Text=Edit5.Text then
begin
Form1.ADOQuery1.Close;
Form1.ADOQuery1.SQL.Clear;
Form1.ADOQuery1.SQL.Add('update 管理员 set 密码='''+Edit4.Text+'''where 用户名='''+Edit2.Text+'''');
Form1.ADOQuery1.SQL.Add('select *from 管理员');
Form1.ADOQuery1.Open;
Edit2.Text:='';
Edit3.Text:='';
Edit4.Text:='';
Edit5.Text:='';
showmessage('密码修改成功！请按返回键返回！');
end
else
begin
showmessage('新密码不唯一，请重新输入！');
Edit3.Text:='';
Edit4.Text:='';
Edit5.Text:='';
end;
end
else
begin
showmessage('密码不正确，请重新输入！');
Edit3.Text:='';
Edit4.Text:='';
Edit5.Text:='';
end;
end;

procedure TForm2.Button8Click(Sender: TObject);
begin
Edit2.Text:='';
Edit3.Text:='';
Edit4.Text:='';
Edit5.Text:='';
panel1.Visible:=true;
panel3.Visible:=false;
end;

procedure TForm2.Button5Click(Sender: TObject);
begin
Edit1.Text:='';
panel2.Visible:=false;
panel1.Visible:=true;
end;

procedure TForm2.Button6Click(Sender: TObject);
begin
if trim(Edit14.Text)<>'' then
begin
Form1.ADOQuery1.Close;
Form1.ADOQuery1.SQL.Clear;
Form1.ADOQuery1.SQL.Add('delete from 课程 where 课程编号='''+Edit14.Text+'''');
Form1.ADOQuery1.SQL.Add('select *from 课程');
Form1.ADOQuery1.Open;
Edit14.Text:='';
Edit15.Text:='';
Edit16.Text:='';
Edit17.Text:='';
Edit18.Text:='';
Edit19.Text:='';
Edit20.Text:='';
Edit21.Text:='';
end
else
begin
showmessage('请输入要删除的课程编号！');
end;
end;

procedure TForm2.Button10Click(Sender: TObject);
begin
Button13.Enabled:=true;
Button14.Enabled:=true;
Edit6.Text:='';
Edit7.Text:='';
Edit8.Text:='';
Edit9.Text:='';
Edit10.Text:='';
Edit11.Text:='';
end;

procedure TForm2.Button12Click(Sender: TObject);
begin
Edit14.Text:='';
Edit15.Text:='';
Edit16.Text:='';
Edit17.Text:='';
Edit18.Text:='';
Edit19.Text:='';
Edit20.Text:='';
Edit21.Text:='';
Edit14.ReadOnly:=true;
//Dbgrid2.Visible:=false;
panel5.Visible:=false;
panel2.Visible:=true;
end;

procedure TForm2.Button11Click(Sender: TObject);
begin