主题:[讨论]高手们帮忙讲解一下下面的几段代码吧~辛苦辛苦~~
请高手们帮忙详细的讲解下各语句的含义吧~~看了好久没看明白~劳驾各位拉~~谢谢~~我会给帖子评分的~不会让你们白辛苦~~
第一段:
adoquery1.ExecSQL;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.sql.add('delete from 单位信息表');
第二段:
adoquery1.Parameters.clear;
adoquery1.Parameters.AddParameter;
adoquery1.Parameters[0].name:='s0';
adoquery1.Parameters[0].DataType:=ftstring;
adoquery1.Parameters[0].Direction:=pdinput;
adoquery1.Parameters[0].Value:='admin';
第三段:
if adotable1.Eof then
bitbtn4.Enabled:=false
else
loadfromtable;
end;
第四段:
adodataset1:=TAdoDataset.Create(self);
adodataset1.Connection:=adoconnection1;
adodataset1.Close;
adodataset1.CommandType:=cmdText;
adodataset1.CommandText:='select * from 班级表 where 班级名=:classname';
第五段:
if adodataset1.Recordset.RecordCount=1 then...
第六段:
procedure TClassForm.BitBtn1Click(Sender: TObject);
begin
if new_record then
begin
adotable1.Append;
adotable1.FieldByName('书费').AsCurrency:=0;
new_record:=false;
end;
savetotable;
if adotable1.Recordset.RecordCount>0 then
bitbtn4.Enabled:=true;
end;
第七段:
procedure TClassForm.LoadFromTable;
begin
edit1.text:=adotable1.FieldByName('班级名').asstring;
maskedit1.text:=DatetoStr(adotable1.FieldByName('入学时间').asdatetime);
edit3.text:=adotable1.FieldByName('所在院系').AsString;
edit4.text:=adotable1.FieldByName('班长').asstring;
edit5.Text:=adotable1.fieldbyname('班长联系电话').asstring;
edit6.text:=adotable1.FieldByName('班主任').asstring;
edit7.Text:=adotable1.FieldByName('班主任联系电话').asstring;
edit2.text:=adotable1.FieldByName('所学专业').asstring;
edit8.text:=IntToStr(adotable1.FieldByName('班级人数').asinteger);
end;
第八段:
procedure TClassForm.BitBtn4Click(Sender: TObject);
begin
adotable1.Delete;
adotable1.first;
end;
第九段:
procedure TBookFeeForm.FormActivate(Sender: TObject);
var
adotable1:TAdoTable;
begin
AdoTable1:=TAdoTable.Create(self);
AdoTable1.Connection:=adoconnection1;
adotable1.tablename:='班级表';
adotable1.Active:=true;
edit1.Text:=floattostr(adotable1.fieldbyname('书费').ascurrency);
initiate;
ComboBox1.Items.Clear;
while not adotable1.Eof do
begin
ComboBox1.Items.add(adotable1.fieldbyname('班级名').asstring);
adotable1.next;
end;
combobox1.text:='';
adotable1.Close;
end;
[em2][em2]
第一段:
adoquery1.ExecSQL;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.sql.add('delete from 单位信息表');
第二段:
adoquery1.Parameters.clear;
adoquery1.Parameters.AddParameter;
adoquery1.Parameters[0].name:='s0';
adoquery1.Parameters[0].DataType:=ftstring;
adoquery1.Parameters[0].Direction:=pdinput;
adoquery1.Parameters[0].Value:='admin';
第三段:
if adotable1.Eof then
bitbtn4.Enabled:=false
else
loadfromtable;
end;
第四段:
adodataset1:=TAdoDataset.Create(self);
adodataset1.Connection:=adoconnection1;
adodataset1.Close;
adodataset1.CommandType:=cmdText;
adodataset1.CommandText:='select * from 班级表 where 班级名=:classname';
第五段:
if adodataset1.Recordset.RecordCount=1 then...
第六段:
procedure TClassForm.BitBtn1Click(Sender: TObject);
begin
if new_record then
begin
adotable1.Append;
adotable1.FieldByName('书费').AsCurrency:=0;
new_record:=false;
end;
savetotable;
if adotable1.Recordset.RecordCount>0 then
bitbtn4.Enabled:=true;
end;
第七段:
procedure TClassForm.LoadFromTable;
begin
edit1.text:=adotable1.FieldByName('班级名').asstring;
maskedit1.text:=DatetoStr(adotable1.FieldByName('入学时间').asdatetime);
edit3.text:=adotable1.FieldByName('所在院系').AsString;
edit4.text:=adotable1.FieldByName('班长').asstring;
edit5.Text:=adotable1.fieldbyname('班长联系电话').asstring;
edit6.text:=adotable1.FieldByName('班主任').asstring;
edit7.Text:=adotable1.FieldByName('班主任联系电话').asstring;
edit2.text:=adotable1.FieldByName('所学专业').asstring;
edit8.text:=IntToStr(adotable1.FieldByName('班级人数').asinteger);
end;
第八段:
procedure TClassForm.BitBtn4Click(Sender: TObject);
begin
adotable1.Delete;
adotable1.first;
end;
第九段:
procedure TBookFeeForm.FormActivate(Sender: TObject);
var
adotable1:TAdoTable;
begin
AdoTable1:=TAdoTable.Create(self);
AdoTable1.Connection:=adoconnection1;
adotable1.tablename:='班级表';
adotable1.Active:=true;
edit1.Text:=floattostr(adotable1.fieldbyname('书费').ascurrency);
initiate;
ComboBox1.Items.Clear;
while not adotable1.Eof do
begin
ComboBox1.Items.add(adotable1.fieldbyname('班级名').asstring);
adotable1.next;
end;
combobox1.text:='';
adotable1.Close;
end;
[em2][em2]