SOS---一个刚用DELPHI做课程设计得大三学生得紧急求救!谁能救小妹一命,感激万分!
我用DELPHI做一个学生缴费注册系统。需要做一个复合统计功能!我用到2个COMBOBOX
用来显示字段,如年级,班级等,和逻辑符号。4个DBLOOKUPCOMBOBOX用来显示具体得班机等项目这样输入时不用手写了。2个MEMO,一个用来显示下来菜单选择选中的组合的项目,如:年级=高二;班级《3,等等;另一个MEMO显示统计后的结果
一个按钮;表示统计(该程序执行一次是可以的,执行第2次就出错,说是WHERE语句附近有错误)
现给出所有源码:望高手救急。明天就要交了,我已经辛苦了两星期了unit Unit3;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ExtCtrls, StdCtrls, ADODB, DB, DBCtrls, Buttons, ComCtrls,
DBTables;
type
TForm3 = class(TForm)
Label1: TLabel;
Image1: TImage;
Label2: TLabel;
Panel1: TPanel;
Panel2: TPanel;
ComboBox1: TComboBox;
ComboBox2: TComboBox;
DBLookupComboBox1: TDBLookupComboBox;
DBLookupComboBox2: TDBLookupComboBox;
DBLookupComboBox3: TDBLookupComboBox;
DBLookupComboBox4: TDBLookupComboBox;
Label3: TLabel;
Label4: TLabel;
Label5: TLabel;
Label6: TLabel;
Label7: TLabel;
Label8: TLabel;
ADOConnection1: TADOConnection;
ADOTable1: TADOTable;
DataSource1: TDataSource;
Memo1: TMemo;
Memo2: TMemo;
Label9: TLabel;
Label10: TLabel;
BitBtn1: TBitBtn;
BitBtn2: TBitBtn;
StatusBar1: TStatusBar;
Query1: TQuery;
procedure Label1Click(Sender: TObject);
procedure BitBtn1Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
procedure ComboBox1Change(Sender: TObject);
procedure ComboBox2Change(Sender: TObject);
procedure DBLookupComboBox1Click(Sender: TObject);
procedure DBLookupComboBox2Click(Sender: TObject);
procedure DBLookupComboBox3Click(Sender: TObject);
procedure DBLookupComboBox4Click(Sender: TObject);
procedure BitBtn2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form3: TForm3;
implementation
uses Unit2;
{$R *.dfm}
procedure TForm3.FormCreate(Sender: TObject);
var
i:integer;
begin
memo1.Text:='';
memo2.Text:='';
for i:=0 to query1.FieldCount-1 do
combobox1.Items.Add(query1.Fields[i].FieldName);
end;
procedure TForm3.Label1Click(Sender: TObject);
begin
form2.show;form3.Hide;
end;
procedure TForm3.BitBtn1Click(Sender: TObject);
var
sum1:real;
s,s1,s2,s3:string;
bookmark1:tbookmark;
begin
if memo1.Text='' then
begin
Application.MessageBox('请输入查询条件!','提醒',Mb_Ok+Mb_iconwarning);
end
else
begin
sum1:=0;
s1:=combobox1.Text;
s2:=combobox2.Text;
s3:=dblookupcombobox1.Text+dblookupcombobox2.Text+dblookupcombobox3.Text+dblookupcombobox4.Text;
bookmark1:=query1.GetBookmark;
query1.close;
query1.SQL.Add(' where '+memo1.Text);
query1.Open;
if query1.RecordCount=0 then
begin
Application.MessageBox('没有符合条件的记录!','信息',Mb_Ok+Mb_IconInformation);
end
else
begin
query1.DisableControls;
query1.First;
while not query1.Eof do
begin
sum1:=sum1+query1.FieldValues['应缴'];
query1.Next;
end;
query1.GotoBookmark(bookmark1);
query1.FreeBookmark(bookmark1);
end;
str(sum1:8:2,s);
memo2.Text:='符合条件的学生共缴费'+s+'元';
end;
end;
procedure TForm3.ComboBox1Change(Sender: TObject);
begin
memo1.Text:=memo1.Text+combobox1.Text;
end;
procedure TForm3.ComboBox2Change(Sender: TObject);
begin
memo1.Text:=memo1.Text+' '+combobox2.Text+' ';
end;
procedure TForm3.DBLookupComboBox1Click(Sender: TObject);
begin
memo1.Text:=memo1.Text+''''+dblookupcombobox1.Text+'''';
end;
procedure TForm3.DBLookupComboBox2Click(Sender: TObject);
begin
memo1.Text:=memo1.Text+''''+dblookupcombobox2.Text+'''';
end;
procedure TForm3.DBLookupComboBox3Click(Sender: TObject);
begin
memo1.Text:=memo1.Text+''''+dblookupcombobox3.Text+'''';
end;
procedure TForm3.DBLookupComboBox4Click(Sender: TObject);
begin
memo1.Text:=memo1.Text+''''+dblookupcombobox4.Text+'''';
end;
procedure TForm3.BitBtn2Click(Sender: TObject);
begin
memo1.Text:='';
memo2.Text:='';
combobox1.Text:='';
combobox2.Text:='';
end;
end.