1、农药登记证的创建CREATETABLE`nydjz`(`registNum`varchar(20)NOTNULLCOMMENT'注册证号',`name`varchar(20)DEFAULTNULLCOMMENT'农药名称',`startTime`dateDEFAULTNULLCOMMENT'开始有效时间',
2、`endTime`dateDEFAULTNULLCOMMENT'结束时间',`activeContent`varchar(40)DEFAULTNULLCOMMENT'有效成分',`totalContent`varchar(10)DEFAULTNULLCOMMENT'总含量',`typeFormulation`varchar(20)DEFAULTNULLCOMMENT'剂型',
3、`type`varchar(20)DEFAULTNULLCOMMENT'种类',`toxicity`varchar(10)DEFAULTNULLCOMMENT'毒性',`scope`varchar(20)DEFAULTNULLCOMMENT'使用范围',`pests`varchar(20)DEFAULTNULLCOMMENT'防止对象',`rates`varchar(50)DEFAULTNULLCOMMENT'用药量',`methods`varchar(50)DEFAULTNULLCOMMENT'使用方法',`f_id`bigint(20)DEFAULTNULLCOMMENT'对应生产厂家',PRIMARYKEY(`registNum`))ENGINE=InnoDBDEFAULTCHARSET=utf8
4、public class Nydj所鼙艘疯z { private String registNum; private Date startTime; priv锾攒揉敫ate 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;}pub盟敢势袂lic String getActiveContent() {return th足毂忍珩is.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、农药登记证的基本属性大概就这么多，根据农药登记证号，分为大田登记证，大田临时登记证，卫生登记证，卫生临时登记证。等等；
