基于Java软件开发平台设计与实现温湿度检测系统

基于Java软件开发平台设计与实现温湿度检测系统,具有实时温湿度显示、历史温湿度曲线、历史温度保存统计。具有一定的数据管理功能。 基于Java软件开发平台设计与实现温湿度检测系统登录注册界面

基于Java软件开发平台设计与实现温湿度检测系统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_wsd(
	id int primary key auto_increment comment '主键',
	wd int comment '温度',
	sd int comment '湿度',
	insertDate datetime comment '日期'
) comment '温湿度';

预警阈值表创建语句如下:


create table t_yjfz(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '预警名称',
	fz int comment '阈值',
	types varchar(100) comment '向上、向下预警'
) comment '预警阈值';

预警信息表创建语句如下:


create table t_yjxx(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '预警名称',
	types varchar(100) comment '类型',
	insertDate datetime comment '日期'
) comment '预警信息';

基于Java软件开发平台设计与实现温湿度检测系统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_wsd(
	id integer,
	wd int,
	sd int,
	insertDate datetime
);
--温湿度字段加注释
comment on column t_wsd.id is '主键';
comment on column t_wsd.wd is '温度';
comment on column t_wsd.sd is '湿度';
comment on column t_wsd.insertDate is '日期';
--温湿度表加注释
comment on table t_wsd is '温湿度';

预警阈值表创建语句如下:


create table t_yjfz(
	id integer,
	title varchar(100),
	fz int,
	types varchar(100)
);
--预警阈值字段加注释
comment on column t_yjfz.id is '主键';
comment on column t_yjfz.title is '预警名称';
comment on column t_yjfz.fz is '阈值';
comment on column t_yjfz.types is '向上、向下预警';
--预警阈值表加注释
comment on table t_yjfz is '预警阈值';

预警信息表创建语句如下:


create table t_yjxx(
	id integer,
	title varchar(100),
	types varchar(100),
	insertDate datetime
);
--预警信息字段加注释
comment on column t_yjxx.id is '主键';
comment on column t_yjxx.title is '预警名称';
comment on column t_yjxx.types is '类型';
comment on column t_yjxx.insertDate is '日期';
--预警信息表加注释
comment on table t_yjxx is '预警信息';

oracle特有,对应序列如下:


create sequence s_t_wsd;
create sequence s_t_yjfz;
create sequence s_t_yjxx;

基于Java软件开发平台设计与实现温湿度检测系统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_wsd(
	id int identity(1,1) primary key not null,--主键
	wd int,--温度
	sd int,--湿度
	insertDate datetime--日期
);

预警阈值表创建语句如下:


--预警阈值表注释
create table t_yjfz(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--预警名称
	fz int,--阈值
	types varchar(100)--向上、向下预警
);

预警信息表创建语句如下:


--预警信息表注释
create table t_yjxx(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--预警名称
	types varchar(100),--类型
	insertDate datetime--日期
);

基于Java软件开发平台设计与实现温湿度检测系统登录后主页

基于Java软件开发平台设计与实现温湿度检测系统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_wsd")
public class Wsd {
//主键
@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 wd;
//湿度
private Integer sd;
//日期
private Date insertDate;
public Integer getWd() {return wd;}
public void setWd(Integer wd) {this.wd = wd;}
public Integer getSd() {return sd;}
public void setSd(Integer sd) {this.sd = sd;}
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_yjfz")
public class Yjfz {
//主键
@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 Integer fz;
//向上、向下预警
private String types;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFz() {return fz;}
public void setFz(Integer fz) {this.fz = fz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}

预警信息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_yjxx")
public class Yjxx {
//主键
@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 types;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

基于Java软件开发平台设计与实现温湿度检测系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

温湿度javaBean创建语句如下:


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

//温湿度
public class Wsd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//温度
private Integer wd;
//湿度
private Integer sd;
//日期
private Date insertDate;
public Integer getWd() {return wd;}
public void setWd(Integer wd) {this.wd = wd;}
public Integer getSd() {return sd;}
public void setSd(Integer sd) {this.sd = sd;}
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 Yjfz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//预警名称
private String title;
//阈值
private Integer fz;
//向上、向下预警
private String types;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFz() {return fz;}
public void setFz(Integer fz) {this.fz = fz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}

预警信息javaBean创建语句如下:


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

//预警信息
public class Yjxx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//预警名称
private String title;
//类型
private String types;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

源代码下载点这里

评论