- 基于Web的渔业专家咨询响应系统mysql数据库创建语句
- 基于Web的渔业专家咨询响应系统oracle数据库创建语句
- 基于Web的渔业专家咨询响应系统sqlserver数据库创建语句
- 基于Web的渔业专家咨询响应系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于Web的渔业专家咨询响应系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于Web的渔业专家咨询响应系统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_fl(
id int primary key auto_increment comment '主键',
flName varchar(100) comment '分类名称'
) comment '分类';
知识分享表创建语句如下：
create table t_fx(
id int primary key auto_increment comment '主键',
fxName varchar(100) comment '标题',
flId int comment '分类',
fxr varchar(100) comment '分享人',
insertDate datetime comment '分享日期',
pic varchar(100) comment '图片',
sp varchar(100) comment '视频',
content varchar(100) comment '分享内容'
) comment '知识分享';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
cotnent varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '公告';
问题咨询表创建语句如下：
create table t_wt(
id int primary key auto_increment comment '主键',
yzhId int comment '养殖户',
flId int comment '分类',
wtName varchar(100) comment '问题',
content varchar(100) comment '内容',
fileUrl varchar(100) comment '附件',
back varchar(100) comment '回复',
insertDate datetime comment '发起日期',
backDate datetime comment '回复日期',
status varchar(100) comment '状态',
zjId int comment '专家',
iszsk varchar(100) comment '是否显示到知识库',
bq varchar(100) comment '标签'
) comment '问题咨询';
养殖户表创建语句如下：
create table t_yzh(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
yzhName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '养殖户';
专家表创建语句如下：
create table t_zj(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
zjName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
flId int comment '分类',
rz varchar(100) comment '认证等级'
) comment '专家';
基于Web的渔业专家咨询响应系统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_fl(
id integer,
flName varchar(100)
);
--分类字段加注释
comment on column t_fl.id is '主键';
comment on column t_fl.flName is '分类名称';
--分类表加注释
comment on table t_fl is '分类';
知识分享表创建语句如下：
create table t_fx(
id integer,
fxName varchar(100),
flId int,
fxr varchar(100),
insertDate datetime,
pic varchar(100),
sp varchar(100),
content varchar(100)
);
--知识分享字段加注释
comment on column t_fx.id is '主键';
comment on column t_fx.fxName is '标题';
comment on column t_fx.flId is '分类';
comment on column t_fx.fxr is '分享人';
comment on column t_fx.insertDate is '分享日期';
comment on column t_fx.pic is '图片';
comment on column t_fx.sp is '视频';
comment on column t_fx.content is '分享内容';
--知识分享表加注释
comment on table t_fx is '知识分享';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.cotnent is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
问题咨询表创建语句如下：
create table t_wt(
id integer,
yzhId int,
flId int,
wtName varchar(100),
content varchar(100),
fileUrl varchar(100),
back varchar(100),
insertDate datetime,
backDate datetime,
status varchar(100),
zjId int,
iszsk varchar(100),
bq varchar(100)
);
--问题咨询字段加注释
comment on column t_wt.id is '主键';
comment on column t_wt.yzhId is '养殖户';
comment on column t_wt.flId is '分类';
comment on column t_wt.wtName is '问题';
comment on column t_wt.content is '内容';
comment on column t_wt.fileUrl is '附件';
comment on column t_wt.back is '回复';
comment on column t_wt.insertDate is '发起日期';
comment on column t_wt.backDate is '回复日期';
comment on column t_wt.status is '状态';
comment on column t_wt.zjId is '专家';
comment on column t_wt.iszsk is '是否显示到知识库';
comment on column t_wt.bq is '标签';
--问题咨询表加注释
comment on table t_wt is '问题咨询';
养殖户表创建语句如下：
create table t_yzh(
id integer,
username varchar(100),
password varchar(100),
yzhName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--养殖户字段加注释
comment on column t_yzh.id is '主键';
comment on column t_yzh.username is '账号';
comment on column t_yzh.password is '密码';
comment on column t_yzh.yzhName is '姓名';
comment on column t_yzh.phone is '电话';
comment on column t_yzh.age is '年龄';
comment on column t_yzh.sex is '性别';
--养殖户表加注释
comment on table t_yzh is '养殖户';
专家表创建语句如下：
create table t_zj(
id integer,
username varchar(100),
password varchar(100),
zjName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
flId int,
rz varchar(100)
);
--专家字段加注释
comment on column t_zj.id is '主键';
comment on column t_zj.username is '账号';
comment on column t_zj.password is '密码';
comment on column t_zj.zjName is '姓名';
comment on column t_zj.phone is '电话';
comment on column t_zj.age is '年龄';
comment on column t_zj.sex is '性别';
comment on column t_zj.flId is '分类';
comment on column t_zj.rz is '认证等级';
--专家表加注释
comment on table t_zj is '专家';
oracle特有，对应序列如下：
create sequence s_t_fl;
create sequence s_t_fx;
create sequence s_t_gg;
create sequence s_t_wt;
create sequence s_t_yzh;
create sequence s_t_zj;
基于Web的渔业专家咨询响应系统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_fl(
id int identity(1,1) primary key not null,--主键
flName varchar(100)--分类名称
);
知识分享表创建语句如下：
--知识分享表注释
create table t_fx(
id int identity(1,1) primary key not null,--主键
fxName varchar(100),--标题
flId int,--分类
fxr varchar(100),--分享人
insertDate datetime,--分享日期
pic varchar(100),--图片
sp varchar(100),--视频
content varchar(100)--分享内容
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
cotnent varchar(100),--内容
showDate datetime--日期
);
问题咨询表创建语句如下：
--问题咨询表注释
create table t_wt(
id int identity(1,1) primary key not null,--主键
yzhId int,--养殖户
flId int,--分类
wtName varchar(100),--问题
content varchar(100),--内容
fileUrl varchar(100),--附件
back varchar(100),--回复
insertDate datetime,--发起日期
backDate datetime,--回复日期
status varchar(100),--状态
zjId int,--专家
iszsk varchar(100),--是否显示到知识库
bq varchar(100)--标签
);
养殖户表创建语句如下：
--养殖户表注释
create table t_yzh(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
yzhName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
专家表创建语句如下：
--专家表注释
create table t_zj(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
zjName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
flId int,--分类
rz varchar(100)--认证等级
);
登录后主页.jpg?x-oss-process=style/00001)
基于Web的渔业专家咨询响应系统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_fl")
public class Fl {
//主键
@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 flName;
public String getFlName() {return flName;}
public void setFlName(String flName) {this.flName = flName;}
}知识分享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_fx")
public class Fx {
//主键
@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 fxName;
//分类
private Integer flId;
//分享人
private String fxr;
//分享日期
private Date insertDate;
//图片
private String pic;
//视频
private String sp;
//分享内容
private String content;
public String getFxName() {return fxName;}
public void setFxName(String fxName) {this.fxName = fxName;}
public Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
public String getFxr() {return fxr;}
public void setFxr(String fxr) {this.fxr = fxr;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSp() {return sp;}
public void setSp(String sp) {this.sp = sp;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}公告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_gg")
public class Gg {
//主键
@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 title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}问题咨询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_wt")
public class Wt {
//主键
@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 yzhId;
//分类
private Integer flId;
//问题
private String wtName;
//内容
private String content;
//附件
private String fileUrl;
//回复
private String back;
//发起日期
private Date insertDate;
//回复日期
private Date backDate;
//状态
private String status;
//专家
private Integer zjId;
//是否显示到知识库
private String iszsk;
//标签
private String bq;
public Integer getYzhId() {return yzhId;}
public void setYzhId(Integer yzhId) {this.yzhId = yzhId;}
public Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
public String getWtName() {return wtName;}
public void setWtName(String wtName) {this.wtName = wtName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getBackDate() {return backDate;}
public void setBackDate(Date backDate) {this.backDate = backDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getZjId() {return zjId;}
public void setZjId(Integer zjId) {this.zjId = zjId;}
public String getIszsk() {return iszsk;}
public void setIszsk(String iszsk) {this.iszsk = iszsk;}
public String getBq() {return bq;}
public void setBq(String bq) {this.bq = bq;}
}养殖户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_yzh")
public class Yzh {
//主键
@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 yzhName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getYzhName() {return yzhName;}
public void setYzhName(String yzhName) {this.yzhName = yzhName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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;}
}专家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_zj")
public class Zj {
//主键
@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 zjName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//分类
private Integer flId;
//认证等级
private String rz;
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 getZjName() {return zjName;}
public void setZjName(String zjName) {this.zjName = zjName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
public String getRz() {return rz;}
public void setRz(String rz) {this.rz = rz;}
}基于Web的渔业专家咨询响应系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
分类javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//分类
public class Fl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//分类名称
private String flName;
public String getFlName() {return flName;}
public void setFlName(String flName) {this.flName = flName;}
}知识分享javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//知识分享
public class Fx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String fxName;
//分类
private Integer flId;
//分享人
private String fxr;
//分享日期
private Date insertDate;
//图片
private String pic;
//视频
private String sp;
//分享内容
private String content;
public String getFxName() {return fxName;}
public void setFxName(String fxName) {this.fxName = fxName;}
public Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
public String getFxr() {return fxr;}
public void setFxr(String fxr) {this.fxr = fxr;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSp() {return sp;}
public void setSp(String sp) {this.sp = sp;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}问题咨询javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//问题咨询
public class Wt extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//养殖户
private Integer yzhId;
//分类
private Integer flId;
//问题
private String wtName;
//内容
private String content;
//附件
private String fileUrl;
//回复
private String back;
//发起日期
private Date insertDate;
//回复日期
private Date backDate;
//状态
private String status;
//专家
private Integer zjId;
//是否显示到知识库
private String iszsk;
//标签
private String bq;
public Integer getYzhId() {return yzhId;}
public void setYzhId(Integer yzhId) {this.yzhId = yzhId;}
public Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
public String getWtName() {return wtName;}
public void setWtName(String wtName) {this.wtName = wtName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getBackDate() {return backDate;}
public void setBackDate(Date backDate) {this.backDate = backDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getZjId() {return zjId;}
public void setZjId(Integer zjId) {this.zjId = zjId;}
public String getIszsk() {return iszsk;}
public void setIszsk(String iszsk) {this.iszsk = iszsk;}
public String getBq() {return bq;}
public void setBq(String bq) {this.bq = bq;}
}养殖户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//养殖户
public class Yzh 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 yzhName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getYzhName() {return yzhName;}
public void setYzhName(String yzhName) {this.yzhName = yzhName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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;}
}专家javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//专家
public class Zj 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 zjName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//分类
private Integer flId;
//认证等级
private String rz;
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 getZjName() {return zjName;}
public void setZjName(String zjName) {this.zjName = zjName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
public String getRz() {return rz;}
public void setRz(String rz) {this.rz = rz;}
}