共享按摩椅管理系统

共享按摩椅管理系统登录注册界面

共享按摩椅管理系统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_amy(
	id int primary key auto_increment comment '主键',
	bh varchar(100) comment '编号',
	jwd varchar(100) comment '经纬度',
	wz varchar(100) comment '位置',
	insertDate datetime comment '添加日期'
) comment '按摩椅';

用户支付评价表创建语句如下:


create table t_pingjia(
	id int primary key auto_increment comment '主键',
	bh varchar(100) comment '编号',
	pjnr varchar(100) comment '评价内容',
	pf int comment '评分',
	fee int comment '价格',
	insertDate datetime comment '使用日期',
	zffs varchar(100) comment '支付方式',
	sjd 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_amy(
	id integer,
	bh varchar(100),
	jwd varchar(100),
	wz varchar(100),
	insertDate datetime
);
--按摩椅字段加注释
comment on column t_amy.id is '主键';
comment on column t_amy.bh is '编号';
comment on column t_amy.jwd is '经纬度';
comment on column t_amy.wz is '位置';
comment on column t_amy.insertDate is '添加日期';
--按摩椅表加注释
comment on table t_amy is '按摩椅';

用户支付评价表创建语句如下:


create table t_pingjia(
	id integer,
	bh varchar(100),
	pjnr varchar(100),
	pf int,
	fee int,
	insertDate datetime,
	zffs varchar(100),
	sjd varchar(100)
);
--用户支付评价字段加注释
comment on column t_pingjia.id is '主键';
comment on column t_pingjia.bh is '编号';
comment on column t_pingjia.pjnr is '评价内容';
comment on column t_pingjia.pf is '评分';
comment on column t_pingjia.fee is '价格';
comment on column t_pingjia.insertDate is '使用日期';
comment on column t_pingjia.zffs is '支付方式';
comment on column t_pingjia.sjd is '';
--用户支付评价表加注释
comment on table t_pingjia is '用户支付评价';

oracle特有,对应序列如下:


create sequence s_t_amy;
create sequence s_t_pingjia;

共享按摩椅管理系统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_amy(
	id int identity(1,1) primary key not null,--主键
	bh varchar(100),--编号
	jwd varchar(100),--经纬度
	wz varchar(100),--位置
	insertDate datetime--添加日期
);

用户支付评价表创建语句如下:


--用户支付评价表注释
create table t_pingjia(
	id int identity(1,1) primary key not null,--主键
	bh varchar(100),--编号
	pjnr varchar(100),--评价内容
	pf int,--评分
	fee int,--价格
	insertDate datetime,--使用日期
	zffs varchar(100),--支付方式
	sjd 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_amy")
public class Amy {
//主键
@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 bh;
//经纬度
private String jwd;
//位置
private String wz;
//添加日期
private Date insertDate;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getJwd() {return jwd;}
public void setJwd(String jwd) {this.jwd = jwd;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
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_pingjia")
public class Pingjia {
//主键
@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 bh;
//评价内容
private String pjnr;
//评分
private Integer pf;
//价格
private Integer fee;
//使用日期
private Date insertDate;
//支付方式
private String zffs;
//
private String sjd;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getPjnr() {return pjnr;}
public void setPjnr(String pjnr) {this.pjnr = pjnr;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getZffs() {return zffs;}
public void setZffs(String zffs) {this.zffs = zffs;}
public String getSjd() {return sjd;}
public void setSjd(String sjd) {this.sjd = sjd;}
}

共享按摩椅管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

按摩椅javaBean创建语句如下:


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

//按摩椅
public class Amy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String bh;
//经纬度
private String jwd;
//位置
private String wz;
//添加日期
private Date insertDate;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getJwd() {return jwd;}
public void setJwd(String jwd) {this.jwd = jwd;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
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 Pingjia  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String bh;
//评价内容
private String pjnr;
//评分
private Integer pf;
//价格
private Integer fee;
//使用日期
private Date insertDate;
//支付方式
private String zffs;
//
private String sjd;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getPjnr() {return pjnr;}
public void setPjnr(String pjnr) {this.pjnr = pjnr;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getZffs() {return zffs;}
public void setZffs(String zffs) {this.zffs = zffs;}
public String getSjd() {return sjd;}
public void setSjd(String sjd) {this.sjd = sjd;}
}

评论