unit4.pas

DELPHI教师管理系统全套设计(论文+代码).设计好参考

unit Unit4;

interface

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

type
  TForm4 = class(TForm)
    DataSource1: TDataSource;
    Label1: TLabel;
    ADOTable1: TADOTable;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    DBNavigator1: TDBNavigator;
    Label2: TLabel;
    DBEdit1: TDBEdit;
    Label3: TLabel;
    Label4: TLabel;
    DBEdit3: TDBEdit;
    Label5: TLabel;
    Label6: TLabel;
    DBEdit5: TDBEdit;
    DataSource3: TDataSource;
    ADOQuery1: TADOQuery;
    DBGrid1: TDBGrid;
    Button1: TButton;
    ADOTable2: TADOTable;
    DataSource2: TDataSource;
    Label7: TLabel;
    Label8: TLabel;
    ADOTable3: TADOTable;
    DataSource4: TDataSource;
    DBGrid3: TDBGrid;
    TabSheet4: TTabSheet;
    DBComboBox1: TDBComboBox;
    DBGrid4: TDBGrid;
    ComboBox1: TComboBox;
    DBGrid2: TDBGrid;
    DBNavigator2: TDBNavigator;
    TabSheet5: TTabSheet;
    ComboBox2: TComboBox;
    ADOQuery2: TADOQuery;
    DataSource5: TDataSource;
    DBGrid5: TDBGrid;
    Button2: TButton;
    ADOTable1DSDesigner: TIntegerField;
    ADOTable1DSDesigner2: TWideStringField;
    ADOTable1DSDesigner3: TWideStringField;
    ADOTable1DSDesigner4: TWideStringField;
    ADOTable1DSDesigner5: TWideStringField;
    DBLookupComboBox1: TDBLookupComboBox;
    ADOTable4: TADOTable;
    DataSource6: TDataSource;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  
  
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;

implementation

{$R *.dfm}





procedure TForm4.Button2Click(Sender: TObject);
begin

ADOQuery2.Close;
ADOQuery2.SQL.Clear;
ADOQuery2.SQL.Add('SELECT * FROM jh_qh');
ADOQuery2.SQL.Add('where 学期=:ss');
ADOQuery2.Parameters.ParamByName('ss').Value:= ComboBox2.Text ;
ADOQuery2.Open ;
end;

procedure TForm4.Button1Click(Sender: TObject);
begin
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('SELECT * FROM jxjh');
ADOQuery1.SQL.Add('where 学期=:ss');
ADOQuery1.Parameters.ParamByName('ss').Value:= ComboBox1.Text ;
ADOQuery1.Open ;
end;

end.