studentunit.pas

教学管理系统 功能: 选课,查询成绩,学生信息,修改信息, 录入成绩,修改密码

unit studentUnit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Buttons, DB, ADODB, Grids, DBGrids, StdCtrls, ComCtrls, jpeg,
  ExtCtrls;

type
  Tstudent = class(TForm)
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    DBGrid1: TDBGrid;
    SpeedButton1: TSpeedButton;
    ComboBox1: TComboBox;
    Edit1: TEdit;
    SpeedButton2: TSpeedButton;
    Label1: TLabel;
    Label2: TLabel;
    TabSheet2: TTabSheet;
    DataSource2: TDataSource;
    DBGrid2: TDBGrid;
    SpeedButton4: TSpeedButton;
    TabSheet3: TTabSheet;
    DBGrid3: TDBGrid;
    SpeedButton5: TSpeedButton;
    DataSource3: TDataSource;
    ADOQuery2: TADOQuery;
    Edit2: TEdit;
    SpeedButton6: TSpeedButton;
    Label3: TLabel;
    SpeedButton7: TSpeedButton;
    TabSheet4: TTabSheet;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    SpeedButton8: TSpeedButton;
    TabSheet5: TTabSheet;
    SpeedButton3: TSpeedButton;
    SpeedButton9: TSpeedButton;
    Image1: TImage;
    Image2: TImage;
    Image3: TImage;
    Image4: TImage;
    Image5: TImage;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton6Click(Sender: TObject);
    procedure SpeedButton7Click(Sender: TObject);
    procedure SpeedButton8Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton9Click(Sender: TObject);
    //procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  student: Tstudent;

implementation

uses mainunit;

{$R *.dfm}

procedure Tstudent.SpeedButton1Click(Sender: TObject);
  var str1:string;
begin
      str1:=mainform.Edit1.Text;
      datasource1.Enabled:=true;
      with adoquery1 do
      begin
       close;
       sql.clear;
       sql.Add('select * from student where 学号='''+str1+'''') ;
       adoquery1.open;
   end;
 end;
procedure Tstudent.SpeedButton2Click(Sender: TObject);
var
   str1,str2,str3:string;
begin
     str1:=mainform.Edit1.Text;
     str2:=combobox1.Text;
     str3:=edit1.Text;
     datasource1.Enabled:=true;
     if str2='请选择' then
      begin
         showmessage('请选择修改项目!');
         exit ;
      end
      else
        if str3='' then
         begin
             showmessage('请输入修改值!');
             exit;
         end
      else
       begin
         adoquery1.prepared:=true;
         with adoquery1 do
         begin
         close;
         sql.Clear;
         sql.Add('update student set '+str2+'='''+str3+'''where 学号='''+str1+'''');
         adoquery1.ExecSQL;
         showmessage('恭喜你!修改成功^!^');
         end
       end
end;



procedure Tstudent.SpeedButton4Click(Sender: TObject);

begin
    datasource2.Enabled:=true;
    with mainform.adoquery1 do
    close;
    mainform.ADOQuery1.SQL.clear;
    mainform.ADOQuery1.sql.add('select 学号,sc.课程号,课程名,成绩,学分 from sc,course where 学号='''+mainform.Edit1.Text+''' and sc.课程号=course.课程号');
    mainform.ADOQuery1.open;

end;

procedure Tstudent.SpeedButton5Click(Sender: TObject);
begin
    with adoquery2 do
    begin
       adoquery2.Close;
       adoquery2.SQL.Clear;
       adoquery2.SQL.Add('select * from course');
       adoquery2.Open;
    end
end;

procedure Tstudent.SpeedButton6Click(Sender: TObject);
begin
     if edit2.Text='' then
       begin   showmessage('请输入课程号!!!');
                exit;
       end
     else begin
     with adoquery2 do
     begin
     close;
     sql.Clear;
     sql.Add('select * from sc where 学号='''+mainform.Edit1.Text+''' and 课程号='''+edit2.text+'''');
     adoquery2.open;
     if  recordcount>0 then
         begin
          showmessage('你已选修了该课!请重新输入!');
          exit;
         end
      else
        begin
         with adoquery2 do
          close;
          sql.Clear;
          sql.Add('insert into sc(学号,课程号) values('''+mainform.Edit1.Text+''','''+edit2.Text+''')');
          adoquery2.ExecSQL;
         end
         end
       end ;
end;

procedure Tstudent.SpeedButton7Click(Sender: TObject);
begin
     with adoquery2 do
     begin
     close;
     sql.Clear;
     sql.Add('select 学号,SC.课程号,课程名,先修课,学分 from sc,course where 学号='''+mainform.Edit1.Text+''' and sc.课程号=course.课程号');
     adoquery2.open;
     end
end;

procedure Tstudent.SpeedButton8Click(Sender: TObject);
begin
         with mainform.adoquery1 do
          begin
            close;
            sql.Clear;
            sql.Add('select * from pass where 学号='''+mainform.Edit1.Text+'''and 密码='''+edit3.Text+'''');
            open;
            if recordcount=1 then
               begin
                if edit4.Text<>edit5.Text then
                   begin
                     showmessage('两次密码输入不一致,请重新输入!');
                   end
                else
                  if edit4.Text='' then
                     begin
                       showmessage('请输入新密码!');
                     end
                else
                   begin
                    close;
                    sql.Clear;
                    sql.Add('update pass set 密码='''+edit4.Text+''' where 学号='''+mainform.Edit1.Text+'''') ;
                    mainform.adoquery1.ExecSQL;
                    showmessage('恭喜你,密码修改成功^_^');
                    end ;
                end
            else
               begin
               showmessage(' 你输入的旧密码错误,请重新输入!');
               end
           end
         end ;


procedure Tstudent.SpeedButton3Click(Sender: TObject);
begin
   close;
   mainform.Show;
end;

procedure Tstudent.SpeedButton9Click(Sender: TObject);
begin
   close;
   mainform.close;
end;

end.