论文首页哲学论文经济论文法学论文教育论文文学论文历史论文理学论文工学论文医学论文管理论文艺术论文 |
删除学生信息的窗体:
procedure TForm_infos_del.Button3Click(Sender: TObject);
begin
if RadioButton1.Checked then
begin
if edit1.Text='' then
begin
showmessage('请填写学号!');
edit1.SetFocus;
end
else
if MessageDlg('确认删除'+edit1.Text,mtConfirmation,mbOkCancel,0)=mrOk then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('delete from student where sno=:sno');
query1.ParamByName('sno').AsString:=edit1.Text;
query1.ExecSQL;
query2.ParamByName('Num_room').AsString:=Num_room;
query2.ExecSQL;
edit1.Text:='';
end;
end;
if RadioButton3.Checked then
begin
if edit2.Text='' then
begin
showmessage('请填写寝室号!');
edit2.SetFocus;
end (科教范文网http://fw.ΝsΕΑc.com编辑)
else
if edit3.Text='' then
begin
showmessage('请填写床位号!');
edit3.SetFocus;
end
else
if MessageDlg('确认删除?',mtConfirmation,mbOkCancel,0)=mrOk then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('delete from student where Num_room=:Num_room and Num_bed=:Num_bed');
query1.ParamByName('Num_room').AsString:=edit2.Text;
query1.ParamByName('Num_bed').AsString:=edit3.Text;
query1.ExecSQL;
&nbs