基于大数据的智慧能源管家

基于大数据的智慧能源管家登录注册界面

基于大数据的智慧能源管家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_dates(
	id int primary key auto_increment comment '主键',
	dates varchar(100) comment ''
) comment '';

企业能耗表创建语句如下:


create table t_qynh(
	id int primary key auto_increment comment '主键',
	qyxxId int comment '企业',
	ydl int comment '用电量',
	showDate datetime comment '日期'
) comment '企业能耗';

企业信息表创建语句如下:


create table t_qyxx(
	id int primary key auto_increment comment '主键',
	qyName varchar(100) comment '企业名称',
	qyzcdm varchar(100) comment '企业注册代码',
	address varchar(100) comment '地址',
	fr varchar(100) comment '法人',
	lxdh varchar(100) comment '联系电话',
	yyzz varchar(100) comment '营业执照拍照',
	types varchar(100) comment '类型',
	qk 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_dates(
	id integer,
	dates varchar(100)
);
--字段加注释
comment on column t_dates.id is '主键';
comment on column t_dates.dates is '';
--表加注释
comment on table t_dates is '';

企业能耗表创建语句如下:


create table t_qynh(
	id integer,
	qyxxId int,
	ydl int,
	showDate datetime
);
--企业能耗字段加注释
comment on column t_qynh.id is '主键';
comment on column t_qynh.qyxxId is '企业';
comment on column t_qynh.ydl is '用电量';
comment on column t_qynh.showDate is '日期';
--企业能耗表加注释
comment on table t_qynh is '企业能耗';

企业信息表创建语句如下:


create table t_qyxx(
	id integer,
	qyName varchar(100),
	qyzcdm varchar(100),
	address varchar(100),
	fr varchar(100),
	lxdh varchar(100),
	yyzz varchar(100),
	types varchar(100),
	qk varchar(100)
);
--企业信息字段加注释
comment on column t_qyxx.id is '主键';
comment on column t_qyxx.qyName is '企业名称';
comment on column t_qyxx.qyzcdm is '企业注册代码';
comment on column t_qyxx.address is '地址';
comment on column t_qyxx.fr is '法人';
comment on column t_qyxx.lxdh is '联系电话';
comment on column t_qyxx.yyzz is '营业执照拍照';
comment on column t_qyxx.types is '类型';
comment on column t_qyxx.qk is '区块';
--企业信息表加注释
comment on table t_qyxx is '企业信息';

oracle特有,对应序列如下:


create sequence s_t_dates;
create sequence s_t_qynh;
create sequence s_t_qyxx;

基于大数据的智慧能源管家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_dates(
	id int identity(1,1) primary key not null,--主键
	dates varchar(100)--
);

企业能耗表创建语句如下:


--企业能耗表注释
create table t_qynh(
	id int identity(1,1) primary key not null,--主键
	qyxxId int,--企业
	ydl int,--用电量
	showDate datetime--日期
);

企业信息表创建语句如下:


--企业信息表注释
create table t_qyxx(
	id int identity(1,1) primary key not null,--主键
	qyName varchar(100),--企业名称
	qyzcdm varchar(100),--企业注册代码
	address varchar(100),--地址
	fr varchar(100),--法人
	lxdh varchar(100),--联系电话
	yyzz varchar(100),--营业执照拍照
	types varchar(100),--类型
	qk 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_dates")
public class Dates {
//主键
@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 dates;
public String getDates() {return dates;}
public void setDates(String dates) {this.dates = dates;}
}

企业能耗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_qynh")
public class Qynh {
//主键
@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 qyxxId;
//用电量
private Integer ydl;
//日期
private Date showDate;
public Integer getQyxxId() {return qyxxId;}
public void setQyxxId(Integer qyxxId) {this.qyxxId = qyxxId;}
public Integer getYdl() {return ydl;}
public void setYdl(Integer ydl) {this.ydl = ydl;}
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_qyxx")
public class Qyxx {
//主键
@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 qyName;
//企业注册代码
private String qyzcdm;
//地址
private String address;
//法人
private String fr;
//联系电话
private String lxdh;
//营业执照拍照
private String yyzz;
//类型
private String types;
//区块
private String qk;
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getQyzcdm() {return qyzcdm;}
public void setQyzcdm(String qyzcdm) {this.qyzcdm = qyzcdm;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getFr() {return fr;}
public void setFr(String fr) {this.fr = fr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getYyzz() {return yyzz;}
public void setYyzz(String yyzz) {this.yyzz = yyzz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getQk() {return qk;}
public void setQk(String qk) {this.qk = qk;}
}

基于大数据的智慧能源管家spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

javaBean创建语句如下:


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

//
public class Dates  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String dates;
public String getDates() {return dates;}
public void setDates(String dates) {this.dates = dates;}
}

企业能耗javaBean创建语句如下:


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

//企业能耗
public class Qynh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//企业
private Integer qyxxId;
//用电量
private Integer ydl;
//日期
private Date showDate;
public Integer getQyxxId() {return qyxxId;}
public void setQyxxId(Integer qyxxId) {this.qyxxId = qyxxId;}
public Integer getYdl() {return ydl;}
public void setYdl(Integer ydl) {this.ydl = ydl;}
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 Qyxx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//企业名称
private String qyName;
//企业注册代码
private String qyzcdm;
//地址
private String address;
//法人
private String fr;
//联系电话
private String lxdh;
//营业执照拍照
private String yyzz;
//类型
private String types;
//区块
private String qk;
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getQyzcdm() {return qyzcdm;}
public void setQyzcdm(String qyzcdm) {this.qyzcdm = qyzcdm;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getFr() {return fr;}
public void setFr(String fr) {this.fr = fr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getYyzz() {return yyzz;}
public void setYyzz(String yyzz) {this.yyzz = yyzz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getQk() {return qk;}
public void setQk(String qk) {this.qk = qk;}
}

源代码下载点这里

评论