unit5.pas

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

unit Unit5;

interface

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

type
  TForm5 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    DataSource1: TDataSource;
    ComboBox1: TComboBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBNavigator1: TDBNavigator;
    DBGrid1: TDBGrid;
    DBNavigator2: TDBNavigator;
    ADOQuery1: TADOQuery;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    ADOQuery2: TADOQuery;
    DataSource2: TDataSource;
    DBLookupComboBox1: TDBLookupComboBox;
    DBLookupComboBox2: TDBLookupComboBox;
    DBLookupComboBox3: TDBLookupComboBox;
    DBLookupComboBox4: TDBLookupComboBox;
    DBLookupComboBox5: TDBLookupComboBox;
    Label8: TLabel;
    procedure ComboBox1Change(Sender: TObject);
     
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form5: TForm5;
  myxs:string;

implementation

{$R *.dfm}

procedure TForm5.ComboBox1Change(Sender: TObject);
begin
myxs:=ComboBox1.Text;


ADOQuery1.Close;
ADOQuery1.SQL.Clear;
 ADOQuery1.SQL.Add('SELECT * FROM biao');
ADOQuery1.SQL.Add('where 学期=:ss');
  ADOQuery1.Parameters.ParamByName('ss').Value:= ComboBox1.Text ;
ADOQuery1.Open ;

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



end;

end.