学生就业信息共享平台(job_student_system),javaweb课程设计

学生就业信息共享平台登录注册界面

学生就业信息共享平台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_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	name varchar(100) comment '姓名',
	phone varchar(100) comment '手机',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	address varchar(100) comment '家庭住址',
	idcard varchar(100) comment '身份证',
	insertDate datetime comment '入库日期',
	headPic varchar(100) comment ''
) comment '用户';

简历表创建语句如下:


create table t_jl(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	jobId int comment '职位',
	v1 varchar(100) comment '姓名',
	v2 varchar(100) comment '电话',
	v3 varchar(100) comment '年龄',
	v4 varchar(100) comment '工作经验',
	v5 varchar(100) comment '获奖经历',
	v6 varchar(100) comment '特长',
	v7 varchar(100) comment '自我评价',
	jianli varchar(100) comment '简历附件',
	insertDate datetime comment '投递时间',
	status varchar(100) comment '状态',
	remark varchar(100) comment '审核描述',
	isms varchar(100) comment '面试邀约',
	msjg varchar(100) comment '面试结果',
	shr varchar(100) comment '审核人',
	ztpj varchar(100) comment '总体评价'
) comment '简历';

工作岗位表创建语句如下:


create table t_job(
	id int primary key auto_increment comment '主键',
	jobName varchar(100) comment '职位名称',
	v2 varchar(100) comment '招聘地点',
	v3 varchar(100) comment '工作类型',
	v4 varchar(100) comment '职位要求',
	v5 varchar(100) comment '薪资等级',
	v6 varchar(100) comment '福利待遇',
	v7 varchar(100) comment '日期'
) comment '工作岗位';

表创建语句如下:


create table t_xw(
	id int primary key auto_increment comment '主键',
	xwName varchar(100) comment '新闻标题',
	xwPic varchar(100) comment '新闻图片',
	xwContent varchar(100) comment '新闻内容',
	xwDate varchar(100) 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	name varchar(100),
	phone varchar(100),
	sex varchar(100),
	age varchar(100),
	address varchar(100),
	idcard varchar(100),
	insertDate datetime,
	headPic varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.name is '姓名';
comment on column t_customer.phone is '手机';
comment on column t_customer.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.address is '家庭住址';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.insertDate is '入库日期';
comment on column t_customer.headPic is '';
--用户表加注释
comment on table t_customer is '用户';

简历表创建语句如下:


create table t_jl(
	id integer,
	customerId int,
	jobId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100),
	jianli varchar(100),
	insertDate datetime,
	status varchar(100),
	remark varchar(100),
	isms varchar(100),
	msjg varchar(100),
	shr varchar(100),
	ztpj varchar(100)
);
--简历字段加注释
comment on column t_jl.id is '主键';
comment on column t_jl.customerId is '用户';
comment on column t_jl.jobId is '职位';
comment on column t_jl.v1 is '姓名';
comment on column t_jl.v2 is '电话';
comment on column t_jl.v3 is '年龄';
comment on column t_jl.v4 is '工作经验';
comment on column t_jl.v5 is '获奖经历';
comment on column t_jl.v6 is '特长';
comment on column t_jl.v7 is '自我评价';
comment on column t_jl.jianli is '简历附件';
comment on column t_jl.insertDate is '投递时间';
comment on column t_jl.status is '状态';
comment on column t_jl.remark is '审核描述';
comment on column t_jl.isms is '面试邀约';
comment on column t_jl.msjg is '面试结果';
comment on column t_jl.shr is '审核人';
comment on column t_jl.ztpj is '总体评价';
--简历表加注释
comment on table t_jl is '简历';

工作岗位表创建语句如下:


create table t_job(
	id integer,
	jobName varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100)
);
--工作岗位字段加注释
comment on column t_job.id is '主键';
comment on column t_job.jobName is '职位名称';
comment on column t_job.v2 is '招聘地点';
comment on column t_job.v3 is '工作类型';
comment on column t_job.v4 is '职位要求';
comment on column t_job.v5 is '薪资等级';
comment on column t_job.v6 is '福利待遇';
comment on column t_job.v7 is '日期';
--工作岗位表加注释
comment on table t_job is '工作岗位';

表创建语句如下:


create table t_xw(
	id integer,
	xwName varchar(100),
	xwPic varchar(100),
	xwContent varchar(100),
	xwDate varchar(100)
);
--字段加注释
comment on column t_xw.id is '主键';
comment on column t_xw.xwName is '新闻标题';
comment on column t_xw.xwPic is '新闻图片';
comment on column t_xw.xwContent is '新闻内容';
comment on column t_xw.xwDate is '新闻日期';
--表加注释
comment on table t_xw is '';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_jl;
create sequence s_t_job;
create sequence s_t_xw;

学生就业信息共享平台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_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	name varchar(100),--姓名
	phone varchar(100),--手机
	sex varchar(100),--性别
	age varchar(100),--年龄
	address varchar(100),--家庭住址
	idcard varchar(100),--身份证
	insertDate datetime,--入库日期
	headPic varchar(100)--
);

简历表创建语句如下:


--简历表注释
create table t_jl(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	jobId int,--职位
	v1 varchar(100),--姓名
	v2 varchar(100),--电话
	v3 varchar(100),--年龄
	v4 varchar(100),--工作经验
	v5 varchar(100),--获奖经历
	v6 varchar(100),--特长
	v7 varchar(100),--自我评价
	jianli varchar(100),--简历附件
	insertDate datetime,--投递时间
	status varchar(100),--状态
	remark varchar(100),--审核描述
	isms varchar(100),--面试邀约
	msjg varchar(100),--面试结果
	shr varchar(100),--审核人
	ztpj varchar(100)--总体评价
);

工作岗位表创建语句如下:


--工作岗位表注释
create table t_job(
	id int identity(1,1) primary key not null,--主键
	jobName varchar(100),--职位名称
	v2 varchar(100),--招聘地点
	v3 varchar(100),--工作类型
	v4 varchar(100),--职位要求
	v5 varchar(100),--薪资等级
	v6 varchar(100),--福利待遇
	v7 varchar(100)--日期
);

表创建语句如下:


--表注释
create table t_xw(
	id int identity(1,1) primary key not null,--主键
	xwName varchar(100),--新闻标题
	xwPic varchar(100),--新闻图片
	xwContent varchar(100),--新闻内容
	xwDate varchar(100)--新闻日期
);

学生就业信息共享平台登录后主页

学生就业信息共享平台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_customer")
public class Customer {
//主键
@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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//
private String headPic;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}

简历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_jl")
public class Jl {
//主键
@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 customerId;
//职位
private Integer jobId;
//姓名
private String v1;
//电话
private String v2;
//年龄
private String v3;
//工作经验
private String v4;
//获奖经历
private String v5;
//特长
private String v6;
//自我评价
private String v7;
//简历附件
private String jianli;
//投递时间
private Date insertDate;
//状态
private String status;
//审核描述
private String remark;
//面试邀约
private String isms;
//面试结果
private String msjg;
//审核人
private String shr;
//总体评价
private String ztpj;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJobId() {return jobId;}
public void setJobId(Integer jobId) {this.jobId = jobId;}
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 String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getJianli() {return jianli;}
public void setJianli(String jianli) {this.jianli = jianli;}
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;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getIsms() {return isms;}
public void setIsms(String isms) {this.isms = isms;}
public String getMsjg() {return msjg;}
public void setMsjg(String msjg) {this.msjg = msjg;}
public String getShr() {return shr;}
public void setShr(String shr) {this.shr = shr;}
public String getZtpj() {return ztpj;}
public void setZtpj(String ztpj) {this.ztpj = ztpj;}
}

工作岗位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_job")
public class Job {
//主键
@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 jobName;
//招聘地点
private String v2;
//工作类型
private String v3;
//职位要求
private String v4;
//薪资等级
private String v5;
//福利待遇
private String v6;
//日期
private String v7;
public String getJobName() {return jobName;}
public void setJobName(String jobName) {this.jobName = jobName;}
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 String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

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_xw")
public class Xw {
//主键
@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 xwName;
//新闻图片
private String xwPic;
//新闻内容
private String xwContent;
//新闻日期
private String xwDate;
public String getXwName() {return xwName;}
public void setXwName(String xwName) {this.xwName = xwName;}
public String getXwPic() {return xwPic;}
public void setXwPic(String xwPic) {this.xwPic = xwPic;}
public String getXwContent() {return xwContent;}
public void setXwContent(String xwContent) {this.xwContent = xwContent;}
public String getXwDate() {return xwDate;}
public void setXwDate(String xwDate) {this.xwDate = xwDate;}
}

学生就业信息共享平台spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

用户javaBean创建语句如下:


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

//用户
public class Customer  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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//
private String headPic;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}

简历javaBean创建语句如下:


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

//简历
public class Jl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//职位
private Integer jobId;
//姓名
private String v1;
//电话
private String v2;
//年龄
private String v3;
//工作经验
private String v4;
//获奖经历
private String v5;
//特长
private String v6;
//自我评价
private String v7;
//简历附件
private String jianli;
//投递时间
private Date insertDate;
//状态
private String status;
//审核描述
private String remark;
//面试邀约
private String isms;
//面试结果
private String msjg;
//审核人
private String shr;
//总体评价
private String ztpj;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJobId() {return jobId;}
public void setJobId(Integer jobId) {this.jobId = jobId;}
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 String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getJianli() {return jianli;}
public void setJianli(String jianli) {this.jianli = jianli;}
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;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getIsms() {return isms;}
public void setIsms(String isms) {this.isms = isms;}
public String getMsjg() {return msjg;}
public void setMsjg(String msjg) {this.msjg = msjg;}
public String getShr() {return shr;}
public void setShr(String shr) {this.shr = shr;}
public String getZtpj() {return ztpj;}
public void setZtpj(String ztpj) {this.ztpj = ztpj;}
}

工作岗位javaBean创建语句如下:


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

//工作岗位
public class Job  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//职位名称
private String jobName;
//招聘地点
private String v2;
//工作类型
private String v3;
//职位要求
private String v4;
//薪资等级
private String v5;
//福利待遇
private String v6;
//日期
private String v7;
public String getJobName() {return jobName;}
public void setJobName(String jobName) {this.jobName = jobName;}
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 String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

javaBean创建语句如下:


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

//
public class Xw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//新闻标题
private String xwName;
//新闻图片
private String xwPic;
//新闻内容
private String xwContent;
//新闻日期
private String xwDate;
public String getXwName() {return xwName;}
public void setXwName(String xwName) {this.xwName = xwName;}
public String getXwPic() {return xwPic;}
public void setXwPic(String xwPic) {this.xwPic = xwPic;}
public String getXwContent() {return xwContent;}
public void setXwContent(String xwContent) {this.xwContent = xwContent;}
public String getXwDate() {return xwDate;}
public void setXwDate(String xwDate) {this.xwDate = xwDate;}
}

评论