更多成品,定做java毕业设计,请咨询管理员qq:2812491287

排污管理系统

排污管理系统登录注册界面

排污管理系统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_gb(
	id int primary key auto_increment comment '主键',
	v1 int comment '一氧化碳',
	v2 int comment '二氧化碳',
	v3 int comment '二氧化硫',
	v4 int comment 'pm2.5'
) comment '污染物国标';

排放记录表创建语句如下:


create table t_pf(
	id int primary key auto_increment comment '主键',
	qyName varchar(100) comment '企业',
	showDate datetime comment '记录日期',
	v1num int comment '一氧化碳',
	v2num int comment '二氧化碳',
	v3num int comment '二氧化硫',
	v4num int comment 'pm2.5'
) comment '排放记录';

企业表创建语句如下:


create table t_qy(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	qyName varchar(100) comment '企业名称',
	fzr varchar(100) comment '负责人',
	phone varchar(100) comment '联系电话',
	address varchar(100) comment '地址'
) comment '企业';

政府部门表创建语句如下:


create table t_zf(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	zfName varchar(100) comment '部门名称',
	fzr varchar(100) comment '负责人',
	phone varchar(100) comment '联系电话',
	address 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_gb(
	id integer,
	v1 int,
	v2 int,
	v3 int,
	v4 int
);
--污染物国标字段加注释
comment on column t_gb.id is '主键';
comment on column t_gb.v1 is '一氧化碳';
comment on column t_gb.v2 is '二氧化碳';
comment on column t_gb.v3 is '二氧化硫';
comment on column t_gb.v4 is 'pm2.5';
--污染物国标表加注释
comment on table t_gb is '污染物国标';

排放记录表创建语句如下:


create table t_pf(
	id integer,
	qyName varchar(100),
	showDate datetime,
	v1num int,
	v2num int,
	v3num int,
	v4num int
);
--排放记录字段加注释
comment on column t_pf.id is '主键';
comment on column t_pf.qyName is '企业';
comment on column t_pf.showDate is '记录日期';
comment on column t_pf.v1num is '一氧化碳';
comment on column t_pf.v2num is '二氧化碳';
comment on column t_pf.v3num is '二氧化硫';
comment on column t_pf.v4num is 'pm2.5';
--排放记录表加注释
comment on table t_pf is '排放记录';

企业表创建语句如下:


create table t_qy(
	id integer,
	username varchar(100),
	password varchar(100),
	qyName varchar(100),
	fzr varchar(100),
	phone varchar(100),
	address varchar(100)
);
--企业字段加注释
comment on column t_qy.id is '主键';
comment on column t_qy.username is '账号';
comment on column t_qy.password is '密码';
comment on column t_qy.qyName is '企业名称';
comment on column t_qy.fzr is '负责人';
comment on column t_qy.phone is '联系电话';
comment on column t_qy.address is '地址';
--企业表加注释
comment on table t_qy is '企业';

政府部门表创建语句如下:


create table t_zf(
	id integer,
	username varchar(100),
	password varchar(100),
	zfName varchar(100),
	fzr varchar(100),
	phone varchar(100),
	address varchar(100)
);
--政府部门字段加注释
comment on column t_zf.id is '主键';
comment on column t_zf.username is '账号';
comment on column t_zf.password is '密码';
comment on column t_zf.zfName is '部门名称';
comment on column t_zf.fzr is '负责人';
comment on column t_zf.phone is '联系电话';
comment on column t_zf.address is '地址';
--政府部门表加注释
comment on table t_zf is '政府部门';

oracle特有,对应序列如下:


create sequence s_t_gb;
create sequence s_t_pf;
create sequence s_t_qy;
create sequence s_t_zf;

排污管理系统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_gb(
	id int identity(1,1) primary key not null,--主键
	v1 int,--一氧化碳
	v2 int,--二氧化碳
	v3 int,--二氧化硫
	v4 int--pm2.5
);

排放记录表创建语句如下:


--排放记录表注释
create table t_pf(
	id int identity(1,1) primary key not null,--主键
	qyName varchar(100),--企业
	showDate datetime,--记录日期
	v1num int,--一氧化碳
	v2num int,--二氧化碳
	v3num int,--二氧化硫
	v4num int--pm2.5
);

企业表创建语句如下:


--企业表注释
create table t_qy(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	qyName varchar(100),--企业名称
	fzr varchar(100),--负责人
	phone varchar(100),--联系电话
	address varchar(100)--地址
);

政府部门表创建语句如下:


--政府部门表注释
create table t_zf(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	zfName varchar(100),--部门名称
	fzr varchar(100),--负责人
	phone varchar(100),--联系电话
	address 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_gb")
public class Gb {
//主键
@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 v1;
//二氧化碳
private Integer v2;
//二氧化硫
private Integer v3;
//pm2.5
private Integer v4;
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer 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_pf")
public class Pf {
//主键
@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 Date showDate;
//一氧化碳
private Integer v1num;
//二氧化碳
private Integer v2num;
//二氧化硫
private Integer v3num;
//pm2.5
private Integer v4num;
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getV1num() {return v1num;}
public void setV1num(Integer v1num) {this.v1num = v1num;}
public Integer getV2num() {return v2num;}
public void setV2num(Integer v2num) {this.v2num = v2num;}
public Integer getV3num() {return v3num;}
public void setV3num(Integer v3num) {this.v3num = v3num;}
public Integer getV4num() {return v4num;}
public void setV4num(Integer v4num) {this.v4num = v4num;}
}

企业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_qy")
public class Qy {
//主键
@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 qyName;
//负责人
private String fzr;
//联系电话
private String phone;
//地址
private String address;
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 getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

政府部门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_zf")
public class Zf {
//主键
@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 zfName;
//负责人
private String fzr;
//联系电话
private String phone;
//地址
private String address;
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 getZfName() {return zfName;}
public void setZfName(String zfName) {this.zfName = zfName;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

排污管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

污染物国标javaBean创建语句如下:


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

//污染物国标
public class Gb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//一氧化碳
private Integer v1;
//二氧化碳
private Integer v2;
//二氧化硫
private Integer v3;
//pm2.5
private Integer v4;
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
}

排放记录javaBean创建语句如下:


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

//排放记录
public class Pf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//企业
private String qyName;
//记录日期
private Date showDate;
//一氧化碳
private Integer v1num;
//二氧化碳
private Integer v2num;
//二氧化硫
private Integer v3num;
//pm2.5
private Integer v4num;
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getV1num() {return v1num;}
public void setV1num(Integer v1num) {this.v1num = v1num;}
public Integer getV2num() {return v2num;}
public void setV2num(Integer v2num) {this.v2num = v2num;}
public Integer getV3num() {return v3num;}
public void setV3num(Integer v3num) {this.v3num = v3num;}
public Integer getV4num() {return v4num;}
public void setV4num(Integer v4num) {this.v4num = v4num;}
}

企业javaBean创建语句如下:


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

//企业
public class Qy  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 qyName;
//负责人
private String fzr;
//联系电话
private String phone;
//地址
private String address;
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 getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

政府部门javaBean创建语句如下:


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

//政府部门
public class Zf  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 zfName;
//负责人
private String fzr;
//联系电话
private String phone;
//地址
private String address;
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 getZfName() {return zfName;}
public void setZfName(String zfName) {this.zfName = zfName;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

评论