📄 add.pas

📁 教学管理软件北农业大学教学管理系统. 运行环境, ASP+ACCESS, 新云网站管理系统
💻 PAS
字号:
unit add;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Grids, DBGrids, ExtCtrls, Buttons, DBCtrls,dfdd;

type
  TForm2 = class(TForm)
    Button1: TButton;
    RadioGroup1: TRadioGroup;
    Panel1: TPanel;
    Edit1: TEdit;
    Edit2: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Edit3: TEdit;
    Edit4: TEdit;
    Button3: TButton;
    Panel3: TPanel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    Panel2: TPanel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    BitBtn1: TBitBtn;
    DBGrid1: TDBGrid;
    BitBtn5: TBitBtn;
    Button4: TButton;
    Button5: TButton;
    BitBtn4: TBitBtn;
    Panel4: TPanel;
    Panel5: TPanel;
    Edit13: TEdit;
    Label12: TLabel;
    Label13: TLabel;
    Label11: TLabel;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Button2: TButton;
    BitBtn2: TBitBtn;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    ComboBox3: TComboBox;
    ComboBox4: TComboBox;
    Edit11: TEdit;
    Button6: TButton;
    BitBtn3: TBitBtn;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure RadioGroup1Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure BitBtn6Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure Button2Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form2: TForm2;
  s: ansistring;
implementation

uses unit1;
{$R *.dfm}

procedure TForm2.Button1Click(Sender: TObject);
begin
    form1.show;
    add.Form2.Hide;
end;

procedure TForm2.Button3Click(Sender: TObject);
begin
add.Form2.Show;
panel1.Hide;
end;

procedure TForm2.Button5Click(Sender: TObject);
begin
add.Form2.Show;
panel3.Hide;
end;
procedure TForm2.RadioGroup1Click(Sender: TObject);
begin
  with add.Form2.Panel1  do
  case radiogroup1.ItemIndex of
    0:
    begin
      dfdd.DataModule1.addADOQuery1.close;
      dfdd.DataModule1.addADOQuery1.SQL.Clear;
      dfdd.DataModule1.addADOQuery1.SQL.Add('select * from teachers');
      dfdd.DataModule1.addADOQuery1.Open;
      visible:=true;
    end;
    1: visible:=false;
    2: visible:=false;
    3: visible:=false;
    4: visible:=false;
  end;
  with add.Form2.Panel2 do
  case radiogroup1.ItemIndex of
    0: visible:=false;
    1:
    begin
      visible:=true;
      dfdd.DataModule1.addADOQuery1.close;
      dfdd.DataModule1.addADOQuery1.SQL.Clear;
      dfdd.DataModule1.addADOQuery1.SQL.Add('select * from student');
      dfdd.DataModule1.addADOQuery1.Open;
    end;
    2: visible:=false;
    3: visible:=false;
    4: visible:=false;
  end;
  with add.Form2.Panel3 do
  case radiogroup1.ItemIndex of
    0: visible:=false;
    1: visible:=false;
    2:
    begin
      visible:=true;
      dfdd.DataModule1.addADOQuery1.close;
      dfdd.DataModule1.addADOQuery1.SQL.Clear;
      dfdd.DataModule1.addADOQuery1.SQL.Add('select * from subjects');
      dfdd.DataModule1.addADOQuery1.Open;
    end;
    3: visible:=false;
    4: visible:=false;
  end;
  with add.Form2.Panel4 do
  case radiogroup1.ItemIndex of
    0: visible:=false;
    1: visible:=false;
    2: visible:=false;
    3:
    begin
      dfdd.DataModule1.addADOQuery1.close;
      dfdd.DataModule1.addADOQuery1.SQL.Clear;
      dfdd.DataModule1.addADOQuery1.SQL.Add('select * from ss');
      dfdd.DataModule1.addADOQuery1.Open;
      dfdd.DataModule1.addADOQuery2.close;
      DataModule1.addADOQuery2.SQL.Clear;
      DataModule1.addADOQuery2.SQL.Add('select * from student');
      DataModule1.addADOQuery2.Open;
      combobox1.Items.Clear;
      while not DataModule1.addADOQuery2.Eof do
      begin
        s:=DataModule1.addADOQuery2.Fields[0].Value;
        form2.ComboBox1.Items.Add(s);
        DataModule1.addADOQuery2.Next;
        end;
      dfdd.DataModule1.addADOQuery3.close;
      dfdd.DataModule1.addADOQuery3.SQL.Clear;
      dfdd.DataModule1.addADOQuery3.SQL.Add('select * from subjects');
      dfdd.DataModule1.addADOQuery3.Open;
      combobox2.Items.Clear;
      while not dfdd.DataModule1.addADOQuery3.Eof do
      begin
        s:=dfdd.DataModule1.addADOQuery3.Fields[0].Value;
        form2.ComboBox2.Items.Add(s);
        dfdd.DataModule1.addADOQuery3.Next;
      end;
      visible:=true;
    end;
    4: visible:=false;
  end;
  with add.Form2.Panel5 do
  case radiogroup1.ItemIndex of
    0: visible:=false;
    1: visible:=false;
    2: visible:=false;
    3: visible:=false;
    4:
    begin
      visible:=true;
      dfdd.DataModule1.addADOQuery1.close;
      dfdd.DataModule1.addADOQuery1.SQL.Clear;
      dfdd.DataModule1.addADOQuery1.SQL.Add('select * from ts');
      dfdd.DataModule1.addADOQuery1.Open;
      dfdd.DataModule1.addADOQuery4.close;
      DataModule1.addADOQuery4.SQL.Clear;
      DataModule1.addADOQuery4.SQL.Add('select * from teachers');
      DataModule1.addADOQuery4.Open;
      combobox3.Items.Clear;
      while not DataModule1.addADOQuery4.Eof do
      begin
        s:=DataModule1.addADOQuery4.Fields[0].Value;
        form2.ComboBox3.Items.Add(s);
        DataModule1.addADOQuery4.Next;
      end;
      dfdd.DataModule1.addADOQuery3.close;
      dfdd.DataModule1.addADOQuery3.SQL.Clear;
      dfdd.DataModule1.addADOQuery3.SQL.Add('select * from subjects');
      dfdd.DataModule1.addADOQuery3.Open;
      combobox4.Items.Clear;
      while not dfdd.DataModule1.addADOQuery3.Eof do
      begin
        s:=dfdd.DataModule1.addADOQuery3.Fields[0].Value;
        form2.ComboBox4.Items.Add(s);
        dfdd.DataModule1.addADOQuery3.Next;
      end;
    end;
  end;
end;
procedure TForm2.BitBtn1Click(Sender: TObject);
begin
  begin
  try
  dfdd.DataModule1.addADOQuery1.Close;
  dfdd.DataModule1.addADOQuery1.SQL.Clear;
  dfdd.DataModule1.addADOQuery1.SQL.Add('insert into student values(:sno,:class,:sname)');
  dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('sno').Value:=trim(edit5.Text);//trim()消除空格
  dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('class').Value:=trim(edit6.Text);
  dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('sname').Value:=trim(edit7.Text);
  dfdd.DataModule1.addADOQuery1.ExecSQL;//指出出错的行
  add.Form2.Edit5.Clear;
  add.Form2.Edit6.Clear;
  add.Form2.Edit7.Clear;
  dfdd.DataModule1.addADOQuery1.close;
  dfdd.DataModule1.addADOQuery1.SQL.Clear;
  dfdd.DataModule1.addADOQuery1.SQL.Add('select * from student');
  dfdd.DataModule1.addADOQuery1.Open;
  except
    showmessage('向数据库添加信息错误！');
  end;
  end;
end;
procedure TForm2.BitBtn2Click(Sender: TObject);
begin
  begin
    try
      dfdd.DataModule1.addADOQuery1.Close; //添加
      dfdd.DataModule1.addADOQuery1.SQL.Clear;
      dfdd.DataModule1.addADOQuery1.SQL.Add('insert into ss values(:sno,:con,:grade)');
      dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('sno').Value:=trim(combobox1.Text);//trim()消除空格
      dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('con').Value:=trim(combobox2.Text);
      dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('grade').Value:=trim(edit13.Text);

      dfdd.DataModule1.addADOQuery1.ExecSQL;//指出出错的行

      add.Form2.ComboBox1.Clear; //清空选项框内容
      add.Form2.ComboBox2.Clear;
      add.Form2.Edit13.Clear;

      dfdd.DataModule1.addADOQuery1.close;
      dfdd.DataModule1.addADOQuery1.SQL.Clear;
      dfdd.DataModule1.addADOQuery1.SQL.Add('select * from ss');
      dfdd.DataModule1.addADOQuery1.Open;

      dfdd.DataModule1.addADOQuery2.close;
      DataModule1.addADOQuery2.SQL.Clear;
      DataModule1.addADOQuery2.SQL.Add('select * from student');
      DataModule1.addADOQuery2.Open;
      while not DataModule1.addADOQuery2.Eof do
        begin
          s:=DataModule1.addADOQuery2.Fields[0].Value;
          form2.ComboBox1.Items.Add(s);
          DataModule1.addADOQuery2.Next;
        end;
          dfdd.DataModule1.addADOQuery3.close;
          dfdd.DataModule1.addADOQuery3.SQL.Clear;
          dfdd.DataModule1.addADOQuery3.SQL.Add('select * from subjects');
          dfdd.DataModule1.addADOQuery3.Open;
          while not dfdd.DataModule1.addADOQuery3.Eof do
             begin
              s:=dfdd.DataModule1.addADOQuery3.Fields[0].Value;
              form2.ComboBox2.Items.Add(s);
              dfdd.DataModule1.addADOQuery3.Next;

             end;
except
    showmessage('向数据库添加信息错误！');
   end;
end;
end;

procedure TForm2.BitBtn5Click(Sender: TObject);
begin
  begin
    try
    dfdd.DataModule1.addADOQuery1.Close;
    dfdd.DataModule1.addADOQuery1.SQL.Clear;
    dfdd.DataModule1.addADOQuery1.SQL.Add('insert into subjects values(:cno,:cname,:credit)');
    dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('cno').Value:=trim(edit8.Text);//trim()消除空格
    dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('cname').Value:=trim(edit9.Text);
    dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('credit').Value:=trim(edit10.Text);
    dfdd.DataModule1.addADOQuery1.ExecSQL;//指出出错的行
    add.Form2.Edit8.Clear;
    add.Form2.Edit9.Clear;
    add.Form2.Edit10.Clear;
    dfdd.DataModule1.addADOQuery1.close;
    dfdd.DataModule1.addADOQuery1.SQL.Clear;
    dfdd.DataModule1.addADOQuery1.SQL.Add('select * from subjects');
    dfdd.DataModule1.addADOQuery1.Open;
    except
    showmessage('向数据库添加信息错误！');
    end;
  end;
end;

procedure TForm2.Button4Click(Sender: TObject);
begin
add.Form2.Show;
add.Form2.Panel2.Hide;
end;

procedure TForm2.BitBtn6Click(Sender: TObject);
begin
dfdd.DataModule1.addADOQuery2.close;
dfdd.DataModule1.addADOQuery2.SQL.Clear;
dfdd.DataModule1.addADOQuery2.SQL.Add('select * from subjects');
dfdd.DataModule1.addADOQuery2.Open;
end;

procedure TForm2.BitBtn4Click(Sender: TObject);
begin
    begin
try
dfdd.DataModule1.addADOQuery1.Close;
dfdd.DataModule1.addADOQuery1.SQL.Clear;
dfdd.DataModule1.addADOQuery1.SQL.Add('insert into teachers values(:workid,:dept,:tname,:jobtitle)');
dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('workid').Value:=trim(edit1.Text);//trim()消除空格
dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('dept').Value:=trim(edit2.Text);
dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('tname').Value:=trim(edit3.Text);
dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('jobtitle').Value:=trim(edit4.Text);
dfdd.DataModule1.addADOQuery1.ExecSQL;//指出出错的行
add.Form2.Edit1.Clear;
add.Form2.Edit2.Clear;
add.Form2.Edit3.Clear;
add.Form2.Edit4.Clear;
dfdd.DataModule1.addADOQuery1.close;
dfdd.DataModule1.addADOQuery1.SQL.Clear;
dfdd.DataModule1.addADOQuery1.SQL.Add('select * from teachers');
dfdd.DataModule1.addADOQuery1.Open;
 except
    showmessage('向数据库添加信息错误！');
    end;
end;
end;

procedure TForm2.FormCloseQuery(Sender: TObject; var CanClose: Boolean);
begin
  form1.show;
  add.Form2.Hide;
end;
procedure TForm2.Button2Click(Sender: TObject);
begin
add.Form2.Show;
add.Form2.Panel4.Hide;
end;

procedure TForm2.Button6Click(Sender: TObject);
begin
add.Form2.Show;
add.Form2.Panel5.Hide;
end;

procedure TForm2.BitBtn3Click(Sender: TObject);
begin
  begin
    try
      dfdd.DataModule1.addADOQuery1.Close; //添加
      dfdd.DataModule1.addADOQuery1.SQL.Clear;
      dfdd.DataModule1.addADOQuery1.SQL.Add('insert into ts values(:workid,:con,:room)');
      dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('workid').Value:=trim(combobox3.Text);//trim()消除空格
      dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('con').Value:=trim(combobox4.Text);
      dfdd.DataModule1.addADOQuery1.Parameters.ParamByName('room').Value:=trim(edit11.Text);

      dfdd.DataModule1.addADOQuery1.ExecSQL;//指出出错的行

      add.Form2.ComboBox3.Clear; //清空选项框内容
      add.Form2.ComboBox4.Clear;
      add.Form2.Edit11.Clear;

      dfdd.DataModule1.addADOQuery1.close;//刷新数据库
      dfdd.DataModule1.addADOQuery1.SQL.Clear;
      dfdd.DataModule1.addADOQuery1.SQL.Add('select * from ts');
      dfdd.DataModule1.addADOQuery1.Open;

      DataModule1.addADOQuery4.SQL.Clear;//
      DataModule1.addADOQuery4.SQL.Add('select * from teachers');
      DataModule1.addADOQuery4.Open;
      while not DataModule1.addADOQuery4.Eof do
        begin
          s:=DataModule1.addADOQuery4.Fields[0].Value;
          form2.ComboBox3.Items.Add(s);
          DataModule1.addADOQuery4.Next;
        end;
          dfdd.DataModule1.addADOQuery3.SQL.Clear;
          dfdd.DataModule1.addADOQuery3.SQL.Add('select * from subjects');
          dfdd.DataModule1.addADOQuery3.Open;
          while not dfdd.DataModule1.addADOQuery3.Eof do
             begin
              s:=dfdd.DataModule1.addADOQuery3.Fields[0].Value;
              form2.ComboBox4.Items.Add(s);
              dfdd.DataModule1.addADOQuery3.Next;

             end;
except
    showmessage('向数据库添加信息错误！');
   end;
end;
end;


end.
💿 文件大小 522 K
👤 上传用户 foresnake
📂 所属分类数据库系统
🏷️ 相关标签

#ACCESS #ASP #管理系统 #管理软件
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -