fkxx.pas

学生管理系统小鸟做了

unit fkxx;

interface

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

type
  Tfmfkxx = class(TForm)
    Label7: TLabel;
    Image1: TImage;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Label6: TLabel;
    ComboBox1: TComboBox;
    Edit1: TEdit;
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fmfkxx: Tfmfkxx;

implementation

uses dm, denglu;

{$R *.dfm}

procedure Tfmfkxx.Button2Click(Sender: TObject);
begin
edit1.Clear;
edit1.SetFocus;
end;

procedure Tfmfkxx.Button3Click(Sender: TObject);
begin
close;
end;

procedure Tfmfkxx.Button1Click(Sender: TObject);
begin
if edit1.Text='' then
begin
  messagedlg('所在公司不能为空',mtInformation,[mbYes],0);
  exit;
end;
fmdm.qryfkxx.Close;
fmdm.qryfkxx.SQL.Clear;
fmdm.qryfkxx.SQL.Add('update tab_stu set stu_employmentstate=:A,stu_company=:S where stu_id=:D');
fmdm.qryfkxx.Parameters.ParamByName('A').Value:=combobox1.Text;
fmdm.qryfkxx.Parameters.ParamByName('S').Value:=edit1.Text;
fmdm.qryfkxx.Parameters.ParamByName('D').Value:=fmdenglu.edit1.Text;
try
    fmdm.qryfkxx.ExecSQL;
    MessageDlg('成功反馈！',mtInformation , [mbYes],0);
    except
    MessageDlg('操作失败！',mtInformation , [mbYes],0);
  end;
end;

end.