农药登记证的创建CREATE TABLE `nydjz` ( `registNum` varchar(20) NOT NULL COMMENT '注册证号', `name` varchar(20) DEFAULT NULL COMMENT '农药名称', `startTime` date DEFAULT NULL COMMENT '开始有效时间',
`endTime` date DEFAULT NULL COMMENT '结束时间', `activeContent` varchar(40) DEFAULT NULL COMMENT '有效成分', `totalContent` varchar(10) DEFAULT NULL COMMENT '总含量', `typeFormulation` varchar(20) DEFAULT NULL COMMENT '剂型',
`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
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; }
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) {
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;}}
农药登记证的基本属性大概就这么多，根据农药登记证号，分为大田登记证，大田临时登记证，卫生登记证，卫生临时登记证。等等；