- 日常事务管理系统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 '班级',
fdls varchar(100) comment '辅导老师',
zy varchar(100) comment '专业'
) comment '班级';
成绩表创建语句如下：
create table t_cj(
id int primary key auto_increment comment '主键',
title varchar(100) comment '',
fenshu int comment '成绩',
jd int comment '绩点',
studentId int comment '学生'
) comment '成绩';
计划安排表创建语句如下：
create table t_jihua(
id int primary key auto_increment comment '主键',
title varchar(100) comment '计划标题',
showDate datetime comment '日期',
content text comment '详细内容',
studentId int comment '学生'
) comment '计划安排';
留言表创建语句如下：
create table t_liuyan(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
insertDate datetime comment '日期',
content text comment '内容',
status varchar(100) comment '状态',
back text comment '回复',
studentId int comment '学生'
) comment '留言';
收入支出表创建语句如下：
create table t_srzc(
id int primary key auto_increment comment '主键',
title varchar(100) comment '收入支出说明',
lx varchar(100) comment '',
showDate datetime comment '操作日期',
content text comment '详细内容',
studentId int 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_tongzhi(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
insertDate datetime comment '日期',
content text comment '内容'
) comment '通知公告';
通讯录表创建语句如下：
create table t_txl(
id int primary key auto_increment comment '主键',
xm varchar(100) comment '姓名',
phone varchar(100) comment '电话',
address varchar(100) comment '地址',
pic varchar(100) comment '图片',
fl varchar(100) comment '',
studentId int 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),
fdls varchar(100),
zy varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
comment on column t_bj.fdls is '辅导老师';
comment on column t_bj.zy is '专业';
--班级表加注释
comment on table t_bj is '班级';
成绩表创建语句如下：
create table t_cj(
id integer,
title varchar(100),
fenshu int,
jd int,
studentId int
);
--成绩字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.title is '';
comment on column t_cj.fenshu is '成绩';
comment on column t_cj.jd is '绩点';
comment on column t_cj.studentId is '学生';
--成绩表加注释
comment on table t_cj is '成绩';
计划安排表创建语句如下：
create table t_jihua(
id integer,
title varchar(100),
showDate datetime,
content text,
studentId int
);
--计划安排字段加注释
comment on column t_jihua.id is '主键';
comment on column t_jihua.title is '计划标题';
comment on column t_jihua.showDate is '日期';
comment on column t_jihua.content is '详细内容';
comment on column t_jihua.studentId is '学生';
--计划安排表加注释
comment on table t_jihua is '计划安排';
留言表创建语句如下：
create table t_liuyan(
id integer,
title varchar(100),
insertDate datetime,
content text,
status varchar(100),
back text,
studentId int
);
--留言字段加注释
comment on column t_liuyan.id is '主键';
comment on column t_liuyan.title is '标题';
comment on column t_liuyan.insertDate is '日期';
comment on column t_liuyan.content is '内容';
comment on column t_liuyan.status is '状态';
comment on column t_liuyan.back is '回复';
comment on column t_liuyan.studentId is '学生';
--留言表加注释
comment on table t_liuyan is '留言';
收入支出表创建语句如下：
create table t_srzc(
id integer,
title varchar(100),
lx varchar(100),
showDate datetime,
content text,
studentId int
);
--收入支出字段加注释
comment on column t_srzc.id is '主键';
comment on column t_srzc.title is '收入支出说明';
comment on column t_srzc.lx is '';
comment on column t_srzc.showDate is '操作日期';
comment on column t_srzc.content is '详细内容';
comment on column t_srzc.studentId is '学生';
--收入支出表加注释
comment on table t_srzc 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_tongzhi(
id integer,
title varchar(100),
insertDate datetime,
content text
);
--通知公告字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.insertDate is '日期';
comment on column t_tongzhi.content is '内容';
--通知公告表加注释
comment on table t_tongzhi is '通知公告';
通讯录表创建语句如下：
create table t_txl(
id integer,
xm varchar(100),
phone varchar(100),
address varchar(100),
pic varchar(100),
fl varchar(100),
studentId int
);
--通讯录字段加注释
comment on column t_txl.id is '主键';
comment on column t_txl.xm is '姓名';
comment on column t_txl.phone is '电话';
comment on column t_txl.address is '地址';
comment on column t_txl.pic is '图片';
comment on column t_txl.fl is '';
comment on column t_txl.studentId is '学生';
--通讯录表加注释
comment on table t_txl is '通讯录';
oracle特有，对应序列如下：
create sequence s_t_bj;
create sequence s_t_cj;
create sequence s_t_jihua;
create sequence s_t_liuyan;
create sequence s_t_srzc;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_tongzhi;
create sequence s_t_txl;
日常事务管理系统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),--班级
fdls varchar(100),--辅导老师
zy varchar(100)--专业
);
成绩表创建语句如下：
--成绩表注释
create table t_cj(
id int identity(1,1) primary key not null,--主键
title varchar(100),--
fenshu int,--成绩
jd int,--绩点
studentId int--学生
);
计划安排表创建语句如下：
--计划安排表注释
create table t_jihua(
id int identity(1,1) primary key not null,--主键
title varchar(100),--计划标题
showDate datetime,--日期
content text,--详细内容
studentId int--学生
);
留言表创建语句如下：
--留言表注释
create table t_liuyan(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
insertDate datetime,--日期
content text,--内容
status varchar(100),--状态
back text,--回复
studentId int--学生
);
收入支出表创建语句如下：
--收入支出表注释
create table t_srzc(
id int identity(1,1) primary key not null,--主键
title varchar(100),--收入支出说明
lx varchar(100),--
showDate datetime,--操作日期
content text,--详细内容
studentId int--学生
);
学生表创建语句如下：
--学生表注释
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_tongzhi(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
insertDate datetime,--日期
content text--内容
);
通讯录表创建语句如下：
--通讯录表注释
create table t_txl(
id int identity(1,1) primary key not null,--主键
xm varchar(100),--姓名
phone varchar(100),--电话
address varchar(100),--地址
pic varchar(100),--图片
fl varchar(100),--
studentId int--学生
);
登录后主页.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;
//辅导老师
private String fdls;
//专业
private String zy;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getFdls() {return fdls;}
public void setFdls(String fdls) {this.fdls = fdls;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}成绩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_cj")
public class Cj {
//主键
@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 Integer fenshu;
//绩点
private Integer jd;
//学生
private Long studentId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFenshu() {return fenshu;}
public void setFenshu(Integer fenshu) {this.fenshu = fenshu;}
public Integer getJd() {return jd;}
public void setJd(Integer jd) {this.jd = jd;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}计划安排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_jihua")
public class Jihua {
//主键
@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 Date showDate;
//详细内容
private String content;
//学生
private Long studentId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}留言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_liuyan")
public class Liuyan {
//主键
@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 Date insertDate;
//内容
private String content;
//状态
private String status;
//回复
private String back;
//学生
private Long studentId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}收入支出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_srzc")
public class Srzc {
//主键
@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 lx;
//操作日期
private Date showDate;
//详细内容
private String content;
//学生
private Long studentId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}学生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_tongzhi")
public class Tongzhi {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//日期
private Date insertDate;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_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 phone;
//地址
private String address;
//图片
private String pic;
//
private String fl;
//学生
private Long studentId;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFl() {return fl;}
public void setFl(String fl) {this.fl = fl;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}日常事务管理系统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;
//辅导老师
private String fdls;
//专业
private String zy;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getFdls() {return fdls;}
public void setFdls(String fdls) {this.fdls = fdls;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}成绩javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//成绩
public class Cj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String title;
//成绩
private Integer fenshu;
//绩点
private Integer jd;
//学生
private Long studentId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFenshu() {return fenshu;}
public void setFenshu(Integer fenshu) {this.fenshu = fenshu;}
public Integer getJd() {return jd;}
public void setJd(Integer jd) {this.jd = jd;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}计划安排javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//计划安排
public class Jihua extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//计划标题
private String title;
//日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//详细内容
private String content;
//学生
private Long studentId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}留言javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言
public class Liuyan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//日期
private Date insertDate;
//内容
private String content;
//状态
private String status;
//回复
private String back;
//学生
private Long studentId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}收入支出javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//收入支出
public class Srzc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//收入支出说明
private String title;
//
private String lx;
//操作日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//详细内容
private String content;
//学生
private Long studentId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}学生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;
//
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}通知公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通知公告
public class Tongzhi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//日期
private Date insertDate;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Txl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String xm;
//电话
private String phone;
//地址
private String address;
//图片
private String pic;
//
private String fl;
//学生
private Long studentId;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFl() {return fl;}
public void setFl(String fl) {this.fl = fl;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
}