職工工資管理系統
職工工資管理系統
- 職工工資管理系統mysql資料庫建立語句
- 職工工資管理系統oracle資料庫建立語句
- 職工工資管理系統sqlserver資料庫建立語句
- 職工工資管理系統spring springMVC hibernate框架物件(javaBean,pojo)設計
- 職工工資管理系統spring springMVC mybatis框架物件(javaBean,pojo)設計
職工工資管理系統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_cfjl(
id int primary key auto_increment comment '主鍵',
customerId int comment '員工',
types varchar(100) comment '型別',
fee int comment '金額',
showDate datetime comment '日期',
content varchar(100) comment '說明'
) comment '懲罰獎勵';
員工表建立語句如下：
create table t_customer(
id int primary key auto_increment comment '主鍵',
username varchar(100) comment '賬號',
password varchar(100) comment '密碼',
customerName varchar(100) comment '姓名',
gh varchar(100) comment '工號',
age varchar(100) comment '年齡',
sex varchar(100) comment '性別',
phone varchar(100) comment '電話'
) comment '員工';
公告表建立語句如下：
create table t_gg(
id int primary key auto_increment comment '主鍵',
title varchar(100) comment '標題',
pic varchar(100) comment '圖片',
content varchar(100) comment '內容',
showDate datetime comment '日期'
) comment '公告';
工資發放表建立語句如下：
create table t_gzff(
id int primary key auto_increment comment '主鍵',
customerId int comment '員工',
yf varchar(100) comment '月份',
fee int comment '工資額',
content varchar(100) comment '明細'
) comment '工資發放';
基本工資表建立語句如下：
create table t_jbgz(
id int primary key auto_increment comment '主鍵',
customerId int comment '員工',
jbgz int comment '基本工資'
) comment '基本工資';
請假表建立語句如下：
create table t_qj(
id int primary key auto_increment comment '主鍵',
customerId int comment '員工',
title varchar(100) comment '請假標題',
types varchar(100) comment '型別',
content varchar(100) comment '詳細說明',
beginDate datetime comment '請假開始日期',
endDate datetime comment '請假結束日期',
status 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_cfjl(
id integer,
customerId int,
types varchar(100),
fee int,
showDate datetime,
content varchar(100)
);
--懲罰獎勵欄位加註釋
comment on column t_cfjl.id is '主鍵';
comment on column t_cfjl.customerId is '員工';
comment on column t_cfjl.types is '型別';
comment on column t_cfjl.fee is '金額';
comment on column t_cfjl.showDate is '日期';
comment on column t_cfjl.content is '說明';
--懲罰獎勵表加註釋
comment on table t_cfjl is '懲罰獎勵';
員工表建立語句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
gh varchar(100),
age varchar(100),
sex varchar(100),
phone 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.gh is '工號';
comment on column t_customer.age is '年齡';
comment on column t_customer.sex is '性別';
comment on column t_customer.phone is '電話';
--員工表加註釋
comment on table t_customer is '員工';
公告表建立語句如下：
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
--公告欄位加註釋
comment on column t_gg.id is '主鍵';
comment on column t_gg.title is '標題';
comment on column t_gg.pic is '圖片';
comment on column t_gg.content is '內容';
comment on column t_gg.showDate is '日期';
--公告表加註釋
comment on table t_gg is '公告';
工資發放表建立語句如下：
create table t_gzff(
id integer,
customerId int,
yf varchar(100),
fee int,
content varchar(100)
);
--工資發放欄位加註釋
comment on column t_gzff.id is '主鍵';
comment on column t_gzff.customerId is '員工';
comment on column t_gzff.yf is '月份';
comment on column t_gzff.fee is '工資額';
comment on column t_gzff.content is '明細';
--工資發放表加註釋
comment on table t_gzff is '工資發放';
基本工資表建立語句如下：
create table t_jbgz(
id integer,
customerId int,
jbgz int
);
--基本工資欄位加註釋
comment on column t_jbgz.id is '主鍵';
comment on column t_jbgz.customerId is '員工';
comment on column t_jbgz.jbgz is '基本工資';
--基本工資表加註釋
comment on table t_jbgz is '基本工資';
請假表建立語句如下：
create table t_qj(
id integer,
customerId int,
title varchar(100),
types varchar(100),
content varchar(100),
beginDate datetime,
endDate datetime,
status varchar(100)
);
--請假欄位加註釋
comment on column t_qj.id is '主鍵';
comment on column t_qj.customerId is '員工';
comment on column t_qj.title is '請假標題';
comment on column t_qj.types is '型別';
comment on column t_qj.content is '詳細說明';
comment on column t_qj.beginDate is '請假開始日期';
comment on column t_qj.endDate is '請假結束日期';
comment on column t_qj.status is '狀態';
--請假表加註釋
comment on table t_qj is '請假';
oracle特有，對應序列如下：
create sequence s_t_cfjl;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_gzff;
create sequence s_t_jbgz;
create sequence s_t_qj;
職工工資管理系統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_cfjl(
id int identity(1,1) primary key not null,--主鍵
customerId int,--員工
types varchar(100),--型別
fee int,--金額
showDate datetime,--日期
content varchar(100)--說明
);
員工表建立語句如下：
--員工表註釋
create table t_customer(
id int identity(1,1) primary key not null,--主鍵
username varchar(100),--賬號
password varchar(100),--密碼
customerName varchar(100),--姓名
gh varchar(100),--工號
age varchar(100),--年齡
sex varchar(100),--性別
phone varchar(100)--電話
);
公告表建立語句如下：
--公告表註釋
create table t_gg(
id int identity(1,1) primary key not null,--主鍵
title varchar(100),--標題
pic varchar(100),--圖片
content varchar(100),--內容
showDate datetime--日期
);
工資發放表建立語句如下：
--工資發放表註釋
create table t_gzff(
id int identity(1,1) primary key not null,--主鍵
customerId int,--員工
yf varchar(100),--月份
fee int,--工資額
content varchar(100)--明細
);
基本工資表建立語句如下：
--基本工資表註釋
create table t_jbgz(
id int identity(1,1) primary key not null,--主鍵
customerId int,--員工
jbgz int--基本工資
);
請假表建立語句如下：
--請假表註釋
create table t_qj(
id int identity(1,1) primary key not null,--主鍵
customerId int,--員工
title varchar(100),--請假標題
types varchar(100),--型別
content varchar(100),--詳細說明
beginDate datetime,--請假開始日期
endDate datetime,--請假結束日期
status 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_cfjl")
public class Cfjl {
//主鍵
@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 types;
//金額
private Integer fee;
//日期
private Date showDate;
//說明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}員工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 gh;
//年齡
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
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_gg")
public class Gg {
//主鍵
@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 title;
//圖片
private String pic;
//內容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}工資發放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_gzff")
public class Gzff {
//主鍵
@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 yf;
//工資額
private Integer fee;
//明細
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}基本工資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_jbgz")
public class Jbgz {
//主鍵
@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 jbgz;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJbgz() {return jbgz;}
public void setJbgz(Integer jbgz) {this.jbgz = jbgz;}
}請假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_qj")
public class Qj {
//主鍵
@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 title;
//型別
private String types;
//詳細說明
private String content;
//請假開始日期
private Date beginDate;
//請假結束日期
private Date endDate;
//狀態
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}職工工資管理系統spring springMVC mybatis框架物件(javaBean,pojo)設計：
懲罰獎勵javaBean建立語句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//懲罰獎勵
public class Cfjl extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//員工
private Integer customerId;
//型別
private String types;
//金額
private Integer fee;
//日期
private Date showDate;
//說明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}員工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 gh;
//年齡
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
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 Gg extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//標題
private String title;
//圖片
private String pic;
//內容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}工資發放javaBean建立語句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//工資發放
public class Gzff extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//員工
private Integer customerId;
//月份
private String yf;
//工資額
private Integer fee;
//明細
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}基本工資javaBean建立語句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//基本工資
public class Jbgz extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//員工
private Integer customerId;
//基本工資
private Integer jbgz;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJbgz() {return jbgz;}
public void setJbgz(Integer jbgz) {this.jbgz = jbgz;}
}請假javaBean建立語句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//請假
public class Qj extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//員工
private Integer customerId;
//請假標題
private String title;
//型別
private String types;
//詳細說明
private String content;
//請假開始日期
private Date beginDate;
//請假結束日期
private Date endDate;
//狀態
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}相關文章
- 3職工管理系統
- C語言職工工資管理系統C語言
- 職工資訊管理系統的設計
- 員工管理系統
- 工業採購管理系統
- 智慧工廠工業能耗監測管理系統開發數字工廠管理平臺開發
- 企業如何規範管理員工時間 工時管理系統的作用
- 開發員工自助業務管理系統
- 停止員工拖延症！工時管理系統的作用之一
- 超實用 2 ArrayList連結串列之 員工工資管理系統
- 創新公司員工的資訊管理系統
- 用C++編寫一個簡單的員工工資管理系統~C++
- 山東工廠能源管理系統,能耗管理軟體
- 工廠MES製造管理系統解決方案
- 工時管理系統在企業管理中的獨特功效
- Good&CO：微軟職工比谷歌和Facebook職工更富冒險精神Go微軟谷歌
- 如何改進企業舊式工時管理系統？
- IT團隊適用的工時管理系統有哪些？
- 除了Excel，還有哪些好用的工時管理系統？Excel
- 資料結構 課程設計 員工管理系統（C語言）資料結構C語言
- 探究員工述職管理用什麼管理軟體好實現?
- 工業智慧閘道器助力智慧工廠打造視覺化節能管理系統視覺化
- 職工資訊核對總結
- IT管理運維工單系統如何賦能新運維運維
- 4款企業常用的工時管理系統盤點
- 計件工資管理系統軟體有哪個好
- java SSH員工管理系統以及Demo程式碼下載Java
- OA辦公系統之工資管理流程，合理規劃薪資結構
- MySQL資料庫系統日常管理職責MySql資料庫
- 工單管理中的工單型別型別
- 企業員工流動大難管理？低程式碼+人事管理系統輕鬆掌控員工檔案資訊！
- 企業能源線上管理系統開發工廠能耗管理平臺搭建
- 員工工作管理
- 智慧工業能源管理系統開發能源線上監測系統建設
- 工業物聯網資料庫管理系統Apache IoTDB新特性與實踐資料庫Apache
- 工業製造業供應鏈管理系統怎麼做？
- 基於java jsp的某企業員工管理系統JavaJS
- MRO工業品平臺應用管理系統解決方案