56,677
社区成员
发帖
与我相关
我的任务
分享
create table mysystem (
systemid int(10) NOT NULL AUTO_INCREMENT,
systemname varchar(20),
primary key(systemid)
);
insert into mysystem (systemname) values('systemA');
insert into mysystem (systemname) values('systemB');
insert into mysystem (systemname) values('systemC');
create table project(
projectid int(10) NOT NULL AUTO_INCREMENT,
projectname varchar(20),
systemnum int(10),
groupnum int(10),
primary key(projectid)
);
insert into project (projectname,systemnum,groupnum) values('projectA01',1,1);
insert into project (projectname,systemnum,groupnum) values('projectA02',1,1);
insert into project (projectname,systemnum,groupnum) values('projectA03',1,2);
insert into project (projectname,systemnum,groupnum) values('projectA04',1,2);
insert into project (projectname,systemnum,groupnum) values('projectA05',1,3);
insert into project (projectname,systemnum,groupnum) values('projectA06',1,3);
insert into project (projectname,systemnum,groupnum) values('projectB01',2,1);
insert into project (projectname,systemnum,groupnum) values('projectB02',2,1);
insert into project (projectname,systemnum,groupnum) values('projectB03',2,2);
insert into project (projectname,systemnum,groupnum) values('projectB04',2,2);
insert into project (projectname,systemnum,groupnum) values('projectB05',2,3);
insert into project (projectname,systemnum,groupnum) values('projectB06',2,3);
insert into project (projectname,systemnum,groupnum) values('projectC01',3,1);
insert into project (projectname,systemnum,groupnum) values('projectC02',3,1);
insert into project (projectname,systemnum,groupnum) values('projectC03',3,2);
insert into project (projectname,systemnum,groupnum) values('projectC04',3,2);
insert into project (projectname,systemnum,groupnum) values('projectC05',3,3);
insert into project (projectname,systemnum,groupnum) values('projectC06',3,3);
create table parametertable (
pname varchar(20) NOT NULL ,
pvalue double,
systemnum int(10),
groupnum int(10),
primary key(pname)
);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('cs01',1.1,1,1);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('cs02',1.2,1,2);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('cs03',2.1,2,1);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('cs04',2.2,2,2);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('cs05',3.1,3,1);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('cs06',3.2,3,2);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('cs07',0.1,0,0);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('cs08',0.2,0,0);
public class ProjectA {
private int projectid;
private String projectname;
private int systemnum;
private int groupnum;
private double cs;
//此属性比特殊,如果此项目是A系统的第一类(即:groupnum=1)刚对应参数cs01
//如果此项目是A系统的第二类(即:groupnum=2)刚对应参数cs02
private double cs07; //公共的参数
private double cs08; //公共的参数
}
insert into parametertable (pname,pvalue,systemnum,groupnum) values('csA',9.1,1,0);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('csB',9.2,2,0);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('csC',9.3,3,0);
insert into parametertable (pname,pvalue,systemnum,groupnum) values('csC1',9.31,3,0);
public class ProjectA {
private int projectid;
private String projectname;
private int systemnum;
private int groupnum;
private Double xfjz_f;
//(可能是参数表中xfjz_f02,xfjz_f02,xfjz_f03,xfjz_f04,xfjz_f05,xfjz_f06,xfjz_f07中一个的值)
//跟据它所属组决定的
private Double ere;
private Double tariff;
private Double gre;
private Double gasprices;
}
public class ProjectB {
private int projectid;
private String projectname;
private int systemnum;
private int groupnum;
//(可能是参数表中shrs_f01,shrs_f02中一个的值)
//跟据它所属组决定的
private Double shrs_f;
}
public class ProjectC {
private int projectid;
private String projectname;
private int systemnum;
private int groupnum;
private Double xfkz_f1;
private Double xfkz_f2;
private Double xfkz_f3;
private Double xfkz_f4;
private Double xfkz_f5;
private Double erg;
private Double grco2;
private Double grso2;
private Double grno;
private Double grdust;
}