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

                介绍：

jsp：mysql：servlet 。员工签到系统

截图：

数据库表：
CREATE TABLE (
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;