jsp新生报到系统(new_student_system),java专业毕业设计

jsp新生报到系统登录注册界面

jsp新生报到系统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_gy(
	id int primary key auto_increment comment '主键',
	gyName varchar(100) comment '宿舍'
) comment '公寓宿舍';

缴费表创建语句如下:


create table t_jf(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	status varchar(100) comment '是否缴费',
	jfDate varchar(100) comment '缴费日期'
) comment '缴费';

表创建语句如下:


create table t_lt(
	id int primary key auto_increment comment '主键',
	studentId int comment '',
	toId int comment '',
	content varchar(100) comment '内容',
	only varchar(100) comment ''
) comment '';

信息表创建语句如下:


create table t_message(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	v1 varchar(100) comment '内容',
	insertDate datetime comment '日期',
	status 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	bjId int comment '班级',
	gyId int comment '宿舍',
	ishd varchar(100) comment '信息是否核对',
	iszc varchar(100) comment '是否注册'
) comment '学生';

体检表创建语句如下:


create table t_tj(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	status varchar(100) comment '是否体检',
	tjDate varchar(100) comment '体检日期',
	tjPic varchar(100) comment '体检拍照'
) comment '体检';

体检报名表创建语句如下:


create table t_tjbm(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	v1 varchar(100) comment '姓名',
	v2 varchar(100) comment '性别',
	v3 varchar(100) comment '院系',
	v4 varchar(100) comment '专业班级',
	insertDate datetime comment '日期'
) comment '体检报名';

jsp新生报到系统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_gy(
	id integer,
	gyName varchar(100)
);
--公寓宿舍字段加注释
comment on column t_gy.id is '主键';
comment on column t_gy.gyName is '宿舍';
--公寓宿舍表加注释
comment on table t_gy is '公寓宿舍';

缴费表创建语句如下:


create table t_jf(
	id integer,
	studentId int,
	status varchar(100),
	jfDate varchar(100)
);
--缴费字段加注释
comment on column t_jf.id is '主键';
comment on column t_jf.studentId is '学生';
comment on column t_jf.status is '是否缴费';
comment on column t_jf.jfDate is '缴费日期';
--缴费表加注释
comment on table t_jf is '缴费';

表创建语句如下:


create table t_lt(
	id integer,
	studentId int,
	toId int,
	content varchar(100),
	only varchar(100)
);
--字段加注释
comment on column t_lt.id is '主键';
comment on column t_lt.studentId is '';
comment on column t_lt.toId is '';
comment on column t_lt.content is '内容';
comment on column t_lt.only is '';
--表加注释
comment on table t_lt is '';

信息表创建语句如下:


create table t_message(
	id integer,
	studentId int,
	v1 varchar(100),
	insertDate datetime,
	status varchar(100)
);
--信息字段加注释
comment on column t_message.id is '主键';
comment on column t_message.studentId is '学生';
comment on column t_message.v1 is '内容';
comment on column t_message.insertDate is '日期';
comment on column t_message.status is '状态';
--信息表加注释
comment on table t_message is '信息';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	bjId int,
	gyId int,
	ishd varchar(100),
	iszc 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.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.bjId is '班级';
comment on column t_student.gyId is '宿舍';
comment on column t_student.ishd is '信息是否核对';
comment on column t_student.iszc is '是否注册';
--学生表加注释
comment on table t_student is '学生';

体检表创建语句如下:


create table t_tj(
	id integer,
	studentId int,
	status varchar(100),
	tjDate varchar(100),
	tjPic varchar(100)
);
--体检字段加注释
comment on column t_tj.id is '主键';
comment on column t_tj.studentId is '学生';
comment on column t_tj.status is '是否体检';
comment on column t_tj.tjDate is '体检日期';
comment on column t_tj.tjPic is '体检拍照';
--体检表加注释
comment on table t_tj is '体检';

体检报名表创建语句如下:


create table t_tjbm(
	id integer,
	studentId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	insertDate datetime
);
--体检报名字段加注释
comment on column t_tjbm.id is '主键';
comment on column t_tjbm.studentId is '学生';
comment on column t_tjbm.v1 is '姓名';
comment on column t_tjbm.v2 is '性别';
comment on column t_tjbm.v3 is '院系';
comment on column t_tjbm.v4 is '专业班级';
comment on column t_tjbm.insertDate is '日期';
--体检报名表加注释
comment on table t_tjbm is '体检报名';

oracle特有,对应序列如下:


create sequence s_t_bj;
create sequence s_t_gy;
create sequence s_t_jf;
create sequence s_t_lt;
create sequence s_t_message;
create sequence s_t_student;
create sequence s_t_tj;
create sequence s_t_tjbm;

jsp新生报到系统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_gy(
	id int identity(1,1) primary key not null,--主键
	gyName varchar(100)--宿舍
);

缴费表创建语句如下:


--缴费表注释
create table t_jf(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	status varchar(100),--是否缴费
	jfDate varchar(100)--缴费日期
);

表创建语句如下:


--表注释
create table t_lt(
	id int identity(1,1) primary key not null,--主键
	studentId int,--
	toId int,--
	content varchar(100),--内容
	only varchar(100)--
);

信息表创建语句如下:


--信息表注释
create table t_message(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	v1 varchar(100),--内容
	insertDate datetime,--日期
	status varchar(100)--状态
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--录取通知书编号
	password varchar(100),--身份证号
	studentName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	bjId int,--班级
	gyId int,--宿舍
	ishd varchar(100),--信息是否核对
	iszc varchar(100)--是否注册
);

体检表创建语句如下:


--体检表注释
create table t_tj(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	status varchar(100),--是否体检
	tjDate varchar(100),--体检日期
	tjPic varchar(100)--体检拍照
);

体检报名表创建语句如下:


--体检报名表注释
create table t_tjbm(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	v1 varchar(100),--姓名
	v2 varchar(100),--性别
	v3 varchar(100),--院系
	v4 varchar(100),--专业班级
	insertDate datetime--日期
);

jsp新生报到系统登录后主页

jsp新生报到系统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_gy")
public class Gy {
//主键
@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 gyName;
public String getGyName() {return gyName;}
public void setGyName(String gyName) {this.gyName = gyName;}
}

缴费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_jf")
public class Jf {
//主键
@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 status;
//缴费日期
private String jfDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getJfDate() {return jfDate;}
public void setJfDate(String jfDate) {this.jfDate = jfDate;}
}

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_lt")
public class Lt {
//主键
@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 toId;
//内容
private String content;
//
private String only;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getOnly() {return only;}
public void setOnly(String only) {this.only = only;}
}

信息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_message")
public class Message {
//主键
@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 v1;
//日期
private Date insertDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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_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 age;
//性别
private String sex;
//电话
private String phone;
//班级
private Integer bjId;
//宿舍
private Integer gyId;
//信息是否核对
private String ishd;
//是否注册
private String iszc;
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 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 getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getGyId() {return gyId;}
public void setGyId(Integer gyId) {this.gyId = gyId;}
public String getIshd() {return ishd;}
public void setIshd(String ishd) {this.ishd = ishd;}
public String getIszc() {return iszc;}
public void setIszc(String iszc) {this.iszc = iszc;}
}

体检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_tj")
public class Tj {
//主键
@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 status;
//体检日期
private String tjDate;
//体检拍照
private String tjPic;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getTjDate() {return tjDate;}
public void setTjDate(String tjDate) {this.tjDate = tjDate;}
public String getTjPic() {return tjPic;}
public void setTjPic(String tjPic) {this.tjPic = tjPic;}
}

体检报名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_tjbm")
public class Tjbm {
//主键
@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 v1;
//性别
private String v2;
//院系
private String v3;
//专业班级
private String v4;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

jsp新生报到系统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 Gy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宿舍
private String gyName;
public String getGyName() {return gyName;}
public void setGyName(String gyName) {this.gyName = gyName;}
}

缴费javaBean创建语句如下:


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

//缴费
public class Jf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//是否缴费
private String status;
//缴费日期
private String jfDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getJfDate() {return jfDate;}
public void setJfDate(String jfDate) {this.jfDate = jfDate;}
}

javaBean创建语句如下:


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

//
public class Lt  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer studentId;
//
private Integer toId;
//内容
private String content;
//
private String only;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getOnly() {return only;}
public void setOnly(String only) {this.only = only;}
}

信息javaBean创建语句如下:


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

//信息
public class Message  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//内容
private String v1;
//日期
private Date insertDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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 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 age;
//性别
private String sex;
//电话
private String phone;
//班级
private Integer bjId;
//宿舍
private Integer gyId;
//信息是否核对
private String ishd;
//是否注册
private String iszc;
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 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 getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getGyId() {return gyId;}
public void setGyId(Integer gyId) {this.gyId = gyId;}
public String getIshd() {return ishd;}
public void setIshd(String ishd) {this.ishd = ishd;}
public String getIszc() {return iszc;}
public void setIszc(String iszc) {this.iszc = iszc;}
}

体检javaBean创建语句如下:


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

//体检
public class Tj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//是否体检
private String status;
//体检日期
private String tjDate;
//体检拍照
private String tjPic;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getTjDate() {return tjDate;}
public void setTjDate(String tjDate) {this.tjDate = tjDate;}
public String getTjPic() {return tjPic;}
public void setTjPic(String tjPic) {this.tjPic = tjPic;}
}

体检报名javaBean创建语句如下:


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

//体检报名
public class Tjbm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//姓名
private String v1;
//性别
private String v2;
//院系
private String v3;
//专业班级
private String v4;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

源代码下载点这里

评论