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

基于jsp的工地员工及建材管理系统

基于jsp的工地员工及建材管理系统登录注册界面

基于jsp的工地员工及建材管理系统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_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	gh varchar(100) comment '工号',
	gz varchar(100) comment '工种',
	sex varchar(100) comment '性别'
) comment '员工';

工作任务表创建语句如下:


create table t_gongzuo(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	title varchar(100) comment '任务名称',
	content varchar(100) comment '内容',
	insertDate datetime comment '任务发起日期'
) comment '工作任务';

工作任务反馈表创建语句如下:


create table t_gongzuolist(
	id int primary key auto_increment comment '主键',
	gongzuoId int comment '工作',
	customerId int comment '员工',
	content varchar(100) comment '完成内容',
	insertDate datetime comment '反馈日期',
	ps varchar(100) comment '批示',
	status varchar(100) comment '状态'
) comment '工作任务反馈';

建材表创建语句如下:


create table t_jiancai(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '名称',
	lb varchar(100) comment '类别',
	sl int comment '数量',
	jg int 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 '姓名',
	bh varchar(100) comment '编号',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别'
) comment '普通管理员';

签到表创建语句如下:


create table t_qiandao(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	insertDate datetime comment '日期'
) comment '签到';

基于jsp的工地员工及建材管理系统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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age varchar(100),
	gh varchar(100),
	gz varchar(100),
	sex varchar(100)
);
--员工字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.gh is '工号';
comment on column t_customer.gz is '工种';
comment on column t_customer.sex is '性别';
--员工表加注释
comment on table t_customer is '员工';

工作任务表创建语句如下:


create table t_gongzuo(
	id integer,
	customerId int,
	title varchar(100),
	content varchar(100),
	insertDate datetime
);
--工作任务字段加注释
comment on column t_gongzuo.id is '主键';
comment on column t_gongzuo.customerId is '员工';
comment on column t_gongzuo.title is '任务名称';
comment on column t_gongzuo.content is '内容';
comment on column t_gongzuo.insertDate is '任务发起日期';
--工作任务表加注释
comment on table t_gongzuo is '工作任务';

工作任务反馈表创建语句如下:


create table t_gongzuolist(
	id integer,
	gongzuoId int,
	customerId int,
	content varchar(100),
	insertDate datetime,
	ps varchar(100),
	status varchar(100)
);
--工作任务反馈字段加注释
comment on column t_gongzuolist.id is '主键';
comment on column t_gongzuolist.gongzuoId is '工作';
comment on column t_gongzuolist.customerId is '员工';
comment on column t_gongzuolist.content is '完成内容';
comment on column t_gongzuolist.insertDate is '反馈日期';
comment on column t_gongzuolist.ps is '批示';
comment on column t_gongzuolist.status is '状态';
--工作任务反馈表加注释
comment on table t_gongzuolist is '工作任务反馈';

建材表创建语句如下:


create table t_jiancai(
	id integer,
	title varchar(100),
	lb varchar(100),
	sl int,
	jg int
);
--建材字段加注释
comment on column t_jiancai.id is '主键';
comment on column t_jiancai.title is '名称';
comment on column t_jiancai.lb is '类别';
comment on column t_jiancai.sl is '数量';
comment on column t_jiancai.jg is '价格';
--建材表加注释
comment on table t_jiancai is '建材';

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


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

签到表创建语句如下:


create table t_qiandao(
	id integer,
	customerId int,
	insertDate datetime
);
--签到字段加注释
comment on column t_qiandao.id is '主键';
comment on column t_qiandao.customerId is '员工';
comment on column t_qiandao.insertDate is '日期';
--签到表加注释
comment on table t_qiandao is '签到';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_gongzuo;
create sequence s_t_gongzuolist;
create sequence s_t_jiancai;
create sequence s_t_ptadmin;
create sequence s_t_qiandao;

基于jsp的工地员工及建材管理系统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_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	gh varchar(100),--工号
	gz varchar(100),--工种
	sex varchar(100)--性别
);

工作任务表创建语句如下:


--工作任务表注释
create table t_gongzuo(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	title varchar(100),--任务名称
	content varchar(100),--内容
	insertDate datetime--任务发起日期
);

工作任务反馈表创建语句如下:


--工作任务反馈表注释
create table t_gongzuolist(
	id int identity(1,1) primary key not null,--主键
	gongzuoId int,--工作
	customerId int,--员工
	content varchar(100),--完成内容
	insertDate datetime,--反馈日期
	ps varchar(100),--批示
	status varchar(100)--状态
);

建材表创建语句如下:


--建材表注释
create table t_jiancai(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--名称
	lb varchar(100),--类别
	sl int,--数量
	jg int--价格
);

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


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

签到表创建语句如下:


--签到表注释
create table t_qiandao(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	insertDate datetime--日期
);

基于jsp的工地员工及建材管理系统登录后主页

基于jsp的工地员工及建材管理系统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_customer")
public class Customer {
//主键
@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 customerName;
//电话
private String phone;
//年龄
private String age;
//工号
private String gh;
//工种
private String gz;
//性别
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getGz() {return gz;}
public void setGz(String gz) {this.gz = gz;}
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_gongzuo")
public class Gongzuo {
//主键
@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 customerId;
//任务名称
private String title;
//内容
private String content;
//任务发起日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_gongzuolist")
public class Gongzuolist {
//主键
@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 gongzuoId;
//员工
private Integer customerId;
//完成内容
private String content;
//反馈日期
private Date insertDate;
//批示
private String ps;
//状态
private String status;
public Integer getGongzuoId() {return gongzuoId;}
public void setGongzuoId(Integer gongzuoId) {this.gongzuoId = gongzuoId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPs() {return ps;}
public void setPs(String ps) {this.ps = ps;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

建材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_jiancai")
public class Jiancai {
//主键
@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 lb;
//数量
private Integer sl;
//价格
private Integer jg;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
}

普通管理员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 bh;
//年龄
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 getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
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_qiandao")
public class Qiandao {
//主键
@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 customerId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

基于jsp的工地员工及建材管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

员工javaBean创建语句如下:


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

//员工
public class Customer  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 customerName;
//电话
private String phone;
//年龄
private String age;
//工号
private String gh;
//工种
private String gz;
//性别
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getGz() {return gz;}
public void setGz(String gz) {this.gz = gz;}
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 Gongzuo  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//任务名称
private String title;
//内容
private String content;
//任务发起日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Gongzuolist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//工作
private Integer gongzuoId;
//员工
private Integer customerId;
//完成内容
private String content;
//反馈日期
private Date insertDate;
//批示
private String ps;
//状态
private String status;
public Integer getGongzuoId() {return gongzuoId;}
public void setGongzuoId(Integer gongzuoId) {this.gongzuoId = gongzuoId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPs() {return ps;}
public void setPs(String ps) {this.ps = ps;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

建材javaBean创建语句如下:


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

//建材
public class Jiancai  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String title;
//类别
private String lb;
//数量
private Integer sl;
//价格
private Integer jg;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
}

普通管理员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 bh;
//年龄
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 getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
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 Qiandao  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

评论