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

基于ssm的企业人事管理,java毕业设计项目

基于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_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	bh varchar(100) comment '编号',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	cs varchar(100) comment '出生',
	xl varchar(100) comment '学历',
	sfhy varchar(100) comment '是否婚姻',
	phone varchar(100) comment '电话',
	address varchar(100) comment '住址',
	jtlxr varchar(100) comment '家庭联系人信息',
	rzsj varchar(100) comment '入职时间',
	deptId int comment '部门',
	isfzr varchar(100) comment '是否部门负责人'
) comment '员工';

部门表创建语句如下:


create table t_dept(
	id int primary key auto_increment comment '主键',
	deptName varchar(100) comment '部门名称',
	v1 varchar(100) comment '部门编号',
	v2 varchar(100) comment '部门级别',
	v3 varchar(100) comment '部门职能',
	pDeptId int comment '父级部门'
) comment '部门';

工资表创建语句如下:


create table t_gz(
	id int primary key auto_increment comment '主键',
	customerId int comment '人员',
	v1 varchar(100) comment '基本工资',
	v2 varchar(100) comment '浮动工资',
	v3 varchar(100) comment '加班工资',
	v4 varchar(100) comment '工资合计',
	v5 varchar(100) comment '备注'
) comment '工资';

打卡表创建语句如下:


create table t_kq(
	id int primary key auto_increment comment '主键',
	customerId int comment '人员',
	v1 varchar(100) comment '打卡属性',
	inseretDate datetime comment '部门编号',
	v2 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	bh varchar(100),
	age varchar(100),
	sex varchar(100),
	cs varchar(100),
	xl varchar(100),
	sfhy varchar(100),
	phone varchar(100),
	address varchar(100),
	jtlxr varchar(100),
	rzsj varchar(100),
	deptId int,
	isfzr 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.customerName is '姓名';
comment on column t_customer.bh is '编号';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.cs is '出生';
comment on column t_customer.xl is '学历';
comment on column t_customer.sfhy is '是否婚姻';
comment on column t_customer.phone is '电话';
comment on column t_customer.address is '住址';
comment on column t_customer.jtlxr is '家庭联系人信息';
comment on column t_customer.rzsj is '入职时间';
comment on column t_customer.deptId is '部门';
comment on column t_customer.isfzr is '是否部门负责人';
--员工表加注释
comment on table t_customer is '员工';

部门表创建语句如下:


create table t_dept(
	id integer,
	deptName varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	pDeptId int
);
--部门字段加注释
comment on column t_dept.id is '主键';
comment on column t_dept.deptName is '部门名称';
comment on column t_dept.v1 is '部门编号';
comment on column t_dept.v2 is '部门级别';
comment on column t_dept.v3 is '部门职能';
comment on column t_dept.pDeptId is '父级部门';
--部门表加注释
comment on table t_dept is '部门';

工资表创建语句如下:


create table t_gz(
	id integer,
	customerId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100)
);
--工资字段加注释
comment on column t_gz.id is '主键';
comment on column t_gz.customerId is '人员';
comment on column t_gz.v1 is '基本工资';
comment on column t_gz.v2 is '浮动工资';
comment on column t_gz.v3 is '加班工资';
comment on column t_gz.v4 is '工资合计';
comment on column t_gz.v5 is '备注';
--工资表加注释
comment on table t_gz is '工资';

打卡表创建语句如下:


create table t_kq(
	id integer,
	customerId int,
	v1 varchar(100),
	inseretDate datetime,
	v2 varchar(100)
);
--打卡字段加注释
comment on column t_kq.id is '主键';
comment on column t_kq.customerId is '人员';
comment on column t_kq.v1 is '打卡属性';
comment on column t_kq.inseretDate is '部门编号';
comment on column t_kq.v2 is '备注';
--打卡表加注释
comment on table t_kq is '打卡';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_dept;
create sequence s_t_gz;
create sequence s_t_kq;

基于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_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	bh varchar(100),--编号
	age varchar(100),--年龄
	sex varchar(100),--性别
	cs varchar(100),--出生
	xl varchar(100),--学历
	sfhy varchar(100),--是否婚姻
	phone varchar(100),--电话
	address varchar(100),--住址
	jtlxr varchar(100),--家庭联系人信息
	rzsj varchar(100),--入职时间
	deptId int,--部门
	isfzr varchar(100)--是否部门负责人
);

部门表创建语句如下:


--部门表注释
create table t_dept(
	id int identity(1,1) primary key not null,--主键
	deptName varchar(100),--部门名称
	v1 varchar(100),--部门编号
	v2 varchar(100),--部门级别
	v3 varchar(100),--部门职能
	pDeptId int--父级部门
);

工资表创建语句如下:


--工资表注释
create table t_gz(
	id int identity(1,1) primary key not null,--主键
	customerId int,--人员
	v1 varchar(100),--基本工资
	v2 varchar(100),--浮动工资
	v3 varchar(100),--加班工资
	v4 varchar(100),--工资合计
	v5 varchar(100)--备注
);

打卡表创建语句如下:


--打卡表注释
create table t_kq(
	id int identity(1,1) primary key not null,--主键
	customerId int,--人员
	v1 varchar(100),--打卡属性
	inseretDate datetime,--部门编号
	v2 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_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 customerName;
//编号
private String bh;
//年龄
private String age;
//性别
private String sex;
//出生
private String cs;
//学历
private String xl;
//是否婚姻
private String sfhy;
//电话
private String phone;
//住址
private String address;
//家庭联系人信息
private String jtlxr;
//入职时间
private String rzsj;
//部门
private Integer deptId;
//是否部门负责人
private String isfzr;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
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 getCs() {return cs;}
public void setCs(String cs) {this.cs = cs;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getSfhy() {return sfhy;}
public void setSfhy(String sfhy) {this.sfhy = sfhy;}
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 getJtlxr() {return jtlxr;}
public void setJtlxr(String jtlxr) {this.jtlxr = jtlxr;}
public String getRzsj() {return rzsj;}
public void setRzsj(String rzsj) {this.rzsj = rzsj;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getIsfzr() {return isfzr;}
public void setIsfzr(String isfzr) {this.isfzr = isfzr;}
}

部门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;
//部门编号
private String v1;
//部门级别
private String v2;
//部门职能
private String v3;
//父级部门
private Integer pDeptId;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
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 Integer getPDeptId() {return pDeptId;}
public void setPDeptId(Integer pDeptId) {this.pDeptId = pDeptId;}
}

工资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_gz")
public class Gz {
//主键
@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 String v1;
//浮动工资
private String v2;
//加班工资
private String v3;
//工资合计
private String v4;
//备注
private String v5;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

打卡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_kq")
public class Kq {
//主键
@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 String v1;
//部门编号
private Date inseretDate;
//备注
private String v2;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getInseretDate() {return inseretDate;}
public void setInseretDate(Date inseretDate) {this.inseretDate = inseretDate;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

基于ssm的企业人事管理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 customerName;
//编号
private String bh;
//年龄
private String age;
//性别
private String sex;
//出生
private String cs;
//学历
private String xl;
//是否婚姻
private String sfhy;
//电话
private String phone;
//住址
private String address;
//家庭联系人信息
private String jtlxr;
//入职时间
private String rzsj;
//部门
private Integer deptId;
//是否部门负责人
private String isfzr;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
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 getCs() {return cs;}
public void setCs(String cs) {this.cs = cs;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getSfhy() {return sfhy;}
public void setSfhy(String sfhy) {this.sfhy = sfhy;}
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 getJtlxr() {return jtlxr;}
public void setJtlxr(String jtlxr) {this.jtlxr = jtlxr;}
public String getRzsj() {return rzsj;}
public void setRzsj(String rzsj) {this.rzsj = rzsj;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getIsfzr() {return isfzr;}
public void setIsfzr(String isfzr) {this.isfzr = isfzr;}
}

部门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;
//部门编号
private String v1;
//部门级别
private String v2;
//部门职能
private String v3;
//父级部门
private Integer pDeptId;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
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 Integer getPDeptId() {return pDeptId;}
public void setPDeptId(Integer pDeptId) {this.pDeptId = pDeptId;}
}

工资javaBean创建语句如下:


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

//工资
public class Gz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//人员
private Integer customerId;
//基本工资
private String v1;
//浮动工资
private String v2;
//加班工资
private String v3;
//工资合计
private String v4;
//备注
private String v5;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

打卡javaBean创建语句如下:


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

//打卡
public class Kq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//人员
private Integer customerId;
//打卡属性
private String v1;
//部门编号
private Date inseretDate;
//备注
private String v2;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getInseretDate() {return inseretDate;}
public void setInseretDate(Date inseretDate) {this.inseretDate = inseretDate;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

评论