基于SSH的美发店管理系统,javaweb毕业设计

基于SSH的美发店管理系统登录注册界面

基于SSH的美发店管理系统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_cp(
	id int primary key auto_increment comment '主键',
	cpName varchar(100) comment '产品名称',
	cpPic varchar(100) comment '图片',
	cpPrice varchar(100) comment '产品价格',
	cpms varchar(100) comment '产品描述'
) comment '产品';

客户表创建语句如下:


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 '年龄',
	ishy varchar(100) comment '是否会员',
	hykId int comment '会员卡规格',
	hyk varchar(100) comment '卡号',
	hykje int comment '金额'
) comment '客户';

会员卡表创建语句如下:


create table t_hyk(
	id int primary key auto_increment comment '主键',
	hykName varchar(100) comment '会员卡名称',
	hykzq double comment '折扣'
) comment '会员卡';

轮播图表创建语句如下:


create table t_lbt(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '图片',
	v2 varchar(100) comment '标题'
) comment '轮播图';

订单表创建语句如下:


create table t_order(
	id int primary key auto_increment comment '主键',
	orderName varchar(100) comment '订单编号',
	cpId int comment '产品',
	adminId int comment '美发师',
	customerId int comment '客户',
	je int comment '订单金额',
	insertDate datetime comment '时间',
	payType varchar(100) comment ''
) comment '订单';

基于SSH的美发店管理系统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_cp(
	id integer,
	cpName varchar(100),
	cpPic varchar(100),
	cpPrice varchar(100),
	cpms varchar(100)
);
--产品字段加注释
comment on column t_cp.id is '主键';
comment on column t_cp.cpName is '产品名称';
comment on column t_cp.cpPic is '图片';
comment on column t_cp.cpPrice is '产品价格';
comment on column t_cp.cpms is '产品描述';
--产品表加注释
comment on table t_cp 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),
	ishy varchar(100),
	hykId int,
	hyk varchar(100),
	hykje int
);
--客户字段加注释
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.ishy is '是否会员';
comment on column t_customer.hykId is '会员卡规格';
comment on column t_customer.hyk is '卡号';
comment on column t_customer.hykje is '金额';
--客户表加注释
comment on table t_customer is '客户';

会员卡表创建语句如下:


create table t_hyk(
	id integer,
	hykName varchar(100),
	hykzq double
);
--会员卡字段加注释
comment on column t_hyk.id is '主键';
comment on column t_hyk.hykName is '会员卡名称';
comment on column t_hyk.hykzq is '折扣';
--会员卡表加注释
comment on table t_hyk is '会员卡';

轮播图表创建语句如下:


create table t_lbt(
	id integer,
	v1 varchar(100),
	v2 varchar(100)
);
--轮播图字段加注释
comment on column t_lbt.id is '主键';
comment on column t_lbt.v1 is '图片';
comment on column t_lbt.v2 is '标题';
--轮播图表加注释
comment on table t_lbt is '轮播图';

订单表创建语句如下:


create table t_order(
	id integer,
	orderName varchar(100),
	cpId int,
	adminId int,
	customerId int,
	je int,
	insertDate datetime,
	payType varchar(100)
);
--订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.orderName is '订单编号';
comment on column t_order.cpId is '产品';
comment on column t_order.adminId is '美发师';
comment on column t_order.customerId is '客户';
comment on column t_order.je is '订单金额';
comment on column t_order.insertDate is '时间';
comment on column t_order.payType is '';
--订单表加注释
comment on table t_order is '订单';

oracle特有,对应序列如下:


create sequence s_t_cp;
create sequence s_t_customer;
create sequence s_t_hyk;
create sequence s_t_lbt;
create sequence s_t_order;

基于SSH的美发店管理系统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_cp(
	id int identity(1,1) primary key not null,--主键
	cpName varchar(100),--产品名称
	cpPic varchar(100),--图片
	cpPrice varchar(100),--产品价格
	cpms varchar(100)--产品描述
);

客户表创建语句如下:


--客户表注释
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),--年龄
	ishy varchar(100),--是否会员
	hykId int,--会员卡规格
	hyk varchar(100),--卡号
	hykje int--金额
);

会员卡表创建语句如下:


--会员卡表注释
create table t_hyk(
	id int identity(1,1) primary key not null,--主键
	hykName varchar(100),--会员卡名称
	hykzq double--折扣
);

轮播图表创建语句如下:


--轮播图表注释
create table t_lbt(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--图片
	v2 varchar(100)--标题
);

订单表创建语句如下:


--订单表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	orderName varchar(100),--订单编号
	cpId int,--产品
	adminId int,--美发师
	customerId int,--客户
	je int,--订单金额
	insertDate datetime,--时间
	payType varchar(100)--
);

基于SSH的美发店管理系统登录后主页

基于SSH的美发店管理系统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_cp")
public class Cp {
//主键
@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 cpName;
//图片
private String cpPic;
//产品价格
private String cpPrice;
//产品描述
private String cpms;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getCpPic() {return cpPic;}
public void setCpPic(String cpPic) {this.cpPic = cpPic;}
public String getCpPrice() {return cpPrice;}
public void setCpPrice(String cpPrice) {this.cpPrice = cpPrice;}
public String getCpms() {return cpms;}
public void setCpms(String cpms) {this.cpms = cpms;}
}

客户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 ishy;
//会员卡规格
private Integer hykId;
//卡号
private String hyk;
//金额
private Integer hykje;
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 getIshy() {return ishy;}
public void setIshy(String ishy) {this.ishy = ishy;}
public Integer getHykId() {return hykId;}
public void setHykId(Integer hykId) {this.hykId = hykId;}
public String getHyk() {return hyk;}
public void setHyk(String hyk) {this.hyk = hyk;}
public Integer getHykje() {return hykje;}
public void setHykje(Integer hykje) {this.hykje = hykje;}
}

会员卡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_hyk")
public class Hyk {
//主键
@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 hykName;
//折扣
private Double hykzq;
public String getHykName() {return hykName;}
public void setHykName(String hykName) {this.hykName = hykName;}
public Double getHykzq() {return hykzq;}
public void setHykzq(Double hykzq) {this.hykzq = hykzq;}
}

轮播图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_lbt")
public class Lbt {
//主键
@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 v1;
//标题
private String v2;
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;}
}

订单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 String orderName;
//产品
private Integer cpId;
//美发师
private Integer adminId;
//客户
private Integer customerId;
//订单金额
private Integer je;
//时间
private Date insertDate;
//
private String payType;
public String getOrderName() {return orderName;}
public void setOrderName(String orderName) {this.orderName = orderName;}
public Integer getCpId() {return cpId;}
public void setCpId(Integer cpId) {this.cpId = cpId;}
public Integer getAdminId() {return adminId;}
public void setAdminId(Integer adminId) {this.adminId = adminId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPayType() {return payType;}
public void setPayType(String payType) {this.payType = payType;}
}

基于SSH的美发店管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

产品javaBean创建语句如下:


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

//产品
public class Cp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品名称
private String cpName;
//图片
private String cpPic;
//产品价格
private String cpPrice;
//产品描述
private String cpms;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getCpPic() {return cpPic;}
public void setCpPic(String cpPic) {this.cpPic = cpPic;}
public String getCpPrice() {return cpPrice;}
public void setCpPrice(String cpPrice) {this.cpPrice = cpPrice;}
public String getCpms() {return cpms;}
public void setCpms(String cpms) {this.cpms = cpms;}
}

客户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 ishy;
//会员卡规格
private Integer hykId;
//卡号
private String hyk;
//金额
private Integer hykje;
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 getIshy() {return ishy;}
public void setIshy(String ishy) {this.ishy = ishy;}
public Integer getHykId() {return hykId;}
public void setHykId(Integer hykId) {this.hykId = hykId;}
public String getHyk() {return hyk;}
public void setHyk(String hyk) {this.hyk = hyk;}
public Integer getHykje() {return hykje;}
public void setHykje(Integer hykje) {this.hykje = hykje;}
}

会员卡javaBean创建语句如下:


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

//会员卡
public class Hyk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会员卡名称
private String hykName;
//折扣
private Double hykzq;
public String getHykName() {return hykName;}
public void setHykName(String hykName) {this.hykName = hykName;}
public Double getHykzq() {return hykzq;}
public void setHykzq(Double hykzq) {this.hykzq = hykzq;}
}

轮播图javaBean创建语句如下:


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

//轮播图
public class Lbt  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//图片
private String v1;
//标题
private String v2;
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;}
}

订单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 String orderName;
//产品
private Integer cpId;
//美发师
private Integer adminId;
//客户
private Integer customerId;
//订单金额
private Integer je;
//时间
private Date insertDate;
//
private String payType;
public String getOrderName() {return orderName;}
public void setOrderName(String orderName) {this.orderName = orderName;}
public Integer getCpId() {return cpId;}
public void setCpId(Integer cpId) {this.cpId = cpId;}
public Integer getAdminId() {return adminId;}
public void setAdminId(Integer adminId) {this.adminId = adminId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPayType() {return payType;}
public void setPayType(String payType) {this.payType = payType;}
}

源代码下载点这里

评论