queryscore.pas

delphi 学生选课系统的实现 附有sql 语句

unit QueryScore;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids;

type
  TQueryScoreForm = class(TForm)
    DBGrid1: TDBGrid;
    procedure OnShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  QueryScoreForm: TQueryScoreForm;

implementation

uses DataModule,Login;

{$R *.dfm}

procedure TQueryScoreForm.OnShow(Sender: TObject);
begin
  with DataModuleForm.A_Stu_QueryScore do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select 课程详细信息.课程名,课程详细信息.课程号,课程详细信息.课序号,学生选课信息.成绩 from 课程详细信息,学生选课信息');
    SQL.Add('where 课程详细信息.课程号 = 学生选课信息.课程号');
    SQL.Add('and 课程详细信息.课序号 = 学生选课信息.课序号');
    SQL.Add('and 学生选课信息.成绩 is not NULL');
    SQL.Add('and 学生选课信息.学号 = '+''''+Login.UseId+'''');
//    Application.MessageBox(SQL.GetText,'信息',MB_OK);
    Open;
  end
end;

end.