- 校园机房管理信息系统mysql数据库创建语句
- 校园机房管理信息系统oracle数据库创建语句
- 校园机房管理信息系统sqlserver数据库创建语句
- 校园机房管理信息系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 校园机房管理信息系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
校园机房管理信息系统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_bj(
id int primary key auto_increment comment '主键',
bjName varchar(100) 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_jfadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
jfadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment ''
) comment '机房管理员';
机房计算机表创建语句如下：
create table t_jisuanji(
id int primary key auto_increment comment '主键',
jf varchar(100) comment '',
jisuanjiName varchar(100) comment '计算机编号',
status varchar(100) comment ''
) comment '机房计算机';
教务管理员表创建语句如下：
create table t_jwadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
jwadminName varchar(100) comment '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment ''
) comment '教务管理员';
课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
kcName varchar(100) comment '课程名称',
bjId int comment '班级',
skdd varchar(100) comment '上课地点',
sksjd varchar(100) comment '上课时间段',
teacherId int comment '上课老师',
remark text comment '备注'
) comment '课程';
电脑预约表创建语句如下：
create table t_sorder(
id int primary key auto_increment comment '主键',
jf varchar(100) comment '',
jisuanjiName varchar(100) comment '计算机编号',
studentId int comment '学生',
insertDate datetime comment '发起日期',
content text comment '预约说明',
showDate datetime comment '预约日期',
status varchar(100) comment '状态',
back text comment '回复'
) comment '电脑预约';
学生表创建语句如下：
create table t_student(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
studentName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
bjId int 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_torder(
id int primary key auto_increment comment '主键',
jf varchar(100) comment '',
teacherId int comment '老师',
insertDate datetime comment '发起日期',
content text comment '预约说明',
showDate datetime comment '预约日期',
status varchar(100) comment '状态',
back text 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_bj(
id integer,
bjName varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
--班级表加注释
comment on table t_bj 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_jfadmin(
id integer,
username varchar(100),
password varchar(100),
jfadminName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--机房管理员字段加注释
comment on column t_jfadmin.id is '主键';
comment on column t_jfadmin.username is '账号';
comment on column t_jfadmin.password is '密码';
comment on column t_jfadmin.jfadminName is '姓名';
comment on column t_jfadmin.phone is '电话';
comment on column t_jfadmin.age is '年龄';
comment on column t_jfadmin.sex is '';
--机房管理员表加注释
comment on table t_jfadmin is '机房管理员';
机房计算机表创建语句如下：
create table t_jisuanji(
id integer,
jf varchar(100),
jisuanjiName varchar(100),
status varchar(100)
);
--机房计算机字段加注释
comment on column t_jisuanji.id is '主键';
comment on column t_jisuanji.jf is '';
comment on column t_jisuanji.jisuanjiName is '计算机编号';
comment on column t_jisuanji.status is '';
--机房计算机表加注释
comment on table t_jisuanji is '机房计算机';
教务管理员表创建语句如下：
create table t_jwadmin(
id integer,
username varchar(100),
password varchar(100),
jwadminName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--教务管理员字段加注释
comment on column t_jwadmin.id is '主键';
comment on column t_jwadmin.username is '账号';
comment on column t_jwadmin.password is '密码';
comment on column t_jwadmin.jwadminName is '姓名';
comment on column t_jwadmin.headPic is '头像';
comment on column t_jwadmin.phone is '电话';
comment on column t_jwadmin.age is '年龄';
comment on column t_jwadmin.sex is '';
--教务管理员表加注释
comment on table t_jwadmin is '教务管理员';
课程表创建语句如下：
create table t_kc(
id integer,
kcName varchar(100),
bjId int,
skdd varchar(100),
sksjd varchar(100),
teacherId int,
remark text
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.bjId is '班级';
comment on column t_kc.skdd is '上课地点';
comment on column t_kc.sksjd is '上课时间段';
comment on column t_kc.teacherId is '上课老师';
comment on column t_kc.remark is '备注';
--课程表加注释
comment on table t_kc is '课程';
电脑预约表创建语句如下：
create table t_sorder(
id integer,
jf varchar(100),
jisuanjiName varchar(100),
studentId int,
insertDate datetime,
content text,
showDate datetime,
status varchar(100),
back text
);
--电脑预约字段加注释
comment on column t_sorder.id is '主键';
comment on column t_sorder.jf is '';
comment on column t_sorder.jisuanjiName is '计算机编号';
comment on column t_sorder.studentId is '学生';
comment on column t_sorder.insertDate is '发起日期';
comment on column t_sorder.content is '预约说明';
comment on column t_sorder.showDate is '预约日期';
comment on column t_sorder.status is '状态';
comment on column t_sorder.back is '回复';
--电脑预约表加注释
comment on table t_sorder is '电脑预约';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
bjId int
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码';
comment on column t_student.studentName is '姓名';
comment on column t_student.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '';
comment on column t_student.bjId is '班级';
--学生表加注释
comment on table t_student 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_torder(
id integer,
jf varchar(100),
teacherId int,
insertDate datetime,
content text,
showDate datetime,
status varchar(100),
back text
);
--机房预约字段加注释
comment on column t_torder.id is '主键';
comment on column t_torder.jf is '';
comment on column t_torder.teacherId is '老师';
comment on column t_torder.insertDate is '发起日期';
comment on column t_torder.content is '预约说明';
comment on column t_torder.showDate is '预约日期';
comment on column t_torder.status is '状态';
comment on column t_torder.back is '回复';
--机房预约表加注释
comment on table t_torder is '机房预约';
oracle特有，对应序列如下：
create sequence s_t_bj;
create sequence s_t_gonggao;
create sequence s_t_jfadmin;
create sequence s_t_jisuanji;
create sequence s_t_jwadmin;
create sequence s_t_kc;
create sequence s_t_sorder;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_torder;
校园机房管理信息系统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_bj(
id int identity(1,1) primary key not null,--主键
bjName varchar(100)--班级
);
公告表创建语句如下：
--公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--发起日期
);
机房管理员表创建语句如下：
--机房管理员表注释
create table t_jfadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
jfadminName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--
);
机房计算机表创建语句如下：
--机房计算机表注释
create table t_jisuanji(
id int identity(1,1) primary key not null,--主键
jf varchar(100),--
jisuanjiName varchar(100),--计算机编号
status varchar(100)--
);
教务管理员表创建语句如下：
--教务管理员表注释
create table t_jwadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
jwadminName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--
);
课程表创建语句如下：
--课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
kcName varchar(100),--课程名称
bjId int,--班级
skdd varchar(100),--上课地点
sksjd varchar(100),--上课时间段
teacherId int,--上课老师
remark text--备注
);
电脑预约表创建语句如下：
--电脑预约表注释
create table t_sorder(
id int identity(1,1) primary key not null,--主键
jf varchar(100),--
jisuanjiName varchar(100),--计算机编号
studentId int,--学生
insertDate datetime,--发起日期
content text,--预约说明
showDate datetime,--预约日期
status varchar(100),--状态
back text--回复
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
bjId int--班级
);
老师表创建语句如下：
--老师表注释
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_torder(
id int identity(1,1) primary key not null,--主键
jf varchar(100),--
teacherId int,--老师
insertDate datetime,--发起日期
content text,--预约说明
showDate datetime,--预约日期
status varchar(100),--状态
back text--回复
);
登录后主页.jpg?x-oss-process=style/00001)
校园机房管理信息系统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_bj")
public class Bj {
//主键
@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 bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}公告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_jfadmin")
public class Jfadmin {
//主键
@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 jfadminName;
//电话
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 getJfadminName() {return jfadminName;}
public void setJfadminName(String jfadminName) {this.jfadminName = jfadminName;}
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_jisuanji")
public class Jisuanji {
//主键
@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 jf;
//计算机编号
private String jisuanjiName;
//
private String status;
public String getJf() {return jf;}
public void setJf(String jf) {this.jf = jf;}
public String getJisuanjiName() {return jisuanjiName;}
public void setJisuanjiName(String jisuanjiName) {this.jisuanjiName = jisuanjiName;}
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_jwadmin")
public class Jwadmin {
//主键
@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 jwadminName;
//头像
private String headPic;
//电话
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 getJwadminName() {return jwadminName;}
public void setJwadminName(String jwadminName) {this.jwadminName = jwadminName;}
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;}
}课程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_kc")
public class Kc {
//主键
@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 kcName;
//班级
private Long bjId;
//上课地点
private String skdd;
//上课时间段
private String sksjd;
//上课老师
private Long teacherId;
//备注
private String remark;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Long getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksjd() {return sksjd;}
public void setSksjd(String sksjd) {this.sksjd = sksjd;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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_sorder")
public class Sorder {
//主键
@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 jf;
//计算机编号
private String jisuanjiName;
//学生
private Long studentId;
//发起日期
private Date insertDate;
//预约说明
private String content;
//预约日期
private Date showDate;
//状态
private String status;
//回复
private String back;
public String getJf() {return jf;}
public void setJf(String jf) {this.jf = jf;}
public String getJisuanjiName() {return jisuanjiName;}
public void setJisuanjiName(String jisuanjiName) {this.jisuanjiName = jisuanjiName;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}学生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_student")
public class Student {
//主键
@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 studentName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//班级
private Long bjId;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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 getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
}老师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_torder")
public class Torder {
//主键
@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 jf;
//老师
private Long teacherId;
//发起日期
private Date insertDate;
//预约说明
private String content;
//预约日期
private Date showDate;
//状态
private String status;
//回复
private String back;
public String getJf() {return jf;}
public void setJf(String jf) {this.jf = jf;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}校园机房管理信息系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
班级javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级
public class Bj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private String bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}公告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;
//发起日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
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 Jfadmin 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 jfadminName;
//电话
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 getJfadminName() {return jfadminName;}
public void setJfadminName(String jfadminName) {this.jfadminName = jfadminName;}
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 Jisuanji extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String jf;
//计算机编号
private String jisuanjiName;
//
private String status;
public String getJf() {return jf;}
public void setJf(String jf) {this.jf = jf;}
public String getJisuanjiName() {return jisuanjiName;}
public void setJisuanjiName(String jisuanjiName) {this.jisuanjiName = jisuanjiName;}
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 Jwadmin 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 jwadminName;
//头像
private String headPic;
//电话
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 getJwadminName() {return jwadminName;}
public void setJwadminName(String jwadminName) {this.jwadminName = jwadminName;}
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;}
}课程javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//课程
public class Kc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程名称
private String kcName;
//班级
private Long bjId;
//上课地点
private String skdd;
//上课时间段
private String sksjd;
//上课老师
private Long teacherId;
//备注
private String remark;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Long getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksjd() {return sksjd;}
public void setSksjd(String sksjd) {this.sksjd = sksjd;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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 Sorder extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String jf;
//计算机编号
private String jisuanjiName;
//学生
private Long studentId;
//发起日期
private Date insertDate;
//预约说明
private String content;
//预约日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//状态
private String status;
//回复
private String back;
public String getJf() {return jf;}
public void setJf(String jf) {this.jf = jf;}
public String getJisuanjiName() {return jisuanjiName;}
public void setJisuanjiName(String jisuanjiName) {this.jisuanjiName = jisuanjiName;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}学生javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学生
public class Student 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 studentName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//班级
private Long bjId;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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 getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
}老师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;
//性别
@DateTimeFormat(pattern = "yyyy-MM-dd")
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 Torder extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String jf;
//老师
private Long teacherId;
//发起日期
private Date insertDate;
//预约说明
private String content;
//预约日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//状态
private String status;
//回复
private String back;
public String getJf() {return jf;}
public void setJf(String jf) {this.jf = jf;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}