装修公司业务流程管理系统的设计与实现

装修公司业务流程管理系统的设计与实现登录注册界面

装修公司业务流程管理系统的设计与实现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 '年龄',
	sex varchar(100) comment '性别'
) comment '用户';

公告表创建语句如下:


create table t_gonggao(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '公告';

用户表创建语句如下:


create table t_order(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容说明',
	fileUrl1 varchar(100) comment '附件',
	back1 varchar(100) comment '订单审核回复',
	smsj datetime comment '上门时间',
	back2 varchar(100) comment '时间审核回复',
	sdkc varchar(100) comment '实地考察记录',
	jm varchar(100) comment '建模图片',
	back3 varchar(100) comment '建模审核说明',
	ss varchar(100) comment '实施记录',
	wc varchar(100) comment '完成记录',
	insertDate datetime comment '发起日期',
	status 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age 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.sex is '性别';
--用户表加注释
comment on table t_customer is '用户';

公告表创建语句如下:


create table t_gonggao(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.pic is '图片';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.showDate is '日期';
--公告表加注释
comment on table t_gonggao is '公告';

用户表创建语句如下:


create table t_order(
	id integer,
	customerId int,
	title varchar(100),
	content varchar(100),
	fileUrl1 varchar(100),
	back1 varchar(100),
	smsj datetime,
	back2 varchar(100),
	sdkc varchar(100),
	jm varchar(100),
	back3 varchar(100),
	ss varchar(100),
	wc varchar(100),
	insertDate datetime,
	status varchar(100)
);
--用户字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '用户';
comment on column t_order.title is '标题';
comment on column t_order.content is '内容说明';
comment on column t_order.fileUrl1 is '附件';
comment on column t_order.back1 is '订单审核回复';
comment on column t_order.smsj is '上门时间';
comment on column t_order.back2 is '时间审核回复';
comment on column t_order.sdkc is '实地考察记录';
comment on column t_order.jm is '建模图片';
comment on column t_order.back3 is '建模审核说明';
comment on column t_order.ss is '实施记录';
comment on column t_order.wc is '完成记录';
comment on column t_order.insertDate is '发起日期';
comment on column t_order.status is '状态';
--用户表加注释
comment on table t_order is '用户';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_order;

装修公司业务流程管理系统的设计与实现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),--年龄
	sex varchar(100)--性别
);

公告表创建语句如下:


--公告表注释
create table t_gonggao(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate datetime--日期
);

用户表创建语句如下:


--用户表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	title varchar(100),--标题
	content varchar(100),--内容说明
	fileUrl1 varchar(100),--附件
	back1 varchar(100),--订单审核回复
	smsj datetime,--上门时间
	back2 varchar(100),--时间审核回复
	sdkc varchar(100),--实地考察记录
	jm varchar(100),--建模图片
	back3 varchar(100),--建模审核说明
	ss varchar(100),--实施记录
	wc varchar(100),--完成记录
	insertDate datetime,--发起日期
	status 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_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 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 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_gonggao")
public class Gonggao {
//主键
@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 pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_order")
public class Order {
//主键
@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 String fileUrl1;
//订单审核回复
private String back1;
//上门时间
private Date smsj;
//时间审核回复
private String back2;
//实地考察记录
private String sdkc;
//建模图片
private String jm;
//建模审核说明
private String back3;
//实施记录
private String ss;
//完成记录
private String wc;
//发起日期
private Date insertDate;
//状态
private String status;
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 String getFileUrl1() {return fileUrl1;}
public void setFileUrl1(String fileUrl1) {this.fileUrl1 = fileUrl1;}
public String getBack1() {return back1;}
public void setBack1(String back1) {this.back1 = back1;}
public Date getSmsj() {return smsj;}
public void setSmsj(Date smsj) {this.smsj = smsj;}
public String getBack2() {return back2;}
public void setBack2(String back2) {this.back2 = back2;}
public String getSdkc() {return sdkc;}
public void setSdkc(String sdkc) {this.sdkc = sdkc;}
public String getJm() {return jm;}
public void setJm(String jm) {this.jm = jm;}
public String getBack3() {return back3;}
public void setBack3(String back3) {this.back3 = back3;}
public String getSs() {return ss;}
public void setSs(String ss) {this.ss = ss;}
public String getWc() {return wc;}
public void setWc(String wc) {this.wc = wc;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

装修公司业务流程管理系统的设计与实现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 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 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 Gonggao  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Order  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 String fileUrl1;
//订单审核回复
private String back1;
//上门时间
private Date smsj;
//时间审核回复
private String back2;
//实地考察记录
private String sdkc;
//建模图片
private String jm;
//建模审核说明
private String back3;
//实施记录
private String ss;
//完成记录
private String wc;
//发起日期
private Date insertDate;
//状态
private String status;
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 String getFileUrl1() {return fileUrl1;}
public void setFileUrl1(String fileUrl1) {this.fileUrl1 = fileUrl1;}
public String getBack1() {return back1;}
public void setBack1(String back1) {this.back1 = back1;}
public Date getSmsj() {return smsj;}
public void setSmsj(Date smsj) {this.smsj = smsj;}
public String getBack2() {return back2;}
public void setBack2(String back2) {this.back2 = back2;}
public String getSdkc() {return sdkc;}
public void setSdkc(String sdkc) {this.sdkc = sdkc;}
public String getJm() {return jm;}
public void setJm(String jm) {this.jm = jm;}
public String getBack3() {return back3;}
public void setBack3(String back3) {this.back3 = back3;}
public String getSs() {return ss;}
public void setSs(String ss) {this.ss = ss;}
public String getWc() {return wc;}
public void setWc(String wc) {this.wc = wc;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

评论