私人鱼塘管理系统

大概就是分几块鱼塘,然后分别对几号鱼塘的管理,查询一些鱼塘的数据,对水产养殖的环境进行监控,像水温、pH值、溶氧量等数据的监控,
还有警报系统,像水温超过一定的值就报警,然后就是鱼塘里的鱼的种类的增删改查功能都要有。用户登录之类的 也有
这个   能显示出来就行,有数据看就行 
最好能和传感器之类的挂钩 
看着像是监控出来的也行 
可以搞个按钮
假装获取传感器数据 比如 按钮名字就叫 显示数据 点一下就显示数据库的值了  就ok了  
 
私人鱼塘管理系统登录注册界面

私人鱼塘管理系统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_jk(
	id int primary key auto_increment comment '主键',
	ytId int comment '鱼塘',
	types varchar(100) comment '监控分类',
	sz double comment '数值',
	insertDate datetime 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 '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别'
) comment '普通管理员';

鱼塘表创建语句如下:


create table t_yt(
	id int primary key auto_increment comment '主键',
	bh varchar(100) comment '编号',
	address varchar(100) comment '位置',
	dx varchar(100) comment '大小',
	pic varchar(100) comment '图片'
) comment '鱼塘';

鱼种类表创建语句如下:


create table t_zl(
	id int primary key auto_increment comment '主键',
	zlName varchar(100) comment '名称',
	pic 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_jk(
	id integer,
	ytId int,
	types varchar(100),
	sz double,
	insertDate datetime
);
--监控字段加注释
comment on column t_jk.id is '主键';
comment on column t_jk.ytId is '鱼塘';
comment on column t_jk.types is '监控分类';
comment on column t_jk.sz is '数值';
comment on column t_jk.insertDate is '日期';
--监控表加注释
comment on table t_jk is '监控';

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


create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex 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.phone is '电话';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';

鱼塘表创建语句如下:


create table t_yt(
	id integer,
	bh varchar(100),
	address varchar(100),
	dx varchar(100),
	pic varchar(100)
);
--鱼塘字段加注释
comment on column t_yt.id is '主键';
comment on column t_yt.bh is '编号';
comment on column t_yt.address is '位置';
comment on column t_yt.dx is '大小';
comment on column t_yt.pic is '图片';
--鱼塘表加注释
comment on table t_yt is '鱼塘';

鱼种类表创建语句如下:


create table t_zl(
	id integer,
	zlName varchar(100),
	pic varchar(100)
);
--鱼种类字段加注释
comment on column t_zl.id is '主键';
comment on column t_zl.zlName is '名称';
comment on column t_zl.pic is '图片';
--鱼种类表加注释
comment on table t_zl is '鱼种类';

oracle特有,对应序列如下:


create sequence s_t_jk;
create sequence s_t_ptadmin;
create sequence s_t_yt;
create sequence s_t_zl;

私人鱼塘管理系统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_jk(
	id int identity(1,1) primary key not null,--主键
	ytId int,--鱼塘
	types varchar(100),--监控分类
	sz double,--数值
	insertDate datetime--日期
);

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


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

鱼塘表创建语句如下:


--鱼塘表注释
create table t_yt(
	id int identity(1,1) primary key not null,--主键
	bh varchar(100),--编号
	address varchar(100),--位置
	dx varchar(100),--大小
	pic varchar(100)--图片
);

鱼种类表创建语句如下:


--鱼种类表注释
create table t_zl(
	id int identity(1,1) primary key not null,--主键
	zlName varchar(100),--名称
	pic 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_jk")
public class Jk {
//主键
@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 ytId;
//监控分类
private String types;
//数值
private Double sz;
//日期
private Date insertDate;
public Integer getYtId() {return ytId;}
public void setYtId(Integer ytId) {this.ytId = ytId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Double getSz() {return sz;}
public void setSz(Double sz) {this.sz = sz;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

普通管理员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 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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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_yt")
public class Yt {
//主键
@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 bh;
//位置
private String address;
//大小
private String dx;
//图片
private String pic;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getDx() {return dx;}
public void setDx(String dx) {this.dx = dx;}
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_zl")
public class Zl {
//主键
@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 zlName;
//图片
private String pic;
public String getZlName() {return zlName;}
public void setZlName(String zlName) {this.zlName = zlName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

私人鱼塘管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

监控javaBean创建语句如下:


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

//监控
public class Jk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//鱼塘
private Integer ytId;
//监控分类
private String types;
//数值
private Double sz;
//日期
private Date insertDate;
public Integer getYtId() {return ytId;}
public void setYtId(Integer ytId) {this.ytId = ytId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Double getSz() {return sz;}
public void setSz(Double sz) {this.sz = sz;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

普通管理员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 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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 Yt  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String bh;
//位置
private String address;
//大小
private String dx;
//图片
private String pic;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getDx() {return dx;}
public void setDx(String dx) {this.dx = dx;}
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 Zl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String zlName;
//图片
private String pic;
public String getZlName() {return zlName;}
public void setZlName(String zlName) {this.zlName = zlName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

源代码下载点这里

评论