开发语言：Java 框架：ssm JDK版本：JDK1.8 服务器：tomcat7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：eclipse/myeclipse/idea Maven包：Maven3.3.9 浏览器：谷歌浏览器
DROP TABLE IF EXISTS config;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE config (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
name varchar(100) NOT NULL COMMENT '配置参数名称',
value varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table config
--
LOCK TABLES config WRITE;
/*!40000 ALTER TABLE config DISABLE KEYS /;
INSERT INTO config VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/!40000 ALTER TABLE config ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table gongzifafang
--
DROP TABLE IF EXISTS gongzifafang;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE gongzifafang (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
gonghao varchar(200) NOT NULL COMMENT '工号',
xingming varchar(200) NOT NULL COMMENT '姓名',
xingbie varchar(200) DEFAULT NULL COMMENT '性别',
zhicheng varchar(200) DEFAULT NULL COMMENT '职称',
dianhua varchar(200) DEFAULT NULL COMMENT '电话',
xueyuan varchar(200) DEFAULT NULL COMMENT '学院',
shenfenzhenghao varchar(200) DEFAULT NULL COMMENT '身份证号',
yinxingkahao varchar(200) DEFAULT NULL COMMENT '银行卡号',
jibengongzi float DEFAULT NULL COMMENT '基本工资',
yingdekeshifei float DEFAULT NULL COMMENT '应得课时费',
shidekeshifei float DEFAULT NULL COMMENT '实得课时费',
gangweibutie float DEFAULT NULL COMMENT '岗位补贴',
wuxianyijin float DEFAULT NULL COMMENT '五险一金',
gerensuodeshui float DEFAULT NULL COMMENT '个人所得税',
shijigongzi float DEFAULT NULL COMMENT '实际工资',
dengjishijian date DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (id),
UNIQUE KEY gonghao (gonghao)
) ENGINE=InnoDB AUTO_INCREMENT=1646028114854 DEFAULT CHARSET=utf8 COMMENT='工资发放';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table gongzifafang
--
LOCK TABLES gongzifafang WRITE;
/*!40000 ALTER TABLE gongzifafang DISABLE KEYS /;
INSERT INTO gongzifafang VALUES (31,'2022-02-28 05:58:16','工号1','姓名1','男','职称1','13823888881','学院1','440300199101010001','银行卡号1',1,1,1,1,1,1,1,'2022-02-28'),(32,'2022-02-28 05:58:16','工号2','姓名2','男','职称2','13823888882','学院2','440300199202020002','银行卡号2',2,2,2,2,2,2,2,'2022-02-28'),(33,'2022-02-28 05:58:16','工号3','姓名3','男','职称3','13823888883','学院3','440300199303030003','银行卡号3',3,3,3,3,3,3,3,'2022-02-28'),(34,'2022-02-28 05:58:16','工号4','姓名4','男','职称4','13823888884','学院4','440300199404040004','银行卡号4',4,4,4,4,4,4,4,'2022-02-28'),(35,'2022-02-28 05:58:16','工号5','姓名5','男','职称5','13823888885','学院5','440300199505050005','银行卡号5',5,5,5,5,5,5,5,'2022-02-28'),(36,'2022-02-28 05:58:16','工号6','姓名6','男','职称6','13823888886','学院6','440300199606060006','银行卡号6',6,6,6,6,6,6,6,'2022-02-28'),(1646028114853,'2022-02-28 06:01:54','111','胡集','男','教授','13612512512','编辑','136125125125125125','123123123123123123123',5555,2321,2211,333,333,33,7733,'2022-02-28');
/!40000 ALTER TABLE gongzifafang ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table jiaozhiyuangong
--
DROP TABLE IF EXISTS jiaozhiyuangong;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE jiaozhiyuangong (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
gonghao varchar(200) NOT NULL COMMENT '工号',
mima varchar(200) NOT NULL COMMENT '密码',
xingming varchar(200) NOT NULL COMMENT '姓名',
xingbie varchar(200) DEFAULT NULL COMMENT '性别',
zhicheng varchar(200) DEFAULT NULL COMMENT '职称',
dianhua varchar(200) DEFAULT NULL COMMENT '电话',
nianling varchar(200) DEFAULT NULL COMMENT '年龄',
xueyuan varchar(200) DEFAULT NULL COMMENT '学院',
shenfenzhenghao varchar(200) DEFAULT NULL COMMENT '身份证号',
yinxingkahao varchar(200) DEFAULT NULL COMMENT '银行卡号',
PRIMARY KEY (id),
UNIQUE KEY gonghao (gonghao)
) ENGINE=InnoDB AUTO_INCREMENT=1646028039319 DEFAULT CHARSET=utf8 COMMENT='教职员工';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table jiaozhiyuangong
--
LOCK TABLES jiaozhiyuangong WRITE;
/*!40000 ALTER TABLE jiaozhiyuangong DISABLE KEYS /;
INSERT INTO jiaozhiyuangong VALUES (11,'2022-02-28 05:58:16','工号1','123456','姓名1','男','职称1','13823888881','年龄1','学院1','440300199101010001','银行卡号1'),(12,'2022-02-28 05:58:16','工号2','123456','姓名2','男','职称2','13823888882','年龄2','学院2','440300199202020002','银行卡号2'),(13,'2022-02-28 05:58:16','工号3','123456','姓名3','男','职称3','13823888883','年龄3','学院3','440300199303030003','银行卡号3'),(14,'2022-02-28 05:58:16','工号4','123456','姓名4','男','职称4','13823888884','年龄4','学院4','440300199404040004','银行卡号4'),(15,'2022-02-28 05:58:16','工号5','123456','姓名5','男','职称5','13823888885','年龄5','学院5','440300199505050005','银行卡号5'),(16,'2022-02-28 05:58:16','工号6','123456','姓名6','男','职称6','13823888886','年龄6','学院6','440300199606060006','银行卡号6'),(1646028039318,'2022-02-28 06:00:39','111','111','胡集','男','教授','13612512512','36','编辑','136125125125125125','123123123123123123123');
/!40000 ALTER TABLE jiaozhiyuangong ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table kaoqinxinxi
--
DROP TABLE IF EXISTS kaoqinxinxi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE kaoqinxinxi (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
nianyuefen varchar(200) DEFAULT NULL COMMENT '年月份',
gonghao varchar(200) DEFAULT NULL COMMENT '工号',
xingming varchar(200) DEFAULT NULL COMMENT '姓名',
chuqinshijian varchar(200) DEFAULT NULL COMMENT '出勤时间',
qingjiatianshu varchar(200) DEFAULT NULL COMMENT '请假天数',
pingshijiaban varchar(200) DEFAULT NULL COMMENT '平时加班',
zhoumojiaban varchar(200) DEFAULT NULL COMMENT '周末加班',
jiejiarijiaban varchar(200) DEFAULT NULL COMMENT '节假日加班',
chidaocishu varchar(200) DEFAULT NULL COMMENT '迟到次数',
zaotuicishu varchar(200) DEFAULT NULL COMMENT '早退次数',
queqintianshu varchar(200) DEFAULT NULL COMMENT '缺勤天数',
chuchatianshu varchar(200) DEFAULT NULL COMMENT '出差天数',
dengjishijian datetime DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1646028094228 DEFAULT CHARSET=utf8 COMMENT='考勤信息';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table kaoqinxinxi
--
LOCK TABLES kaoqinxinxi WRITE;
/*!40000 ALTER TABLE kaoqinxinxi DISABLE KEYS /;
INSERT INTO kaoqinxinxi VALUES (21,'2022-02-28 05:58:16','年月份1','工号1','姓名1','出勤时间1','请假天数1','平时加班1','周末加班1','节假日加班1','迟到次数1','早退次数1','缺勤天数1','出差天数1','2022-02-28 13:58:16'),(22,'2022-02-28 05:58:16','年月份2','工号2','姓名2','出勤时间2','请假天数2','平时加班2','周末加班2','节假日加班2','迟到次数2','早退次数2','缺勤天数2','出差天数2','2022-02-28 13:58:16'),(23,'2022-02-28 05:58:16','年月份3','工号3','姓名3','出勤时间3','请假天数3','平时加班3','周末加班3','节假日加班3','迟到次数3','早退次数3','缺勤天数3','出差天数3','2022-02-28 13:58:16'),(24,'2022-02-28 05:58:16','年月份4','工号4','姓名4','出勤时间4','请假天数4','平时加班4','周末加班4','节假日加班4','迟到次数4','早退次数4','缺勤天数4','出差天数4','2022-02-28 13:58:16'),(25,'2022-02-28 05:58:16','年月份5','工号5','姓名5','出勤时间5','请假天数5','平时加班5','周末加班5','节假日加班5','迟到次数5','早退次数5','缺勤天数5','出差天数5','2022-02-28 13:58:16'),(26,'2022-02-28 05:58:16','年月份6','工号6','姓名6','出勤时间6','请假天数6','平时加班6','周末加班6','节假日加班6','迟到次数6','早退次数6','缺勤天数6','出差天数6','2022-02-28 13:58:16'),(1646028094227,'2022-02-28 06:01:33','2022/03','111','胡集','22','1','1','1','1','1','1','1','1','2022-02-28 14:01:18');
/!40000 ALTER TABLE kaoqinxinxi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table token
--
DROP TABLE IF EXISTS token;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 */;
CREATE TABLE token (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
userid bigint(20) NOT NULL COMMENT '用户id',
username varchar(100) NOT NULL COMMENT '用户名',
tablename varchar(100) DEFAULT NULL COMMENT '表名',
role varchar(100) DEFAULT NULL COMMENT '角色',
token varchar(200) NOT NULL COMMENT '密码',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
expiratedtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='token表';
