基于JSP装饰施工管理系统

装饰施工管理系统

项目经理登陆  功能

项目信息管理:项目基本信息管理,有合同管理。
材料管理
参与人员管理:要有员工图片上传
费用管理:要有费用产生日期,费用类型,产生者
施工管理:


投诉管理
项目结算:将项目产生的各种信息能在页面显示,能导出Excel。

 


客户登陆

项目基本信息管理
施工凭证查看
参与人员信息查看
材料信息管理
费用检查
施工过程检查
项目投诉
申请售后
项目评价:项目经理评价、员工评价、项目评价

 

员工登陆
项目信息查看
施工信息:主要知道自己要做什么
材料使用信息管理

 


超级管理员登陆

人员管理:项目经理、员工的增删改
项目管理:以项目为单位,点击查看项目有项目各种信息、外加项目维护管理

基于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_cl(
	id int primary key auto_increment comment '主键',
	xmId int comment '项目',
	name varchar(100) comment '材料名称',
	sl varchar(100) comment '数量',
	pic varchar(100) comment '拍照',
	zj int comment '总价'
) comment '材料';

客户表创建语句如下:


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	phone varchar(100) comment '联系方式',
	sex varchar(100) comment '性别',
	yx varchar(100) comment '邮箱'
) comment '客户';

参与人员表创建语句如下:


create table t_cyry(
	id int primary key auto_increment comment '主键',
	xmId int comment '项目',
	name varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	pic varchar(100) comment '头像',
	sex varchar(100) comment '性别',
	idcard varchar(100) comment '身份证',
	address varchar(100) comment '住址'
) comment '参与人员';

费用表创建语句如下:


create table t_fy(
	id int primary key auto_increment comment '主键',
	xmId int comment '项目',
	name varchar(100) comment '费用名称',
	sl varchar(100) comment '费用类型',
	pic varchar(100) comment '生产者',
	showDate datetime comment '费用日期',
	zj int comment '金额'
) comment '费用';

施工记录表创建语句如下:


create table t_sgjl(
	id int primary key auto_increment comment '主键',
	xmId int comment '项目',
	title varchar(100) comment '记录名称',
	content varchar(100) comment '详细内容',
	fzr varchar(100) comment '负责人',
	lxdh varchar(100) comment '联系电话',
	showDate datetime comment '日期'
) comment '施工记录';

项目表创建语句如下:


create table t_xm(
	id int primary key auto_increment comment '主键',
	xmbh varchar(100) comment '项目编号',
	ygId int comment '项目经理',
	customerId int comment '客户',
	xmName varchar(100) comment '项目名称',
	pic varchar(100) comment '合同照片',
	v1 varchar(100) comment '地址',
	v2 datetime comment '开工日期',
	v3 datetime comment '预计结束日期',
	pj1 varchar(100) comment '项目经理评价',
	pj2 varchar(100) comment '项目评价',
	pj3 varchar(100) comment '员工评价',
	status varchar(100) comment '状态'
) comment '项目';

项目售后表创建语句如下:


create table t_xmsh(
	id int primary key auto_increment comment '主键',
	xmId int comment '项目',
	content varchar(100) comment '售后说明',
	lxdh varchar(100) comment '联系电话',
	status varchar(100) comment '状态'
) comment '项目售后';

项目投诉表创建语句如下:


create table t_xmts(
	id int primary key auto_increment comment '主键',
	xmId int comment '项目',
	title varchar(100) comment '标题',
	content varchar(100) comment '投诉内容',
	lxdh varchar(100) comment '联系电话',
	status varchar(100) comment '状态'
) comment '项目投诉';

员工表创建语句如下:


create table t_yg(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ygName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	phone varchar(100) comment '电话',
	sex varchar(100) comment '性别',
	pic varchar(100) comment '图片',
	xmjl varchar(100) 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_cl(
	id integer,
	xmId int,
	name varchar(100),
	sl varchar(100),
	pic varchar(100),
	zj int
);
--材料字段加注释
comment on column t_cl.id is '主键';
comment on column t_cl.xmId is '项目';
comment on column t_cl.name is '材料名称';
comment on column t_cl.sl is '数量';
comment on column t_cl.pic is '拍照';
comment on column t_cl.zj is '总价';
--材料表加注释
comment on table t_cl is '材料';

客户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age varchar(100),
	phone varchar(100),
	sex varchar(100),
	yx 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.age is '年龄';
comment on column t_customer.phone is '联系方式';
comment on column t_customer.sex is '性别';
comment on column t_customer.yx is '邮箱';
--客户表加注释
comment on table t_customer is '客户';

参与人员表创建语句如下:


create table t_cyry(
	id integer,
	xmId int,
	name varchar(100),
	age varchar(100),
	pic varchar(100),
	sex varchar(100),
	idcard varchar(100),
	address varchar(100)
);
--参与人员字段加注释
comment on column t_cyry.id is '主键';
comment on column t_cyry.xmId is '项目';
comment on column t_cyry.name is '姓名';
comment on column t_cyry.age is '年龄';
comment on column t_cyry.pic is '头像';
comment on column t_cyry.sex is '性别';
comment on column t_cyry.idcard is '身份证';
comment on column t_cyry.address is '住址';
--参与人员表加注释
comment on table t_cyry is '参与人员';

费用表创建语句如下:


create table t_fy(
	id integer,
	xmId int,
	name varchar(100),
	sl varchar(100),
	pic varchar(100),
	showDate datetime,
	zj int
);
--费用字段加注释
comment on column t_fy.id is '主键';
comment on column t_fy.xmId is '项目';
comment on column t_fy.name is '费用名称';
comment on column t_fy.sl is '费用类型';
comment on column t_fy.pic is '生产者';
comment on column t_fy.showDate is '费用日期';
comment on column t_fy.zj is '金额';
--费用表加注释
comment on table t_fy is '费用';

施工记录表创建语句如下:


create table t_sgjl(
	id integer,
	xmId int,
	title varchar(100),
	content varchar(100),
	fzr varchar(100),
	lxdh varchar(100),
	showDate datetime
);
--施工记录字段加注释
comment on column t_sgjl.id is '主键';
comment on column t_sgjl.xmId is '项目';
comment on column t_sgjl.title is '记录名称';
comment on column t_sgjl.content is '详细内容';
comment on column t_sgjl.fzr is '负责人';
comment on column t_sgjl.lxdh is '联系电话';
comment on column t_sgjl.showDate is '日期';
--施工记录表加注释
comment on table t_sgjl is '施工记录';

项目表创建语句如下:


create table t_xm(
	id integer,
	xmbh varchar(100),
	ygId int,
	customerId int,
	xmName varchar(100),
	pic varchar(100),
	v1 varchar(100),
	v2 datetime,
	v3 datetime,
	pj1 varchar(100),
	pj2 varchar(100),
	pj3 varchar(100),
	status varchar(100)
);
--项目字段加注释
comment on column t_xm.id is '主键';
comment on column t_xm.xmbh is '项目编号';
comment on column t_xm.ygId is '项目经理';
comment on column t_xm.customerId is '客户';
comment on column t_xm.xmName is '项目名称';
comment on column t_xm.pic is '合同照片';
comment on column t_xm.v1 is '地址';
comment on column t_xm.v2 is '开工日期';
comment on column t_xm.v3 is '预计结束日期';
comment on column t_xm.pj1 is '项目经理评价';
comment on column t_xm.pj2 is '项目评价';
comment on column t_xm.pj3 is '员工评价';
comment on column t_xm.status is '状态';
--项目表加注释
comment on table t_xm is '项目';

项目售后表创建语句如下:


create table t_xmsh(
	id integer,
	xmId int,
	content varchar(100),
	lxdh varchar(100),
	status varchar(100)
);
--项目售后字段加注释
comment on column t_xmsh.id is '主键';
comment on column t_xmsh.xmId is '项目';
comment on column t_xmsh.content is '售后说明';
comment on column t_xmsh.lxdh is '联系电话';
comment on column t_xmsh.status is '状态';
--项目售后表加注释
comment on table t_xmsh is '项目售后';

项目投诉表创建语句如下:


create table t_xmts(
	id integer,
	xmId int,
	title varchar(100),
	content varchar(100),
	lxdh varchar(100),
	status varchar(100)
);
--项目投诉字段加注释
comment on column t_xmts.id is '主键';
comment on column t_xmts.xmId is '项目';
comment on column t_xmts.title is '标题';
comment on column t_xmts.content is '投诉内容';
comment on column t_xmts.lxdh is '联系电话';
comment on column t_xmts.status is '状态';
--项目投诉表加注释
comment on table t_xmts is '项目投诉';

员工表创建语句如下:


create table t_yg(
	id integer,
	username varchar(100),
	password varchar(100),
	ygName varchar(100),
	age varchar(100),
	phone varchar(100),
	sex varchar(100),
	pic varchar(100),
	xmjl varchar(100)
);
--员工字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.username is '账号';
comment on column t_yg.password is '密码';
comment on column t_yg.ygName is '姓名';
comment on column t_yg.age is '年龄';
comment on column t_yg.phone is '电话';
comment on column t_yg.sex is '性别';
comment on column t_yg.pic is '图片';
comment on column t_yg.xmjl is '项目经理';
--员工表加注释
comment on table t_yg is '员工';

oracle特有,对应序列如下:


create sequence s_t_cl;
create sequence s_t_customer;
create sequence s_t_cyry;
create sequence s_t_fy;
create sequence s_t_sgjl;
create sequence s_t_xm;
create sequence s_t_xmsh;
create sequence s_t_xmts;
create sequence s_t_yg;

基于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_cl(
	id int identity(1,1) primary key not null,--主键
	xmId int,--项目
	name varchar(100),--材料名称
	sl varchar(100),--数量
	pic varchar(100),--拍照
	zj int--总价
);

客户表创建语句如下:


--客户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	age varchar(100),--年龄
	phone varchar(100),--联系方式
	sex varchar(100),--性别
	yx varchar(100)--邮箱
);

参与人员表创建语句如下:


--参与人员表注释
create table t_cyry(
	id int identity(1,1) primary key not null,--主键
	xmId int,--项目
	name varchar(100),--姓名
	age varchar(100),--年龄
	pic varchar(100),--头像
	sex varchar(100),--性别
	idcard varchar(100),--身份证
	address varchar(100)--住址
);

费用表创建语句如下:


--费用表注释
create table t_fy(
	id int identity(1,1) primary key not null,--主键
	xmId int,--项目
	name varchar(100),--费用名称
	sl varchar(100),--费用类型
	pic varchar(100),--生产者
	showDate datetime,--费用日期
	zj int--金额
);

施工记录表创建语句如下:


--施工记录表注释
create table t_sgjl(
	id int identity(1,1) primary key not null,--主键
	xmId int,--项目
	title varchar(100),--记录名称
	content varchar(100),--详细内容
	fzr varchar(100),--负责人
	lxdh varchar(100),--联系电话
	showDate datetime--日期
);

项目表创建语句如下:


--项目表注释
create table t_xm(
	id int identity(1,1) primary key not null,--主键
	xmbh varchar(100),--项目编号
	ygId int,--项目经理
	customerId int,--客户
	xmName varchar(100),--项目名称
	pic varchar(100),--合同照片
	v1 varchar(100),--地址
	v2 datetime,--开工日期
	v3 datetime,--预计结束日期
	pj1 varchar(100),--项目经理评价
	pj2 varchar(100),--项目评价
	pj3 varchar(100),--员工评价
	status varchar(100)--状态
);

项目售后表创建语句如下:


--项目售后表注释
create table t_xmsh(
	id int identity(1,1) primary key not null,--主键
	xmId int,--项目
	content varchar(100),--售后说明
	lxdh varchar(100),--联系电话
	status varchar(100)--状态
);

项目投诉表创建语句如下:


--项目投诉表注释
create table t_xmts(
	id int identity(1,1) primary key not null,--主键
	xmId int,--项目
	title varchar(100),--标题
	content varchar(100),--投诉内容
	lxdh varchar(100),--联系电话
	status varchar(100)--状态
);

员工表创建语句如下:


--员工表注释
create table t_yg(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ygName varchar(100),--姓名
	age varchar(100),--年龄
	phone varchar(100),--电话
	sex varchar(100),--性别
	pic varchar(100),--图片
	xmjl varchar(100)--项目经理
);

基于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_cl")
public class Cl {
//主键
@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 xmId;
//材料名称
private String name;
//数量
private String sl;
//拍照
private String pic;
//总价
private Integer zj;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
}

客户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 age;
//联系方式
private String phone;
//性别
private String sex;
//邮箱
private String yx;
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 getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
}

参与人员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_cyry")
public class Cyry {
//主键
@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 xmId;
//姓名
private String name;
//年龄
private String age;
//头像
private String pic;
//性别
private String sex;
//身份证
private String idcard;
//住址
private String address;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
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_fy")
public class Fy {
//主键
@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 xmId;
//费用名称
private String name;
//费用类型
private String sl;
//生产者
private String pic;
//费用日期
private Date showDate;
//金额
private Integer zj;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
}

施工记录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_sgjl")
public class Sgjl {
//主键
@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 xmId;
//记录名称
private String title;
//详细内容
private String content;
//负责人
private String fzr;
//联系电话
private String lxdh;
//日期
private Date showDate;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
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 String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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_xm")
public class Xm {
//主键
@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 xmbh;
//项目经理
private Integer ygId;
//客户
private Integer customerId;
//项目名称
private String xmName;
//合同照片
private String pic;
//地址
private String v1;
//开工日期
private Date v2;
//预计结束日期
private Date v3;
//项目经理评价
private String pj1;
//项目评价
private String pj2;
//员工评价
private String pj3;
//状态
private String status;
public String getXmbh() {return xmbh;}
public void setXmbh(String xmbh) {this.xmbh = xmbh;}
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getXmName() {return xmName;}
public void setXmName(String xmName) {this.xmName = xmName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getV2() {return v2;}
public void setV2(Date v2) {this.v2 = v2;}
public Date getV3() {return v3;}
public void setV3(Date v3) {this.v3 = v3;}
public String getPj1() {return pj1;}
public void setPj1(String pj1) {this.pj1 = pj1;}
public String getPj2() {return pj2;}
public void setPj2(String pj2) {this.pj2 = pj2;}
public String getPj3() {return pj3;}
public void setPj3(String pj3) {this.pj3 = pj3;}
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_xmsh")
public class Xmsh {
//主键
@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 xmId;
//售后说明
private String content;
//联系电话
private String lxdh;
//状态
private String status;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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_xmts")
public class Xmts {
//主键
@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 xmId;
//标题
private String title;
//投诉内容
private String content;
//联系电话
private String lxdh;
//状态
private String status;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
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 String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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_yg")
public class Yg {
//主键
@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 ygName;
//年龄
private String age;
//电话
private String phone;
//性别
private String sex;
//图片
private String pic;
//项目经理
private String xmjl;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getXmjl() {return xmjl;}
public void setXmjl(String xmjl) {this.xmjl = xmjl;}
}

基于JSP装饰施工管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

材料javaBean创建语句如下:


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

//材料
public class Cl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目
private Integer xmId;
//材料名称
private String name;
//数量
private String sl;
//拍照
private String pic;
//总价
private Integer zj;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
}

客户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 age;
//联系方式
private String phone;
//性别
private String sex;
//邮箱
private String yx;
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 getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
}

参与人员javaBean创建语句如下:


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

//参与人员
public class Cyry  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目
private Integer xmId;
//姓名
private String name;
//年龄
private String age;
//头像
private String pic;
//性别
private String sex;
//身份证
private String idcard;
//住址
private String address;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
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 Fy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目
private Integer xmId;
//费用名称
private String name;
//费用类型
private String sl;
//生产者
private String pic;
//费用日期
private Date showDate;
//金额
private Integer zj;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
}

施工记录javaBean创建语句如下:


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

//施工记录
public class Sgjl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目
private Integer xmId;
//记录名称
private String title;
//详细内容
private String content;
//负责人
private String fzr;
//联系电话
private String lxdh;
//日期
private Date showDate;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
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 String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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 Xm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目编号
private String xmbh;
//项目经理
private Integer ygId;
//客户
private Integer customerId;
//项目名称
private String xmName;
//合同照片
private String pic;
//地址
private String v1;
//开工日期
private Date v2;
//预计结束日期
private Date v3;
//项目经理评价
private String pj1;
//项目评价
private String pj2;
//员工评价
private String pj3;
//状态
private String status;
public String getXmbh() {return xmbh;}
public void setXmbh(String xmbh) {this.xmbh = xmbh;}
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getXmName() {return xmName;}
public void setXmName(String xmName) {this.xmName = xmName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getV2() {return v2;}
public void setV2(Date v2) {this.v2 = v2;}
public Date getV3() {return v3;}
public void setV3(Date v3) {this.v3 = v3;}
public String getPj1() {return pj1;}
public void setPj1(String pj1) {this.pj1 = pj1;}
public String getPj2() {return pj2;}
public void setPj2(String pj2) {this.pj2 = pj2;}
public String getPj3() {return pj3;}
public void setPj3(String pj3) {this.pj3 = pj3;}
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 Xmsh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目
private Integer xmId;
//售后说明
private String content;
//联系电话
private String lxdh;
//状态
private String status;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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 Xmts  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目
private Integer xmId;
//标题
private String title;
//投诉内容
private String content;
//联系电话
private String lxdh;
//状态
private String status;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
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 String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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 Yg  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 ygName;
//年龄
private String age;
//电话
private String phone;
//性别
private String sex;
//图片
private String pic;
//项目经理
private String xmjl;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getXmjl() {return xmjl;}
public void setXmjl(String xmjl) {this.xmjl = xmjl;}
}

源代码下载点这里

评论