基于SSM的宿舍管理系统的设计与实现

基于SSM的宿舍管理系统的设计与实现登录注册界面

基于SSM的宿舍管理系统的设计与实现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 '姓名',
	xh varchar(100) comment '学号',
	bj varchar(100) comment '班级',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '学生';

基础信息表创建语句如下:


create table t_jcxx(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '校区',
	v2 varchar(100) comment '楼栋',
	v3 varchar(100) comment '楼层',
	v4 varchar(100) comment '寝室信息',
	v5 varchar(100) comment '日期',
	v6 varchar(100) comment '图片'
) comment '基础信息';

留校登记表创建语句如下:


create table t_lxdj(
	id int primary key auto_increment comment '主键',
	customerId int comment '学生',
	content varchar(100) comment '说明',
	lxsj varchar(100) comment '时间'
) comment '留校登记';

留言板与公告栏表创建语句如下:


create table t_lybggl(
	id int primary key auto_increment comment '主键',
	customerId int comment '学生',
	v2 varchar(100) comment '留言',
	v3 varchar(100) comment '回复',
	insertDate datetime comment '日期',
	status varchar(100) comment '状态'
) comment '留言板与公告栏';

新生寝室分配表创建语句如下:


create table t_qsfp(
	id int primary key auto_increment comment '主键',
	customerId int comment '学生',
	v1 varchar(100) comment '床位',
	v2 varchar(100) comment '日期'
) comment '新生寝室分配';

寝室卫生记录表创建语句如下:


create table t_qsws(
	id int primary key auto_increment comment '主键',
	customerId int comment '学生',
	v1 varchar(100) comment '寝室',
	v2 varchar(100) comment '日期',
	v3 varchar(100) comment '卫生内容'
) comment '寝室卫生记录';

星级寝室表创建语句如下:


create table t_qsxjpd(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '寝室名称',
	v2 varchar(100) comment '评分',
	v3 varchar(100) comment '星级',
	v4 varchar(100) comment '评语'
) comment '星级寝室';

寝室资产的表创建语句如下:


create table t_qszc(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '类型',
	v2 varchar(100) comment '内容',
	v5 varchar(100) comment '日期',
	v6 varchar(100) comment '图片'
) comment '寝室资产的';

水电费表创建语句如下:


create table t_sdf(
	id int primary key auto_increment comment '主键',
	customerId int comment '学生',
	types varchar(100) comment '费用类别',
	je varchar(100) comment '金额',
	jfrq varchar(100) comment '缴费日期'
) comment '水电费';

违规宿舍表创建语句如下:


create table t_wgss(
	id int primary key auto_increment comment '主键',
	ssName varchar(100) comment '违规宿舍',
	content varchar(100) comment '违规说明',
	fbsj varchar(100) comment '发布时间'
) comment '违规宿舍';

维修管理员表创建语句如下:


create table t_wxry(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	wxryName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '维修管理员';

报修表创建语句如下:


create table t_xsbx(
	id int primary key auto_increment comment '主键',
	customerId int comment '',
	xsbxName varchar(100) comment '报修标题',
	content varchar(100) comment '报修内容',
	status varchar(100) comment '状态',
	remark varchar(100) comment '回复'
) comment '报修';

学生违纪信息表创建语句如下:


create table t_xswj(
	id int primary key auto_increment comment '主键',
	customerId int comment '学生',
	v2 varchar(100) comment '日期',
	v3 varchar(100) comment '违纪内容'
) comment '学生违纪信息';

信息表创建语句如下:


create table t_xx(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	fileUrl varchar(100) comment '文件',
	content varchar(100) comment '内容',
	showDate varchar(100) comment '展示日期'
) comment '信息';

资料表创建语句如下:


create table t_zlgl(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	fileUrl varchar(100) comment '文件',
	content varchar(100) comment '内容',
	showDate varchar(100) comment '日期'
) comment '资料';

基于SSM的宿舍管理系统的设计与实现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),
	xh varchar(100),
	bj varchar(100),
	age varchar(100),
	sex varchar(100),
	phone 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.xh is '学号';
comment on column t_customer.bj is '班级';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
--学生表加注释
comment on table t_customer is '学生';

基础信息表创建语句如下:


create table t_jcxx(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--基础信息字段加注释
comment on column t_jcxx.id is '主键';
comment on column t_jcxx.v1 is '校区';
comment on column t_jcxx.v2 is '楼栋';
comment on column t_jcxx.v3 is '楼层';
comment on column t_jcxx.v4 is '寝室信息';
comment on column t_jcxx.v5 is '日期';
comment on column t_jcxx.v6 is '图片';
--基础信息表加注释
comment on table t_jcxx is '基础信息';

留校登记表创建语句如下:


create table t_lxdj(
	id integer,
	customerId int,
	content varchar(100),
	lxsj varchar(100)
);
--留校登记字段加注释
comment on column t_lxdj.id is '主键';
comment on column t_lxdj.customerId is '学生';
comment on column t_lxdj.content is '说明';
comment on column t_lxdj.lxsj is '时间';
--留校登记表加注释
comment on table t_lxdj is '留校登记';

留言板与公告栏表创建语句如下:


create table t_lybggl(
	id integer,
	customerId int,
	v2 varchar(100),
	v3 varchar(100),
	insertDate datetime,
	status varchar(100)
);
--留言板与公告栏字段加注释
comment on column t_lybggl.id is '主键';
comment on column t_lybggl.customerId is '学生';
comment on column t_lybggl.v2 is '留言';
comment on column t_lybggl.v3 is '回复';
comment on column t_lybggl.insertDate is '日期';
comment on column t_lybggl.status is '状态';
--留言板与公告栏表加注释
comment on table t_lybggl is '留言板与公告栏';

新生寝室分配表创建语句如下:


create table t_qsfp(
	id integer,
	customerId int,
	v1 varchar(100),
	v2 varchar(100)
);
--新生寝室分配字段加注释
comment on column t_qsfp.id is '主键';
comment on column t_qsfp.customerId is '学生';
comment on column t_qsfp.v1 is '床位';
comment on column t_qsfp.v2 is '日期';
--新生寝室分配表加注释
comment on table t_qsfp is '新生寝室分配';

寝室卫生记录表创建语句如下:


create table t_qsws(
	id integer,
	customerId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--寝室卫生记录字段加注释
comment on column t_qsws.id is '主键';
comment on column t_qsws.customerId is '学生';
comment on column t_qsws.v1 is '寝室';
comment on column t_qsws.v2 is '日期';
comment on column t_qsws.v3 is '卫生内容';
--寝室卫生记录表加注释
comment on table t_qsws is '寝室卫生记录';

星级寝室表创建语句如下:


create table t_qsxjpd(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100)
);
--星级寝室字段加注释
comment on column t_qsxjpd.id is '主键';
comment on column t_qsxjpd.v1 is '寝室名称';
comment on column t_qsxjpd.v2 is '评分';
comment on column t_qsxjpd.v3 is '星级';
comment on column t_qsxjpd.v4 is '评语';
--星级寝室表加注释
comment on table t_qsxjpd is '星级寝室';

寝室资产的表创建语句如下:


create table t_qszc(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--寝室资产的字段加注释
comment on column t_qszc.id is '主键';
comment on column t_qszc.v1 is '类型';
comment on column t_qszc.v2 is '内容';
comment on column t_qszc.v5 is '日期';
comment on column t_qszc.v6 is '图片';
--寝室资产的表加注释
comment on table t_qszc is '寝室资产的';

水电费表创建语句如下:


create table t_sdf(
	id integer,
	customerId int,
	types varchar(100),
	je varchar(100),
	jfrq varchar(100)
);
--水电费字段加注释
comment on column t_sdf.id is '主键';
comment on column t_sdf.customerId is '学生';
comment on column t_sdf.types is '费用类别';
comment on column t_sdf.je is '金额';
comment on column t_sdf.jfrq is '缴费日期';
--水电费表加注释
comment on table t_sdf is '水电费';

违规宿舍表创建语句如下:


create table t_wgss(
	id integer,
	ssName varchar(100),
	content varchar(100),
	fbsj varchar(100)
);
--违规宿舍字段加注释
comment on column t_wgss.id is '主键';
comment on column t_wgss.ssName is '违规宿舍';
comment on column t_wgss.content is '违规说明';
comment on column t_wgss.fbsj is '发布时间';
--违规宿舍表加注释
comment on table t_wgss is '违规宿舍';

维修管理员表创建语句如下:


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

报修表创建语句如下:


create table t_xsbx(
	id integer,
	customerId int,
	xsbxName varchar(100),
	content varchar(100),
	status varchar(100),
	remark varchar(100)
);
--报修字段加注释
comment on column t_xsbx.id is '主键';
comment on column t_xsbx.customerId is '';
comment on column t_xsbx.xsbxName is '报修标题';
comment on column t_xsbx.content is '报修内容';
comment on column t_xsbx.status is '状态';
comment on column t_xsbx.remark is '回复';
--报修表加注释
comment on table t_xsbx is '报修';

学生违纪信息表创建语句如下:


create table t_xswj(
	id integer,
	customerId int,
	v2 varchar(100),
	v3 varchar(100)
);
--学生违纪信息字段加注释
comment on column t_xswj.id is '主键';
comment on column t_xswj.customerId is '学生';
comment on column t_xswj.v2 is '日期';
comment on column t_xswj.v3 is '违纪内容';
--学生违纪信息表加注释
comment on table t_xswj is '学生违纪信息';

信息表创建语句如下:


create table t_xx(
	id integer,
	title varchar(100),
	pic varchar(100),
	fileUrl varchar(100),
	content varchar(100),
	showDate varchar(100)
);
--信息字段加注释
comment on column t_xx.id is '主键';
comment on column t_xx.title is '标题';
comment on column t_xx.pic is '图片';
comment on column t_xx.fileUrl is '文件';
comment on column t_xx.content is '内容';
comment on column t_xx.showDate is '展示日期';
--信息表加注释
comment on table t_xx is '信息';

资料表创建语句如下:


create table t_zlgl(
	id integer,
	title varchar(100),
	pic varchar(100),
	fileUrl varchar(100),
	content varchar(100),
	showDate varchar(100)
);
--资料字段加注释
comment on column t_zlgl.id is '主键';
comment on column t_zlgl.title is '标题';
comment on column t_zlgl.pic is '图片';
comment on column t_zlgl.fileUrl is '文件';
comment on column t_zlgl.content is '内容';
comment on column t_zlgl.showDate is '日期';
--资料表加注释
comment on table t_zlgl is '资料';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_jcxx;
create sequence s_t_lxdj;
create sequence s_t_lybggl;
create sequence s_t_qsfp;
create sequence s_t_qsws;
create sequence s_t_qsxjpd;
create sequence s_t_qszc;
create sequence s_t_sdf;
create sequence s_t_wgss;
create sequence s_t_wxry;
create sequence s_t_xsbx;
create sequence s_t_xswj;
create sequence s_t_xx;
create sequence s_t_zlgl;

基于SSM的宿舍管理系统的设计与实现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),--姓名
	xh varchar(100),--学号
	bj varchar(100),--班级
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

基础信息表创建语句如下:


--基础信息表注释
create table t_jcxx(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--校区
	v2 varchar(100),--楼栋
	v3 varchar(100),--楼层
	v4 varchar(100),--寝室信息
	v5 varchar(100),--日期
	v6 varchar(100)--图片
);

留校登记表创建语句如下:


--留校登记表注释
create table t_lxdj(
	id int identity(1,1) primary key not null,--主键
	customerId int,--学生
	content varchar(100),--说明
	lxsj varchar(100)--时间
);

留言板与公告栏表创建语句如下:


--留言板与公告栏表注释
create table t_lybggl(
	id int identity(1,1) primary key not null,--主键
	customerId int,--学生
	v2 varchar(100),--留言
	v3 varchar(100),--回复
	insertDate datetime,--日期
	status varchar(100)--状态
);

新生寝室分配表创建语句如下:


--新生寝室分配表注释
create table t_qsfp(
	id int identity(1,1) primary key not null,--主键
	customerId int,--学生
	v1 varchar(100),--床位
	v2 varchar(100)--日期
);

寝室卫生记录表创建语句如下:


--寝室卫生记录表注释
create table t_qsws(
	id int identity(1,1) primary key not null,--主键
	customerId int,--学生
	v1 varchar(100),--寝室
	v2 varchar(100),--日期
	v3 varchar(100)--卫生内容
);

星级寝室表创建语句如下:


--星级寝室表注释
create table t_qsxjpd(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--寝室名称
	v2 varchar(100),--评分
	v3 varchar(100),--星级
	v4 varchar(100)--评语
);

寝室资产的表创建语句如下:


--寝室资产的表注释
create table t_qszc(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--类型
	v2 varchar(100),--内容
	v5 varchar(100),--日期
	v6 varchar(100)--图片
);

水电费表创建语句如下:


--水电费表注释
create table t_sdf(
	id int identity(1,1) primary key not null,--主键
	customerId int,--学生
	types varchar(100),--费用类别
	je varchar(100),--金额
	jfrq varchar(100)--缴费日期
);

违规宿舍表创建语句如下:


--违规宿舍表注释
create table t_wgss(
	id int identity(1,1) primary key not null,--主键
	ssName varchar(100),--违规宿舍
	content varchar(100),--违规说明
	fbsj varchar(100)--发布时间
);

维修管理员表创建语句如下:


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

报修表创建语句如下:


--报修表注释
create table t_xsbx(
	id int identity(1,1) primary key not null,--主键
	customerId int,--
	xsbxName varchar(100),--报修标题
	content varchar(100),--报修内容
	status varchar(100),--状态
	remark varchar(100)--回复
);

学生违纪信息表创建语句如下:


--学生违纪信息表注释
create table t_xswj(
	id int identity(1,1) primary key not null,--主键
	customerId int,--学生
	v2 varchar(100),--日期
	v3 varchar(100)--违纪内容
);

信息表创建语句如下:


--信息表注释
create table t_xx(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	fileUrl varchar(100),--文件
	content varchar(100),--内容
	showDate varchar(100)--展示日期
);

资料表创建语句如下:


--资料表注释
create table t_zlgl(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	fileUrl varchar(100),--文件
	content varchar(100),--内容
	showDate varchar(100)--日期
);

基于SSM的宿舍管理系统的设计与实现登录后主页

基于SSM的宿舍管理系统的设计与实现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 xh;
//班级
private String bj;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
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 String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

基础信息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_jcxx")
public class Jcxx {
//主键
@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;
//楼层
private String v3;
//寝室信息
private String v4;
//日期
private String v5;
//图片
private String v6;
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String 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_lxdj")
public class Lxdj {
//主键
@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 content;
//时间
private String lxsj;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getLxsj() {return lxsj;}
public void setLxsj(String lxsj) {this.lxsj = lxsj;}
}

留言板与公告栏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_lybggl")
public class Lybggl {
//主键
@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 v2;
//回复
private String v3;
//日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
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;}
}

新生寝室分配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_qsfp")
public class Qsfp {
//主键
@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 v1;
//日期
private String v2;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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_qsws")
public class Qsws {
//主键
@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 v1;
//日期
private String v2;
//卫生内容
private String v3;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

星级寝室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_qsxjpd")
public class Qsxjpd {
//主键
@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;
//星级
private String v3;
//评语
private String v4;
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
}

寝室资产的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_qszc")
public class Qszc {
//主键
@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;
//日期
private String v5;
//图片
private String v6;
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 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_sdf")
public class Sdf {
//主键
@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 types;
//金额
private String je;
//缴费日期
private String jfrq;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getJe() {return je;}
public void setJe(String je) {this.je = je;}
public String getJfrq() {return jfrq;}
public void setJfrq(String jfrq) {this.jfrq = jfrq;}
}

违规宿舍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_wgss")
public class Wgss {
//主键
@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 ssName;
//违规说明
private String content;
//发布时间
private String fbsj;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFbsj() {return fbsj;}
public void setFbsj(String fbsj) {this.fbsj = fbsj;}
}

维修管理员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_wxry")
public class Wxry {
//主键
@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 wxryName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getWxryName() {return wxryName;}
public void setWxryName(String wxryName) {this.wxryName = wxryName;}
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 String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

报修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_xsbx")
public class Xsbx {
//主键
@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 xsbxName;
//报修内容
private String content;
//状态
private String status;
//回复
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getXsbxName() {return xsbxName;}
public void setXsbxName(String xsbxName) {this.xsbxName = xsbxName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

学生违纪信息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_xswj")
public class Xswj {
//主键
@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 v2;
//违纪内容
private String v3;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

信息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_xx")
public class Xx {
//主键
@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 fileUrl;
//内容
private String content;
//展示日期
private String 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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String 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_zlgl")
public class Zlgl {
//主键
@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 fileUrl;
//内容
private String content;
//日期
private String 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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

基于SSM的宿舍管理系统的设计与实现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 xh;
//班级
private String bj;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
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 String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

基础信息javaBean创建语句如下:


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

//基础信息
public class Jcxx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//校区
private String v1;
//楼栋
private String v2;
//楼层
private String v3;
//寝室信息
private String v4;
//日期
private String v5;
//图片
private String v6;
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String 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 Lxdj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer customerId;
//说明
private String content;
//时间
private String lxsj;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getLxsj() {return lxsj;}
public void setLxsj(String lxsj) {this.lxsj = lxsj;}
}

留言板与公告栏javaBean创建语句如下:


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

//留言板与公告栏
public class Lybggl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer customerId;
//留言
private String v2;
//回复
private String v3;
//日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
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;}
}

新生寝室分配javaBean创建语句如下:


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

//新生寝室分配
public class Qsfp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer customerId;
//床位
private String v1;
//日期
private String v2;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 Qsws  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer customerId;
//寝室
private String v1;
//日期
private String v2;
//卫生内容
private String v3;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

星级寝室javaBean创建语句如下:


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

//星级寝室
public class Qsxjpd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//寝室名称
private String v1;
//评分
private String v2;
//星级
private String v3;
//评语
private String v4;
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
}

寝室资产的javaBean创建语句如下:


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

//寝室资产的
public class Qszc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String v1;
//内容
private String v2;
//日期
private String v5;
//图片
private String v6;
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 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 Sdf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer customerId;
//费用类别
private String types;
//金额
private String je;
//缴费日期
private String jfrq;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getJe() {return je;}
public void setJe(String je) {this.je = je;}
public String getJfrq() {return jfrq;}
public void setJfrq(String jfrq) {this.jfrq = jfrq;}
}

违规宿舍javaBean创建语句如下:


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

//违规宿舍
public class Wgss  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//违规宿舍
private String ssName;
//违规说明
private String content;
//发布时间
private String fbsj;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFbsj() {return fbsj;}
public void setFbsj(String fbsj) {this.fbsj = fbsj;}
}

维修管理员javaBean创建语句如下:


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

//维修管理员
public class Wxry  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 wxryName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getWxryName() {return wxryName;}
public void setWxryName(String wxryName) {this.wxryName = wxryName;}
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 String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

报修javaBean创建语句如下:


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

//报修
public class Xsbx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer customerId;
//报修标题
private String xsbxName;
//报修内容
private String content;
//状态
private String status;
//回复
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getXsbxName() {return xsbxName;}
public void setXsbxName(String xsbxName) {this.xsbxName = xsbxName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

学生违纪信息javaBean创建语句如下:


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

//学生违纪信息
public class Xswj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer customerId;
//日期
private String v2;
//违纪内容
private String v3;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

信息javaBean创建语句如下:


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

//信息
public class Xx  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 fileUrl;
//内容
private String content;
//展示日期
private String 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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

资料javaBean创建语句如下:


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

//资料
public class Zlgl  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 fileUrl;
//内容
private String content;
//日期
private String 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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

源代码下载点这里

评论