现代渔场管理系统

五大系统模块(渔场简介、组织机构、池塘管理、物资管理、渔场动态)

1.渔场简介

渔场的建场时间、地理位置、自然条件、渔场规模、养殖面积、主要产品

以上内容只是展示出来

 

 

2.组织机构

渔场的场长、副厂长、技术员、管理员、技术部、财务部、生产部、后勤部等的人员信息

以上内容由一个管理员进行修改,并在网页中进行展示

 

3.池塘管理

池塘概况、池塘清理、放养模式、饵料投喂、生长测定、水质管理、鱼病预防、鱼病治疗、日常管等,以上内容由一个管理员进行修改,并在网页中进行展示

 

(1)池塘概况  

编号:001  002……

塘租:

位置:

面积:

规格:长度  宽度   深度

(2)池塘清整

     时间: 

     药物:

     用量:

     用法:

     成本:

(3)放养模式

     种类:

     来源:外购或自培

     时间:

规格:体重  体长

     数量:

     重量:

     药浴:药物种类、用量、时长

     费用:

(4)饵料投喂

     饵料来源:生产厂家

     饲料价格:元/公斤

     饵料粒径:mm

     饵料组分:

营养成分:

     池塘水温:

     投喂次数:

     投喂时间:早上    上午   中午    下午

     日投喂量:

     摄食状态:旺盛  正常  较差  不吃

     饲料成本:

(5)生长测定

     时间:

     种类:

     结果:体长、体重

(6)水质管理

     水质测定:透明度、水色、溶解氧、pH值、氨氮、亚硝酸盐

药物调节:时间、药物种类、使用数量

     换水补水:时间、数量

     换水成本:

     开增氧机:时间、时长

     用电成本:

(6)鱼病预防

     时间:

     药物:

用量:

用法:

费用:

(7)鱼病治疗

     发病时间:

     发病种类:

疾病种类:

     病症表现:

死鱼数量:数量、规格、重量

死鱼损失:

(8)日常管理

     巡塘记录: 早   中  晚

     浮头泛池:

     死鱼数量

     开增氧机:时间、时长

     电费成本:

 

     以上内容量力去做吧,把主要功能差不多实现

 

     4.物资管理,由管理员进行修改和查看

(1)饲料

       种类:

       价格:

       时间:

       数量:

       成本:

       库存

   (2)药品

种类:

       时间:

       数量:

       价格:

       成本:

       库存:

 

 

       5.渔场动态,由管理员进行修改和查看

   (1)销售

        种类:

        时间:

        规格:

        价格:

        数量:

        客户:

(2)存量

         种类:

         规格:

         数量:

     (3)效益

          总销售额:

          存量价值:

          总支出:

          总利润:

现代渔场管理系统登录注册界面

现代渔场管理系统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_cl(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '种类',
	v2 varchar(100) comment '规格',
	v3 varchar(100) comment '数量'
) comment '存量';

池塘概况表创建语句如下:


create table t_ctgk(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '编号',
	v2 varchar(100) comment '塘租',
	v3 varchar(100) comment '位置',
	v4 varchar(100) comment '面积',
	v5 varchar(100) comment '规格:长度/宽度/深度'
) comment '池塘概况';

池塘清理表创建语句如下:


create table t_ctql(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '池塘编号',
	v2 varchar(100) comment '时间',
	v3 varchar(100) comment '药物',
	v4 varchar(100) comment '用量',
	v5 varchar(100) comment '用法',
	v6 varchar(100) comment '成本'
) comment '池塘清理';

放养模式表创建语句如下:


create table t_fyms(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '池塘编号',
	v2 varchar(100) comment '种类',
	v3 varchar(100) comment '来源:外购/自培',
	v4 varchar(100) comment '时间',
	v5 varchar(100) comment '规格:体重/体长',
	v6 varchar(100) comment '数量',
	v7 varchar(100) comment '重量',
	v8 varchar(100) comment '药浴:药物种类用量时长',
	v9 varchar(100) comment '费用'
) comment '放养模式';

普通管理员表创建语句如下:


create table t_ptadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	ptadminName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '普通管理员';

日常管理表创建语句如下:


create table t_rcgl(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '池塘编号',
	v2 varchar(100) comment '巡塘记录:早/中/晚',
	v3 varchar(100) comment '浮头泛池',
	v4 varchar(100) comment ' 死鱼数量',
	v5 varchar(100) comment '开增氧机:时间/时长',
	v6 varchar(100) comment '电费成本'
) comment '日常管理';

饲料表创建语句如下:


create table t_sl(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '种类',
	v2 varchar(100) comment '价格',
	v3 varchar(100) comment '时间',
	v4 varchar(100) comment '数量',
	v5 varchar(100) comment '成本',
	v6 varchar(100) comment '库存'
) comment '饲料';

饲料投喂表创建语句如下:


create table t_sltw(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '池塘编号',
	v2 varchar(100) comment '饵料来源:生产厂家',
	v3 varchar(100) comment '饲料价格:元/公斤',
	v4 varchar(100) comment '饵料粒径:mm',
	v5 varchar(100) comment '饵料组分',
	v6 varchar(100) comment '营养成分',
	v7 varchar(100) comment '池塘水温',
	v8 varchar(100) comment '投喂次数',
	v9 varchar(100) comment '投喂时间:早上/上午/中午/下午',
	v10 varchar(100) comment '日投喂量',
	v11 varchar(100) comment '摄食状态:旺盛/正常/较差/不吃',
	v12 varchar(100) comment '饲料成本'
) comment '饲料投喂';

生长测定表创建语句如下:


create table t_szcd(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '池塘编号',
	v2 varchar(100) comment '时间',
	v3 varchar(100) comment '种类',
	v4 varchar(100) comment '结果:体长/体重'
) comment '生长测定';

水质管理表创建语句如下:


create table t_szgl(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '池塘编号',
	v2 varchar(100) comment '水质测定:透明度、水色、溶解氧、pH值、氨氮、亚硝酸盐',
	v3 varchar(100) comment '药物调节:时间、药物种类、使用数量',
	v4 varchar(100) comment '换水补水:时间、数量',
	v5 varchar(100) comment '换水成本',
	v6 varchar(100) comment '开增氧机:时间、时长',
	v7 varchar(100) comment '用电成本'
) comment '水质管理';

销售表创建语句如下:


create table t_xs(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '种类',
	v2 varchar(100) comment '时间',
	v3 varchar(100) comment '规格',
	v4 varchar(100) comment '价格',
	v5 varchar(100) comment '数量',
	v6 varchar(100) comment '客户'
) comment '销售';

效益表创建语句如下:


create table t_xy(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '总销售额',
	v2 varchar(100) comment '存量价值',
	v3 varchar(100) comment '总支出',
	v4 varchar(100) comment '总利润',
	v5 varchar(100) comment '利润率'
) comment '效益';

鱼病预防表创建语句如下:


create table t_ybyf(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '池塘编号',
	v2 varchar(100) comment '时间',
	v3 varchar(100) comment '药物',
	v4 varchar(100) comment '用量',
	v5 varchar(100) comment '用法',
	v6 varchar(100) comment '费用'
) comment '鱼病预防';

鱼病治疗表创建语句如下:


create table t_ybzl(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '池塘编号',
	v2 varchar(100) comment '发病时间',
	v3 varchar(100) comment '发病种类',
	v4 varchar(100) comment '疾病种类',
	v5 varchar(100) comment '病症表现',
	v6 varchar(100) comment '死鱼数量:数量、规格、重量',
	v7 varchar(100) comment '死鱼损失'
) comment '鱼病治疗';

渔场简介表创建语句如下:


create table t_ycjj(
	id int primary key auto_increment comment '主键',
	content varchar(100) comment '渔场简介'
) comment '渔场简介';

药品表创建语句如下:


create table t_yp(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '种类',
	v2 varchar(100) comment '时间',
	v3 varchar(100) comment '数量',
	v4 varchar(100) comment '价格',
	v5 varchar(100) comment '成本',
	v6 varchar(100) comment '库存'
) comment '药品';

组织机构表创建语句如下:


create table t_zzjg(
	id int primary key auto_increment comment '主键',
	content 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_cl(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--存量字段加注释
comment on column t_cl.id is '主键';
comment on column t_cl.v1 is '种类';
comment on column t_cl.v2 is '规格';
comment on column t_cl.v3 is '数量';
--存量表加注释
comment on table t_cl is '存量';

池塘概况表创建语句如下:


create table t_ctgk(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100)
);
--池塘概况字段加注释
comment on column t_ctgk.id is '主键';
comment on column t_ctgk.v1 is '编号';
comment on column t_ctgk.v2 is '塘租';
comment on column t_ctgk.v3 is '位置';
comment on column t_ctgk.v4 is '面积';
comment on column t_ctgk.v5 is '规格:长度/宽度/深度';
--池塘概况表加注释
comment on table t_ctgk is '池塘概况';

池塘清理表创建语句如下:


create table t_ctql(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--池塘清理字段加注释
comment on column t_ctql.id is '主键';
comment on column t_ctql.v1 is '池塘编号';
comment on column t_ctql.v2 is '时间';
comment on column t_ctql.v3 is '药物';
comment on column t_ctql.v4 is '用量';
comment on column t_ctql.v5 is '用法';
comment on column t_ctql.v6 is '成本';
--池塘清理表加注释
comment on table t_ctql is '池塘清理';

放养模式表创建语句如下:


create table t_fyms(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100),
	v8 varchar(100),
	v9 varchar(100)
);
--放养模式字段加注释
comment on column t_fyms.id is '主键';
comment on column t_fyms.v1 is '池塘编号';
comment on column t_fyms.v2 is '种类';
comment on column t_fyms.v3 is '来源:外购/自培';
comment on column t_fyms.v4 is '时间';
comment on column t_fyms.v5 is '规格:体重/体长';
comment on column t_fyms.v6 is '数量';
comment on column t_fyms.v7 is '重量';
comment on column t_fyms.v8 is '药浴:药物种类用量时长';
comment on column t_fyms.v9 is '费用';
--放养模式表加注释
comment on table t_fyms is '放养模式';

普通管理员表创建语句如下:


create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码 ';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
comment on column t_ptadmin.phone is '电话';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';

日常管理表创建语句如下:


create table t_rcgl(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--日常管理字段加注释
comment on column t_rcgl.id is '主键';
comment on column t_rcgl.v1 is '池塘编号';
comment on column t_rcgl.v2 is '巡塘记录:早/中/晚';
comment on column t_rcgl.v3 is '浮头泛池';
comment on column t_rcgl.v4 is ' 死鱼数量';
comment on column t_rcgl.v5 is '开增氧机:时间/时长';
comment on column t_rcgl.v6 is '电费成本';
--日常管理表加注释
comment on table t_rcgl is '日常管理';

饲料表创建语句如下:


create table t_sl(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--饲料字段加注释
comment on column t_sl.id is '主键';
comment on column t_sl.v1 is '种类';
comment on column t_sl.v2 is '价格';
comment on column t_sl.v3 is '时间';
comment on column t_sl.v4 is '数量';
comment on column t_sl.v5 is '成本';
comment on column t_sl.v6 is '库存';
--饲料表加注释
comment on table t_sl is '饲料';

饲料投喂表创建语句如下:


create table t_sltw(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100),
	v8 varchar(100),
	v9 varchar(100),
	v10 varchar(100),
	v11 varchar(100),
	v12 varchar(100)
);
--饲料投喂字段加注释
comment on column t_sltw.id is '主键';
comment on column t_sltw.v1 is '池塘编号';
comment on column t_sltw.v2 is '饵料来源:生产厂家';
comment on column t_sltw.v3 is '饲料价格:元/公斤';
comment on column t_sltw.v4 is '饵料粒径:mm';
comment on column t_sltw.v5 is '饵料组分';
comment on column t_sltw.v6 is '营养成分';
comment on column t_sltw.v7 is '池塘水温';
comment on column t_sltw.v8 is '投喂次数';
comment on column t_sltw.v9 is '投喂时间:早上/上午/中午/下午';
comment on column t_sltw.v10 is '日投喂量';
comment on column t_sltw.v11 is '摄食状态:旺盛/正常/较差/不吃';
comment on column t_sltw.v12 is '饲料成本';
--饲料投喂表加注释
comment on table t_sltw is '饲料投喂';

生长测定表创建语句如下:


create table t_szcd(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100)
);
--生长测定字段加注释
comment on column t_szcd.id is '主键';
comment on column t_szcd.v1 is '池塘编号';
comment on column t_szcd.v2 is '时间';
comment on column t_szcd.v3 is '种类';
comment on column t_szcd.v4 is '结果:体长/体重';
--生长测定表加注释
comment on table t_szcd is '生长测定';

水质管理表创建语句如下:


create table t_szgl(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100)
);
--水质管理字段加注释
comment on column t_szgl.id is '主键';
comment on column t_szgl.v1 is '池塘编号';
comment on column t_szgl.v2 is '水质测定:透明度、水色、溶解氧、pH值、氨氮、亚硝酸盐';
comment on column t_szgl.v3 is '药物调节:时间、药物种类、使用数量';
comment on column t_szgl.v4 is '换水补水:时间、数量';
comment on column t_szgl.v5 is '换水成本';
comment on column t_szgl.v6 is '开增氧机:时间、时长';
comment on column t_szgl.v7 is '用电成本';
--水质管理表加注释
comment on table t_szgl is '水质管理';

销售表创建语句如下:


create table t_xs(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--销售字段加注释
comment on column t_xs.id is '主键';
comment on column t_xs.v1 is '种类';
comment on column t_xs.v2 is '时间';
comment on column t_xs.v3 is '规格';
comment on column t_xs.v4 is '价格';
comment on column t_xs.v5 is '数量';
comment on column t_xs.v6 is '客户';
--销售表加注释
comment on table t_xs is '销售';

效益表创建语句如下:


create table t_xy(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100)
);
--效益字段加注释
comment on column t_xy.id is '主键';
comment on column t_xy.v1 is '总销售额';
comment on column t_xy.v2 is '存量价值';
comment on column t_xy.v3 is '总支出';
comment on column t_xy.v4 is '总利润';
comment on column t_xy.v5 is '利润率';
--效益表加注释
comment on table t_xy is '效益';

鱼病预防表创建语句如下:


create table t_ybyf(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--鱼病预防字段加注释
comment on column t_ybyf.id is '主键';
comment on column t_ybyf.v1 is '池塘编号';
comment on column t_ybyf.v2 is '时间';
comment on column t_ybyf.v3 is '药物';
comment on column t_ybyf.v4 is '用量';
comment on column t_ybyf.v5 is '用法';
comment on column t_ybyf.v6 is '费用';
--鱼病预防表加注释
comment on table t_ybyf is '鱼病预防';

鱼病治疗表创建语句如下:


create table t_ybzl(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100)
);
--鱼病治疗字段加注释
comment on column t_ybzl.id is '主键';
comment on column t_ybzl.v1 is '池塘编号';
comment on column t_ybzl.v2 is '发病时间';
comment on column t_ybzl.v3 is '发病种类';
comment on column t_ybzl.v4 is '疾病种类';
comment on column t_ybzl.v5 is '病症表现';
comment on column t_ybzl.v6 is '死鱼数量:数量、规格、重量';
comment on column t_ybzl.v7 is '死鱼损失';
--鱼病治疗表加注释
comment on table t_ybzl is '鱼病治疗';

渔场简介表创建语句如下:


create table t_ycjj(
	id integer,
	content varchar(100)
);
--渔场简介字段加注释
comment on column t_ycjj.id is '主键';
comment on column t_ycjj.content is '渔场简介';
--渔场简介表加注释
comment on table t_ycjj is '渔场简介';

药品表创建语句如下:


create table t_yp(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--药品字段加注释
comment on column t_yp.id is '主键';
comment on column t_yp.v1 is '种类';
comment on column t_yp.v2 is '时间';
comment on column t_yp.v3 is '数量';
comment on column t_yp.v4 is '价格';
comment on column t_yp.v5 is '成本';
comment on column t_yp.v6 is '库存';
--药品表加注释
comment on table t_yp is '药品';

组织机构表创建语句如下:


create table t_zzjg(
	id integer,
	content varchar(100)
);
--组织机构字段加注释
comment on column t_zzjg.id is '主键';
comment on column t_zzjg.content is '组织机构';
--组织机构表加注释
comment on table t_zzjg is '组织机构';

oracle特有,对应序列如下:


create sequence s_t_cl;
create sequence s_t_ctgk;
create sequence s_t_ctql;
create sequence s_t_fyms;
create sequence s_t_ptadmin;
create sequence s_t_rcgl;
create sequence s_t_sl;
create sequence s_t_sltw;
create sequence s_t_szcd;
create sequence s_t_szgl;
create sequence s_t_xs;
create sequence s_t_xy;
create sequence s_t_ybyf;
create sequence s_t_ybzl;
create sequence s_t_ycjj;
create sequence s_t_yp;
create sequence s_t_zzjg;

现代渔场管理系统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_cl(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--种类
	v2 varchar(100),--规格
	v3 varchar(100)--数量
);

池塘概况表创建语句如下:


--池塘概况表注释
create table t_ctgk(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--编号
	v2 varchar(100),--塘租
	v3 varchar(100),--位置
	v4 varchar(100),--面积
	v5 varchar(100)--规格:长度/宽度/深度
);

池塘清理表创建语句如下:


--池塘清理表注释
create table t_ctql(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--池塘编号
	v2 varchar(100),--时间
	v3 varchar(100),--药物
	v4 varchar(100),--用量
	v5 varchar(100),--用法
	v6 varchar(100)--成本
);

放养模式表创建语句如下:


--放养模式表注释
create table t_fyms(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--池塘编号
	v2 varchar(100),--种类
	v3 varchar(100),--来源:外购/自培
	v4 varchar(100),--时间
	v5 varchar(100),--规格:体重/体长
	v6 varchar(100),--数量
	v7 varchar(100),--重量
	v8 varchar(100),--药浴:药物种类用量时长
	v9 varchar(100)--费用
);

普通管理员表创建语句如下:


--普通管理员表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	ptadminName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

日常管理表创建语句如下:


--日常管理表注释
create table t_rcgl(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--池塘编号
	v2 varchar(100),--巡塘记录:早/中/晚
	v3 varchar(100),--浮头泛池
	v4 varchar(100),-- 死鱼数量
	v5 varchar(100),--开增氧机:时间/时长
	v6 varchar(100)--电费成本
);

饲料表创建语句如下:


--饲料表注释
create table t_sl(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--种类
	v2 varchar(100),--价格
	v3 varchar(100),--时间
	v4 varchar(100),--数量
	v5 varchar(100),--成本
	v6 varchar(100)--库存
);

饲料投喂表创建语句如下:


--饲料投喂表注释
create table t_sltw(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--池塘编号
	v2 varchar(100),--饵料来源:生产厂家
	v3 varchar(100),--饲料价格:元/公斤
	v4 varchar(100),--饵料粒径:mm
	v5 varchar(100),--饵料组分
	v6 varchar(100),--营养成分
	v7 varchar(100),--池塘水温
	v8 varchar(100),--投喂次数
	v9 varchar(100),--投喂时间:早上/上午/中午/下午
	v10 varchar(100),--日投喂量
	v11 varchar(100),--摄食状态:旺盛/正常/较差/不吃
	v12 varchar(100)--饲料成本
);

生长测定表创建语句如下:


--生长测定表注释
create table t_szcd(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--池塘编号
	v2 varchar(100),--时间
	v3 varchar(100),--种类
	v4 varchar(100)--结果:体长/体重
);

水质管理表创建语句如下:


--水质管理表注释
create table t_szgl(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--池塘编号
	v2 varchar(100),--水质测定:透明度、水色、溶解氧、pH值、氨氮、亚硝酸盐
	v3 varchar(100),--药物调节:时间、药物种类、使用数量
	v4 varchar(100),--换水补水:时间、数量
	v5 varchar(100),--换水成本
	v6 varchar(100),--开增氧机:时间、时长
	v7 varchar(100)--用电成本
);

销售表创建语句如下:


--销售表注释
create table t_xs(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--种类
	v2 varchar(100),--时间
	v3 varchar(100),--规格
	v4 varchar(100),--价格
	v5 varchar(100),--数量
	v6 varchar(100)--客户
);

效益表创建语句如下:


--效益表注释
create table t_xy(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--总销售额
	v2 varchar(100),--存量价值
	v3 varchar(100),--总支出
	v4 varchar(100),--总利润
	v5 varchar(100)--利润率
);

鱼病预防表创建语句如下:


--鱼病预防表注释
create table t_ybyf(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--池塘编号
	v2 varchar(100),--时间
	v3 varchar(100),--药物
	v4 varchar(100),--用量
	v5 varchar(100),--用法
	v6 varchar(100)--费用
);

鱼病治疗表创建语句如下:


--鱼病治疗表注释
create table t_ybzl(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--池塘编号
	v2 varchar(100),--发病时间
	v3 varchar(100),--发病种类
	v4 varchar(100),--疾病种类
	v5 varchar(100),--病症表现
	v6 varchar(100),--死鱼数量:数量、规格、重量
	v7 varchar(100)--死鱼损失
);

渔场简介表创建语句如下:


--渔场简介表注释
create table t_ycjj(
	id int identity(1,1) primary key not null,--主键
	content varchar(100)--渔场简介
);

药品表创建语句如下:


--药品表注释
create table t_yp(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--种类
	v2 varchar(100),--时间
	v3 varchar(100),--数量
	v4 varchar(100),--价格
	v5 varchar(100),--成本
	v6 varchar(100)--库存
);

组织机构表创建语句如下:


--组织机构表注释
create table t_zzjg(
	id int identity(1,1) primary key not null,--主键
	content 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_cl")
public class Cl {
//主键
@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 v1;
//规格
private String v2;
//数量
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

池塘概况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_ctgk")
public class Ctgk {
//主键
@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 v1;
//塘租
private String v2;
//位置
private String v3;
//面积
private String v4;
//规格:长度/宽度/深度
private String v5;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}

池塘清理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_ctql")
public class Ctql {
//主键
@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 v1;
//时间
private String v2;
//药物
private String v3;
//用量
private String v4;
//用法
private String v5;
//成本
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

放养模式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_fyms")
public class Fyms {
//主键
@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 v1;
//种类
private String v2;
//来源:外购/自培
private String v3;
//时间
private String v4;
//规格:体重/体长
private String v5;
//数量
private String v6;
//重量
private String v7;
//药浴:药物种类用量时长
private String v8;
//费用
private String v9;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
}

普通管理员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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}

日常管理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_rcgl")
public class Rcgl {
//主键
@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 v1;
//巡塘记录:早/中/晚
private String v2;
//浮头泛池
private String v3;
// 死鱼数量
private String v4;
//开增氧机:时间/时长
private String v5;
//电费成本
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

饲料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_sl")
public class Sl {
//主键
@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 v1;
//价格
private String v2;
//时间
private String v3;
//数量
private String v4;
//成本
private String v5;
//库存
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

饲料投喂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_sltw")
public class Sltw {
//主键
@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 v1;
//饵料来源:生产厂家
private String v2;
//饲料价格:元/公斤
private String v3;
//饵料粒径:mm
private String v4;
//饵料组分
private String v5;
//营养成分
private String v6;
//池塘水温
private String v7;
//投喂次数
private String v8;
//投喂时间:早上/上午/中午/下午
private String v9;
//日投喂量
private String v10;
//摄食状态:旺盛/正常/较差/不吃
private String v11;
//饲料成本
private String v12;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
public String getV11() {return v11;}
public void setV11(String v11) {this.v11 = v11;}
public String getV12() {return v12;}
public void setV12(String v12) {this.v12 = v12;}
}

生长测定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_szcd")
public class Szcd {
//主键
@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 v1;
//时间
private String v2;
//种类
private String v3;
//结果:体长/体重
private String v4;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
}

水质管理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_szgl")
public class Szgl {
//主键
@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 v1;
//水质测定:透明度、水色、溶解氧、pH值、氨氮、亚硝酸盐
private String v2;
//药物调节:时间、药物种类、使用数量
private String v3;
//换水补水:时间、数量
private String v4;
//换水成本
private String v5;
//开增氧机:时间、时长
private String v6;
//用电成本
private String v7;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

销售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_xs")
public class Xs {
//主键
@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 v1;
//时间
private String v2;
//规格
private String v3;
//价格
private String v4;
//数量
private String v5;
//客户
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

效益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_xy")
public class Xy {
//主键
@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 v1;
//存量价值
private String v2;
//总支出
private String v3;
//总利润
private String v4;
//利润率
private String v5;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}

鱼病预防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_ybyf")
public class Ybyf {
//主键
@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 v1;
//时间
private String v2;
//药物
private String v3;
//用量
private String v4;
//用法
private String v5;
//费用
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

鱼病治疗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_ybzl")
public class Ybzl {
//主键
@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 v1;
//发病时间
private String v2;
//发病种类
private String v3;
//疾病种类
private String v4;
//病症表现
private String v5;
//死鱼数量:数量、规格、重量
private String v6;
//死鱼损失
private String v7;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

渔场简介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_ycjj")
public class Ycjj {
//主键
@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 content;
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_yp")
public class Yp {
//主键
@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 v1;
//时间
private String v2;
//数量
private String v3;
//价格
private String v4;
//成本
private String v5;
//库存
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

组织机构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_zzjg")
public class Zzjg {
//主键
@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 content;
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

现代渔场管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

存量javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//存量
public class Cl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//种类
private String v1;
//规格
private String v2;
//数量
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

池塘概况javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//池塘概况
public class Ctgk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String v1;
//塘租
private String v2;
//位置
private String v3;
//面积
private String v4;
//规格:长度/宽度/深度
private String v5;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}

池塘清理javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//池塘清理
public class Ctql  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//池塘编号
private String v1;
//时间
private String v2;
//药物
private String v3;
//用量
private String v4;
//用法
private String v5;
//成本
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

放养模式javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//放养模式
public class Fyms  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//池塘编号
private String v1;
//种类
private String v2;
//来源:外购/自培
private String v3;
//时间
private String v4;
//规格:体重/体长
private String v5;
//数量
private String v6;
//重量
private String v7;
//药浴:药物种类用量时长
private String v8;
//费用
private String v9;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
}

普通管理员javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//普通管理员
public class Ptadmin  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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}

日常管理javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//日常管理
public class Rcgl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//池塘编号
private String v1;
//巡塘记录:早/中/晚
private String v2;
//浮头泛池
private String v3;
// 死鱼数量
private String v4;
//开增氧机:时间/时长
private String v5;
//电费成本
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

饲料javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//饲料
public class Sl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//种类
private String v1;
//价格
private String v2;
//时间
private String v3;
//数量
private String v4;
//成本
private String v5;
//库存
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

饲料投喂javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//饲料投喂
public class Sltw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//池塘编号
private String v1;
//饵料来源:生产厂家
private String v2;
//饲料价格:元/公斤
private String v3;
//饵料粒径:mm
private String v4;
//饵料组分
private String v5;
//营养成分
private String v6;
//池塘水温
private String v7;
//投喂次数
private String v8;
//投喂时间:早上/上午/中午/下午
private String v9;
//日投喂量
private String v10;
//摄食状态:旺盛/正常/较差/不吃
private String v11;
//饲料成本
private String v12;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
public String getV11() {return v11;}
public void setV11(String v11) {this.v11 = v11;}
public String getV12() {return v12;}
public void setV12(String v12) {this.v12 = v12;}
}

生长测定javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//生长测定
public class Szcd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//池塘编号
private String v1;
//时间
private String v2;
//种类
private String v3;
//结果:体长/体重
private String v4;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
}

水质管理javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//水质管理
public class Szgl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//池塘编号
private String v1;
//水质测定:透明度、水色、溶解氧、pH值、氨氮、亚硝酸盐
private String v2;
//药物调节:时间、药物种类、使用数量
private String v3;
//换水补水:时间、数量
private String v4;
//换水成本
private String v5;
//开增氧机:时间、时长
private String v6;
//用电成本
private String v7;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

销售javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//销售
public class Xs  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//种类
private String v1;
//时间
private String v2;
//规格
private String v3;
//价格
private String v4;
//数量
private String v5;
//客户
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

效益javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//效益
public class Xy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//总销售额
private String v1;
//存量价值
private String v2;
//总支出
private String v3;
//总利润
private String v4;
//利润率
private String v5;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}

鱼病预防javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//鱼病预防
public class Ybyf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//池塘编号
private String v1;
//时间
private String v2;
//药物
private String v3;
//用量
private String v4;
//用法
private String v5;
//费用
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

鱼病治疗javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//鱼病治疗
public class Ybzl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//池塘编号
private String v1;
//发病时间
private String v2;
//发病种类
private String v3;
//疾病种类
private String v4;
//病症表现
private String v5;
//死鱼数量:数量、规格、重量
private String v6;
//死鱼损失
private String v7;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

渔场简介javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//渔场简介
public class Ycjj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//渔场简介
private String content;
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 Yp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//种类
private String v1;
//时间
private String v2;
//数量
private String v3;
//价格
private String v4;
//成本
private String v5;
//库存
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

组织机构javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//组织机构
public class Zzjg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//组织机构
private String content;
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

源代码下载点这里

评论