基于SSM的教师业务数据填报系统,javaweb课程设计

基于SSM的教师业务数据填报系统登录注册界面

基于SSM的教师业务数据填报系统mysql数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '超级管理员账号',
	password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');

表单表创建语句如下:


create table t_bd(
	id int primary key auto_increment comment '主键',
	bdName varchar(100) comment '表单名称',
	lb varchar(100) comment '类别',
	js varchar(100) comment '角色',
	pic varchar(100) comment '图片',
	status varchar(100) comment '状态'
) comment '表单';

表单列表表创建语句如下:


create table t_bdlist(
	id int primary key auto_increment comment '主键',
	bdId int comment '表单',
	bdlName varchar(100) comment '名称'
) comment '表单列表';

填写表单记录列表表创建语句如下:


create table t_bdlisttx(
	id int primary key auto_increment comment '主键',
	bdtxId int comment '表单填写',
	bdltxName varchar(100) comment '填写的值'
) comment '填写表单记录列表';

填写表单记录表创建语句如下:


create table t_bdtx(
	id int primary key auto_increment comment '主键',
	bdId int comment '表单',
	yhId int comment '用户',
	insertDate datetime comment '时间'
) comment '填写表单记录';

部门表创建语句如下:


create table t_dept(
	id int primary key auto_increment comment '主键',
	deptName varchar(100) comment '部门名称'
) comment '部门';

访问日志表创建语句如下:


create table t_log(
	id int primary key auto_increment comment '主键',
	insertDate datetime comment '',
	types varchar(100) comment ''
) comment '访问日志';

员工表创建语句如下:


create table t_yg(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ygName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	deptId int comment '部门',
	js varchar(100) comment '角色'
) comment '员工';

用户表创建语句如下:


create table t_yh(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	yhName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '用户';

基于SSM的教师业务数据填报系统oracle数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

表单表创建语句如下:


create table t_bd(
	id integer,
	bdName varchar(100),
	lb varchar(100),
	js varchar(100),
	pic varchar(100),
	status varchar(100)
);
--表单字段加注释
comment on column t_bd.id is '主键';
comment on column t_bd.bdName is '表单名称';
comment on column t_bd.lb is '类别';
comment on column t_bd.js is '角色';
comment on column t_bd.pic is '图片';
comment on column t_bd.status is '状态';
--表单表加注释
comment on table t_bd is '表单';

表单列表表创建语句如下:


create table t_bdlist(
	id integer,
	bdId int,
	bdlName varchar(100)
);
--表单列表字段加注释
comment on column t_bdlist.id is '主键';
comment on column t_bdlist.bdId is '表单';
comment on column t_bdlist.bdlName is '名称';
--表单列表表加注释
comment on table t_bdlist is '表单列表';

填写表单记录列表表创建语句如下:


create table t_bdlisttx(
	id integer,
	bdtxId int,
	bdltxName varchar(100)
);
--填写表单记录列表字段加注释
comment on column t_bdlisttx.id is '主键';
comment on column t_bdlisttx.bdtxId is '表单填写';
comment on column t_bdlisttx.bdltxName is '填写的值';
--填写表单记录列表表加注释
comment on table t_bdlisttx is '填写表单记录列表';

填写表单记录表创建语句如下:


create table t_bdtx(
	id integer,
	bdId int,
	yhId int,
	insertDate datetime
);
--填写表单记录字段加注释
comment on column t_bdtx.id is '主键';
comment on column t_bdtx.bdId is '表单';
comment on column t_bdtx.yhId is '用户';
comment on column t_bdtx.insertDate is '时间';
--填写表单记录表加注释
comment on table t_bdtx is '填写表单记录';

部门表创建语句如下:


create table t_dept(
	id integer,
	deptName varchar(100)
);
--部门字段加注释
comment on column t_dept.id is '主键';
comment on column t_dept.deptName is '部门名称';
--部门表加注释
comment on table t_dept is '部门';

访问日志表创建语句如下:


create table t_log(
	id integer,
	insertDate datetime,
	types varchar(100)
);
--访问日志字段加注释
comment on column t_log.id is '主键';
comment on column t_log.insertDate is '';
comment on column t_log.types is '';
--访问日志表加注释
comment on table t_log is '访问日志';

员工表创建语句如下:


create table t_yg(
	id integer,
	username varchar(100),
	password varchar(100),
	ygName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	deptId int,
	js varchar(100)
);
--员工字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.username is '账号';
comment on column t_yg.password is '密码';
comment on column t_yg.ygName is '姓名';
comment on column t_yg.age is '年龄';
comment on column t_yg.sex is '性别';
comment on column t_yg.phone is '电话';
comment on column t_yg.deptId is '部门';
comment on column t_yg.js is '角色';
--员工表加注释
comment on table t_yg is '员工';

用户表创建语句如下:


create table t_yh(
	id integer,
	username varchar(100),
	password varchar(100),
	yhName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--用户字段加注释
comment on column t_yh.id is '主键';
comment on column t_yh.username is '账号';
comment on column t_yh.password is '密码';
comment on column t_yh.yhName is '姓名';
comment on column t_yh.age is '年龄';
comment on column t_yh.sex is '性别';
comment on column t_yh.phone is '电话';
--用户表加注释
comment on table t_yh is '用户';

oracle特有,对应序列如下:


create sequence s_t_bd;
create sequence s_t_bdlist;
create sequence s_t_bdlisttx;
create sequence s_t_bdtx;
create sequence s_t_dept;
create sequence s_t_log;
create sequence s_t_yg;
create sequence s_t_yh;

基于SSM的教师业务数据填报系统sqlserver数据库版本源码:

超级管理员表创建语句如下:


--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

表单表创建语句如下:


--表单表注释
create table t_bd(
	id int identity(1,1) primary key not null,--主键
	bdName varchar(100),--表单名称
	lb varchar(100),--类别
	js varchar(100),--角色
	pic varchar(100),--图片
	status varchar(100)--状态
);

表单列表表创建语句如下:


--表单列表表注释
create table t_bdlist(
	id int identity(1,1) primary key not null,--主键
	bdId int,--表单
	bdlName varchar(100)--名称
);

填写表单记录列表表创建语句如下:


--填写表单记录列表表注释
create table t_bdlisttx(
	id int identity(1,1) primary key not null,--主键
	bdtxId int,--表单填写
	bdltxName varchar(100)--填写的值
);

填写表单记录表创建语句如下:


--填写表单记录表注释
create table t_bdtx(
	id int identity(1,1) primary key not null,--主键
	bdId int,--表单
	yhId int,--用户
	insertDate datetime--时间
);

部门表创建语句如下:


--部门表注释
create table t_dept(
	id int identity(1,1) primary key not null,--主键
	deptName varchar(100)--部门名称
);

访问日志表创建语句如下:


--访问日志表注释
create table t_log(
	id int identity(1,1) primary key not null,--主键
	insertDate datetime,--
	types varchar(100)--
);

员工表创建语句如下:


--员工表注释
create table t_yg(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ygName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	deptId int,--部门
	js varchar(100)--角色
);

用户表创建语句如下:


--用户表注释
create table t_yh(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	yhName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

基于SSM的教师业务数据填报系统登录后主页

基于SSM的教师业务数据填报系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

表单javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//表单
@Table(name = "t_bd")
public class Bd {
//主键
@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 bdName;
//类别
private String lb;
//角色
private String js;
//图片
private String pic;
//状态
private String status;
public String getBdName() {return bdName;}
public void setBdName(String bdName) {this.bdName = bdName;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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_bdlist")
public class Bdlist {
//主键
@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 bdId;
//名称
private String bdlName;
public Integer getBdId() {return bdId;}
public void setBdId(Integer bdId) {this.bdId = bdId;}
public String getBdlName() {return bdlName;}
public void setBdlName(String bdlName) {this.bdlName = bdlName;}
}

填写表单记录列表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_bdlisttx")
public class Bdlisttx {
//主键
@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 bdtxId;
//填写的值
private String bdltxName;
public Integer getBdtxId() {return bdtxId;}
public void setBdtxId(Integer bdtxId) {this.bdtxId = bdtxId;}
public String getBdltxName() {return bdltxName;}
public void setBdltxName(String bdltxName) {this.bdltxName = bdltxName;}
}

填写表单记录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_bdtx")
public class Bdtx {
//主键
@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 bdId;
//用户
private Integer yhId;
//时间
private Date insertDate;
public Integer getBdId() {return bdId;}
public void setBdId(Integer bdId) {this.bdId = bdId;}
public Integer getYhId() {return yhId;}
public void setYhId(Integer yhId) {this.yhId = yhId;}
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_dept")
public class Dept {
//主键
@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 deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}

访问日志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_log")
public class Log {
//主键
@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 Date insertDate;
//
private String types;
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}

员工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_yg")
public class Yg {
//主键
@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 ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//部门
private Integer deptId;
//角色
private String js;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}

用户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_yh")
public class Yh {
//主键
@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 yhName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getYhName() {return yhName;}
public void setYhName(String yhName) {this.yhName = yhName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

基于SSM的教师业务数据填报系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

表单javaBean创建语句如下:


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

//表单
public class Bd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//表单名称
private String bdName;
//类别
private String lb;
//角色
private String js;
//图片
private String pic;
//状态
private String status;
public String getBdName() {return bdName;}
public void setBdName(String bdName) {this.bdName = bdName;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 Bdlist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//表单
private Integer bdId;
//名称
private String bdlName;
public Integer getBdId() {return bdId;}
public void setBdId(Integer bdId) {this.bdId = bdId;}
public String getBdlName() {return bdlName;}
public void setBdlName(String bdlName) {this.bdlName = bdlName;}
}

填写表单记录列表javaBean创建语句如下:


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

//填写表单记录列表
public class Bdlisttx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//表单填写
private Integer bdtxId;
//填写的值
private String bdltxName;
public Integer getBdtxId() {return bdtxId;}
public void setBdtxId(Integer bdtxId) {this.bdtxId = bdtxId;}
public String getBdltxName() {return bdltxName;}
public void setBdltxName(String bdltxName) {this.bdltxName = bdltxName;}
}

填写表单记录javaBean创建语句如下:


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

//填写表单记录
public class Bdtx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//表单
private Integer bdId;
//用户
private Integer yhId;
//时间
private Date insertDate;
public Integer getBdId() {return bdId;}
public void setBdId(Integer bdId) {this.bdId = bdId;}
public Integer getYhId() {return yhId;}
public void setYhId(Integer yhId) {this.yhId = yhId;}
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 Dept  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门名称
private String deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}

访问日志javaBean创建语句如下:


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

//访问日志
public class Log  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Date insertDate;
//
private String types;
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}

员工javaBean创建语句如下:


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

//员工
public class Yg  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 ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//部门
private Integer deptId;
//角色
private String js;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}

用户javaBean创建语句如下:


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

//用户
public class Yh  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 yhName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getYhName() {return yhName;}
public void setYhName(String yhName) {this.yhName = yhName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

源代码下载点这里

评论