📄 unit5.pas
字号:
unit Unit5;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, Grids, DBGrids, DB, DBTables, StdCtrls;
type
TForm5 = class(TForm)
GroupBox1: TGroupBox;
Label1: TLabel;
Label2: TLabel;
Label3: TLabel;
Label4: TLabel;
Label5: TLabel;
Label6: TLabel;
Edit1: TEdit;
Edit2: TEdit;
Edit3: TEdit;
Edit4: TEdit;
Edit5: TEdit;
Edit6: TEdit;
Label7: TLabel;
Button1: TButton;
DataSource1: TDataSource;
Query1: TQuery;
DBGrid1: TDBGrid;
Button2: TButton;
Button3: TButton;
procedure Button2Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
procedure Button1Click(Sender: TObject);
procedure Button3Click(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form5: TForm5;
implementation
uses unit2;
{$R *.dfm}
procedure TForm5.Button2Click(Sender: TObject);
begin
form2.Show;
form5.close;
end;
procedure TForm5.FormCreate(Sender: TObject);
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.Prepare;
query1.open;
end;
procedure TForm5.Button1Click(Sender: TObject);
begin
if (edit1.Text<>'') and (edit2.Text<>'') and (edit3.Text<>'') and (edit4.Text<>'') and (edit5.Text<>'') and (edit6.Text<>'') then
begin
query1.Close;
query1.SQL.Clear;
try
begin
query1.SQL.Add('insert into 学生缴费');
query1.SQL.Add('(学生编号,学生姓名,年级,班级,学年年度,应缴费用,缴费)');
query1.SQL.Add('values('''+edit1.text+''','''+edit2.text+''','''+edit3.text+''','''+edit4.text+''','''+edit5.text+''','''+edit6.text+''',false);');
query1.ExecSQL;
end
except
showmessage('your input is wrong! ');
end;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.Prepare;
query1.open;
end
else showmessage('输入有误');
end;
procedure TForm5.Button3Click(Sender: TObject);
begin
application.Terminate;
end;
procedure TForm5.FormClose(Sender: TObject; var Action: TCloseAction);
begin
form2.Show;
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -