宿舍卫生管理系统(xaa71)_mysql

宿舍卫生管理系统mysql数据库创建语句
宿舍卫生管理系统oracle数据库创建语句
宿舍卫生管理系统sqlserver数据库创建语句
宿舍卫生管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
宿舍卫生管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

宿舍卫生管理系统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 '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '',
	ssId int comment '所在宿舍'
) comment '学生用户';

公告表创建语句如下：


create table t_gonggao(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content text comment '内容',
	insertDate datetime comment '发起日期'
) comment '公告';

留言表创建语句如下：


create table t_ly(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	content text comment '内容',
	insertDate datetime comment '发起日期',
	back text comment '回复',
	status varchar(100) comment '状态'
) comment '留言';

宿舍评分表创建语句如下：


create table t_pf(
	id int primary key auto_increment comment '主键',
	ssId int comment '宿舍',
	showDate datetime comment '评分日期',
	pf int comment '评分',
	remark text comment '评分备注',
	pfr varchar(100) comment '评分人'
) comment '宿舍评分';

宿舍表创建语句如下：


create table t_ss(
	id int primary key auto_increment comment '主键',
	lh varchar(100) comment '',
	lc varchar(100) comment '',
	ssName varchar(100) comment '宿舍编号',
	rs int comment '可住人数',
	rzr text comment '入住详情'
) comment '宿舍';

宿舍管理员表创建语句如下：


create table t_teacher(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	teacherName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment ''
) comment '宿舍管理员';

通知表创建语句如下：


create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	title varchar(100) comment '内容',
	insertDate datetime 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),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	ssId 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.customerName is '姓名';
comment on column t_customer.headPic is '头像';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '';
comment on column t_customer.ssId is '所在宿舍';
--学生用户表加注释
comment on table t_customer is '学生用户';

公告表创建语句如下：


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

留言表创建语句如下：


create table t_ly(
	id integer,
	customerId int,
	content text,
	insertDate datetime,
	back text,
	status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.customerId is '用户';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';

宿舍评分表创建语句如下：


create table t_pf(
	id integer,
	ssId int,
	showDate datetime,
	pf int,
	remark text,
	pfr varchar(100)
);
--宿舍评分字段加注释
comment on column t_pf.id is '主键';
comment on column t_pf.ssId is '宿舍';
comment on column t_pf.showDate is '评分日期';
comment on column t_pf.pf is '评分';
comment on column t_pf.remark is '评分备注';
comment on column t_pf.pfr is '评分人';
--宿舍评分表加注释
comment on table t_pf is '宿舍评分';

宿舍表创建语句如下：


create table t_ss(
	id integer,
	lh varchar(100),
	lc varchar(100),
	ssName varchar(100),
	rs int,
	rzr text
);
--宿舍字段加注释
comment on column t_ss.id is '主键';
comment on column t_ss.lh is '';
comment on column t_ss.lc is '';
comment on column t_ss.ssName is '宿舍编号';
comment on column t_ss.rs is '可住人数';
comment on column t_ss.rzr is '入住详情';
--宿舍表加注释
comment on table t_ss is '宿舍';

宿舍管理员表创建语句如下：


create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--宿舍管理员字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.username is '账号';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '姓名';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '';
--宿舍管理员表加注释
comment on table t_teacher is '宿舍管理员';

通知表创建语句如下：


create table t_tongzhi(
	id integer,
	customerId int,
	title varchar(100),
	insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.title is '内容';
comment on column t_tongzhi.insertDate is '发起日期';
--通知表加注释
comment on table t_tongzhi is '通知';

oracle特有，对应序列如下：


create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_ly;
create sequence s_t_pf;
create sequence s_t_ss;
create sequence s_t_teacher;
create sequence s_t_tongzhi;

宿舍卫生管理系统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),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--
	ssId int--所在宿舍
);

公告表创建语句如下：


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

留言表创建语句如下：


--留言表注释
create table t_ly(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	content text,--内容
	insertDate datetime,--发起日期
	back text,--回复
	status varchar(100)--状态
);

宿舍评分表创建语句如下：


--宿舍评分表注释
create table t_pf(
	id int identity(1,1) primary key not null,--主键
	ssId int,--宿舍
	showDate datetime,--评分日期
	pf int,--评分
	remark text,--评分备注
	pfr varchar(100)--评分人
);

宿舍表创建语句如下：


--宿舍表注释
create table t_ss(
	id int identity(1,1) primary key not null,--主键
	lh varchar(100),--
	lc varchar(100),--
	ssName varchar(100),--宿舍编号
	rs int,--可住人数
	rzr text--入住详情
);

宿舍管理员表创建语句如下：


--宿舍管理员表注释
create table t_teacher(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	teacherName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--
);

通知表创建语句如下：


--通知表注释
create table t_tongzhi(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	title varchar(100),--内容
	insertDate datetime--发起日期
);

宿舍卫生管理系统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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//所在宿舍
private Long ssId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
public Long getSsId() {return ssId;}
public void setSsId(Long ssId) {this.ssId = ssId;}
}

公告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 content;
//发起日期
private Date insertDate;
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 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_ly")
public class Ly {
//主键
@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 Long customerId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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_pf")
public class Pf {
//主键
@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 Long ssId;
//评分日期
private Date showDate;
//评分
private Integer pf;
//评分备注
private String remark;
//评分人
private String pfr;
public Long getSsId() {return ssId;}
public void setSsId(Long ssId) {this.ssId = ssId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getPfr() {return pfr;}
public void setPfr(String pfr) {this.pfr = pfr;}
}

宿舍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_ss")
public class Ss {
//主键
@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 lh;
//
private String lc;
//宿舍编号
private String ssName;
//可住人数
private Integer rs;
//入住详情
private String rzr;
public String getLh() {return lh;}
public void setLh(String lh) {this.lh = lh;}
public String getLc() {return lc;}
public void setLc(String lc) {this.lc = lc;}
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public Integer getRs() {return rs;}
public void setRs(Integer rs) {this.rs = rs;}
public String getRzr() {return rzr;}
public void setRzr(String rzr) {this.rzr = rzr;}
}

宿舍管理员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_teacher")
public class Teacher {
//主键
@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 teacherName;
//电话
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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_tongzhi")
public class Tongzhi {
//主键
@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 Long customerId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

宿舍卫生管理系统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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//所在宿舍
private Long ssId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
public Long getSsId() {return ssId;}
public void setSsId(Long ssId) {this.ssId = ssId;}
}

公告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 content;
//发起日期
private Date insertDate;
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 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 Ly  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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 Pf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宿舍
private Long ssId;
//评分日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//评分
private Integer pf;
//评分备注
private String remark;
//评分人
private String pfr;
public Long getSsId() {return ssId;}
public void setSsId(Long ssId) {this.ssId = ssId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getPfr() {return pfr;}
public void setPfr(String pfr) {this.pfr = pfr;}
}

宿舍javaBean创建语句如下：


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

//宿舍
public class Ss  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String lh;
//
private String lc;
//宿舍编号
private String ssName;
//可住人数
private Integer rs;
//入住详情
private String rzr;
public String getLh() {return lh;}
public void setLh(String lh) {this.lh = lh;}
public String getLc() {return lc;}
public void setLc(String lc) {this.lc = lc;}
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public Integer getRs() {return rs;}
public void setRs(Integer rs) {this.rs = rs;}
public String getRzr() {return rzr;}
public void setRzr(String rzr) {this.rzr = rzr;}
}

宿舍管理员javaBean创建语句如下：


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

//宿舍管理员
public class Teacher  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 teacherName;
//电话
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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 Tongzhi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

宿舍卫生管理系统(xaa71)_mysql_oracle代码分享

宿舍卫生管理系统mysql数据库版本源码：

宿舍卫生管理系统oracle数据库版本源码：

宿舍卫生管理系统sqlserver数据库版本源码：

宿舍卫生管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：

宿舍卫生管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

相关毕业设计源码

评论