农药登记证的创建
1、农药登记证的创建CREATE TABLE `nydjz` ( `registNum` varchar(20) NOT NULL COMMENT '注册证号', `name` varchar(20) DEFAULT NULL COMMENT '农药名称', `startTime` date DEFAULT NULL COMMENT '开始有效时间',
2、 `endTime` date DEFAULT NULL COMMENT '结束时间', `activeContent` varchar(40) DEFAULT NULL COMMENT '有效成分', `totalContent` varchar(10) DEFAULT NULL COMMENT '总含量', `typeFormulation` varchar(20) DEFAULT NULL COMMENT '剂型',
3、 `type` varchar(20) DEFAULT NULL COMMENT '种类', `toxicity` varchar(10) DEFAULT NULL COMMENT '毒性', `scope` varchar(20) DEFAULT NULL COMMENT '使用范围', `pests` varchar(20) DEFAULT NULL COMMENT '防止对象', `rates` varchar(50) DEFAULT NULL COMMENT '用药量', `methods` varchar(50) DEFAULT NULL COMMENT '使用方法', `f_id` bigint(20) DEFAULT NULL COMMENT '对应生产厂家', PRIMARY KEY (`registNum`)) ENGINE=InnoDB DEFAULT CHARSET=utf8
4、public class Nydjz {
private String registNum;
private Date startTime;
private Date endTime;
private String name;
private String activeContent;
private String totalContent;
private String typeFormulation;
private String type;
private String toxicity;
private String scope;
private String pests;
private String rates;
private String methods;
private Long f_id;
public String getRegistNum() {
return this.registNum;
}
5、public void setRegistNum(String registNum) {
this.registNum = registNum;
}
public Date getStartTime() {
return this.startTime;
}
public void setStartTime(Date startTime) {
this.startTime = startTime;
}
public Date getEndTime() {
return this.endTime;
}
public void setEndTime(Date endTime) {
this.endTime = endTime;
}
public String getName() {
return this.name;
}
public void setName(String name) {
6、this.name = name;
}
public String getActiveContent() {
return this.activeContent;
}
public void setActiveContent(String activeContent) {
this.activeContent = activeContent;
}
public String getTotalContent() {
return this.totalContent;
}
public void setTotalContent(String totalContent) {
this.totalContent = totalContent;
}
public String getTypeFormulation() {
return this.typeFormulation;
}
public void setTypeFormulation(String typeFormulation) {
this.typeFormulation = typeFormulation;
}
public String getType() {
return this.type;
}
public void setType(String type) {
this.type = type;
}
public String getToxicity() {
return this.toxicity;
}
public void setToxicity(String toxicity) {
this.toxicity = toxicity;
}
public String getScope() {
return this.scope;
}
public void setScope(String scope) {
this.scope = scope;
}
public String getPests() {
return this.pests;
}
public void setPests(String pests) {
this.pests = pests;
}
public String getRates() {
return this.rates;
}
public void setRates(String rates) {
this.rates = rates;
}
public String getMethods() {
return this.methods;
}
public void setMethods(String methods) {
this.methods = methods;
}
public Long getF_id() {
return this.f_id;
}
public void setF_id(Long f_id) {
this.f_id = f_id;
}
}
7、农药登记证的基本属性大概就这么多,根据农药登记证号,分为大田登记证,大田临时登记证,卫生登记证,卫生临时登记证。等等;