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

基于jsp的房屋装修预算系统,java管理系统毕业设计

基于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 '密码',
	name varchar(100) comment '姓名',
	phone varchar(100) comment '手机',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	address varchar(100) comment '家庭住址',
	idcard varchar(100) comment '身份证',
	insertDate datetime comment '入库日期'
) comment '用户';

基础工程预算表创建语句如下:


create table t_jcgcys(
	id int primary key auto_increment comment '主键',
	jcgcysName varchar(100) comment '名称',
	v1 varchar(100) comment '工期',
	v2 varchar(100) comment '项目名称',
	v3 int comment '单位',
	v4 int comment '预算单价',
	v5 varchar(100) comment '材料结构',
	v6 varchar(100) comment '工艺说明'
) comment '基础工程预算';

用户装修方案表创建语句如下:


create table t_mine(
	id int primary key auto_increment comment '主键',
	v1 int comment '面积',
	v2 int comment '价格',
	v3 varchar(100) comment '风格',
	jcgcysId int comment '基础工程预算',
	rzzclpsId int comment '软装方案',
	customerId int comment '客户'
) comment '用户装修方案';

软装材料配置表创建语句如下:


create table t_rzcl(
	id int primary key auto_increment comment '主键',
	df varchar(100) comment '地方',
	cl varchar(100) comment '材料',
	dw int comment '单位',
	dj int comment '单价',
	pp varchar(100) comment '品牌',
	xh varchar(100) comment '型号',
	gg varchar(100) comment '规格'
) comment '软装材料配置';

软装方案表创建语句如下:


create table t_rzzclps(
	id int primary key auto_increment comment '主键',
	rzzclpsName varchar(100) comment '方案名称',
	v1 int comment '客餐厅',
	v2 int comment '卧室',
	v3 int comment '厨卫',
	v4 int comment '书房',
	v5 int comment '阳台',
	v6 int 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),
	name varchar(100),
	phone varchar(100),
	sex varchar(100),
	age varchar(100),
	address varchar(100),
	idcard varchar(100),
	insertDate datetime
);
--用户字段加注释
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.name is '姓名';
comment on column t_customer.phone is '手机';
comment on column t_customer.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.address is '家庭住址';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.insertDate is '入库日期';
--用户表加注释
comment on table t_customer is '用户';

基础工程预算表创建语句如下:


create table t_jcgcys(
	id integer,
	jcgcysName varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 int,
	v4 int,
	v5 varchar(100),
	v6 varchar(100)
);
--基础工程预算字段加注释
comment on column t_jcgcys.id is '主键';
comment on column t_jcgcys.jcgcysName is '名称';
comment on column t_jcgcys.v1 is '工期';
comment on column t_jcgcys.v2 is '项目名称';
comment on column t_jcgcys.v3 is '单位';
comment on column t_jcgcys.v4 is '预算单价';
comment on column t_jcgcys.v5 is '材料结构';
comment on column t_jcgcys.v6 is '工艺说明';
--基础工程预算表加注释
comment on table t_jcgcys is '基础工程预算';

用户装修方案表创建语句如下:


create table t_mine(
	id integer,
	v1 int,
	v2 int,
	v3 varchar(100),
	jcgcysId int,
	rzzclpsId int,
	customerId int
);
--用户装修方案字段加注释
comment on column t_mine.id is '主键';
comment on column t_mine.v1 is '面积';
comment on column t_mine.v2 is '价格';
comment on column t_mine.v3 is '风格';
comment on column t_mine.jcgcysId is '基础工程预算';
comment on column t_mine.rzzclpsId is '软装方案';
comment on column t_mine.customerId is '客户';
--用户装修方案表加注释
comment on table t_mine is '用户装修方案';

软装材料配置表创建语句如下:


create table t_rzcl(
	id integer,
	df varchar(100),
	cl varchar(100),
	dw int,
	dj int,
	pp varchar(100),
	xh varchar(100),
	gg varchar(100)
);
--软装材料配置字段加注释
comment on column t_rzcl.id is '主键';
comment on column t_rzcl.df is '地方';
comment on column t_rzcl.cl is '材料';
comment on column t_rzcl.dw is '单位';
comment on column t_rzcl.dj is '单价';
comment on column t_rzcl.pp is '品牌';
comment on column t_rzcl.xh is '型号';
comment on column t_rzcl.gg is '规格';
--软装材料配置表加注释
comment on table t_rzcl is '软装材料配置';

软装方案表创建语句如下:


create table t_rzzclps(
	id integer,
	rzzclpsName varchar(100),
	v1 int,
	v2 int,
	v3 int,
	v4 int,
	v5 int,
	v6 int
);
--软装方案字段加注释
comment on column t_rzzclps.id is '主键';
comment on column t_rzzclps.rzzclpsName is '方案名称';
comment on column t_rzzclps.v1 is '客餐厅';
comment on column t_rzzclps.v2 is '卧室';
comment on column t_rzzclps.v3 is '厨卫';
comment on column t_rzzclps.v4 is '书房';
comment on column t_rzzclps.v5 is '阳台';
comment on column t_rzzclps.v6 is '总价';
--软装方案表加注释
comment on table t_rzzclps is '软装方案';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_jcgcys;
create sequence s_t_mine;
create sequence s_t_rzcl;
create sequence s_t_rzzclps;

基于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),--密码
	name varchar(100),--姓名
	phone varchar(100),--手机
	sex varchar(100),--性别
	age varchar(100),--年龄
	address varchar(100),--家庭住址
	idcard varchar(100),--身份证
	insertDate datetime--入库日期
);

基础工程预算表创建语句如下:


--基础工程预算表注释
create table t_jcgcys(
	id int identity(1,1) primary key not null,--主键
	jcgcysName varchar(100),--名称
	v1 varchar(100),--工期
	v2 varchar(100),--项目名称
	v3 int,--单位
	v4 int,--预算单价
	v5 varchar(100),--材料结构
	v6 varchar(100)--工艺说明
);

用户装修方案表创建语句如下:


--用户装修方案表注释
create table t_mine(
	id int identity(1,1) primary key not null,--主键
	v1 int,--面积
	v2 int,--价格
	v3 varchar(100),--风格
	jcgcysId int,--基础工程预算
	rzzclpsId int,--软装方案
	customerId int--客户
);

软装材料配置表创建语句如下:


--软装材料配置表注释
create table t_rzcl(
	id int identity(1,1) primary key not null,--主键
	df varchar(100),--地方
	cl varchar(100),--材料
	dw int,--单位
	dj int,--单价
	pp varchar(100),--品牌
	xh varchar(100),--型号
	gg varchar(100)--规格
);

软装方案表创建语句如下:


--软装方案表注释
create table t_rzzclps(
	id int identity(1,1) primary key not null,--主键
	rzzclpsName varchar(100),--方案名称
	v1 int,--客餐厅
	v2 int,--卧室
	v3 int,--厨卫
	v4 int,--书房
	v5 int,--阳台
	v6 int--总价
);

基于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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
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 getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
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_jcgcys")
public class Jcgcys {
//主键
@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 jcgcysName;
//工期
private String v1;
//项目名称
private String v2;
//单位
private Integer v3;
//预算单价
private Integer v4;
//材料结构
private String v5;
//工艺说明
private String v6;
public String getJcgcysName() {return jcgcysName;}
public void setJcgcysName(String jcgcysName) {this.jcgcysName = jcgcysName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String 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;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

用户装修方案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_mine")
public class Mine {
//主键
@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 String v3;
//基础工程预算
private Integer jcgcysId;
//软装方案
private Integer rzzclpsId;
//客户
private Integer customerId;
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getJcgcysId() {return jcgcysId;}
public void setJcgcysId(Integer jcgcysId) {this.jcgcysId = jcgcysId;}
public Integer getRzzclpsId() {return rzzclpsId;}
public void setRzzclpsId(Integer rzzclpsId) {this.rzzclpsId = rzzclpsId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}

软装材料配置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_rzcl")
public class Rzcl {
//主键
@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 df;
//材料
private String cl;
//单位
private Integer dw;
//单价
private Integer dj;
//品牌
private String pp;
//型号
private String xh;
//规格
private String gg;
public String getDf() {return df;}
public void setDf(String df) {this.df = df;}
public String getCl() {return cl;}
public void setCl(String cl) {this.cl = cl;}
public Integer getDw() {return dw;}
public void setDw(Integer dw) {this.dw = dw;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
}

软装方案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_rzzclps")
public class Rzzclps {
//主键
@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 rzzclpsName;
//客餐厅
private Integer v1;
//卧室
private Integer v2;
//厨卫
private Integer v3;
//书房
private Integer v4;
//阳台
private Integer v5;
//总价
private Integer v6;
public String getRzzclpsName() {return rzzclpsName;}
public void setRzzclpsName(String rzzclpsName) {this.rzzclpsName = rzzclpsName;}
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;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public Integer getV6() {return v6;}
public void setV6(Integer v6) {this.v6 = v6;}
}

基于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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
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 getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
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 Jcgcys  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String jcgcysName;
//工期
private String v1;
//项目名称
private String v2;
//单位
private Integer v3;
//预算单价
private Integer v4;
//材料结构
private String v5;
//工艺说明
private String v6;
public String getJcgcysName() {return jcgcysName;}
public void setJcgcysName(String jcgcysName) {this.jcgcysName = jcgcysName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String 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;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

用户装修方案javaBean创建语句如下:


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

//用户装修方案
public class Mine  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 String v3;
//基础工程预算
private Integer jcgcysId;
//软装方案
private Integer rzzclpsId;
//客户
private Integer customerId;
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getJcgcysId() {return jcgcysId;}
public void setJcgcysId(Integer jcgcysId) {this.jcgcysId = jcgcysId;}
public Integer getRzzclpsId() {return rzzclpsId;}
public void setRzzclpsId(Integer rzzclpsId) {this.rzzclpsId = rzzclpsId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}

软装材料配置javaBean创建语句如下:


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

//软装材料配置
public class Rzcl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//地方
private String df;
//材料
private String cl;
//单位
private Integer dw;
//单价
private Integer dj;
//品牌
private String pp;
//型号
private String xh;
//规格
private String gg;
public String getDf() {return df;}
public void setDf(String df) {this.df = df;}
public String getCl() {return cl;}
public void setCl(String cl) {this.cl = cl;}
public Integer getDw() {return dw;}
public void setDw(Integer dw) {this.dw = dw;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
}

软装方案javaBean创建语句如下:


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

//软装方案
public class Rzzclps  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//方案名称
private String rzzclpsName;
//客餐厅
private Integer v1;
//卧室
private Integer v2;
//厨卫
private Integer v3;
//书房
private Integer v4;
//阳台
private Integer v5;
//总价
private Integer v6;
public String getRzzclpsName() {return rzzclpsName;}
public void setRzzclpsName(String rzzclpsName) {this.rzzclpsName = rzzclpsName;}
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;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public Integer getV6() {return v6;}
public void setV6(Integer v6) {this.v6 = v6;}
}

评论