unit12.pas

宿舍管理系统

unit Unit12;

interface

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

type
  TForm12 = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    GroupBox2: TGroupBox;
    GroupBox3: TGroupBox;
    Label2: TLabel;
    Edit1: TEdit;
    BitBtn1: TBitBtn;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    ADOQuery2: TADOQuery;
    DataSource2: TDataSource;
    GroupBox4: TGroupBox;
    Label3: TLabel;
    GroupBox5: TGroupBox;
    Label4: TLabel;
    Image1: TImage;
    GroupBox6: TGroupBox;
    GroupBox7: TGroupBox;
    Label5: TLabel;
    Edit2: TEdit;
    BitBtn2: TBitBtn;
    Label6: TLabel;
    GroupBox8: TGroupBox;
    Label7: TLabel;
    DBGrid3: TDBGrid;
    Label8: TLabel;
    GroupBox9: TGroupBox;
    DBGrid4: TDBGrid;
    Label9: TLabel;
    ADOQuery3: TADOQuery;
    ADOQuery4: TADOQuery;
    DataSource3: TDataSource;
    DataSource4: TDataSource;
    procedure FormActivate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure DBGrid3DblClick(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form12: TForm12;

implementation

{$R *.dfm}

procedure TForm12.FormActivate(Sender: TObject);
begin
ADOQuery1.Connection :=DataModule2.ADOConnection1 ;     //初始化连接
ADOQuery2.Connection :=DataModule2.ADOConnection1 ;
ADOQuery3.Connection :=DataModule2.ADOConnection1 ;
ADOQuery4.Connection :=DataModule2.ADOConnection1 ;
end;

procedure TForm12.BitBtn1Click(Sender: TObject);
begin                              //按学号查询学生基本信息
ADOQuery1.Close ;
ADOQuery1.SQL.Clear ;
ADOQuery1.SQL.Text :='select * from 学生信息表 where 学号='''+Edit1.Text+'''';
ADOQuery1.Prepared ;
ADOQuery1.Open ;

ADOQuery2.Close ;                //接学号查询学生学期注册信息
ADOQuery2.SQL.Clear ;
ADOQuery2.SQL.Text :='select * from 学期注册表 where 学号='''+Edit1.Text+'''';
ADOQuery2.Prepared ;
ADOQuery2.Open ;

end;

procedure TForm12.BitBtn2Click(Sender: TObject);
begin
ADOQuery3.Close ;                //按姓名查询学生基本信息
ADOQuery3.SQL.Clear ;
ADOQuery3.SQL.Text :='select * from 学生信息表 where 姓名 like ''%'+Trim(Edit2.Text)+'%''';
ADOQuery3.Prepared ;
ADOQuery3.Open ;
end;

procedure TForm12.DBGrid3DblClick(Sender: TObject);
begin
ADOQuery4.Close ;
ADOQuery4.SQL.Clear ;
ADOQuery4.SQL.Text :='select * from 学期注册表 where 学号=:A' ;
ADOQuery4.Parameters.ParamByName('A').Value :=ADOQuery3.fieldByName('学号').AsString ;
ADOQuery4.Prepared ;
ADOQuery4.Open ;

end;

procedure TForm12.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
  if Key=#13 then
    begin
      BitBtn1.Click;
    end;

end;

procedure TForm12.Edit2KeyPress(Sender: TObject; var Key: Char);
begin
  if Key=#13 then
    begin
      BitBtn2.Click;
    end;
end;

end.