基于jsp+mysql java 员工签到系统

最新推荐文章于 2022-12-27 16:08:03 发布

QQ-79120063

最新推荐文章于 2022-12-27 16:08:03 发布

阅读量328

点赞数

分类专栏： javaweb 文章标签： mysql jsp servlet sql

本文链接：https://blog.csdn.net/m0_53156010/article/details/110520591

版权

javaweb 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

这是一个使用jsp、mysql和servlet技术实现的员工签到系统。系统包括员工信息、部门信息、签到记录等数据库表结构，并展示了部分数据插入示例。

摘要由CSDN通过智能技术生成

介绍：
jsp+mysql+servlet 。员工签到系统

截图：

数据库表：
CREATE TABLE tb_count (
StaffId varchar(20) NOT NULL DEFAULT ‘’,
Time varchar(20) DEFAULT NULL,
DepartId varchar(20) DEFAULT NULL,
StaffName varchar(20) DEFAULT NULL,
DepartName varchar(20) DEFAULT NULL,
Priviliges varchar(20) DEFAULT NULL,
Gender varchar(20) DEFAULT NULL,
Age varchar(20) DEFAULT NULL,
Frequency varchar(20) DEFAULT NULL,
ATT varchar(20) DEFAULT NULL,
Type varchar(20) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (StaffId)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

– Records of tb_count

INSERT INTO tb_count VALUES (‘hhh’, null, null, null, null, null, null, null, null, null, null);

– Table structure for tb_department

DROP TABLE IF EXISTS tb_department;
CREATE TABLE tb_department (
DepartId varchar(20) NOT NULL DEFAULT ‘’,
DepartName varchar(20) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (DepartId)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

– Records of tb_department

INSERT INTO tb_department VALUES (‘001’, ‘销售部’);
INSERT INTO tb_department VALUES (‘002’, ‘事业部’);
INSERT INTO tb_department VALUES (‘003’, ‘策划部’);
INSERT INTO tb_department VALUES (‘004’, ‘营业部’);
INSERT INTO tb_department VALUES (‘005’, ‘保卫部’);
INSERT INTO tb_department VALUES (‘006’, ‘文化部’);

– Table structure for tb_schedule

DROP TABLE IF EXISTS tb_schedule;
CREATE TABLE tb_schedule (
SchId varchar(20) NOT NULL DEFAULT ‘’,
DepartId varchar(20) DEFAULT NULL,
SchName varchar(20) DEFAULT NULL,
CheckTime varchar(20) DEFAULT NULL,
StartTime varchar(20) DEFAULT NULL,
CheckOutTime varchar(20) DEFAULT NULL,
EndTime varchar(20) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (SchId)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

– Records of tb_schedule

– Table structure for tb_staffback

DROP TABLE IF EXISTS tb_staffback;
CREATE TABLE tb_staffback (
CheckOut varchar(20) NOT NULL DEFAULT ‘’,
StaffId varchar(20) DEFAULT NULL,
DepartId varchar(20) DEFAULT NULL,
Privilige varchar(20) DEFAULT NULL,
Gender varchar(20) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (CheckOut)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

– Records of tb_staffback

INSERT INTO tb_staffback VALUES (‘2015-06-21 19:04:46’, ‘10001’, ‘001’, ‘renshibu’, ‘man’);
INSERT INTO tb_staffback VALUES (‘2015-06-21 19:46’, ‘10001’, ‘001’, ‘renshibu’, ‘man’);
INSERT INTO tb_staffback VALUES (‘2015-06-21 19:48’, ‘10001’, ‘001’, ‘renshibu’, ‘man’);
INSERT INTO tb_staffback VALUES (‘2015-06-21 19:51’, ‘10001’, ‘null’, ‘null’, ‘null’);
INSERT INTO tb_staffback VALUES (‘2015-06-21 19:52’, ‘10001’, ‘null’, ‘null’, ‘null’);
INSERT INTO tb_staffback VALUES (‘2015-06-21 20:18’, ‘10001’, ‘001’, ‘renshibu’, ‘man’);
INSERT INTO tb_staffback VALUES (‘2015-06-21 20:35’, ‘10001’, ‘001’, ‘renshibu’, ‘man’);
INSERT INTO tb_staffback VALUES (‘2015-06-21 20:56’, ‘10001’, ‘001’, ‘renshibu’, ‘man’);

– Table structure for tb_staffinfo

DROP TABLE IF EXISTS tb_staffinfo;
CREATE TABLE tb_staffinfo (
StaffId varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT ‘’,
DepartId varchar(20) DEFAULT NULL,
StaffName varchar(20) DEFAULT NULL,
passwords varchar(20) CHARACTER SET utf8 DEFAULT NULL,
Priviliges varchar(20) DEFAULT NULL,
Gender varchar(20) DEFAULT NULL,
Age int(2) DEFAULT NULL,
Birthday varchar(20) DEFAULT NULL,
Phone varchar(20) DEFAULT NULL,
Address varchar(30) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (StaffId)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;