更多成品,定做java毕业设计,请咨询管理员qq:2812491287

学生干部评价系统

学生干部评价系统登录注册界面

学生干部评价系统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_df(
	id int primary key auto_increment comment '主键',
	studentId int comment '干部',
	dfId int comment '打分人',
	fs int comment '分数',
	insertDate datetime comment '日期'
) comment '干部打分';

干部表创建语句如下:


create table t_gb(
	id int primary key auto_increment comment '主键',
	gbName varchar(100) comment '干部名册',
	gbzz varchar(100) comment '干部职责'
) comment '干部';

干部评价表创建语句如下:


create table t_gbpj(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	pjName varchar(100) comment '姓名',
	pic varchar(100) comment '头像',
	conetnt varchar(100) comment '内容',
	insertDate datetime comment '日期'
) comment '干部评价';

干部申请表创建语句如下:


create table t_gbsq(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	gbId int comment '申请干部',
	insertDate datetime comment '日期',
	status varchar(100) comment '状态'
) comment '干部申请';

教务人员表创建语句如下:


create table t_ptadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	ptadminName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) 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 '姓名',
	bjId int comment '班级',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像',
	gbId 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)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
--班级表加注释
comment on table t_bj is '班级';

干部打分表创建语句如下:


create table t_df(
	id integer,
	studentId int,
	dfId int,
	fs int,
	insertDate datetime
);
--干部打分字段加注释
comment on column t_df.id is '主键';
comment on column t_df.studentId is '干部';
comment on column t_df.dfId is '打分人';
comment on column t_df.fs is '分数';
comment on column t_df.insertDate is '日期';
--干部打分表加注释
comment on table t_df is '干部打分';

干部表创建语句如下:


create table t_gb(
	id integer,
	gbName varchar(100),
	gbzz varchar(100)
);
--干部字段加注释
comment on column t_gb.id is '主键';
comment on column t_gb.gbName is '干部名册';
comment on column t_gb.gbzz is '干部职责';
--干部表加注释
comment on table t_gb is '干部';

干部评价表创建语句如下:


create table t_gbpj(
	id integer,
	studentId int,
	pjName varchar(100),
	pic varchar(100),
	conetnt varchar(100),
	insertDate datetime
);
--干部评价字段加注释
comment on column t_gbpj.id is '主键';
comment on column t_gbpj.studentId is '学生';
comment on column t_gbpj.pjName is '姓名';
comment on column t_gbpj.pic is '头像';
comment on column t_gbpj.conetnt is '内容';
comment on column t_gbpj.insertDate is '日期';
--干部评价表加注释
comment on table t_gbpj is '干部评价';

干部申请表创建语句如下:


create table t_gbsq(
	id integer,
	studentId int,
	gbId int,
	insertDate datetime,
	status varchar(100)
);
--干部申请字段加注释
comment on column t_gbsq.id is '主键';
comment on column t_gbsq.studentId is '学生';
comment on column t_gbsq.gbId is '申请干部';
comment on column t_gbsq.insertDate is '日期';
comment on column t_gbsq.status is '状态';
--干部申请表加注释
comment on table t_gbsq is '干部申请';

教务人员表创建语句如下:


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

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	bjId int,
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100),
	gbId 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.bjId is '班级';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.pic is '头像';
comment on column t_student.gbId is '干部';
--学生表加注释
comment on table t_student is '学生';

oracle特有,对应序列如下:


create sequence s_t_bj;
create sequence s_t_df;
create sequence s_t_gb;
create sequence s_t_gbpj;
create sequence s_t_gbsq;
create sequence s_t_ptadmin;
create sequence s_t_student;

学生干部评价系统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_df(
	id int identity(1,1) primary key not null,--主键
	studentId int,--干部
	dfId int,--打分人
	fs int,--分数
	insertDate datetime--日期
);

干部表创建语句如下:


--干部表注释
create table t_gb(
	id int identity(1,1) primary key not null,--主键
	gbName varchar(100),--干部名册
	gbzz varchar(100)--干部职责
);

干部评价表创建语句如下:


--干部评价表注释
create table t_gbpj(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	pjName varchar(100),--姓名
	pic varchar(100),--头像
	conetnt varchar(100),--内容
	insertDate datetime--日期
);

干部申请表创建语句如下:


--干部申请表注释
create table t_gbsq(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	gbId int,--申请干部
	insertDate datetime,--日期
	status varchar(100)--状态
);

教务人员表创建语句如下:


--教务人员表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	ptadminName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--学号
	password varchar(100),--密码 
	studentName varchar(100),--姓名
	bjId int,--班级
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100),--头像
	gbId int--干部
);

学生干部评价系统登录后主页

学生干部评价系统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_df")
public class Df {
//主键
@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 Integer dfId;
//分数
private Integer fs;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getDfId() {return dfId;}
public void setDfId(Integer dfId) {this.dfId = dfId;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
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_gb")
public class Gb {
//主键
@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 gbName;
//干部职责
private String gbzz;
public String getGbName() {return gbName;}
public void setGbName(String gbName) {this.gbName = gbName;}
public String getGbzz() {return gbzz;}
public void setGbzz(String gbzz) {this.gbzz = gbzz;}
}

干部评价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_gbpj")
public class Gbpj {
//主键
@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 pjName;
//头像
private String pic;
//内容
private String conetnt;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getPjName() {return pjName;}
public void setPjName(String pjName) {this.pjName = pjName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getConetnt() {return conetnt;}
public void setConetnt(String conetnt) {this.conetnt = conetnt;}
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_gbsq")
public class Gbsq {
//主键
@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 Integer gbId;
//日期
private Date insertDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getGbId() {return gbId;}
public void setGbId(Integer gbId) {this.gbId = gbId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

教务人员javaBean创建语句如下:


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

//教务人员
@Table(name = "t_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//年龄
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

学生javaBean创建语句如下:


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

//学生
@Table(name = "t_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 Integer bjId;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//干部
private Integer gbId;
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
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 String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getGbId() {return gbId;}
public void setGbId(Integer gbId) {this.gbId = gbId;}
}

学生干部评价系统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 Df  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//干部
private Integer studentId;
//打分人
private Integer dfId;
//分数
private Integer fs;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getDfId() {return dfId;}
public void setDfId(Integer dfId) {this.dfId = dfId;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
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 Gb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//干部名册
private String gbName;
//干部职责
private String gbzz;
public String getGbName() {return gbName;}
public void setGbName(String gbName) {this.gbName = gbName;}
public String getGbzz() {return gbzz;}
public void setGbzz(String gbzz) {this.gbzz = gbzz;}
}

干部评价javaBean创建语句如下:


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

//干部评价
public class Gbpj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//姓名
private String pjName;
//头像
private String pic;
//内容
private String conetnt;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getPjName() {return pjName;}
public void setPjName(String pjName) {this.pjName = pjName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getConetnt() {return conetnt;}
public void setConetnt(String conetnt) {this.conetnt = conetnt;}
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 Gbsq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//申请干部
private Integer gbId;
//日期
private Date insertDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getGbId() {return gbId;}
public void setGbId(Integer gbId) {this.gbId = gbId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

教务人员javaBean创建语句如下:


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

//教务人员
public class Ptadmin  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 ptadminName;
//年龄
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

学生javaBean创建语句如下:


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

//学生
public class 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 Integer bjId;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//干部
private Integer gbId;
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
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 String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getGbId() {return gbId;}
public void setGbId(Integer gbId) {this.gbId = gbId;}
}

评论