在好例子网,分享、交流、成长!
您当前所在位置:首页Pascal 开发实例Delphi数据库编程 → delphi学生成绩管理查询例子源码(含access数据库)

delphi学生成绩管理查询例子源码(含access数据库)

Delphi数据库编程

下载此实例
  • 开发语言:Pascal
  • 实例大小:0.96M
  • 下载次数:60
  • 浏览次数:859
  • 发布时间:2018-10-16
  • 实例类别:Delphi数据库编程
  • 发 布 人:ai751295059
  • 文件格式:.rar
  • 所需积分:2

实例介绍

【实例简介】登陆账号:admin 密码 admin

【实例截图】

from clipboard

from clipboard


from clipboard

from clipboard


from clipboard

打印成绩

from clipboard



【核心代码】

unit U_CJCX;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, StdCtrls, Buttons, DB, ADODB, Grids, DBGrids, Menus,
  Mask, DBCtrls, QRCtrls, QuickRpt,Excel2000,ComObj;

type
  Tfrm_cjcx = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Panel4: TPanel;
    CheckBox1: TCheckBox;
    ComboBox1: TComboBox;
    CheckBox5: TCheckBox;
    Edit4: TEdit;
    BitBtn1: TBitBtn;
    DBGrid2: TDBGrid;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    CheckBox2: TCheckBox;
    ComboBox2: TComboBox;
    PopupMenu1: TPopupMenu;
    N1: TMenuItem;
    BitBtn2: TBitBtn;
    Panel3: TPanel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    Button1: TButton;
    Button2: TButton;
    BitBtn3: TBitBtn;
    QuickRep: TQuickRep;
    QRSubDetail4: TQRSubDetail;
    QRLabel4: TQRLabel;
    QRShape26: TQRShape;
    QRShape31: TQRShape;
    QRLabel5: TQRLabel;
    QRShape32: TQRShape;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRShape34: TQRShape;
    QRShape35: TQRShape;
    QRShape37: TQRShape;
    QRShape21: TQRShape;
    QRSubDetail1: TQRSubDetail;
    QRShape8: TQRShape;
    qrdbtxtXH: TQRDBText;
    QRShape10: TQRShape;
    QRShape11: TQRShape;
    QRShape12: TQRShape;
    QRShape9: TQRShape;
    QRDBText3: TQRDBText;
    QRShape1: TQRShape;
    QRLabel1: TQRLabel;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    QRShape4: TQRShape;
    QRShape5: TQRShape;
    QRShape15: TQRShape;
    QRShape16: TQRShape;
    QRShape17: TQRShape;
    QRShape18: TQRShape;
    QRShape19: TQRShape;
    QRDBText2: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    QRDBText1: TQRDBText;
    QRShape13: TQRShape;
    BitBtn4: TBitBtn;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure N1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure DBEdit3Change(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure DBGrid2CellClick(Column: TColumn);
    procedure Button2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
  private
    { Private declarations }
    procedure re();
    procedure BubbleSort(N:array of integer);
  public
    { Public declarations }
    temp:array of Integer;
  end;

var
  frm_cjcx: Tfrm_cjcx;

implementation

uses U_DM;

{$R *.dfm}

procedure Tfrm_cjcx.FormClose(Sender: TObject; var Action: TCloseAction);
begin
Action:=CaFree;
end;
procedure Tfrm_cjcx.re();
 var
  sqlstr:string;
begin
 DBEdit3.Enabled:=False;
 DBEdit3.ReadOnly:=true;

 DBEdit4.Enabled:=False;
 DBEdit4.ReadOnly:=true;

 DBEdit5.Enabled:=False;
 DBEdit5.ReadOnly:=true;
 try
  sqlstr:=' where (1=1) ';
  if CheckBox1.Checked then sqlstr:=sqlstr ' and (所在班级 like''' '%' combobox1.text '%'')';
  if CheckBox2.Checked then sqlstr:=sqlstr ' and (学期 like''' '%' combobox2.text '%'')';

  if CheckBox5.Checked then
  sqlstr:=sqlstr 'and (姓名 like''' '%' edit4.text '%'')' ;

  sqlstr:=sqlstr 'ORDER BY 总分 DESC';


   ADOQuery1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' extractfilepath(application.ExeName) 'ztj007.mdb;Persist Security Info=False';
   ADOQuery1.Close ;
   ADOQuery1.SQL.Clear ;
   ADOQuery1.SQL.Add('select * from 成绩信息表 ');
   ADOQuery1.SQL.Add(sqlstr);
   ADOQuery1.Open ;
   except
   exit;
  end;
end;

procedure Tfrm_cjcx.BitBtn1Click(Sender: TObject);
begin
 re();
end;
procedure Tfrm_cjcx.FormShow(Sender: TObject);
begin
DM.LoadItemFromBase_NEW(ComboBox1,'年级班级',0,'Y');
DM.LoadItemFromBase_NEW(ComboBox2,'考试类型',0,'Y');
end;

procedure Tfrm_cjcx.N1Click(Sender: TObject);
var
  id,str:string;
begin
 if (not ADOQuery1.Active ) or (ADOQuery1.RecordCount<1) then
  begin
    ShowMessage('没有记录!');
    exit;
  end;
  id := ADOQuery1.FieldByName('id').AsString;

  str:='delete from 成绩信息表 where id=' id '';
  DM.MyExecSQL(DM.sql1,str);

  ShowMessage('该记录已删除');
  Sleep(1000);
 re();
end;

procedure Tfrm_cjcx.BitBtn2Click(Sender: TObject);
var
  i,j,k,tempfs:Integer;
  yw,sx,wy,zf:array of Integer;
  id :array of string;
  asSql:string;
begin
  re();
  SetLength(yw,ADOQuery1.RecordCount);
  SetLength(sx,ADOQuery1.RecordCount);
  SetLength(wy,ADOQuery1.RecordCount);
  SetLength(zf,ADOQuery1.RecordCount);
  SetLength(id,ADOQuery1.RecordCount);
  if not ADOQuery1.Eof then
  begin
   for i:=0 to ADOQuery1.RecordCount-1 do
    begin
     yw[i]:=StrToInt(ADOQuery1.FieldByName('语文').AsString);
     sx[i]:=StrToInt(ADOQuery1.FieldByName('数学').AsString);
     wy[i]:=StrToInt(ADOQuery1.FieldByName('英语').AsString);
     zf[i]:=StrToInt(ADOQuery1.FieldByName('总分').AsString);
     id[i]:=ADOQuery1.FieldByName('id').AsString;
     ADOQuery1.Next;
    end;
    BubbleSort(yw);
   for j:=0 to ADOQuery1.RecordCount-1 do
   begin
     tempfs:=yw[j];
      for k:=0 to ADOQuery1.RecordCount-1 do
      begin
         if temp[k]=tempfs then
         begin
           asSql:='UPDATE 成绩信息表 SET 语文排名 = ''' inttostr(k 1) ''' WHERE ID = ' id[j] '';
           DM.MyExecSQL(DM.sql1,asSql);
           Break;
         end;
      end;
   end;

    BubbleSort(sx);
   for j:=0 to ADOQuery1.RecordCount-1 do
   begin
     tempfs:=sx[j];
      for k:=0 to ADOQuery1.RecordCount-1 do
      begin
         if temp[k]=tempfs then
         begin
           asSql:='UPDATE 成绩信息表 SET 数学排名 = ''' inttostr(k 1) ''' WHERE ID = ' id[j] '';
           DM.MyExecSQL(DM.sql1,asSql);
           Break;
         end;
      end;
   end;

    BubbleSort(wy);
   for j:=0 to ADOQuery1.RecordCount-1 do
   begin
     tempfs:=wy[j];
      for k:=0 to ADOQuery1.RecordCount-1 do
      begin
         if temp[k]=tempfs then
         begin
           asSql:='UPDATE 成绩信息表 SET 英语排名 = ''' inttostr(k 1) ''' WHERE ID = ' id[j] '';
           DM.MyExecSQL(DM.sql1,asSql);
           Break;
         end;
      end;
   end;

    BubbleSort(zf);
   for j:=0 to ADOQuery1.RecordCount-1 do
   begin
     tempfs:=zf[j];
      for k:=0 to ADOQuery1.RecordCount-1 do
      begin
         if temp[k]=tempfs then
         begin
           asSql:='UPDATE 成绩信息表 SET 总分排名 = ''' inttostr(k 1) ''' WHERE ID = ' id[j] '';
           DM.MyExecSQL(DM.sql1,asSql);
           Break;
         end;
      end;
   end;
  end;

end;
procedure Tfrm_cjcx.BubbleSort(N:array of integer);
var
  I,J,IntTemp:integer;
begin
  SetLength(temp,High(N) 1);
  for I := 0 to High(N) do
  begin
    for J := 0 to High(N)-1 do
    begin
      if N[J]>N[J 1] then
      begin
        IntTemp:=N[J];
        N[J]:=N[J 1];
        N[J 1]:=IntTemp;
      end;
    end;
  end;

  for I := 0 to High(N) do
  begin
    temp[i]:=N[High(N)-i];
  end;
end;
procedure Tfrm_cjcx.DBEdit3Change(Sender: TObject);
begin
  DBEdit6.Text:= IntToStr(StrToIntDef(DBEdit3.Text,0) StrToIntDef(DBEdit4.Text,0) StrToIntDef(DBEdit5.Text,0))
end;

procedure Tfrm_cjcx.Button1Click(Sender: TObject);
begin
 ADOQuery1.Edit;
 DBEdit3.Enabled:=True;
 DBEdit3.ReadOnly:=False;

 DBEdit4.Enabled:=True;
 DBEdit4.ReadOnly:=False;

 DBEdit5.Enabled:=True;
 DBEdit5.ReadOnly:=False;
end;

procedure Tfrm_cjcx.DBGrid2CellClick(Column: TColumn);
begin
 DBEdit3.Enabled:=False;
 DBEdit3.ReadOnly:=true;

 DBEdit4.Enabled:=False;
 DBEdit4.ReadOnly:=true;

 DBEdit5.Enabled:=False;
 DBEdit5.ReadOnly:=true;
end;

procedure Tfrm_cjcx.Button2Click(Sender: TObject);
begin
 ADOQuery1.Post;
 DBEdit3.Enabled:=False;
 DBEdit3.ReadOnly:=true;

 DBEdit4.Enabled:=False;
 DBEdit4.ReadOnly:=true;

 DBEdit5.Enabled:=False;
 DBEdit5.ReadOnly:=true;
end;

procedure Tfrm_cjcx.BitBtn3Click(Sender: TObject);
begin
  QRLabel4.Caption:=ComboBox1.Text ComboBox2.Text '成绩分析';


  QuickRep.Preview;
end;

procedure Tfrm_cjcx.BitBtn4Click(Sender: TObject);
var
  I,j,maxcolumn,maxrow:integer;
  v,sheet,range,sheet2:variant;
  sRepName: String;
Const
  asFieldTitle: array[1..10] of String = (
      '排名','学号','姓名','语文','语文排名','数学','数学排名','英语','英语排名','总分');
  asFieldName: array[1..10] of String = (
      '总分排名','学号','姓名','语文','语文排名','数学','数学排名','英语','英语排名','总分');
begin
  inherited;

  if ADOQuery1.Active then
    begin
      maxcolumn:=ADOQuery1.RecordCount;
    end
  else
    begin
      maxcolumn:=0;
    end;
  if maxcolumn >= 1 then
  begin
    try
      maxrow:=10;
      ADOQuery1.First;
      v:=createoleobject('Excel.Application');//创建OLE对象
      v.visible:=true;
      v.workbooks.add(-4167); //添加工作表
      v.workbooks[1].sheets[1].name:='学生成绩统计';
      sheet:=v.workbooks[1].sheets[1];
      for j:=1 to maxrow do
      begin
          v.workbooks[1].sheets[1].cells[2,j] := asFieldTitle[j];
      end;

      for I:=3 to maxcolumn 2 do
      begin
        for j:=1 to maxrow do
        begin
         v.workbooks[1].sheets[1].cells[I,j]:=ADOQuery1.FieldByName(asFieldName[j]).AsString //导入数据
        end;
        ADOQuery1.Next;
      end;

      range:=sheet.range[sheet.cells[1,1],sheet.cells[1,10]];//选定表格
      range.select;
      range.merge; //合并单元格
      v.workbooks[1].sheets[1].cells[1,1] := ComboBox1.Text ComboBox2.Text '成绩分析';
      range.font.size:=18; //改变表格内文本字体大小

      sheet2 := v.workbooks[1].worksheets[1] ;
      sheet2.Range['A1'].ColumnWidth :=8;
      sheet2.Range['B1'].ColumnWidth :=15;
      sheet2.Range['C1'].ColumnWidth :=15;
      sheet2.Range['D1'].ColumnWidth :=25;
      sheet2.Range['E1'].ColumnWidth :=15;
      sheet2.Range['F1'].ColumnWidth :=15;
      sheet2.Rows[1].RowHeight := 33;
      sheet2.Rows[2].RowHeight := 27; 

      range:=sheet2.range['A1','G' IntToStr(maxcolumn 3)];
      range.VerticalAlignment := xlCenter;
      range.HorizontalAlignment := xlCenter;


      //保存
      if not DirectoryExists('D:\学生成绩统计') then
      begin
        try
          CreateDir('D:\学生成绩统计');
        except
          ShowMessage('创建文件夹“' 'D:\学生成绩统计' '”失败');
          Exit;
        end;

      end;

      sRepName := 'D:\学生成绩统计\' FormatDateTime('yyyymmddhhmmss',Now) '.xls';

      v.workbooks[1].saveas(sRepName);//保存文件  savedialog.FileName
      v.workbooks[1].close; //关闭工作表
      v.quit; //关闭Excel
      v := unassigned;

      ShowMessage('报表已保存为: ' sRepName);
    except
      ShowMessage('报表保存失败!');
    end;
  end
  else
    begin
      ShowMessage('无查询记录!');
    end;
end;
end.

实例下载地址

delphi学生成绩管理查询例子源码(含access数据库)

不能下载?内容有错? 点击这里报错 + 投诉 + 提问

好例子网口号:伸出你的我的手 — 分享

网友评论

发表评论

(您的评论需要经过审核才能显示)

查看所有0条评论>>

小贴士

感谢您为本站写下的评论,您的评论对其它用户来说具有重要的参考价值,所以请认真填写。

  • 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  • 相信您也不想看到一排文字/表情墙,所以请不要反馈意义不大的重复字符,也请尽量不要纯表情的回复。
  • 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  • 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。

关于好例子网

本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享,对搜索内容的合法性不具有预见性、识别性、控制性,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论平台是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定,若资源存在侵权或相关问题请联系本站客服人员,点此联系我们。关于更多版权及免责申明参见 版权及免责申明

;
报警