- 班级网站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_bjjj(
id int primary key auto_increment comment '主键',
content varchar(100) comment '班级简介'
) comment '班级简介';
班级相册表创建语句如下：
create table t_bjxc(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
types varchar(100) comment '类别',
title varchar(100) comment '标题',
pic varchar(100) comment '图片'
) comment '班级相册';
班级新闻表创建语句如下：
create table t_bjxw(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容'
) comment '班级新闻';
班级资源表创建语句如下：
create table t_bjzy(
id int primary key auto_increment comment '主键',
types varchar(100) comment '类别',
title varchar(100) comment '标题',
url varchar(100) comment '资源',
content varchar(100) comment '内容',
remark varchar(100) comment '备注'
) comment '班级资源';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '公告';
留言板表创建语句如下：
create table t_lyb(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime 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 '姓名',
pic varchar(100) comment '头像',
xh varchar(100) comment '学号',
xx varchar(100) comment '学校',
bj varchar(100) comment '班级',
rzzw varchar(100) comment '任职职位',
yx varchar(100) comment '院系',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '学生';
投票表创建语句如下：
create table t_tp(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
title varchar(100) comment '投票主题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
status varchar(100) comment '状态',
insertDate datetime comment '日期'
) comment '投票';
投票记录表创建语句如下：
create table t_tplist(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
insertDate datetime comment '日期',
tpId int comment '投票'
) comment '投票记录';
通讯录表创建语句如下：
create table t_txl(
id int primary key auto_increment comment '主键',
xm varchar(100) comment '姓名',
zz varchar(100) comment '家庭住址',
dh varchar(100) comment '电话'
) comment '通讯录';
你问我答表创建语句如下：
create table t_wt(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
hd varchar(100) comment '回答答案',
status 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_bjjj(
id integer,
content varchar(100)
);
--班级简介字段加注释
comment on column t_bjjj.id is '主键';
comment on column t_bjjj.content is '班级简介';
--班级简介表加注释
comment on table t_bjjj is '班级简介';
班级相册表创建语句如下：
create table t_bjxc(
id integer,
studentId int,
types varchar(100),
title varchar(100),
pic varchar(100)
);
--班级相册字段加注释
comment on column t_bjxc.id is '主键';
comment on column t_bjxc.studentId is '学生';
comment on column t_bjxc.types is '类别';
comment on column t_bjxc.title is '标题';
comment on column t_bjxc.pic is '图片';
--班级相册表加注释
comment on table t_bjxc is '班级相册';
班级新闻表创建语句如下：
create table t_bjxw(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100)
);
--班级新闻字段加注释
comment on column t_bjxw.id is '主键';
comment on column t_bjxw.title is '标题';
comment on column t_bjxw.pic is '图片';
comment on column t_bjxw.content is '内容';
--班级新闻表加注释
comment on table t_bjxw is '班级新闻';
班级资源表创建语句如下：
create table t_bjzy(
id integer,
types varchar(100),
title varchar(100),
url varchar(100),
content varchar(100),
remark varchar(100)
);
--班级资源字段加注释
comment on column t_bjzy.id is '主键';
comment on column t_bjzy.types is '类别';
comment on column t_bjzy.title is '标题';
comment on column t_bjzy.url is '资源';
comment on column t_bjzy.content is '内容';
comment on column t_bjzy.remark is '备注';
--班级资源表加注释
comment on table t_bjzy is '班级资源';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.content is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
留言板表创建语句如下：
create table t_lyb(
id integer,
studentId int,
title varchar(100),
content varchar(100),
insertDate datetime
);
--留言板字段加注释
comment on column t_lyb.id is '主键';
comment on column t_lyb.studentId is '学生';
comment on column t_lyb.title is '标题';
comment on column t_lyb.content is '内容';
comment on column t_lyb.insertDate is '留言日期';
--留言板表加注释
comment on table t_lyb is '留言板';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
pic varchar(100),
xh varchar(100),
xx varchar(100),
bj varchar(100),
rzzw varchar(100),
yx varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--学生字段加注释
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.pic is '头像';
comment on column t_student.xh is '学号';
comment on column t_student.xx is '学校';
comment on column t_student.bj is '班级';
comment on column t_student.rzzw is '任职职位';
comment on column t_student.yx is '院系';
comment on column t_student.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
--学生表加注释
comment on table t_student is '学生';
投票表创建语句如下：
create table t_tp(
id integer,
studentId int,
title varchar(100),
pic varchar(100),
content varchar(100),
status varchar(100),
insertDate datetime
);
--投票字段加注释
comment on column t_tp.id is '主键';
comment on column t_tp.studentId is '学生';
comment on column t_tp.title is '投票主题';
comment on column t_tp.pic is '图片';
comment on column t_tp.content is '内容';
comment on column t_tp.status is '状态';
comment on column t_tp.insertDate is '日期';
--投票表加注释
comment on table t_tp is '投票';
投票记录表创建语句如下：
create table t_tplist(
id integer,
studentId int,
insertDate datetime,
tpId int
);
--投票记录字段加注释
comment on column t_tplist.id is '主键';
comment on column t_tplist.studentId is '学生';
comment on column t_tplist.insertDate is '日期';
comment on column t_tplist.tpId is '投票';
--投票记录表加注释
comment on table t_tplist is '投票记录';
通讯录表创建语句如下：
create table t_txl(
id integer,
xm varchar(100),
zz varchar(100),
dh varchar(100)
);
--通讯录字段加注释
comment on column t_txl.id is '主键';
comment on column t_txl.xm is '姓名';
comment on column t_txl.zz is '家庭住址';
comment on column t_txl.dh is '电话';
--通讯录表加注释
comment on table t_txl is '通讯录';
你问我答表创建语句如下：
create table t_wt(
id integer,
studentId int,
title varchar(100),
pic varchar(100),
content varchar(100),
hd varchar(100),
status varchar(100),
insertDate datetime
);
--你问我答字段加注释
comment on column t_wt.id is '主键';
comment on column t_wt.studentId is '学生';
comment on column t_wt.title is '标题';
comment on column t_wt.pic is '图片';
comment on column t_wt.content is '内容';
comment on column t_wt.hd is '回答答案';
comment on column t_wt.status is '状态';
comment on column t_wt.insertDate is '日期';
--你问我答表加注释
comment on table t_wt is '你问我答';
oracle特有，对应序列如下：
create sequence s_t_bjjj;
create sequence s_t_bjxc;
create sequence s_t_bjxw;
create sequence s_t_bjzy;
create sequence s_t_gg;
create sequence s_t_lyb;
create sequence s_t_student;
create sequence s_t_tp;
create sequence s_t_tplist;
create sequence s_t_txl;
create sequence s_t_wt;
班级网站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_bjjj(
id int identity(1,1) primary key not null,--主键
content varchar(100)--班级简介
);
班级相册表创建语句如下：
--班级相册表注释
create table t_bjxc(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
types varchar(100),--类别
title varchar(100),--标题
pic varchar(100)--图片
);
班级新闻表创建语句如下：
--班级新闻表注释
create table t_bjxw(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100)--内容
);
班级资源表创建语句如下：
--班级资源表注释
create table t_bjzy(
id int identity(1,1) primary key not null,--主键
types varchar(100),--类别
title varchar(100),--标题
url varchar(100),--资源
content varchar(100),--内容
remark varchar(100)--备注
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
showDate datetime--日期
);
留言板表创建语句如下：
--留言板表注释
create table t_lyb(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
title varchar(100),--标题
content varchar(100),--内容
insertDate datetime--留言日期
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
pic varchar(100),--头像
xh varchar(100),--学号
xx varchar(100),--学校
bj varchar(100),--班级
rzzw varchar(100),--任职职位
yx varchar(100),--院系
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
投票表创建语句如下：
--投票表注释
create table t_tp(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
title varchar(100),--投票主题
pic varchar(100),--图片
content varchar(100),--内容
status varchar(100),--状态
insertDate datetime--日期
);
投票记录表创建语句如下：
--投票记录表注释
create table t_tplist(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
insertDate datetime,--日期
tpId int--投票
);
通讯录表创建语句如下：
--通讯录表注释
create table t_txl(
id int identity(1,1) primary key not null,--主键
xm varchar(100),--姓名
zz varchar(100),--家庭住址
dh varchar(100)--电话
);
你问我答表创建语句如下：
--你问我答表注释
create table t_wt(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
hd varchar(100),--回答答案
status varchar(100),--状态
insertDate datetime--日期
);
登录后主页.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_bjjj")
public class Bjjj {
//主键
@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 content;
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}班级相册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_bjxc")
public class Bjxc {
//主键
@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 studentId;
//类别
private String types;
//标题
private String title;
//图片
private String pic;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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;}
}班级新闻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_bjxw")
public class Bjxw {
//主键
@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 content;
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
}班级资源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_bjzy")
public class Bjzy {
//主键
@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 types;
//标题
private String title;
//资源
private String url;
//内容
private String content;
//备注
private String remark;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_gg")
public class Gg {
//主键
@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 content;
//日期
private Date 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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date 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_lyb")
public class Lyb {
//主键
@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 studentId;
//标题
private String title;
//内容
private String content;
//留言日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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_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 pic;
//学号
private String xh;
//学校
private String xx;
//班级
private String bj;
//任职职位
private String rzzw;
//院系
private String yx;
//电话
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getRzzw() {return rzzw;}
public void setRzzw(String rzzw) {this.rzzw = rzzw;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
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_tp")
public class Tp {
//主键
@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 studentId;
//投票主题
private String title;
//图片
private String pic;
//内容
private String content;
//状态
private String status;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 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 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_tplist")
public class Tplist {
//主键
@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 studentId;
//日期
private Date insertDate;
//投票
private Integer tpId;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getTpId() {return tpId;}
public void setTpId(Integer tpId) {this.tpId = tpId;}
}通讯录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_txl")
public class Txl {
//主键
@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 xm;
//家庭住址
private String zz;
//电话
private String dh;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
}你问我答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_wt")
public class Wt {
//主键
@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 studentId;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//回答答案
private String hd;
//状态
private String status;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getHd() {return hd;}
public void setHd(String hd) {this.hd = hd;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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 Bjjj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级简介
private String content;
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}班级相册javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级相册
public class Bjxc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//类别
private String types;
//标题
private String title;
//图片
private String pic;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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;}
}班级新闻javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级新闻
public class Bjxw 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 content;
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
}班级资源javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级资源
public class Bjzy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类别
private String types;
//标题
private String title;
//资源
private String url;
//内容
private String content;
//备注
private String remark;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Gg 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 content;
//日期
private Date 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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}留言板javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言板
public class Lyb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//标题
private String title;
//内容
private String content;
//留言日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 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 pic;
//学号
private String xh;
//学校
private String xx;
//班级
private String bj;
//任职职位
private String rzzw;
//院系
private String yx;
//电话
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getRzzw() {return rzzw;}
public void setRzzw(String rzzw) {this.rzzw = rzzw;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
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 Tp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//投票主题
private String title;
//图片
private String pic;
//内容
private String content;
//状态
private String status;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 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 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 Tplist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//日期
private Date insertDate;
//投票
private Integer tpId;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getTpId() {return tpId;}
public void setTpId(Integer tpId) {this.tpId = tpId;}
}通讯录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通讯录
public class Txl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String xm;
//家庭住址
private String zz;
//电话
private String dh;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
}你问我答javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//你问我答
public class Wt extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//回答答案
private String hd;
//状态
private String status;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getHd() {return hd;}
public void setHd(String hd) {this.hd = hd;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}