昆蟲分類與檢索系統的設計與開發

昆蟲分類與檢索系統的設計與開發

• 昆蟲分類與檢索系統的設計與開發mysql資料庫建立語句
• 昆蟲分類與檢索系統的設計與開發oracle資料庫建立語句
• 昆蟲分類與檢索系統的設計與開發sqlserver資料庫建立語句
• 昆蟲分類與檢索系統的設計與開發spring springMVC hibernate框架物件(javaBean,pojo)設計
• 昆蟲分類與檢索系統的設計與開發spring springMVC mybatis框架物件(javaBean,pojo)設計

昆蟲分類與檢索系統的設計與開發mysql資料庫版本原始碼：

超級管理員表建立語句如下：

create table t_admin(
	id int primary key auto_increment comment '主鍵',
	username varchar(100) comment '超級管理員賬號',
	password varchar(100) comment '超級管理員密碼'
) comment '超級管理員';
insert into t_admin(username,password) values('admin','123456');

使用者表建立語句如下：

create table t_customer(
	id int primary key auto_increment comment '主鍵',
	username varchar(100) comment '賬號',
	password varchar(100) comment '密碼 ',
	customerName varchar(100) comment '姓名',
	age varchar(100) comment '年齡',
	sex varchar(100) comment '性別',
	phone varchar(100) comment '電話',
	pic varchar(100) comment '頭像'
) comment '使用者';

科表建立語句如下：

create table t_vk(
	id int primary key auto_increment comment '主鍵',
	vmId int comment '目',
	vkName varchar(100) comment '目名稱',
	vkPic varchar(100) comment '圖片',
	vkms varchar(100) comment '描述'
) comment '科';

目表建立語句如下：

create table t_vm(
	id int primary key auto_increment comment '主鍵',
	vmName varchar(100) comment '目名稱',
	vmPic varchar(100) comment '圖片',
	vmms varchar(100) comment '描述'
) comment '目';

屬表建立語句如下：

create table t_vs(
	id int primary key auto_increment comment '主鍵',
	vmId int comment '目',
	vkId int comment '科',
	vsName varchar(100) comment '屬名稱'
) comment '屬';

種表建立語句如下：

create table t_vz(
	id int primary key auto_increment comment '主鍵',
	vmId int comment '目',
	vkId int comment '科',
	vsId int comment '屬',
	vzName varchar(100) comment '種名稱',
	vzPic varchar(100) comment '圖片',
	vmms varchar(100) comment '描述',
	fb varchar(100) comment '分佈'
) comment '種';

昆蟲分類與檢索系統的設計與開發oracle資料庫版本原始碼：

超級管理員表建立語句如下：

create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超級管理員欄位加註釋
comment on column t_admin.id is '主鍵';
comment on column t_admin.username is '超級管理員賬號';
comment on column t_admin.password is '超級管理員密碼';
--超級管理員表加註釋
comment on table t_admin is '超級管理員';

使用者表建立語句如下：

create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100)
);
--使用者欄位加註釋
comment on column t_customer.id is '主鍵';
comment on column t_customer.username is '賬號';
comment on column t_customer.password is '密碼 ';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.age is '年齡';
comment on column t_customer.sex is '性別';
comment on column t_customer.phone is '電話';
comment on column t_customer.pic is '頭像';
--使用者表加註釋
comment on table t_customer is '使用者';

科表建立語句如下：

create table t_vk(
	id integer,
	vmId int,
	vkName varchar(100),
	vkPic varchar(100),
	vkms varchar(100)
);
--科欄位加註釋
comment on column t_vk.id is '主鍵';
comment on column t_vk.vmId is '目';
comment on column t_vk.vkName is '目名稱';
comment on column t_vk.vkPic is '圖片';
comment on column t_vk.vkms is '描述';
--科表加註釋
comment on table t_vk is '科';

目表建立語句如下：

create table t_vm(
	id integer,
	vmName varchar(100),
	vmPic varchar(100),
	vmms varchar(100)
);
--目欄位加註釋
comment on column t_vm.id is '主鍵';
comment on column t_vm.vmName is '目名稱';
comment on column t_vm.vmPic is '圖片';
comment on column t_vm.vmms is '描述';
--目表加註釋
comment on table t_vm is '目';

屬表建立語句如下：

create table t_vs(
	id integer,
	vmId int,
	vkId int,
	vsName varchar(100)
);
--屬欄位加註釋
comment on column t_vs.id is '主鍵';
comment on column t_vs.vmId is '目';
comment on column t_vs.vkId is '科';
comment on column t_vs.vsName is '屬名稱';
--屬表加註釋
comment on table t_vs is '屬';

種表建立語句如下：

create table t_vz(
	id integer,
	vmId int,
	vkId int,
	vsId int,
	vzName varchar(100),
	vzPic varchar(100),
	vmms varchar(100),
	fb varchar(100)
);
--種欄位加註釋
comment on column t_vz.id is '主鍵';
comment on column t_vz.vmId is '目';
comment on column t_vz.vkId is '科';
comment on column t_vz.vsId is '屬';
comment on column t_vz.vzName is '種名稱';
comment on column t_vz.vzPic is '圖片';
comment on column t_vz.vmms is '描述';
comment on column t_vz.fb is '分佈';
--種表加註釋
comment on table t_vz is '種';

oracle特有，對應序列如下：

create sequence s_t_customer;
create sequence s_t_vk;
create sequence s_t_vm;
create sequence s_t_vs;
create sequence s_t_vz;

昆蟲分類與檢索系統的設計與開發sqlserver資料庫版本原始碼：

超級管理員表建立語句如下：

--超級管理員
create table t_admin(
	id int identity(1,1) primary key not null,--主鍵
	username varchar(100),--超級管理員賬號
	password varchar(100)--超級管理員密碼
);
insert into t_admin(username,password) values('admin','123456');

使用者表建立語句如下：

--使用者表註釋
create table t_customer(
	id int identity(1,1) primary key not null,--主鍵
	username varchar(100),--賬號
	password varchar(100),--密碼 
	customerName varchar(100),--姓名
	age varchar(100),--年齡
	sex varchar(100),--性別
	phone varchar(100),--電話
	pic varchar(100)--頭像
);

科表建立語句如下：

--科表註釋
create table t_vk(
	id int identity(1,1) primary key not null,--主鍵
	vmId int,--目
	vkName varchar(100),--目名稱
	vkPic varchar(100),--圖片
	vkms varchar(100)--描述
);

目表建立語句如下：

--目表註釋
create table t_vm(
	id int identity(1,1) primary key not null,--主鍵
	vmName varchar(100),--目名稱
	vmPic varchar(100),--圖片
	vmms varchar(100)--描述
);

屬表建立語句如下：

--屬表註釋
create table t_vs(
	id int identity(1,1) primary key not null,--主鍵
	vmId int,--目
	vkId int,--科
	vsName varchar(100)--屬名稱
);

種表建立語句如下：

--種表註釋
create table t_vz(
	id int identity(1,1) primary key not null,--主鍵
	vmId int,--目
	vkId int,--科
	vsId int,--屬
	vzName varchar(100),--種名稱
	vzPic varchar(100),--圖片
	vmms varchar(100),--描述
	fb varchar(100)--分佈
);

昆蟲分類與檢索系統的設計與開發spring springMVC hibernate框架物件(javaBean,pojo)設計：

使用者javaBean建立語句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//使用者
@Table(name = "t_customer")
public class Customer {
//主鍵
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//賬號
private String username;
//密碼 
private String password;
//姓名
private String customerName;
//年齡
private String age;
//性別
private String sex;
//電話
private String phone;
//頭像
private String pic;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

科javaBean建立語句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//科
@Table(name = "t_vk")
public class Vk {
//主鍵
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//目
private Integer vmId;
//目名稱
private String vkName;
//圖片
private String vkPic;
//描述
private String vkms;
public Integer getVmId() {return vmId;}
public void setVmId(Integer vmId) {this.vmId = vmId;}
public String getVkName() {return vkName;}
public void setVkName(String vkName) {this.vkName = vkName;}
public String getVkPic() {return vkPic;}
public void setVkPic(String vkPic) {this.vkPic = vkPic;}
public String getVkms() {return vkms;}
public void setVkms(String vkms) {this.vkms = vkms;}
}

目javaBean建立語句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//目
@Table(name = "t_vm")
public class Vm {
//主鍵
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//目名稱
private String vmName;
//圖片
private String vmPic;
//描述
private String vmms;
public String getVmName() {return vmName;}
public void setVmName(String vmName) {this.vmName = vmName;}
public String getVmPic() {return vmPic;}
public void setVmPic(String vmPic) {this.vmPic = vmPic;}
public String getVmms() {return vmms;}
public void setVmms(String vmms) {this.vmms = vmms;}
}

屬javaBean建立語句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//屬
@Table(name = "t_vs")
public class Vs {
//主鍵
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//目
private Integer vmId;
//科
private Integer vkId;
//屬名稱
private String vsName;
public Integer getVmId() {return vmId;}
public void setVmId(Integer vmId) {this.vmId = vmId;}
public Integer getVkId() {return vkId;}
public void setVkId(Integer vkId) {this.vkId = vkId;}
public String getVsName() {return vsName;}
public void setVsName(String vsName) {this.vsName = vsName;}
}

種javaBean建立語句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//種
@Table(name = "t_vz")
public class Vz {
//主鍵
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//目
private Integer vmId;
//科
private Integer vkId;
//屬
private Integer vsId;
//種名稱
private String vzName;
//圖片
private String vzPic;
//描述
private String vmms;
//分佈
private String fb;
public Integer getVmId() {return vmId;}
public void setVmId(Integer vmId) {this.vmId = vmId;}
public Integer getVkId() {return vkId;}
public void setVkId(Integer vkId) {this.vkId = vkId;}
public Integer getVsId() {return vsId;}
public void setVsId(Integer vsId) {this.vsId = vsId;}
public String getVzName() {return vzName;}
public void setVzName(String vzName) {this.vzName = vzName;}
public String getVzPic() {return vzPic;}
public void setVzPic(String vzPic) {this.vzPic = vzPic;}
public String getVmms() {return vmms;}
public void setVmms(String vmms) {this.vmms = vmms;}
public String getFb() {return fb;}
public void setFb(String fb) {this.fb = fb;}
}

昆蟲分類與檢索系統的設計與開發spring springMVC mybatis框架物件(javaBean,pojo)設計：

使用者javaBean建立語句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//使用者
public class Customer  extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//賬號
private String username;
//密碼 
private String password;
//姓名
private String customerName;
//年齡
private String age;
//性別
private String sex;
//電話
private String phone;
//頭像
private String pic;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

科javaBean建立語句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//科
public class Vk  extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//目
private Integer vmId;
//目名稱
private String vkName;
//圖片
private String vkPic;
//描述
private String vkms;
public Integer getVmId() {return vmId;}
public void setVmId(Integer vmId) {this.vmId = vmId;}
public String getVkName() {return vkName;}
public void setVkName(String vkName) {this.vkName = vkName;}
public String getVkPic() {return vkPic;}
public void setVkPic(String vkPic) {this.vkPic = vkPic;}
public String getVkms() {return vkms;}
public void setVkms(String vkms) {this.vkms = vkms;}
}

目javaBean建立語句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//目
public class Vm  extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//目名稱
private String vmName;
//圖片
private String vmPic;
//描述
private String vmms;
public String getVmName() {return vmName;}
public void setVmName(String vmName) {this.vmName = vmName;}
public String getVmPic() {return vmPic;}
public void setVmPic(String vmPic) {this.vmPic = vmPic;}
public String getVmms() {return vmms;}
public void setVmms(String vmms) {this.vmms = vmms;}
}

屬javaBean建立語句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//屬
public class Vs  extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//目
private Integer vmId;
//科
private Integer vkId;
//屬名稱
private String vsName;
public Integer getVmId() {return vmId;}
public void setVmId(Integer vmId) {this.vmId = vmId;}
public Integer getVkId() {return vkId;}
public void setVkId(Integer vkId) {this.vkId = vkId;}
public String getVsName() {return vsName;}
public void setVsName(String vsName) {this.vsName = vsName;}
}

種javaBean建立語句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//種
public class Vz  extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//目
private Integer vmId;
//科
private Integer vkId;
//屬
private Integer vsId;
//種名稱
private String vzName;
//圖片
private String vzPic;
//描述
private String vmms;
//分佈
private String fb;
public Integer getVmId() {return vmId;}
public void setVmId(Integer vmId) {this.vmId = vmId;}
public Integer getVkId() {return vkId;}
public void setVkId(Integer vkId) {this.vkId = vkId;}
public Integer getVsId() {return vsId;}
public void setVsId(Integer vsId) {this.vsId = vsId;}
public String getVzName() {return vzName;}
public void setVzName(String vzName) {this.vzName = vzName;}
public String getVzPic() {return vzPic;}
public void setVzPic(String vzPic) {this.vzPic = vzPic;}
public String getVmms() {return vmms;}
public void setVmms(String vmms) {this.vmms = vmms;}
public String getFb() {return fb;}
public void setFb(String fb) {this.fb = fb;}
}