delphi 7课程设计案例精编

connect 'D:\书稿\delphi 7课程案例\编程实例\案例8\salary.gdb' user 'sysdba' password 'masterkey'; drop table operator; create table operator ( name char(8) not null PRIMARY KEY, /*用户名*/ pass char(8), /*密码*/ units char(20) character set gb_2312, /*所在单位*/ right_1 char default 'F' not null, /*管理权限*/ right_2 char default 'F' not null , /*操作权限*/ right_3 char default 'F' not null , /*查询权限*/ opera char(8) character set gb_2312 default 'default' not null , /*操作者*/ stamp timestamp default 'now' not null /*最后修改时间*/ ); insert into operator values('admin','admin','网络管理','T','T','T','系统默认','Now'); drop table tax; create table tax ( division integer default 0 not null primary key, /*分征点*/ rate float default 0 not null, /*税率*/ note char(40) character set gb_2312 /*说明*/ ); drop table salary; /*职工信息表*/ create table salary ( number char(6) default '000000' not null primary key, /*职工编号*/ name char(8) character set gb_2312 not null , /*职工姓名*/ sex char(2) character set gb_2312 not null, /*性别*/ id char(18) not null, /*身份证号*/ birthdate timestamp, /*出生年月*/ workdate timestamp, /*参加工作时间*/ operatordate timestamp default 'Now', /*最后操作时间*/ job char(8) character set gb_2312, /*职称*/ office char(8) character set gb_2312, /*所在单位*/ opera char(8) character set gb_2312, /*操作员*/ base_salary float default 0, /*基本单位*/ float_salary float default 0, /*浮动工资*/ allowance_salary float default 0, /*津贴*/ age_salary float default 0, /*工龄工资*/ award float default 0, /*奖金*/ addition_award float default 0, /*补贴*/ rest float default 0, /*其它*/ insurance float default 0, /*保险*/ rent float default 0, /*房租*/ detain float default 0, /*补扣*/ total float default 0, /*全部工资*/ real_salary float default 0, /*实发工资*/ tax float default 0, /*所得税*/ note char(40) character set gb_2312, /*说明*/ enabled char default 'F' not null /*冻结标志*/ ); drop table month_salary; create table month_salary ( number char(6) not null primary key, /*职工编号*/ name char(6) character set gb_2312, /*职工姓名*/ salary_date char(2), /*工资月份*/ opera char(8), /*操作员*/ base_salary float default 0, /*基本工资*/ float_salary float default 0, /*浮动工资*/ allowance_salary float default 0, /*津贴*/ age_salary float default 0, /*工龄工资*/ award float default 0, /*奖金*/ addition_award float default 0, /*补贴*/ rest float default 0, /*其它*/ insurance float default 0, /*保险*/ rent float default 0, /*房租*/ detain float default 0, /*补扣*/ total float default 0, /*全部工资*/ real_salary float default 0, /*实发工资*/ tax float default 0, /*所得税*/ note char(40) character set gb_2312, /*说明*/ operatordate timestamp /*操作时间*/ ); drop table info; create table info ( number char(6) not null, /*职工编号*/ name char(6) character set gb_2312, /*职工姓名*/ operatordate timestamp, /*操作时间*/ opera char(8) character set gb_2312, /*操作员*/ base_salary float default 0, /*基本工资*/ float_salary float default 0, /*浮动工资*/ allowance_salary float default 0, /*津贴*/ age_salary float default 0, /*工龄工资*/ award float default 0, /*奖金*/ addition_award float default 0, /*补贴*/ rest float default 0, /*其它*/ insurance float default 0, /*保险*/ rent float default 0, /*房租*/ detain float default 0, /*补扣*/ total float default 0, /*全部工资*/ real_salary float default 0, /*实发工资*/ tax float default 0, /*所得税*/ note char(40) character set gb_2312 /*说明*/ ); commit;